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.
• Introduction
• -Summarizing Data with SUMIF
• - Summarizing Data with AVERAGEIF
• - Summarizing Data with COUNTIF
• - 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
• - Creating a Nested IF Function
• - Using the IFERROR Function
• - Using the LEN Function
• - Using the TRIM Function
• - Using the SUBSTITUTE Function
• - Showing Formulas
• - Tracing Cell Precedents and Dependents
• - Adding a Watch Window
• - Error Checking
• - Using the Scenario Manager
• - Using Goal Seek
• - Analyzing with Data Tables
• - Protection Overview
• - Excel File Password Encryption
• - Allowing Specific Worksheet Changes
• - Adding Protection to Only Certain Cells in a Worksheet
• - Additional Protection Features
• - 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
• - 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
• - What are Form Controls?
• - Adding Spin Buttons and Check Boxes to a Spreadsheet
• - Adding a Combo Box to a Spreadsheet
• - 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
• - Working with Comments
• - Printing Comments and Errors
• - Sharing a Workbook
• - Tracking Changes in a Workbook
• - Working with Versions
• - Sharing Files Via Email
• - Importing a Text File into Excel
• - Exporting Data to a Text File
• - Data Analysis and Visualization for Business Intelligence
• - Self-Service BI with Microsoft Power BI
• - Create Data Connections
• - Model Data with Relationships
• - Save Power BI Files
• - Clean and Transform Data with the Query Editor
• - Shape Data with the Query Editor
• - Combine and Manage Data Rows
• - Create Visualizations in Power BI
• - Chart Data in Power BI
• - Enhance Analysis with Customized Visuals and Pages
• - Enhance Analysis with Tooltips
• - Create Calculations with Data Analysis Expressions (DAX)
• - Create Calculated Measures and Conditional Columns
• - Create and Manage Data Hierarchies
• - Filter and Slice Reports
• - Create Dashboards in Power BI