Excel 2000-Part 1 |
|
Excel 2000-Part 2 |
|
Excel 2000-Part 3: Macros |
Calendar of classes
Enroll in a class
Excel 2000 - Part 1
6 Hours / $195
Lesson 1: Introduction to Excel 2000
A) Starting Microsoft Excel 2000
B) Overview of the Microsoft Excel workbook concept
C) The Microsoft Excel 2000 screen
D) Command menus
Lesson 2: File Operations
A) Opening an existing file
B) Saving a file
C) Closing a file
D) Creating a new file
Lesson 3: Navigating in Excel 2000
A) Moving the active cell within a worksheet
B) Moving between sheets
Lesson 4: Entering Data
A) Enter mode
B) Edit mode
C) Data types
D) Creating formulas: Operators
E) Order of operations
Lesson 5: Working with Ranges
A) Selecting ranges
B) Moving ranges
C) Copying ranges
D) Erasing ranges
E) How copying and moving a range of cells affect formulasLesson 6: Absolute vs. Relative Cell References
A) Relative cell references
B) Absolute references
Lesson 7: Functions
A) =SUM()
B) AutoSum
C) Common functions
D) Paste function
E) AutoCalculate
Lesson 8: AutoFill
A) Right-AutoFill
B) Custom lists
Lesson 9: AutoComplete and AutoCorrect
A) Using AutoComplete
B) Using AutoCorrect
Lesson 10: Cell Operations
A) Inserting a range of cells
B) Deleting a range of cells
C) Inserting a row or column
D) Deleting a row or column
E) Hiding columns
F) Unhiding columns
G) Column width and row height
Lesson 11: Cell Formatting: Changing Number Appearance
A) Custom formatting
B) Format painter
Lesson 12: Budget Exercise
A) Naming a worksheet
Lesson 13: Window Panes
A) Splitting panes
B) Freezing panes
C) Removing panes
Lesson 14: Cell Formatting: Alignment, Fonts, Borders and Colors
A) Cell alignment
B) Choosing fonts
C) Borders and shading
D) AutoFormat
Lesson 15: Cell Protection
A) Protecting the worksheet
Lesson 16: Printing Worksheets
A) Print preview
B) Printing your worksheet
C) Page breaks
Lesson 17: Using Help
A) Accessing help
B) Context-Sensitive help
Excel 2000 - Part 2
6 Hours / $195
Lesson 1: Multiple Worksheets
A) Moving between sheets in a workbook
B) Changing workbook defaults
C) Inserting a new sheet
D) Deleting sheets
E) Renaming worksheets
F) Moving or copying a sheet within a workbook
G) Copying a sheet to another workbook
H) Grouping worksheets
Lesson 2: Names
A) Defining names
B) Using GO TO with range names
C) Applying range names
D) Creating a named formula
Lesson 3: Dates
A) Entering dates
B) NOW and TODAY functions
C) Filling in a date series
D) Calculations with dates
E) Referencing day, month or year
Lesson 4: Finding and Replacing
A) Find
B) Replace
Lesson 5: Logical Functions
A) IF statements
B) Comparison operators
C) The AND function
D) The OR function
Lesson 6: The PMT Function
Lesson 7: Data Tables
A) A table for one set of variables
B) A table for two set of variables
Lesson 8: Sorting and Filtering Data
A) Sorting data
B) Filtering and subtotaling data
Lesson 9: PivotTables
A) Creating a PivotTable
B) Changing a PivotTable layout
C) Creating detail reports from the PivotTable
Lesson 10: Lookup Tables
A) VLOOKUP and HLOOKUP
B) Lookup tables with values
Lesson 11: Reorganizing Data
A) Making small worksheets from large worksheets
B) Combining data
C) Transposing
Lesson 12: Linking Worksheets
A) 3-D reference
Lesson 13: Comments
A) Attaching comments to cells
B) Viewing comments
C) Editing comments
D) Printing comments
E) Removing comments
Lesson 14: Charts
A) Creating a chart sheet
B) Creating an embedded chart
C) Modifying a chart
D) Formatting objects
E) Exploding a pie slice
F) Adding arrows in a chart
G) Adding a Text Box
H) Adding data to an existing chart
I) Changing the chart type for an individual data seriesLesson 15: (Optional) PivotCharts
A) Creating a PivotChart
B) Changing the chart type of a PivotChart
Excel 2000-Part 3: Macros 6 Hours / $195
Lesson 1: Creating and Using Personal Macros
A) What is a macro?
B) Recording a personal macro
C) Running a personal macro
D) Displaying macro instructions
E) Editing a macro
F) Using absolute and relative cell references in a macro
Lesson 2: Creating and Using Workbook Macros
A) Recording and running a workbook macro
B) Adding a macro button to a worksheet
Lesson 3: Using Visual Basic to Write Macros
A) Opening a new module in the Visual Basic editor
B) Displaying a data prompt during macro execution
C) Using a conditional statement in a macro
D) Using a control loop in a macro
E) Additional control statements
Lesson 4: Placing Controls on a Worksheet
A) Placing a combination box and check box on a worksheet/linking a control to worksheet data
Lesson 5: Creating a Custom Macro Toolbar
A) Creating a new toolbar
B) Adding a button to a toolbar/assigning a macro to a toolbar button
Lesson 6: Creating a Custom Macro Menu
A) Creating a new menu
B) Adding an item to a menu/assigning a macro to a menu item
Lesson 7: Using the Visual Basic Help System
A) Displaying visual basic help information