Udemy - Microsoft Excel Data Analysis for Business and Finance

Microsoft Excel Data Analysis for Business & Finance

https://WebToolTip.com

Published 8/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 2h 16m | Size: 1.29 GB

Excel Data Analysis: Learn to clean, analyze and visualize financial & business data using Excel’s most powerful tools.

What you'll learn
Understanding the Excel Interface.
Navigating Workbooks, Worksheets, and Ribbons.
Saving, Sharing, and Printing Excel Files.
Using Basic Formulas and Functions (SUM, AVERAGE, COUNT).
Understanding Relative, Absolute, and Mixed References.
Sorting and Filtering Data.
Conditional Formatting and Rules.
Using Logical Functions (IF, AND, OR).
Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH).
Creating Slicers for Dynamic Filtering.
Advanced Filtering Techniques.
Using What-If Analysis (Goal Seek, Scenario Manager, Data Tables).
Creating advanced charts (Waterfall, Histogram, Pareto).
Designing professional dashboards.
Customizing chart elements.
Using sparklines and data bars.

Requirements
A basic understanding of Excel (no advanced experience required)