Business Intelligence with Advanced Excel & Power BI

Course Instructor

Microsoft Excel Expert

With 8+ years in data analytics and business intelligence, I’ve trained over 500 professionals in Excel and Power BI for impactful decision-making. As a Business Intelligence Consultant, I specialize in advanced Excel, Power BI dashboards, and data storytelling, delivering scalable solutions for top organizations. Certified in Microsoft Data Analysis and Power BI, I focus on hands-on, practical training to empower learners with real-world skills and confidence.

Part: 01 - Advanced Excel Course Outline

1 - Introduction

• Introduction

2 - Using SUMIF, AVERAGEIF, and COUNTIF

• -Summarizing Data with SUMIF

• - Summarizing Data with AVERAGEIF

• - Summarizing Data with COUNTIF

3 - Using Advanced Lookup Functions

• - Using VLOOKUP with TRUE to Find an Approximate Match

• - Using HLOOKUP with TRUE to Find an Approximate Match

• - Using the INDEX Function

• - Using the MATCH Function

• - Creating a Combined INDEX and MATCH Formula

• - Comparing Two Lists with VLOOKUP

• - Comparing Two Lists with a Combined VLOOKUP and ISNA

4 - Using Complex Logical and Text Functions

• - Creating a Nested IF Function

• - Using the IFERROR Function

• - Using the LEN Function

• - Using the TRIM Function

• - Using the SUBSTITUTE Function

5 - Formula Auditing

• - Showing Formulas

• - Tracing Cell Precedents and Dependents

• - Adding a Watch Window

• - Error Checking

6 - What-If Analysis Tools

• - Using the Scenario Manager

• - Using Goal Seek

• - Analyzing with Data Tables

7 - Worksheet and Workbook Protection

• - Protection Overview

• - Excel File Password Encryption

• - Allowing Specific Worksheet Changes

• - Adding Protection to Only Certain Cells in a Worksheet

• - Additional Protection Features

8 - Advanced Use of PivotTables and PowerPivot

• - Using the PivotTable and PivotChart Wizard

• - Adding a Calculated Field

• - Adding a Calculated Item

• - Applying Conditional Formatting to a PivotTable

• - Filters in the PivotTable Fields Pane

• - Creating Filter Pages for a PivotTable

• - Enabling the PowerPivot Add-In

9 - Automating with Macros

• - What are Macros?

• - Displaying the Developer Tab & Enabling Macros in Excel

• - Creating a Basic Formatting Macro

• - Running a Macro

• - Assigning a Macro to a Button

• - Creating a More Complex Macro

• - Viewing and Editing the VBA Code for an Existing Macro

• - Adding a Macro to the Quick Access Toolbar

10 - Working with Form Controls

• - What are Form Controls?

• - Adding Spin Buttons and Check Boxes to a Spreadsheet

• - Adding a Combo Box to a Spreadsheet

11 - Ensuring Data Integrity

• - What is Data Validation?

• - Restricting Data Entry to Whole Numbers

• - Restricting Data Entry to a List

• - Restricting Data Entry to Specific Text Lengths

• - Restricting Data Entry to a Date

• - Composing Input Messages

• - Composing Error Alerts

• - Finding Invalid Data

• - Editing and Deleting Data Validation Rules

12 - Collaborating in Excel

• - Working with Comments

• - Printing Comments and Errors

• - Sharing a Workbook

• - Tracking Changes in a Workbook

• - Working with Versions

• - Sharing Files Via Email

13 - Importing and Exporting Data to a Text File

• - Importing a Text File into Excel

• - Exporting Data to a Text File

14 - Conclusion

• - Course Recap

Part: 02 - Microsoft Power BI - Data Analysis Practitioner

1 - Analyzing Data with Self-Service BI

• - Data Analysis and Visualization for Business Intelligence

• - Self-Service BI with Microsoft Power BI

2 - Connecting to Data

• - Create Data Connections

• - Model Data with Relationships

• - Save Power BI Files

3 - Performing Advanced Data Modeling and Shaping

• - Clean and Transform Data with the Query Editor

• - Shape Data with the Query Editor

• - Combine and Manage Data Rows

4 - Visualizing Data with Power BI

• - Create Visualizations in Power BI

• - Chart Data in Power BI

5 - Enhancing Data Analysis

• - Enhance Analysis with Customized Visuals and Pages

• - Enhance Analysis with Tooltips

6 - Modeling Data with Calculations

• - Create Calculations with Data Analysis Expressions (DAX)

• - Create Calculated Measures and Conditional Columns

7 - Creating Interactive Visualizations

• - Create and Manage Data Hierarchies

• - Filter and Slice Reports

• - Create Dashboards in Power BI

Course Fee: BDT 8000-12000 only
Register Now

Need More Information?

Call Us

01404090700

Social Logo Social Logo Social Logo Social Logo Social Logo Social Logo Social Logo