Microsoft Excel Databases

R695.65 Excl 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

Description

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

Reviews

There are no reviews yet.

Be the first to review “Microsoft Excel Databases”

Your email address will not be published. Required fields are marked *