+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

4-Hour Live Virtual Training on Microsoft Excel from Beginner to Advance - Webinar (Recorded)

  • Webinar

  • 240 Minutes
  • August 2023
  • Simpliv
  • ID: 5715448

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.

What Basic Knowledge Required to Learn Microsoft Excel Certification Course?

  • Basics of Excel
  • Versions: Microsoft Excel 2010, 2013, 2016, 2019, 0365


  • 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

Who Should Attend

Beginning MS Excel users