Learning Excel

Intro to Excel	Intermediate Excel	Advanced Excel
Exploring the Excel workspace Examining a worksheet Locating/Opening an existing workbook Moving between worksheets in a workbook Selecting cells Go to a specific cell Entering text and numbers Applying number formats Modifying the size of columns Using AutoFit Modifying the size of rows Creating a new workbook Inserting worksheets Moving/Deleting worksheets Renaming a worksheet Working with series (AutoFill) Editing cell content Using Save/Save As Modifying alignment of cell content Merging cells Applying Font Styles Entering formulas in a cell Using Copy/Paste commands Entering a formula using the Formula bar Entering a function using the formula palette Using AutoSum Clearing cell content/formatting Using Undo/Redo Copying a worksheet Checking Spelling Examining Print Settings Printing an entire workbook Setting page margins/centering Setting up headers/footers	Changing zoom settings Zooming specific cells Splitting a worksheet Freezing columns and rows Unfreezing panes Hiding/Unhiding columns and rows Inserting/deleting selected cells Deleting individual cells Inserting columns and rows Inserting multiple columns/rows Moving selected cells Utilizing the office clipboard Merging and centering Adding named ranges Selecting named ranges Naming single cells Inserting rows in a named range Preparing formulas Deleting named ranges Revising formulas Printing selections Changing page scaling Applying borders/shading Using Paste Special Removing a format style Hiding/Displaying gridlines Rotating text Changing indents Defining/Applying styles Merging styles Applying autoformats Creating templates Customizing an invoice Applying templates Editing templates Saving templates Applying date formats	Opening Excel Grouping and Outlines Outlining an entire worksheet Expanding/Collapsing outline levels Print Previewing a worksheet Changing Page Orientation Setting print titles & options Using Page Break Preview Inserting/Removing a page break Removing an outline Opening multiple workbooks Arranging workbook windows Creating/Saving a customized workspace Using a workspace Consolidating data from multiple workbooks Creating a link to source data Link worksheets & consolidate data using 3D references Opening/Viewing an Excel list Use Data Forms Adding a new record to a list Finding records using a data form Performing single/multi-level sorts Applying data filters Filtering data using custom criteria Extracting data Use subtotaling Exporting to other applications Importing from Text Files (Inserting) Importing from Text Files (Drag and Drop) Adjusting the decimal place Query a database Importing a table from an HTML file Creating a shared workbook Sending a workbook via email Merging workbooks Tracking changes (Highlight) Tracking changes (Accept/Reject) Creating/Editing/Removing a comment Apply a file password Remove a file password
Formulas and Functions	Visual Basic for Excel
Opening Excel Creating a formula Using realative/absolute Using AutoSum Using the Paste Function tool Using basic functions Using comparisons in a formula Opening/linking multiple workbooks Creating a hyperlink Working with RATE & PMT functions Using the FV function Listing the DDB function arguments Using the DDb function Discussing elements within a function Calculating dates with a formula Using the IF function Working with Date functions Using/applying conditional formats Working with the Auditing toolbar Tracing precedents/dependents Tracing errors Using the Data Validation	Opening Excel 2000 Enabling macros Running a macro Starting Visual Basic Editor Working with constants Using ActiveSheet properties Applying the Cells method Using the While/For…Next loop Employing the Set statement Executing If…Then statements Calculating/Assigning cell values Modifying cells Discussing user friendly macros Importing UserForms Declaring Boolean variables Changing constants Displaying UserForms Entering event codes Hiding UserForms Assigning variable values Importing chart forms Handling UserForm Activate events Initializing control variables Using Redim/Preserve statements Handling Chart Click Applying Range methods Adding chart objects Using With statements Setting chart properties Creating pointers Adding sub procedures Triggering errors Examining ListIndex properties Testing/Locating error codes Creating error traps Using error objects Creating user friendly messages Applying If…Then…Else statements Employing Else clauses Testing for bad data Using IsNumeric functions