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.

What will you Learn?

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 How to Import XML Data into Excel [Example]
Tutorial How to Import CSV Data (Text) into Excel [Example]
Tutorial How to Import MS Access Data into Excel [Example]
Tutorial How to Import SQL Database Data into Excel [Example]
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?
Tutorial Excel VLOOKUP Tutorial for Beginners: Learn with Examples
Tutorial Excel ISBLANK Function: Learn with Example
Tutorial Sparkline in Excel with EXAMPLES
Tutorial SUMIF function in Excel: Learn with EXAMPLE
Tutorial Top 40 Microsoft Excel Interview Questions & Answers
Tutorial Top 10 Excel Formulas Asked in an Interview & Answers
Tutorial 20 Best Excel Courses
Tutorial 17 BEST Excel Alternatives
Tutorial 85 Best Microsoft Office Classes Courses
Tutorial Excel PDF

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