MS Excel (All Levels)

This is a complete package to learn MS Excel from scratch and move to intermediate and advanced topics/levels accordingly as required by the student. The skills and knowledge acquired here will help you become a proficient user of MS Excel. It includes discussions, practice and learning of Excel formula, Charts, Tables and much more.

Learning Outcomes:

• Introduction to Microsoft Excel
• Excel Data Validation, Filters, Grouping
• How to Add, Subtract, Multiply, Divide in Excel
• Introduction to formulas and functions in Excel
• Visualizing data using charts in Excel
• Logical functions (operators) and conditions in Excel
• Connecting Microsoft Excel to External Data Sources
• Case Study: Managing personal finance using Microsoft Excel
• Creating Advanced Charts in Excel
• Pivot Tables in Excel: Beginner’s Guide
• Excel in the cloud: Office 365
• Excel VLOOKUP Tutorial for Beginners: Learn with Examples
• CSV vs Excel (.xls) - What's the Difference?
• Excel ISBLANK Function: Learn with Example
• SUMIF function in Excel: Learn with EXAMPLE
• Sparkline in Excel with EXAMPLES
• Macros & VBA in Excel
• Creating your First Visual Basic for Applications (VBA) in Excel
• Introduction to Macros in Excel
• VBA Arrays
• VBA Data Types, Variables & Constant
• VBA Excel Form Control & Activex Control
• VBA String Operators
• VBA Arithmetic Operators
• VBA Comparison Operators
• Excel VBA Call a Subroutine
• VBA Logical Operators
• VBA Range Objects
• Excel VBA Function Tutorial: Return, Call, Examples