Excel Data Insights: Power Query Pivot Analysis and Visuals
Excel Data Mastery: Use Power Query, Pivot Tables, and Visualization Techniques to Deliver Clear and Actionable Business
0
students
2.5 hours
content
Aug 2025
last update
$19.99
regular price
What you will learn
Understanding the Excel Interface
Navigating the Excel Window
Working with Worksheets and Workbooks
Entering Data into Cells
Applying Cell Styles and Formatting
Basic Arithmetic Operations (+, -, *, /)
Using Built-in Functions (SUM, AVERAGE, COUNT, etc.)
Sorting Data in Ascending or Descending Order
Filtering Data Based on Specific Criteria
Creating Pivot Tables to Summarize and Analyze Data
Customizing Pivot Tables with Slicers and Filters
Performing Descriptive Statistics (mean, median, mode, standard deviation, etc.)
Scatter Plots and Bubble Charts
Applying Conditional Formatting Rules
Creating Data Bars, Color Scales, and Icon Sets
Accessing and Transforming Data from Various Sources (Excel, CSV, text, web, etc.)
Merging and Appending Data
Shaping and Transforming Data
Building Interactive Reports with Power Pivot and Power BI and more....
Course Gallery
Loading charts...
6790885
udemy ID
25/08/2025
course created date
03/09/2025
course indexed date
Bot
course submited by