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
Tutorial Introduction to Microsoft Excel
Tutorial How to Add, Subtract, Multiply, Divide in Excel
Tutorial Excel Data Validation, Filters, Grouping
Tutorial Introduction to formulas and functions in Excel
Tutorial Logical functions (operators) and conditions in Excel
Tutorial Visualizing data using charts in Excel
Tutorial Case Study: Managing personal finance using Microsoft Excel

Advance Stuff

Tutorial Connecting Microsoft Excel to External Data Sources
Tutorial Pivot Tables in Excel: Beginner’s Guide
Tutorial Creating Advanced Charts in Excel
Tutorial Excel in the cloud: Office 365
Tutorial CSV vs Excel (.xls) - What's the Difference?

Macros & VBA in Excel

Tutorial Introduction to Macros in Excel
Tutorial Creating your First Visual Basic for Applications (VBA) in Excel
Tutorial VBA Data Types, Variables & Constant
Tutorial VBA Arrays
Tutorial VBA Excel Form Control & Activex Control
Tutorial VBA Arithmetic Operators
Tutorial VBA String Operators
Tutorial VBA Comparison Operators
Tutorial VBA Logical Operators
Tutorial Excel VBA Call a Subroutine
Tutorial Excel VBA Function Tutorial: Return, Call, Examples
Tutorial VBA Range Objects