Microsoft Excel - 3 month online course - Learning segments New Features Starting in Excel Basic Navigation Working with Data Formulas and Functions Formatting Data Working with Worksheets Printing Level Summary Use AutoSum and AutoFill Use the Vlookup Function Use Themes, Styles and Formats Use Table Styles Insert Cells, Rows and Columns Cut, Copy and Paste Cells Manage Worksheets Adjust Page Layout Templates Sorting and Filtering Navigating in Excel Working with Comments Using Name Box Controlling and Validating Data Entry Controlling What You See Using Drawing Tools Charting Level Summary Create a Hyperlink Use AutoFilter Sort Data in a Range or Table Use the Subtotal Command Use Advanced Filter Create a Custom List Use the Name Box and Go To Add, Edit, and Delete Comments Advanced Data Tools Advanced Formula and Function Tools Protecting and Reviewing Your Work Merging and Consolidating Working with External Data Macros XML Trusting and Privacy in 2007 Excel Options Level Summary Use Scenarios Audit a Formula Use a PivotTable Report Consolidate Data Track and Review Changes Use Goal Seek Validate Data Use Conditional Formatting. The Training Shop has B-BBEE Status Level of “Level Four Contributor”