Excel Tutorials

Class 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! With some basic exposure to Excel spreadsheet, this tutorial will give you a complete tour of various applications of Excel to practice and become an Excel-pro.


Syllabus


  1. Introduction to Microsoft Excel
  2. Learning Microsoft Excel 101
  3. Getting Started with Microsoft Excel
  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. Introduction to Macros in Excel
  9. Creating your First Visual Basic for Applications (VBA) in Excel
  10. Connecting Microsoft Excel to External Data Sources
  11. Pivot Tables in Excel: Beginner’s Guide
  12. Creating Advanced Charts in Excel
  13. Excel in the cloud: Office 365