Syllabus:
MS Excel:
- Introduction to Microsoft Excel
- Entering and Amending Data
- Saving and Opening Workbooks
- Navigating and Selecting Ranges
- Entering Formulas
- Inserting/Deleting Rows and Columns
- Formatting Worksheets
- Using Simple Functions
- Copying, Moving and AutoFill
- Relative vs. Absolute References
- Previewing and Printing
- Find and Replace
- Introduction to Range Names
- Using Multiple Worksheets
- Cell Styles and Conditional Formatting
- Paste Special
- Text and Date Formulas
- IF Function
- Using Charts
- Sorting and Filtering Lists
- Using Tables
- SmartArt and Drawings
- Comments and Hyperlinks
- Importing and Exporting Data
- Managing Range Names
- Date and Time Formulas
- Custom Formats
- IF and Related Functions
- VLOOKUP and Related Functions
- Advanced Filter / Subtotals
- Database Functions
- Multiple Workbooks / Consolidation
- Data Validation
- Auditing
- Pivot Tables
- Shared Workbooks / Tracking
- Protecting Worksheets
- Using Templates