Novice to Expert in One Hour - Microsoft Excel

What you'll learn
Learn to get familiar with Excel.
Learn simply tips and tricks to make work easier.
Learn how to complete graphs and PivotTables.
Learn VBA and Macros to automate routine tasks.
Requirements
No programming experience or prior experience with Excel needed.
Description
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.
Who this course is for
Those who want to automate their Excel work and learn only practical tools.
Homepage

https://www.udemy.com/course/novice-to-expert-in-one-hour-microsoft-excel/