Everyday Excel, Part 2
Completed by BUGATHA NAGA VENKATA SAI DINESH NAI VU22CSEN0100384
September 1, 2022
17 hours (approximately)
BUGATHA NAGA VENKATA SAI DINESH NAI VU22CSEN0100384'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 Creation
- Category: Dashboard
- Category: Problem Solving
- Category: Microsoft Excel
- Category: Reconciliation
- Category: Pivot Tables And Charts
- Category: Data Management
- Category: Excel Formulas
- Category: Data Analysis
- Category: Data Validation
