Novice to Expert in One Hour - Microsoft Excel

Novice to Expert in One Hour - Microsoft Excel

As you go through the lectures, you will get familiar with Excel and all the tools it has to offer. This course takes you to the intermediate and advanced level in just a fraction of the time other courses do. You will only find purposeful and practical tricks to help you navigate Excel more efficiently, saving you valuable time.

At completion of this course, you will have mastered the most popular Excel tools. Here are just some of the topics that you will master:

• Customizing your Excel Workbook through the ribbon and quick access toolbar

• Learning formatting tricks and tips like Freezing Columns, Sorting, Filtering, Find and Replace, and more

• Data manipulation like Flash Fill, AutoSum, Remove Duplicates, and Conditional Formatting

• Mastering advanced functions and formulas (SUM, VLOOKUP, IF, CONCATENATE, DATEDIF and more...)

• Creating PivotTables to see trends in your data.

• Creating PivotCharts and Slicers to filter data in every way you want.

• Setting up your Personal Macro Workbook to use Macros and automate tasks.

• See how to utilize Macros, share them, and debug VBA when errors occur.

There are 8 lectures included. The exercise file from the videos is included as a resource for each of the lectures. You can work alongside the videos or use your own sample to challenge yourself and customize your Workbook as you see fit.

Learn all there is to know about Excel without wasting your time.

Url: View Details

What you will learn

• Learn to get familiar with Excel.
• Learn simply tips and tricks to make work easier.
• Learn how to complete graphs and PivotTables.

Rating: 4

Level: All Levels

Duration: 1.5 hours

Instructor: Taylor Nelson