Excel 2003 Data Manipulation & Calculations (1 Day):
Prerequisites:
Excel 2003 FundamentalsDescription:
Formulas and Functions in Excel
• Calculating Value Totals with AutoSum
• Entering Formulas
• Working with Absolute and Relative Cell References
• Formulas with Several Operators and Cell Ranges
• Using the Insert Function Feature
• Creating and Using Range Names
• Selecting Nonadjacent Ranges and Using AutoCalculate
• Displaying and Printing Formulas
• Fixing Formula Errors
Managing Your Workbooks in Excel
• Switching Between Sheets Inserting and Deleting Worksheets
• Renaming and Moving Worksheets
• Working with Several Workbooks Splitting and Freezing a Window
• Referencing External Data
• Protecting a Worksheet
• Hiding Columns, Rows and Sheets
Working with Lists in Excel
• Creating a List
• Using the Data Form to Add Records
• Finding and Deleting Records
• Sorting a List
• Filtering a List with the AutoFilter
• Creating a Custom AutoFilter
• Filtering a List with an Advanced Filter
• Copying Filtered Records
• Using Data Validation
Automating Tasks with Macros in Excel
• Recording a Macro
• Playing a Macro and Assigning a Macro a Shortcut Key
• Adding a Macro to a Toolbar
• Editing a Macro’s Visual Basic Code
• Inserting Code in an Existing Macro
Creating PivotTables in Excel
• Creating a PivotTable
• Specifying the Data a PivotTable Analyzes
• Changing a PivotTable's Calculation
• Selecting What Appears in a PivotTable
• Grouping Dates in a PivotTable
• Updating a PivotTable
• Formatting and Charting a PivotTable
Data Analysis in Excel
• Creating Subtotals
• Using Database Functions
• Using Lookup Functions
• Grouping and Outlining a Worksheet
What If Analysis Using Excel
• Defining a Scenario
• Creating a Scenario Summary Report
• Using a One and Two Input Data Table
• Understanding Goal Seek
• Using Solver
