Microsoft Excel Databases

R899.00 Incl VAT

This course is designed for those who wish to gain the necessary skills to manipulate data in Microsoft Excel worksheets.

You will learn:

  • How to get started with MS Excel
  • How to create, modify, format and print a workbook
  • Use basic formulas


Unit Standard: 258876

Course Schedule

  1. Importing and Exporting Data
  2. Consolidating and Linking Data
  3. Working with Filtered Data (including subtotals)
  4. Advanced Filtering
  5. Using Forms to input data
  6. Creating and using Macros
  7. Conditional Formatting
  8. Editing Macros in VBA
  9. Creating Pivot Tables
  10. Working with Pivot Tables
  11. Using the Pivot Table Tabs
  12. Creating Pivot Charts
  13. Working with Pivot Charts
  14. Using charts for data analysis
  15. Creating and using PowerPivots to build reports