Advanced Microsoft Excel

Advanced Microsoft Excel

This course is designed for Intermediate users, although any user should be able to complete this course, it would be much better if users had Intermediate level knowledge. The first part of this course is a revision section covering some of the intermediate topics. After the revision section users should at the right level for this course. The course is divided into nine sections. After each section there is a consolidation exercise, instructions for the exercise are explained by and a small video. After a student has completed the exercise the tutor will demonstrate how to complete the exercises correctly.

Section 0- Revision - Functions, Pivot tables, linking sheets, conditional formating, subtotal and data analysis.

Section 1- Functions - Ifs, countifs, sumifs, averageifs, index, match and forecast.ets

Section 2 - Data Analysis - Scenarios, Goal seek, Data tables, Solver and Forecast Sheets

Section 3 - Power Query, Power Pivot and Pivot table calculations

Section 4 - Text Functions - Concatenate, search, len, right, mid, iferror and database functions

Section 5 - Vlookup - Web links, advanced vlookup features

Section 6 - Macros - Record macros, add macros to command buttons

Section 7 - Form Controls - How to create form controls without using VBA

Section 8 - Data validation - How to create interdependent lists, how to use Indirect

Section 9 - Final consolidation exercise

Get the best from Microsoft Excel with some great functions, techniques and features.

Url: View Details

What you will learn

• Advanced Excel techniques
• Understand how Power Pivot works, create relationships between data sets
• Use the What IF analysis tools, Goal Seek, Scenario Manager, Data Tables and Solver

Rating: 4

Level: Expert Level

Duration: 7 hours

Instructor: Stephen Saxton