Master Excel Course

Master Excel Course

Microsoft Excel Master Training that will boost your Knowledge, Skills & Personal Growth.

This course aims at providing complete knowledge about the Microsoft excel from the very basic to intermediate to advance. This course starts from the root level and goes on to the stem level. You will be taught about all the functions of basic excel, intermediate excel and advance excel all in a single course. This will help one increase their knowledge about excel. Students or employees both are in dire need of such courses as they not only add to the professional qualification but boost the self confidence of a person as well.

About the course: Master Microsoft Excel course educates students upon topics such as pivot tables, excel formulas, Vlookup, Hlookup, sorting filtering and analyzing data. This course teaches people fast and effective ways to get familiar with the Microsoft excel. It will help you become an excel expert and an on the go person at your job.

Microsoft Excel All-In-One Training
Click Here to Register

This Microsoft Excel course includes all three Levels from Beginner to Advanced

  • Microsoft Excel Level 1 – Beginner
  • Microsoft Excel Level 2 – Intermediate
  • Microsoft Excel Level 3 – Advanced

Material recorded with Excel 2016 but works in 2010, 2013, 2016, 2019 and 365.

As your instructor I will use my 17+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.

At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both Microsoft’s Excel Core and Excel Expert Exams and become certified, like me. Below are just a few of the topics that you will master:

  • Creating effective worksheets
  • Writing and editing formulas and calculations
  • Use sorting and filtering options
  • Build a database right the first time and avoid common design flaws
  • Creating informative and captivating Charts
  • Eliminate repetitive tasks instantly using Macros
  • Create many scenarios with varying groups of data
  • Manage large ranges of data in a List or Table

Target students: This course is best suited for beginners with limited knowledge of excel looking to sharpen their skills thereby getting a better grasp at more advance topics. This course can also be applied for by advanced users of excel looking for different perspective, wish to brush up their skills and start learning from the very beginning. People who want a good reference and want to learn shortcuts and techniques in excel can also apply for the master excel training course.

microsoft excel master certification  Basic Excel Course Outline

Getting Started with Microsoft Office Excel 2016

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data Topic E: Use Excel Help

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

microsoft excel master certification  Intermediate Excel Course Outline

 Working with Functions

  • Work with Ranges name
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

 Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analyzing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and Pivot Charts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with Pivot Charts
  • Filter Data by Using Timelines and Slicers

microsoft excel master certification  Advanced Excel Course Outline

Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

Using Lookup Functions and Formula Auditing

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

Creating Sparklines and Mapping Data

  • Create Sparklines
  • Map Data

Forecasting Data

  • Determine Potential Outcomes using Data Tables
  • Determine Potential Outcomes using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends
× How can I help you?