Office Productivity Online Course by Udemy, On Sale Here
Get the best from Microsoft Excel with some great functions, techniques and features.
An excellent training about Microsoft
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. etsSection 2 – Data Analysis – Scenarios, Goal seek, Data tables, Solver and Forecast SheetsSection 3 – Power Query, Power Pivot and Pivot table calculationsSection 4 – Text Functions – Concatenate, search, len, right, mid, iferror and database functionsSection 5 – Vlookup – Web links, advanced vlookup featuresSection 6 – Macros – Record macros, add macros to command buttonsSection 7 – Form Controls – How to create form controls without using VBASection 8 – Data validation – How to create interdependent lists, how to use IndirectSection 9 – Final consolidation exercise
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.