Everyday Excel, Part 2
Completed by GUDIPATI VENKATA SESHA SATYA SURYA GOPAL
October 26, 2022
17 hours (approximately)
GUDIPATI VENKATA SESHA SATYA SURYA GOPAL'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: Data Transformation
- Category: Dashboard
- Category: Microsoft Excel
- Category: Problem Solving
- Category: Pivot Tables And Charts
- Category: Data Management
- Category: Data Validation
- Category: Reconciliation
- Category: Dashboard Creation
- Category: Excel Formulas
- Category: Data Analysis
