Training Summary


Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.

What should I know?


Nothing! This course assumes you are a beginner to Excel.


Syllabus


    Introduction

  1. Introduction to Microsoft Excel
  2. How to Add, Subtract, Multiply, Divide in Excel
  3. Excel Data Validation, Filters, Grouping
  4. Introduction to formulas and functions in Excel
  5. Logical functions (operators) and conditions in Excel
  6. Visualizing data using charts in Excel
  7. Case Study: Managing personal finance using Microsoft Excel
  8. Advance Stuff

  9. Connecting Microsoft Excel to External Data Sources
  10. Pivot Tables in Excel: Beginner’s Guide
  11. Creating Advanced Charts in Excel
  12. Excel in the cloud: Office 365
  13. CSV vs Excel (.xls) - What's the Difference?
  14. Macros & VBA in Excel

  15. Introduction to Macros in Excel
  16. Creating your First Visual Basic for Applications (VBA) in Excel
  17. VBA Data Types, Variables & Constant
  18. VBA Arrays
  19. VBA Excel Form Control & Activex Control
  20. VBA Arithmetic Operators
  21. VBA String Operators
  22. VBA Comparison Operators
  23. VBA Logical Operators
  24. Excel VBA Call a Subroutine
  25. Excel VBA Function Tutorial: Return, Call, Examples
  26. VBA Range Objects