|
Excel Level 3
The uses for Excel are limitless. Businesses use Excel for creating financial reports, scientists use Excel for statistical analysis, and families use Excel to help manage their investment portfolios. Microsoft Excel is by far the most widely used and, according to most reviews, the most powerful and user friendly spreadsheet program available.
Microsoft Excel 2003 is a powerful spreadsheet software program that allows you to make quick and accurate numerical calculations. Entering data onto a worksheet is quick and easy. Excel can instantly perform any type of calculation with data entered onto a worksheet. Excel can also make your information look sharp and professional. You have made a great choice by deciding to learn more about Excel.
Course Outline
Chapter One: Data Analysis and PivotTables
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
Creating Subtotals
Using Database Functions
Using Lookup Functions
Grouping and Outlining a Worksheet
Chapter Two: What If Analysis
Defining a Scenario
Creating a Scenario Summary Report
Using a One and Two Input Data Table
Understanding Goal Seek
Using Solver
Chapter Three: Automating Tasks with Macros
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
Declaring Variables and Adding Remarks to VBA Code
Prompting for User Input
Using the If...Then...Else Statement
Chapter Four: Using Excel with the Internet
Adding and Working with Hyperlinks
Browsing Hyperlinks and using the Web Toolbar
Saving a Workbook as a Non-Interactive Web Page
Saving a Workbook as an Interactive Web Page
Import an External Data Source
Working with a Data Source
Create a New Web Query
Student Practice Files for this class are located here.
|