Microsoft Excel – From Beginner to Expert with examples

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Latest Version Excel for Windows

This training provides you everything you need to know about Microsoft Excel.

What you’ll learn

  • How to navigate around Excel.
  • How to enter and edit data in Excel.
  • How to enter and edit data in Excel.
  • How to write formulas quickly and easily with the point-and-click method.
  • How to use relative, absolute, and mixed references in Excel.
  • How to create powerful calculations with Excel functions.
  • How to visually represent your data with charts and graphs in Excel.
  • How to use Excel data tools like sorting, subtotaling, and filtering.
  • How to “freeze columns and rows” with freeze panes in Excel.
  • How to remove duplicates from data in Excel.
  • How to “transpose data” – switching the columns and rows in Excel.
  • How to use Excel to leverage data with Pivot Tables & Pivot Charts.
  • How to format worksheets in Excel for impact and appeal.
  • How to automate Excel tasks with time-saving macros.
  • How to integrate Microsoft Excel with Microsoft Word.
  • How to use passwords in Excel to protect your work in multiple scenarios.
  • How to tricks about Excel, as well as Excel secrets and shortcuts.
  • How to use printing and sharing in Excel What will i learn?.

Course Content

  • Introduction –> 1 lecture • 3min.
  • Microsoft Exel Basics –> 10 lectures • 2hr 31min.
  • Microsoft Excel Advanced –> 17 lectures • 52min.

Microsoft Excel - From Beginner to Expert with examples

Requirements

  • In order to participate in the hands-on portions of this course, you will need to have Microsoft Excel..

This training provides you everything you need to know about Microsoft Excel.

From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel.

The course covers all of Excel´s must-know features which include the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros Data Validation, Excel new features and keyboard shortcuts!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in Microsoft Excel.

The course is designed for Excel 2007, 2010, 2013 2016 or 2019. There are 28 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to work with various time saving Formulas, create automated reports with the press of a button, WOW your boss with stunning Excel Charts and get noticed.

Get Tutorial