Analysing and Visualising Data with Microsoft Excel – PC version

OVERVIEW

Excel is one of the most requested analysis tools in the job market. The ability to use it to an advanced level is a desirable skill.

Completing the course will enable you to create advanced analyses of your own, and know how to overcome common problems. The course includes a few “wrong turns”, so you can confidently identify common problems which might arise.

WHO IS THE COURSE FOR?

This course is ideal for those who already use Excel for PC to create data analysis but need to create more advanced analyses, combine various sets of data, or manipulate existing data sets.

This reporting course is suitable for those with little or no prior experience of Pivot Tables, Get and Transform (Power Query), and Power Pivot. The difficulty level increases steadily.

This course is not for those with existing knowledge of the advanced functionality of Get and Transform and Power Pivots. However, later lectures cover some more advanced topics, including the M and DAX languages.

LEARNING PATH

REVIEWS

“This course appears to be the fastest, easiest way to learn what the market is demanding. The professor is knowledgeable, enjoys teaching, is easy to follow, responds almost immediately to questions, and keeps his courses updated. I especially like how he includes his own tips in the course, rather than just repeating what Microsoft wants.” Frank

“Love the course. Easy to follow and well structured. Philip, thank you for your course!” Van Linh

“Detailed and methodical approach to learning.” Ogbu Uche