Course Description

Have you always wanted to learn Microsoft Excel but you just don't know where to start?

Or maybe you have started, but you just don't know how to use some of the more advanced features of Excel.

Then the our complete Microsoft Excel 2016 Master Class: Beginner to Advanced is for You!

_________________________________________________________________________

What do you get with this course?

• Hours of easy-to-watch video lessons

• Downloadable Resources

• Practical activities

• Instructor support if you have any questions

• Community of students ready to help

What will you learn in this Microsoft Excel 2016 Master Class: Beginner to Advanced.

In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Excel course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Excel.

You'll start with an overview of the course and how to get started with Microsoft Excel.

You'll then learn the worksheet basics and some beginner excel strategies.

Once you understand the basics, you will learn about manipulating columns and rows, entering data, selecting cells and ranges, formulas, copying and moving, the fill handle, naming ranges, functions, formatting worksheet contents, table filters and keyboard shortcuts, and how to bring it all together. You will also learn about payment function and what if analysis, finding and fixing errors, more on working with tables, protecting your work, pivot tables, viewing large worksheets and multiple workbooks, and working with charts.

By the end of our course you will:

• Understand how Excel works and the most efficient way to do most tasks.

• Understand worksheet basics and learn keyboard shortcuts

• Learn how to manipulate columns and rows.

• Learn how to enter and edit different kinds of data: text, numbers, dates and symbols

• Learn how to select cells and ranges and discover basic formulas

• Save time copying and moving, and know how to use the fill handle

• Create names for ranges or individual cells and work with SUM and many other functions

• Format Excel worksheet content like a pro

• Learn how to modify a large Excel file to prepare it for printing

• Use Payment Function and What If Analysis

• Work with tables, pivot tables, charts and protect your work

• Find and fix errors easily

Ready to get started?