This course is designed for those interested in understanding Microsoft Excel on a deeper level.Read more.
My name is Andy Norris and I've been an engineer for 5 years. I graduated from SDSU with a bachelor's degree in mechanical engineering, and I am EIT certified in California. I currently work as a salary design engineer for a multinational diversified engineering and manufacturing corporation. I have a passion for teaching and I hope my courses help you succeed in your professional life, as well as your personal life.
Only want this course? Buy this course for
$199 $29 and keep lifetime access.
About This Course
The Advanced Microsoft Excel Master Class course is designed for professionals that want to learn the advanced ins and outs of Excel to help boost your productivity and skills for work or personal use.
Andrew explains in depth the advanced topics of Microsoft Excel including VLOOKUP, PivotTables and Macros. This is meant to be an advanced version of the Microsoft Excel Masterclass.
I’m sure if you are looking at this course, you already have some experience with excel but don’t really know how to use excel to its full power.
There are so many different buttons and features in excel that it can become really overwhelming, confusing and frustrating.
I can relate.
I’ve been using excel since high school but it wasn’t until I started getting properly trained that I really understood the different options, tools and functionalities excel really had.
It was a shift in my career.
It has made my job much easier and I now have a highly developed skill desired by employers.
If you don’t understand how to really use excel, you’ll slowly get left behind. I encourage you to take the next step in separating yourself from your peers by learning how to really use excel.
Advanced Sections Covered:
Our Promise to You
By the end of this course, you will have the knowledge to use Excel more effectively.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and develop the skill of Microsoft Excel!
|Section 1 - Vlookup|
|Inputs For Vlookup||00:00:00|
|Recap Of Vlookup First Example||00:00:00|
|Naming A Range||00:00:00|
|Name Manager – Ctrl F3||00:00:00|
|IfError Simple Use||00:00:00|
|Using Iferror With Vlookup For Clarity||00:00:00|
|Example Of Time Consuming Operation||00:00:00|
|How Vlookup Eliminates Time Consuming Operations||00:00:00|
|Approximate Match – How It Works||00:00:00|
|Vlookup And Absolute Cell References||00:00:00|
|Using Vlookup Within Cost Calculations||00:00:00|
|Adding Drop Downs & Data Validation||00:00:00|
|Example Drop Down||00:00:00|
|Using Vlookup With Drop Downs||00:00:00|
|Using Vlookup & Drop Downs Without Editing Formula||00:00:00|
|Special Paste Options & Transposing Tables||00:00:00|
|Vlookup Reports On Other Sheets||00:00:00|
|Quickly Copying Vlookup For Reports||00:00:00|
|Using Vlookup Within Vlookup, Search Using A Search||00:00:00|
|Additional Values Useful For Reports||00:00:00|
|LOOKUP Function Intro||00:00:00|
|Filtering To Sort Data Easily||00:00:00|
|Checking Lookups For Assurance||00:00:00|
|Thoughts On Reports & Performance Tracking||00:00:00|
|Using COLUMNS With Vlookup||00:00:00|
|COLUMNS & ROWS For Vlookup/Hlookup||00:00:00|
|Conditional Formatting Intro||00:00:00|
|Conditional Formatting Example||00:00:00|
|Conditional Formatting Example 2||00:00:00|
|Conditional Formatting Example 3||00:00:00|
|Conditional Formatting Data Bars||00:00:00|
|Conditional Formatting Color Scales||00:00:00|
|Conditional Formatting Icon Sets||00:00:00|
|Using The MATCH Function||00:00:00|
|Vlookup With MATCH Function||00:00:00|
|Concatenate And Using “&” To Join||00:00:00|
|Vlookup With Multiple Inputs||00:00:00|
|Section 2 - PivotTable|
|Intro To PivotTables||00:00:00|
|Creating An “Excel Table” And A PivotTable||00:00:00|
|PivotTables User Interface||00:00:00|
|Row Labels & Values||00:00:00|
|Filtering Row Labels & Cell Types||00:00:00|
|Different Types of Values||00:00:00|
|Multiple Row Labels And Stylizing PivotTables||00:00:00|
|Filtering PivotTables Part 2||00:00:00|
|Grouping PivotTable Data||00:00:00|
|In-depth Sales Tracking||00:00:00|
|Line Graphs With PivotCharts||00:00:00|
|Grouping Numbers Into Ranges||00:00:00|
|Grouping Price Ranges||00:00:00|
|Slicer Intro & Pie Graph PivotCharts||00:00:00|
|Inserting A Slicer||00:00:00|
|Formatting A Slicer||00:00:00|
|Section 3 - Macros|
|Intro To Macros||00:00:00|
|Developer Tab & VBA Editor||00:00:00|
|Golden Rules For Macros||00:00:00|
|Macro Relative References||00:00:00|
|Using Arrow Keys For Macros||00:00:00|
|Make Macros Short & Simple||00:00:00|
|Recording A Macro||00:00:00|
|Seeing What Macros Record||00:00:00|
|Adding A Command Button||00:00:00|
|VBA Coding Inside Command Button||00:00:00|
|Using Command Buttons||00:00:00|
|Hard Coding Cells In VBA||00:00:00|