Everyday Excel, Part 2
Completed by Sreeram Sivaramakrishna Iyer
June 28, 2023
17 hours (approximately)
Sreeram Sivaramakrishna Iyer's account is verified. Coursera certifies their successful completion of Everyday Excel, Part 2
What you will learn
Dynamic array functions and formulas in Excel
A variety of lookup techniques including: two-way forward, one-way reverse, and two-way reverse lookups, as well as Top 5/Bottom 5 techniques
Advanced data management tools (filtering, conditional formatting, randomizing techniques)
How to create dashboards using Pivot Tables, Pivot Charts, and Power Query
Skills you will gain
- Category: Spreadsheet Software
- Category: Model Optimization
- Category: Data Management
- Category: Data Analysis
- Category: Microsoft Excel
- Category: Financial Modeling
- Category: Regression Analysis
- Category: Pivot Tables And Charts
- Category: Data Validation
- Category: Dashboard Creation
- Category: Excel Formulas
- Category: Dashboard
