Excel & Data Visualization, creating impactful dashboards
Excel & Data Visualization, creating impactful dashboards
Duration: 3h 52m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 2.36 GB
Genre: eLearning | Language: English
Duration: 3h 52m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 2.36 GB
Genre: eLearning | Language: English
Become an Excel Pro by creating dynamic & impactful dashboards based on 3 practical cases (Google Analytics, ..)!
What you'll learn
Learn the most used Excel functions & formulas, from basic to advanced level (incl. Vlookup, Pivot Table, Slicer, GETPIVOTDATA, Conditional formatting, Dynamic metric, etc.)
Learn data analysis and data visualization by practicing! Create beautiful, dynamic and impactful dashboards!
3 practical cases based on the real data from Google Analytics, INSEE and Yahoo Finance
One unique methodology for processing the 3 dataset of the practical cases
Requirements
Microsoft Excel version 2016 + ou Office 365 (ps. certain functions or tips may not be applicable to previous versions)
Description
Have you already stepped into the professional world? If yes, you must have noticed that Excel is essential to any function in any industry, not only Bankers or Analysts, but also Marketing (Product/Project manager…), Digital (SEO/SEA managers, CRM, Community manager, Business developer, Product owner…), HR, Client relationship manager etc.
Excel is a powerful tool that has become entrenched in business processes worldwide, for analyzing sales data, budgeting, financial modelling, HR planning etc.. It can be your best friend, helping you to simplify your life; but it could also be a nightmare if you don't master it well! Within this course, I hope you can discover the beauty of Excel, perform a deep-dive into this powerful tool and master data analysis with EXCEL! To make your learning more attractive, I organize this course by going through 3 practical cases and also cover the trendy topic of data visualization. I will also share my methodology to create impressive interactive Excel dashboards and show you the most useful Excel functions & formulas!
The 3 practical cases are based on different sets of data:
- Audience and sales data of an e-commerce site, extracted from Google Analytics (c. 5000 lines)
- Data on names given in France from 1900 to 2019, extracted from INSEE (c. 700 000 lines)
- Data on prices of Cryptocurrency, from Yahoo Finance (c. 50 000 lines)
I hope that this course can help you to improve your Excel skills and impress your (future) colleagues! Are you ready? Let’s GO!
****** You can also find the SYLLABUS of this course in the introduction section.******
Who this course is for:
Anyone who would like to learn how to create impressive dynamic and impactful dashboards that lead to better decisions
Anyone using Excel in their daily work and particularly those target to pursue a career as a Data analyst or Business analyst
Beginners who would like to get familiar with different functions of Excel by going through real cases
But also advanced users who would like to gain in productivity and discover a methodology to build dynamic and impactful dashboards
More Info