Excel Application Development Course — Excel & Data Visualization, Creating Attractive Dashboards
Become an Excel Pro by creating dynamic & impactful dashboards based on 3 practical cases (Google Analytics, ...)!
What You Will Learn
-
Learn the most frequently used Excel functions & formulas, from basic to advanced level (including Vlookup, Pivot Tables, Slicers, GETPIVOTDATA, Conditional Formatting, Dynamic Metrics, etc.)
-
Learn data analysis and data visualization through practice! Create beautiful, dynamic, and impactful dashboards!
-
3 practical cases based on real data from Google Analytics, INSEE, and Yahoo Finance
-
One unique methodology for processing 3 datasets from practical cases
Requirements
- Microsoft Excel version 2016 + Office 365
Description
Have you stepped into the professional world? If so, you must have noticed that Excel is essential for any function in any industry, not only for Bankers or Analysts, but also for Marketing (Product/Project Managers...), Digital (SEO/SEA managers, CRM, Community Managers, Business Developers, Product Owners...), Human Resources, Customer Relationship Managers, etc.
Excel is a powerful tool that has become entrenched in business processes worldwide, for analyzing sales data, budgeting, financial modeling, HR planning, etc. It can be your best friend, helping you simplify your life; but it can also be a nightmare if you don't master it well! In this course, I hope you can discover the beauty of Excel, delve into this advanced tool and master data analysis with EXCEL! To make your learning more engaging, I have structured this course by covering 3 practical cases and also addressing the trending topic of data visualization. I will also share my methodology for creating impressive interactive Excel dashboards and show you the most useful Excel functions & formulas!
Three practical cases are based on different datasets:
– Audience and sales data from an e-commerce website, extracted from Google Analytics (5000 rows)
– Data about given names in France from 1900 to 2019, extracted from INSEE (approximately 700,000 rows)
– Cryptocurrency price data from Yahoo Finance (50,000 rows)



