This course will cover getting started with Excel 2003, manipulating, formatting data and Worksheets, reviewing and printing. The training also teaches you Excel 2003 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data management, advanced customization and how to analyze data and how to protect and share Excel 2003 workbooks.

Upon successful completion of this Microsoft Office Excel 2003 training course, you will be fully prepared to sit for the Microsoft Office Specialist Excel 2003 Exam MOS: Microsoft Office Excel 2003. All of our Microsoft Office 2003 training courses map to MOS certification paths.

Expected Duration (hours) – 13.25
Mentoring – 24x7

Price: USD $149.00

USD

Basic Features of Excel 2003

• Outline the basic features of a spreadsheet and identify the main interface and Help features of Excel 2003
• Create a workbook and navigate through the worksheets in it
• Enter data and text in a worksheet in Excel 2003
• Save a new workbook and distinguish between the different file formats used to save workbooks in Excel 2003
• Enter data in a workbook and save it
• Edit data and filter cells in an Excel 2003 worksheet
• Copy and move a cell and a range of cells in Excel 2003
• Insert, edit, copy, and move worksheets
• Insert a worksheet, move data between worksheets, and copy a worksheet to another workbook
• Add and modify data and a worksheet in Excel 2003

Formatting Data in Excel 2003

• Apply and adapt a range of Excel cell formats
• Use visual design techniques to apply formatting to an Excel 2003 workbook
• Manipulate rows and columns in an Excel 2003 worksheet
• Apply various types of formatting to an Excel 2003 workbook
• Apply number formatting to cells in Excel 2003
• Apply a number format to cell content in Excel 2003
• Format text and cells and apply number formats to data in Excel 2003

Printing and Collaborating in Excel 2003

• Run a spell check, and use the previewing features in Excel 2003
• Adjust the Page Setup options and print a document in Excel 2003
• Use a range of printing option features in Excel 2003
• Adjust printing options and preview and print a document in Excel 2003
• Create and edit comments and send a workbook for review in Excel 2003
• Insert comments and send a workbook for review in Excel 2003

Excel 2003 Formulas and Functions

• Use formulas to perform basic calculations in Excel 2003
• Create a formula in Excel 2003
• Use references and names in Excel 2003 formulas
• Enter a formula that uses cell references in Excel 2003
• Use functions to perform calculations in Excel 2003
• Use logical, financial, and date functions in Excel 2003
• Use the Insert Function feature to insert basic and advanced functions
• Use formulas and functions to perform calculations in Excel 2003

Excel 2003 Chart and Multimedia Features

• Create charts to display data in Excel 2003
• Create a chart using the Chart wizard in Excel 2003
• Edit chart source data and change chart type in Excel 2003
• Format, move, and resize a chart in Excel 2003
• Change a data series and chart type in Excel 2003
• Insert graphics in Excel 2003
• Modify graphics in Excel 2003
• Insert a picture into an Excel 2003 worksheet
• Save a worksheet as a web page and work with hyperlinks in Excel 2003
• Create an HTML spreadsheet in Excel 2003