Microsoft Excel Training Tutorial: Learn in 7 Days

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

 TutorialIntroduction to Microsoft Excel
 TutorialHow to Add, Subtract, Multiply, Divide in Excel
 TutorialExcel Data Validation, Filters, Grouping
 TutorialIntroduction to formulas and functions in Excel
 TutorialLogical functions (operators) and conditions in Excel
 TutorialVisualizing data using charts in Excel
 TutorialCase Study: Managing personal finance using Microsoft Excel

Advance Stuff

 TutorialHow to Import XML Data into Excel [Example]
 TutorialHow to Import CSV Data (Text) into Excel [Example]
 TutorialHow to Import MS Access Data into Excel [Example]
 TutorialHow to Import SQL Database Data into Excel [Example]
 TutorialPivot Tables in Excel: Beginner’s Guide
 TutorialCreating Advanced Charts in Excel
 TutorialExcel in the cloud: Office 365
 TutorialCSV vs Excel (.xls) – What’s the Difference?
 TutorialExcel VLOOKUP Tutorial for Beginners: Learn with Examples
 TutorialExcel ISBLANK Function: Learn with Example
 TutorialSparkline in Excel with EXAMPLES
 TutorialSUMIF function in Excel: Learn with EXAMPLE
 TutorialTop 40 Microsoft Excel Interview Questions & Answers
 TutorialTop 10 Excel Formulas Asked in an Interview & Answers
 Tutorial20 Best Excel Courses
 Tutorial17 BEST Excel Alternatives
 Tutorial15 BEST Excel Books
 Tutorial85 Best Microsoft Office Classes Courses
 TutorialExcel PDF

Macros & VBA in Excel

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

Be the first to comment

Leave a Reply

Your email address will not be published.


*