Excel and Power BI Course

Lesson 1 • Managing Workbooks and Sheets

Covers sheet operations, file formats, and workbook protection. These skills ensure data integrity and professional file management.

Lesson 2 • Navigating the Excel Interface

Covers the Ribbon, Quick Access Toolbar, and workbook structure. Establishes the spatial awareness needed for all subsequent Excel tasks.

Lesson 3 • Formatting Cells and Worksheets

Applies number formats, fonts, borders, and conditional formatting to raw data. Clean formatting improves readability and prepares data for reporting.

Lesson 1 • Text and Date Functions

Applies LEFT, RIGHT, MID, TEXT, CONCATENATE, and date functions to manipulate strings and dates. These functions clean and transform raw data for analysis.

Lesson 2 • Logical and Conditional Functions

Teaches IF, AND, OR, NOT, and nested logic to build decision-driven formulas. Logical functions enable dynamic outputs based on data conditions.

Lesson 3 • Mathematical and Statistical Functions

Covers SUM, AVERAGE, COUNT, MIN, MAX, and ROUND families. These functions handle the majority of quantitative business calculations.

Lesson 4 • Formula Syntax and Cell References

Explains formula structure, operator precedence, and absolute vs. relative references. Correct referencing is the foundation of all reusable formulas.

Lesson 1 • Power Query for Data Transformation

Introduces Power Query to import, reshape, and merge data from multiple sources. Power Query automates repeatable cleaning steps without manual intervention.

Lesson 2 • Sorting, Filtering, and Structured Tables

Converts ranges to Excel Tables and applies multi-level sort and filter. Structured tables enforce consistency and enable dynamic formula ranges.

Lesson 3 • Text-to-Columns and Flash Fill

Uses Text-to-Columns and Flash Fill to split and reformat data quickly. These tools reduce manual effort when restructuring imported or pasted data.

Lesson 4 • Identifying and Fixing Data Quality Issues

Covers duplicate detection, blank handling, and inconsistent formatting. Recognizing data quality problems is the first step toward reliable analysis.

Lesson 1 • Statistical and Forecasting Functions

Uses FORECAST, TREND, CORREL, and descriptive statistics tools for data insight. Statistical functions quantify patterns and support evidence-based decisions.

Lesson 2 • Building and Configuring PivotTables

Creates PivotTables from structured data and configures rows, columns, and values. PivotTables are the fastest way to summarize large datasets interactively.

Lesson 3 • What-If Analysis and Scenario Tools

Applies Goal Seek, Scenario Manager, and Data Tables for sensitivity analysis. These tools support business decision-making by modeling variable outcomes.

Lesson 4 • Grouping, Filtering, and Slicers

Groups dates and numbers, applies filters, and adds Slicers and Timelines. These controls make PivotTables interactive for end-user reporting.

Lesson 1 • Advanced Chart Techniques

Builds combo charts, secondary axes, dynamic charts, and sparklines. Advanced techniques handle complex comparisons that standard charts cannot display.

Lesson 2 • Formatting and Customizing Charts

Applies titles, labels, legends, colors, and axis scales to charts. Consistent formatting ensures charts are readable and aligned with brand standards.

Lesson 3 • Dashboard Design Principles in Excel

Arranges charts, KPI metrics, and Slicers into a cohesive Excel dashboard. Applying layout and design principles transforms individual charts into actionable reports.

Lesson 1 • Shaping Data with Power Query in Power BI

Uses the Power Query Editor inside Power BI to clean and reshape imported data. Transformation steps applied here run automatically on every data refresh.

Lesson 2 • Connecting and Importing Data Sources

Connects Power BI to Excel files, CSV files, databases, and web sources. Reliable data connections are the entry point for every Power BI report.

Lesson 3 • Power BI Desktop Interface Overview

Explores the Report, Data, and Model views and the Power BI workflow. Understanding the interface accelerates navigation and reduces errors during development.

Lesson 4 • Building a Relational Data Model

Defines relationships between fact and dimension tables in the Model view. A well-structured model is the prerequisite for accurate DAX calculations.

Lesson 1 • Variables and Measure Optimization

Introduces VAR and RETURN syntax to simplify and optimize complex DAX expressions. Variables improve readability, reduce redundant calculations, and ease debugging.

Lesson 2 • Filter Context and CALCULATE

Explains filter context manipulation using CALCULATE and filter arguments. CALCULATE is the most powerful DAX function and enables virtually all advanced metrics.

Lesson 3 • Time Intelligence Functions

Applies TOTALYTD, SAMEPERIODLASTYEAR, DATEADD, and related functions for period analysis. Time intelligence measures are essential for financial and operational reporting.

Lesson 4 • Advanced DAX Patterns

Implements ratio-to-total, ABC classification, and dynamic segmentation patterns. These reusable patterns solve common business analysis problems efficiently.

Lesson 1 • Row-Level Security and Governance

Implements row-level security roles and manages dataset access in the Service. Security and governance ensure sensitive data reaches only authorized users.

Lesson 2 • Interactivity and Cross-Filtering

Configures slicers, drill-through, drill-down, and visual interactions. Interactivity allows end users to explore data without requiring report modifications.

Lesson 3 • Choosing and Configuring Visuals

Selects and configures bar, line, matrix, card, and map visuals for different data types. Matching visuals to data types ensures accurate and intuitive communication.

Lesson 4 • Publishing and Sharing in Power BI Service

Publishes reports to workspaces, creates dashboards, and configures sharing permissions. The Service enables collaboration and scheduled data refresh at scale.