Blog
Library

4-Hour Live Virtual Training on Microsoft Excel from Beginner to Advanced

In this special Microsoft Excel Complete Course from Beginner to Advance you can learn most important features of MS Excel, All in One place like Dashboards, Pivot Tables, Functions, Vlookup, Visualization tools, Automate with Macros and more.
  • Training Type
    Live Training
  • Category
    MS Excel
  • Duration
    4 Hours
  • Rating
    5/5
4-Hour Live Virtual Training on Microsoft Excel from Beginner to Advanced

Microsoft Excel Certification Course Introduction

About Microsoft Excel Certification Course

This course begins with getting you familiar with the MS Excel interface, menu systems, and Ribbon and how to enter and organize, format data, how to create formulas using simple functions and learn how to use absolute and relative referencing with your functions in Excel. Then it progresses to more advanced features like building charts, conditional formatting, SmartArt, PivotTables and PivotCharts, working with multiple worksheets, using advanced functions like IF, VLookup, PMT. You will also learn to automate tasks using Macros and use data analysis tools like Goal Seek and the Scenario Manager.

Microsoft Excel Certification Course Objective

Understand Excel’s Menu system and perform simple to advanced calculations easily

Get time saving tips and tricks to improve efficiency

Learn how to perform printing and charting capabilities in Excel

Learn to work with multiple worksheets and workbooks

Learn data management and analysis techniques with data validation, sorting, and using filter

Understand how to create PivotTables and Pivot Charts to make your spreadsheets more appealing and easier to read

Automate routine steps with Macros to save your valuable time.

Who is the Microsoft Excel Certification Course Target Audience?

Beginning MS Excel users  

What Basic Knowledge Required to Learn Microsoft Excel Certification Course?

Basics of Excel

Versions: Microsoft Excel 2010, 2013, 2016, 2019, 0365

Related Virtual Classroom
Have Any Queries
Call Us : +510-849-6155
Email : support@simplivlearning.com

Available Batches

14 Dec 2023 Thu ( 1 Day ) Filling Fast12:00 PM - 04:00 PM (Eastern Time)
17 Jan 2024 Wed ( 1 Day ) 12:00 PM - 04:00 PM (Eastern Time)
15 Feb 2024 Thu ( 1 Day ) 12:00 PM - 04:00 PM (Eastern Time)
19 Mar 2024 Tue ( 1 Day ) 12:00 PM - 04:00 PM (Eastern Time)
22 Apr 2024 Mon ( 1 Day ) 12:00 PM - 04:00 PM (Eastern Time)

Pricing

Live
Single Attendee
149 249
Live Session
Recorded
Single Attendee
199 332
6 month Access for Rec
Live+Recorded
Single Attendee
249 416
6 month Access for Rec
Contact Support for Group Offers

Require a Different Batch?

Request a Batch For

Microsoft Excel Certification Course Curriculum
Total Duration : 4 Hours
Navigate and Explore Excel
Fill Data Easy with Fill Handle
Flash Fill
Basic Functions - Sum, Avg, Min, Max, Count
SubTotals
Date and Text Functions
Absolute and Relative Cell Reference
Advanced Function If, VLookup, PMT
What If Analysis tools - Goal seek and Scenario Manager
Auditing Errors
Visualization tools – Conditional Formatting, Charts, SmartArt
PivotTable and PivotCharts
Automate with Macros
Keyboard Shortcut List
Several Tips and Tricks throughout