The Complete Excel Guide: Beginners to Advanced

Preview this course

This video course will help you learn all the basic and advanced concepts of Microsoft Excel 2019. You’ll start with Excel basics and slowly move to the advanced concepts in Excel. Each section is accompanied by an exercise at the end to practice what you have learned.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
160 on-demand videos & exercises
Level: Beginner
English
15hrs 35mins
Access on mobile, web and TV

What to know about this course

Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential and learning it thoroughly will improve your productivity drastically. This course will help you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities. 

We’ll start with the basic topics and see what’s new in Excel 2019. Then we will create workbooks; enter data into; explore page setup and print options; work with rows, columns, and cells; learn how the Cut, Copy, and Paste option works; understand functions and formulas; and also get introduced to PivotTables, logical, and lookup formulas. After this, we will move towards advanced concepts such as lookup and advanced lookup functions, financial functions including calculating interest and depreciation, statistical functions, learning how to connect to other workbooks and datasets outside of Excel, and creating awesome visualizations using sparklines and data bars. We’ll also cover some advanced charts such as Surface, Radar, Bubble, and Stock Charts. 

By the end of this course, you’ll become proficient in using Microsoft Excel for your professional and personal needs.  All the resources for this course are available at https://github.com/PacktPublishing/The-Complete-Excel-Guide-Beginners-to-Advanced

Who's this course for?

This course is designed for anyone who is interested in mastering Microsoft Excel 2019 and becoming an expert in Microsoft Excel. To get started with this course, you need to have basic computer skills and Microsoft Office installed on your computer.

What you'll learn

  • Grasp techniques to back up and recover your Excel spreadsheets.
  • Discover the essentials of using formulas and functions in Excel.
  • Discover what’s new or different in Excel 2019.
  • Learn to effectively use autofill and flashfill.
  • Discover how to create stunning charts and graphs in Excel.
  • Learn practical methods to sort and filter your data in Excel.

Key Features

  • Gain a solid understanding of Microsoft Excel 2019.
  • Uncover amazing Microsoft Excel suite techniques and shortcuts to make your job easy .
  • Learn how to add life to your Excel spreadsheets by creating stunning charts and graphs.

Course Curriculum

About the Author

Simon Sez IT

Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.