Search courses
Skip to main content
MyExcelOnline
toggle menu Menu
  • Microsoft Project

    • Project Cheat Sheet
    • Resource Files
    • What is Microsoft Project
    • The Project Interface
    • Project Management Phases
    • Create a new Project Plan
    • Create a Project Calendar
    • Creating Project Tasks
    • Placeholder Text and Task Types
    • Create Work Breakdown Structure
    • Define Task Relationships
    • Tying Up Loose Ends
    • Add Resources to Project Plan
    • Creating a Resource Calendar
    • Assign Resources to Tasks
    • Resolve Resource Conflicts
    • Optimize the Project Plan
    • Cost of the Project
    • Adding Additional Resources
    • Setting a Baseline
    • [QUIZ] Project Introduction
    • Your Assignment - Create a Project plan
    • Unlock your Certificate of Completion
  • Microsoft SharePoint

    • SharePoint Cheat Sheet
    • What is SharePoint
    • SharePoint Look Book
    • Getting SharePoint and Home Page Overview
    • Create a New Team Site in SharePoint
    • Team Site Home Page in SharePoint
    • Uploading Files in SharePoint
    • Creating a New List in SharePoint
    • Adding Web Parts in SharePoint
    • Reorganizing and Customizing Web Parts in SharePoint
    • Republish Team Site in SharePoint
    • Add Members to Team Site in SharePoint
    • Teams and Sharepoint Integration
    • Create a New Communication Site in SharePoint
    • Add Countdown Timer Web Part in SharePoint
    • Edit Web Part Layouts in SharePoint
    • Edit Sections in SharePoint
    • Add Youtube Web Part in SharePoint
    • Change Page Look and Editing Navigation in SharePoint
    • Create a News Post in SharePoint
    • Manage Site Access in SharePoint
    • [QUIZ] SharePoint Introduction
    • Your Assignment - Create a SharePoint site
    • Unlock your Certificate of Completion
  • Microsoft Power Apps

    • Power Apps Cheat Sheet
    • How to access Power Apps
    • Create Excel Data Source in Power Apps
    • Creating the Power App
    • Previewing the Power App
    • Tree View in Power Apps
    • Edit Properties in Power Apps
    • Insert New Item in Power Apps
    • Insert New Screen in Power Apps
    • Actions in Power Apps
    • Additional Options in Power Apps
    • Save and Distribute the Power App
    • Mobile Power App
    • [QUIZ] Power Apps - Introduction
    • Your Assignment - Create an app
    • Unlock your Certificate of Completion
  • Microsoft Power Automate

    • Power Automate Flows Cheat Sheet
    • Accessing Power Automate
    • First Power Automate Template Flow
    • Test run your first Power Automate Flow
    • My Power Automate Flows
    • Power Automate Templates Overview
    • Power Automate Connectors Overview
    • Different Power Automate Flow Types
    • Create a Power Automate Flow from scratch
    • Test run your New Power Automate Flow
    • Book Order Tracker Power Automation - Introduction
    • Book Order Tracker Power Automation
    • [QUIZ] Power Automate - Introduction
    • Your Assignment - Create an automation
    • Unlock your Certificate of Completion

  • SQL

    • SQL Cheat Sheet
    • Resource Files
    • 01 - What You Will Learn in this SQL course
    • 02 - All About SQL
    • 03 - Setting Up Your SQL Training Ground
    • 04 - SQL Data Manipulation
    • 04 - Running the Initial SQL File
    • 05 - Simple SQL Queries
    • 06 - Simple SQL Queries (exercise)
    • 07 - Advanced Simple SQL Queries
    • 08 - Advanced Simple SQL Queries (exercise)
    • 09 - SQL Joins
    • 10 - SQL Joins (exercise)
    • 11 - SQL Subqueries
    • 12 - SQL Subqueries (exercise)
    • 13 - More SQL Examples and Exercises!
    • [QUIZ] SQL - Introduction
    • Your Assignment - What are the averages of the Mouse Family?
    • Unlock your Certificate of Completion

  • Beginner - Introduction

    • A message from John Michaloudis!
    • Excercise Files
    • Download Workbooks
    • Course Intro
    • Launching Excel
    • Excel Interface 
    • Quick Access Toolbar
    • Workbook Structure
    • Saving
    • Opening Workbooks
    • Entering Data
    • Entering Numeric Data
    • Entering Dates
    • [QUIZ] Beginner - Introduction
    • Unlock your Certificate of Completion
  • Beginner - Formulas

    • Download Workbooks
    • Cell References
    • Basic Formulas
    • Relative vs. Absolute References
    • Order of Operation
    • Function Basics
    • Sum
    • Min & Max
    • Average
    • Count
    • AutoSum
    • AutoFill
    • [QUIZ] Beginner - Formulas
    • Unlock your Certificate of Completion
  • Beginner - Formatting

    • Download Workbook
    • Copy, Cut & Paste
    • Adding & Deleting Rows or Columns
    • Column Widths
    • Hide & Unhide Columns
    • Delete Worksheets
    • Renaming Worksheets
    • Move & Copy Worksheets
    • Font Formatting
    • Fill & Font Color
    • Adding Borders
    • Formatting Numbers as Currency
    • Formatting Numbers as Percentage
    • Format Painter
    • Cell Styles
    • Merge & Center
    • Conditional Formatting
    • [QUIZ] Beginner - Formatting
    • Unlock your Certificate of Completion
  • Beginner - Charts

    • Download Workbook
    • Inserting Images
    • Shapes
    • Formatting Shapes
    • Smart Art
    • Creating Charts
    • Chart Elements & Layout
    • Chart Data
    • Chart Formatting
    • Chart Location
    • Pie Chart
    • [QUIZ] Beginner - Charts
    • Unlock your Certificate of Completion
  • Beginner - Printing

    • Download Workbook
    • Print Preview
    • Print Settings
    • Page Layout
    • Header & Footer
    • Print Area
    • Template Intro
    • Open Existing Templates
    • Custom Templates
    • [QUIZ] Beginner - Printing
    • Unlock your Certificate of Completion

  • Intermediate - Formulas

    • A message from John Michaloudis!
    • Download Workbooks
    • Cheat Sheet - Top 7 Formulas!
    • Creating a Named Range
    • IF
    • Nesting the IF & AND Functions
    • COUNTIF
    • COUNTIFS
    • SUMIF
    • IFERROR
    • VLOOKUP
    • HLOOKUP
    • INDEX & MATCH
    • LEFT, RIGHT & MID
    • LEN
    • SEARCH
    • CONCATENATE
    • Trace Precedents
    • Trace Dependents
    • Watch Window
    • Show Formulas
    • Worksheet protection
    • Workbook Structure Protection
    • Workbook Password
    • DATE & REGIONAL LOCATION SETTINGS
    • DATEDIF
    • DATEVALUE
    • DAY
    • DAYS
    • EOMONTH
    • HOUR
    • MONTH
    • NETWORKDAYS
    • TODAY
    • WEEKDAY
    • WEEKNUM
    • WORKDAY
    • YEAR
    • [QUIZ] Intermediate - Formulas
    • Unlock your Certificate of Completion
  • Intermediate - Pivot Tables

    • Downloadable Workbooks
    • New Intermediate Pivot Table Videos - Uploaded 02.2020
    • Cheat Sheet - 5 Speedy Steps to an Excel Pivot Table
    • Cheat Sheet - The Top Pivot Table Features
    • Setting Up Your Data - Tabular Format
    • No Gaps in your data
    • Formatting your data
    • Excel Tables
    • Clean Your Data Set
    • Inserting a Pivot Table
    • Field List - Activate, move, resize & layout
    • Field List & Areas
    • Drill down to audit
    • Sort Field List from A to Z
    • Double click on any labels to show more Fields
    • Defer Layout Update
    • Pivot Cache explained
    • Refresh a Pivot Table
    • Clear Filters & Clear Pivot
    • Select & format
    • Move a Pivot Table
    • Pivot Table Styles
    • Customize Pivot Table Styles
    • Pivot Table Subtotals
    • Pivot Table Grand Totals
    • Pivot Table Report Layouts
    • Pivot Table Blank Rows
    • Expand & Collapse buttons
    • Move & Remove Fields and Items
    • Show/Hide Field List
    • Show/Hide Field Headers
    • Change Count of to Sum of
    • Number formatting
    • Field name formatting
    • Change Sum views in Label Areas
    • Indent rows in compact layout
    • Change the layout of a report filter
    • Format error values
    • Format empty cells
    • Printing a pivot table on two pages
    • Show Report Filter on multiple pages
    • Create multiple subtotals
    • Count
    • Average
    • Maximum
    • Minimum
    • Product
    • Count Numbers
    • Show Various Grand Totals
    • Shortcuts to access Value Field Setting & Summarize Values By
    • Percentage of Grand Total
    • Percentage of Column Total
    • Percentage of Row Total
    • Percentage Of
    • Difference From
    • Percentage Difference From
    • Running Total In
    • Percentage Running Total In
    • Shortcuts to Show Values As
    • CASE STUDY: Actual v Plan Variation
    • Group by Days
    • Group by Months
    • Group by Quarters & Years
    • Group by Sales ranges
    • Group by Text fields
    • Group by Time
    • Sort by Largest or Smallest
    • Sort an Item Row (Left to Right)
    • Sort Manually
    • Sort using a Custom List
    • Filter by Dates
    • Filter by Labels - Text
    • Filter by Labels - Numerical Text
    • Filter by Values
    • Filter by Values - Top or Bottom 10 Items
    • Filter by Values - Top or Bottom Percent
    • Filter by Values - Top or Bottom Sum
    • Filter by Report Filter
    • Insert a Slicer
    • Slicer Styles
    • Slicer Settings
    • Slicer Size & Properties
    • Slicer Connections for multiple pivot tables
    • Different ways to filter a Slicer
    • CASE STUDY: Select a Monthly Profit & Loss Report with a Slicer
    • Creating a Calculated Field
    • Use an existing Calculated Field in a new calculation
    • Editing a Calculated Field
    • Excel Formulas and Calculated Fields
    • Creating a Calculated Item
    • Use an existing Calculated Item in a new calculation
    • Editing a Calculated Item
    • Excel Formulas and Calculated Items
    • Calculated Item on Column Labels
    • Shortcomings of Calculated Items
    • CASE STUDY: Actuals v Plan with Calculated Fields
    • Insert a Pivot Chart
    • Insert a Slicer with a Pivot Chart
    • Pivot Chart Designs
    • Pivot Chart Layouts
    • Pivot Chart Formats
    • Limitations of Pivot Charts & Workarounds
    • Saving a Pivot Chart template
    • Printing a Pivot Chart
    • Include a Sparkline with your Pivot Table
    • CASE STUDY: Pivot Table Slicer and Chart Dashboard
    • Intro to Conditional Formatting
    • Highlight Cells Rules based on Values
    • Highlight Cell Rules based on text labels
    • Highlight Cell Rules based on date labels
    • Top and Bottom Rules
    • Data Bars, Color Scales and Icon Sets
    • CASE STUDY: Conditionally Format your Sales results
    • [QUIZ] Intermediate - Pivot Tables
    • Unlock your Certificate of Completion
  • Intermediate - Macros & VBA

    • Download Workbook
    • Understanding Macros
    • Activate the Developer Tab
    • Recording Macros
    • Editing Macros
    • Macro Buttons
    • [QUIZ] Intermediate -Macros & VBA
    • Unlock your Certificate of Completion
  • Intermediate - Analysis

    • Download Workbooks
    • List Design
    • Quick Sorts
    • Multi Level Sorts
    • Custom Sort
    • AutoFilter
    • List Subtotals
    • Excel Tables
    • Find Duplicates with Conditional Formatting
    • Remove Duplicates
    • Data Validation Intro
    • Data Validation - List
    • Data Validation - Custom Errors
    • DSUM
    • DAVERAGE
    • DCOUNT
    • SUBTOTAL
    • Data Validation - List Formulas
    • Importing from Text
    • Importing from Access
    • Export to Text
    • Freeze Panes
    • Group & Outline
    • Printing Large Docs
    • 3D Formulas
    • Consolidate
    • Convert Text Dates to Excel Dates with Text To Columns
    • Regional Dates with Text To Columns
    • Remove Emails from Names with Text To Columns
    • Split Full Names with Text To Columns
    • Go To Blanks by Color
    • Delete Empty Rows
    • Go to Constants
    • Row Differences
    • Find & Replace Intro
    • Conditional Formatting a Cell's Value
    • Conditional Formatting to Find Blank Cells
    • What is Flash Fill?
    • Different Ways to Flash Fill
    • Extract Names
    • Combine Names
    • Hyphen Between Numbers
    • Move Text & Numbers
    • Create Emails
    • Excel Dates
    • Fix Incorrect Formatting
    • Extract Numbers from Text
    • Reformat Sales Data
    • Extract Hours & Minutes
    • Special Number Formats
    • Fill In Empty Cells
    • Goal Seek
    • Solver
    • Data Table
    • Scenario Manager
    • [QUIZ] Intermediate - Analysis
    • Unlock your Certificate of Completion
  • Intermediate - Charts

    • Download Workbooks
    • Cheat Sheet - Chart Helper Guide
    • Radar Chart
    • 100% Stacked Bar Chart
    • Clustered Bar Chart: Year over Year Comparison
    • Stacked Column Chart: Compare Contributions
    • 100% Stacked Column Chart: Percentage Contributions
    • Logarithmic Scale
    • Line Chart: Trend with lots of data
    • Pie Chart
    • XY Scatter Chart: Related Variables
    • Bubble Chart: 3 Variables On A Chart
    • Stock - Candlestick Chart
    • Organizational Chart using Smart Art
    • Sparklines - High and Low Points
    • Sparklines - WIN/LOSS
    • [QUIZ] Intermediate - Charts
    • Unlock your Certificate of Completion

  • Advanced - Formulas

    • A message from John Michaloudis!
    • Download Workbooks
    • Course Intro
    • Relative Cell References
    • Absolute Cell References
    • Variations on Absolute References
    • Name Ranges
    • Nesting Functions
    • Course Intro
    • Evaluate Formulas
    • Locating Errors in a Formula
    • Using Excel's IFERROR() Function
    • Course Intro
    • What are Arrays?
    • Nesting Array Formulas
    • Using Arrays to SUM Data
    • Streamline Conditions Using Arrays
    • Course Intro
    • INDEX() Function
    • MATCH() Function
    • Nesting INDEX() and MATCH()
    • Course Intro
    • Creating a Dynamic SUM() Using INDEX() - Part 1
    • Creating a Dynamic SUM() Using INDEX() - Part 2
    • Combine Multiplication with INDEX() and MATCH() - Part 1
    • Combine Multiplication with INDEX() and MATCH() - Part 2
    • Create a Dynamic VLOOKUP() with MATCH() - Part 1
    • Create a Dynamic VLOOKUP() with MATCH() - Part 2
    • Create a Dynamic VLOOKUP() with MATCH() - Part 3
    • Turn INDEX() and MATCH() into an ARRAY - Part 1
    • Turn INDEX() and MATCH() into an ARRAY - Part 2
    • Returning Multiple Values with INDEX() - Part 1
    • Returning Multiple Values with INDEX() - Part 2
    • Returning Multiple Values with INDEX() - Part 3
    • Returning Multiple Values with INDEX() - Part 4
    • Adding Criteria to INDEX() and MATCH() - Part 1
    • Adding Criteria to INDEX() and MATCH() - Part 2
    • Return an Associated Value Using INDEX() and MATCH() - Part 1
    • Return an Associated Value Using INDEX() and MATCH() - Part 2
    • Conditional Formatting Using MATCH() - Part 1
    • Conditional Formatting Using MATCH() - Part 2
    • CLEAN - Intro
    • FIND - Intro
    • MID - Extract Numbers Between Hyphens
    • PROPER - Intro
    • REPLACE - Intro
    • REPLACE - Phone Area Codes
    • REPLACE - Insert Hyphens In Your Serial Number
    • REPLACE - Extract Last Name
    • REPLACE - Clear Everything Before the Hyphen
    • REPLACE - Insert New Code within Old Part Numbers
    • SUBSTITUTE - Intro
    • SUBSTITUTE - Add a Comma after the Surname
    • SUBSTITUTE - Remove Second Hyphen
    • SUBSTITUTE - Count Text Occurrences in a Cell
    • SUBSTITUTE - Report Name
    • TEXT - Intro
    • TRIM - Intro
    • Convert Formulas to Values
    • Convert Text to Numbers
    • MID {ARRAY FORMULA} - Extract Cell Contents in Separate Rows
    • VLOOKUP - A TAX TABLE WITH APPROXIMATE MATCH
    • VLOOKUP - SUM MULTIPLE COLUMNS WITH DATA VALIDATION DROP DOWN MENUS
    • VLOOKUP - MULTIPLE CRITERIA
    • SUMIFS WITH DATA VALIDATION DROP DOWN MENUS
    • CONCAT
    • IFS
    • MAXIFS
    • SWITCH
    • TEXTJOIN
    • FILTER
    • LAMBDA
    • LET
    • RANDARRAY
    • SEQUENCE
    • SORT
    • SORTBY
    • UNIQUE
    • XLOOKUP
    • XLOOKUP - More Examples
    • How to use the XLOOKUP function in Excel with 7 Examples!
    • LAMBDA Function in Excel - Create Custom Functions in Excel
    • Dynamic Search List using Data Validation & Formulas
    • Nested IF Formula with VLOOKUP Formula
    • MATCH, HLOOKUP & VLOOKUP
    • [Quiz] - Advanced - Formulas
    • Unlock your Certificate of Completion
  • Advanced - Pivot Tables

    • Downloadable Workbooks
    • New Advanced Pivot Table Videos - Uploaded 02.2020
    • Refresh All
    • Refresh External Data
    • Import from Access database
    • Change Data Source
    • Use a customized style in another workbook
    • Show the Classic Pivot Table Layout
    • Predetermined number formatting
    • Keep Column Widths upon Refresh
    • Automatically Refresh a Pivot Table
    • StdDevp - Standard Deviation Population
    • VarP - Variance Population
    • See all Pivot Items
    • Show a unique or distinct count in a Pivot Table
    • Percentage of Parent Row Total
    • Percentage of Parent Column Total
    • Percentage of Parent Total
    • Rank Smallest to Largest
    • Rank Largest to Smallest
    • Index
    • CASE STUDY: Percentage of Revenue Margins
    • Shortcuts to Grouping
    • Group by Half Years
    • Group by a Date that starts on a Monday
    • Grouping by a custom date
    • Grouping by a Fiscal Year and Quarter
    • Errors when Grouping by Dates
    • Group 2 Pivot Tables in the same Workbook
    • Fixing the problem of counting Grouped sales
    • Display dates that have no data
    • CASE STUDY: Quarterly Comparative Report
    • CASE STUDY: Min and Max Bank Balance Report
    • Override a Custom List sort
    • Sort row from A-Z and sales from Z-A
    • Sort new Items added to your data source
    • Clear a sort
    • Sort Largest to Smallest Grand Totals
    • Shortcuts to filters
    • Keep or hide selected items
    • Filter by Text wildcards
    • Filter by multiple fields
    • Apply multiple filters
    • Filter by multiple values
    • Include new Items in manual filter
    • Clear filters with one click
    • Add a filter for the column items
    • CASE STUDY: Top 5 Expense Report
    • CASE STUDY: Top 25 Percent of Channel Partners
    • Creating a custom Slicer style
    • Copy a custom Slicer style into a new workbook
    • Use one Slicer for two pivot tables
    • Lock the workbook but not the Slicer
    • Interactive employee photos with Slicers!
    • CASE STUDY: Base, Best and Worst Case Slicer Forecast
    • Solve Order for Calculated Items
    • List Calculated Field & Item formulas
    • Remove a Calculated Field temporarily
    • Order of operations
    • CASE STUDY: Creating a Profit & Loss Pivot Table Report
    • Shortcuts to formatting a Pivot Chart
    • Link a Pivot Chart title to a pivot cell
    • Copy a second Pivot Chart
    • Put a Pivot Chart on a separate page with F11
    • Insert Pivot Chart straight from the data source
    • Paste Pivot Chart to your email as a picture
    • Paste a Pivot Chart to PowerPoint & make live updates
    • Chart Do's and Dont's
    • Use Slicers to change Chart types
    • Pivot Chart workaround to creating an interactive Scatter graph
    • CASE STUDY: Profit & Loss Pivot table Report with Graphs
    • Conditionally Format only cells that contain - For Bonuses
    • Conditionally Format only Top or Bottom ranked values - Top 3 sales per year
    • Conditionally Format values that are above or below the average - For Promotions
    • Use a formula to determine which cells to Conditionally Format
    • Use selected cells to Conditionally Format multiple fields
    • All cells showing values to Conditionally Format multiple fields
    • Control Conditional Formatting with Slicers
    • Show Text in the Pivot Table Values area with Conditional Formatting
    • Conditionally Formatting Blank Cells
    • CASE STUDY: Accounts Receivable Ageing Report Matrix
    • Intro to GETPIVOTDATA
    • Create a custom report with GETPIVOTDATA
    • Reference Dates with GETPIVOTDATA
    • Data Validation with GETPIVOTDATA
    • Shortfalls of GETPIVOTDATA
    • Grand Totals to the left of the Pivot Table
    • CASE STUDY: Live forecasting with GETPIVOTDATA
    • CASE STUDY: Channel analysis with GETPIVOTDATA
    • Adding the Developer Tab
    • Record a simple Macro to Refresh a Pivot Table
    • Date Filter Macro
    • Different Pivot Table views Macro
    • Top 10 Macro
    • Add Macro to Quick Access Toolbar
    • Reducing file memory by copying existing Pivot Table
    • Reducing file memory by deleting the data source
    • Reducing file memory by saving file as XLSB
    • Reducing file memory by keeping data in Access
    • Compatibility Issues with Excel 2007 and Excel 2010
    • Sharing a Pivot Table via OneDrive
    • Frequency Distribution with a Pivot Table
    • Interactive Balance Sheet Pivot Table
    • Sales Forecasting with Calculated Fields
    • Consolidate with a Pivot Table
    • Break Even Model with a Pivot Table
    • Several Slicer custom styles for you to use
    • Monthly Sales Manager Performance
    • Reconciling customer payments
    • Cosmetic Changes
    • Recommended Pivot Tables
    • Distinct Count
    • Timeline Slicer
    • Data Model
    • Group Periods
    • Multiselect Slicers
    • PivotChart Expand and Collapse
    • 3D Maps
    • Which Excel version do you have?
    • Default Pivot Table Layout
    • Automatic Relationship Detection
    • Automatic Time Grouping
    • Search in a Pivot Table Field List
    • [Quiz] - Advanced - Pivot Tables
    • Unlock your Certificate of Completion
  • Advanced - Power Pivot

    • Download Workbooks - 1. IMPORT/LOAD DATA
    • Download Workbooks - 2. TABLE RELATIONSHIPS
    • Download Workbooks - 3. PIVOT TABLES & SLICERS
    • Download Workbooks - 4. MEASURES & CALCULATED COLUMNS
    • Power Pivot Cheat Sheet
    • Power Pivot Cheat Sheet
    • [JULY 2018 UPDATE] Power Pivot is now available in all versions of Excel
    • Installing Power Pivot in Excel 2010
    • Download Link for Power Pivot in Excel 2010
    • Enabling Power Pivot in Excel 2013, 2016, 2019 and Office 365
    • Import From Workbook
    • Import From Worksheet
    • Import From Separate Workbooks
    • Create Relationships
    • Create Relationships via the Diagram View
    • Create a Pivot Table
    • Insert a Slicer
    • Intro to DAX Formulas
    • Intro to DAX Formulas: Measures vs Calculated Columns - Part 1
    • Intro to DAX Formulas: Measures vs Calculated Columns - Part 2
    • DAX Syntax
    • Date and Time Functions
    • Time Intelligence Functions
    • Filter Functions
    • Information Functions
    • Logical Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Other Functions
    • DISTINCTCOUNT() - Create a "Unique Order Dates" Measure
    • SUM() - Create a "Total Sales" Measure
    • Combine 2 Measures to get "Average Sales Per Date"
    • CALCULATE() - Filter & Show Individual Product Sales
    • CALCULATE() - Show Largest Sales Values
    • Calculated Column - Extract Years from Order Date
    • CALCULATE() - Group Years
    • Link a Calendar Table
    • Sort Month Dates Into The Correct Order
    • Add a Hierarchy to the Calendar
    • Combine a Calculated Column with a Measure - Net Profit Analysis
    • [Quiz] - Advanced - Power Pivot
    • Unlock your Certificate of Completion
  • Advanced - Power Query

    • Download Workbooks
    • Power Query Cheat Sheet - Getting Started with Power Query
    • Power Query Cheat Sheet - M Functions
    • Introduction
    • Query Editor Overview
    • Excel 2010 & 2013 Add-In Download Link
    • Installing Power Query in Excel 2013
    • Installing Power Query in Excel 2010
    • Trim
    • Format Dates and Values
    • Parsing URLs (Split Columns by Delimiter)
    • Split Text Fields (Split Columns by Delimiter & Number of Characters)
    • Group By
    • Unpivot Columns
    • Pivot Columns
    • Split Columns into Other Columns with Delimiters
    • Filter Your Data & Add a "Year" Column
    • Sort Your Data
    • Transform v Add Column
    • Add Column From Examples
    • Group and Rank Items
    • Modulo
    • FROM FOLDER: Consolidate Workbooks - Part 1
    • FROM FOLDER: Consolidate Workbooks - Part 2
    • FROM FOLDER: Extract Data from Forms
    • FROM WORKBOOK: Extract & Consolidate Data Based on Multiple Criteria
    • FROM WORKBOOK: Extract & Consolidate Data from Multiple Worksheets
    • Append Worksheets to Consolidate Data
    • Merge - Joins Introduction
    • Merge - Full Outer Join (all rows from both)
    • Merge - Left Outer Join (all from first, matching from second)
    • Merge - Right Outer Join (all from second, matching from first)
    • Merge - Inner Join (only matching rows)
    • Merge - Left Anti Join (rows only in first)
    • Merge - Right Anti Join (rows only in second)
    • BONUS EXAMPLE: Merge - Left Outer
    • BONUS EXAMPLE: Merge - Full Outer Join
    • BONUS EXAMPLE: Merge - Right Anti Join
    • Convert Reports into Pivot Tables
    • Get a List of File Names
    • Get File Names Based on User Selection
    • M Overview
    • M Functions Cheat Sheet
    • M Function List using #Shared
    • Using M Functions
    • Your Assignment - Create Custom Columns Using M Functions!
    • Viewing M Code
    • Simple M Expressions
    • Simple M Expressions - Nested Expressions
    • M Variables
    • M Functions
    • M Functions - Reusable Functions
    • M Functions - Invoking
    • Passing M Functions
    • Passing M Functions - Using the "each" keyword
    • [Quiz] - Advanced - Power Query (Get & Transform)
    • Unlock your Certificate of Completion
  • Advanced - Power BI

    • Download Workbooks - 1. POWER BI DESKTOP - FUNDAMENTALS
    • Download Workbook - 2. REAL WORLD EXAMPLE - NBA Website Links
    • Download Workbooks - 3. POWER BI DESKTOP - ADVANCED TIPS
    • Power BI Cheat Sheet
    • Overview of Power BI Course
    • Power BI Overview
    • Power BI High Level Flow
    • Install Power BI Desktop and Sign Up
    • Install Power BI Desktop and Sign Up - URL LINKS
    • Get Data (Power Query Overview)
    • Data & Model (Power Pivot Overview)
    • Report (Power View Overview)
    • The Big Picture - Your First Power BI Solution!
    • Get Data
    • How to Get More Data & Edit Queries
    • Data, Model & Relationships
    • Adding Relationships Manually
    • Report Visualization
    • More Report Visualizations
    • Report Visualization Format and Analytics
    • Ask a Question
    • Your Assignment - Create a Power BI Dashboard!
    • Real World Example: NBA Statistics
    • Get and Clean Data From Multiple Web Sources
    • Modelling Data - Add Relationships
    • Report Visualization with Multiple Charts
    • Publish to Power BI Website and Create Dashboards from Existing Reports
    • Power BI Website Features
    • Introduction to our Dashboard's Data Setup
    • Use the Bookmarks feature to show/hide a panel of Slicers
    • Use the Drill through feature to drill down on specific data
    • Drill down on data using Date Hierarchy
    • Use the Analytics feature to Forecast future data points on a Line chart
    • Use the Format painter to copy formats
    • Use Bookmarks to Filter to specific data for your presentation
    • Advanced Editor display options for M code
    • [Quiz] - Advanced - Power BI
    • Unlock your Certificate of Completion
  • Advanced - Dashboards

    • Downloadable Workbooks & LAB Notes
    • 1.1 Introduction
    • 1.2 Why Excel
    • 1.3 Why Dashboards
    • 1.4 Interactive Dashboards in Excel
    • 2.1 Thinking Outside the Cell
    • 2.2 Why Develop Differently
    • 2.3 Inserting the Camera Tool
    • 2.4 Camera Tool Demo
    • 2.5 Development Principles
    • 3.1 Formula Editing Tips
    • 3.2 Excels Calculation Engine
    • 3.3 Writing Better Formulas
    • 4.1 Lookup Functions
    • 4.2 VLookup
    • 4.3 Index Match
    • 4.4 Combination
    • 4.5 Array Formulas
    • 4.6 Array Formulas Demo
    • 4.7 Array Formula Review
    • 5.1 Introduction to Excel Tables
    • 5.2 Inserting an Excel Table
    • 5.3 Working with Tables
    • 5.4 Excel Table Chart Example
    • 5.5 Excel Table Rules
    • 6.1 Sorting Functions
    • 6.2 Filters and SUMPRODUCT
    • 6.3 Filtering on Excel Tables
    • 6.4 Aggregation with Excel Tables
    • 6.5 Summary
    • Downloadable Workbooks & LAB Notes
    • 7.1 Installing the Developer Tab
    • 7.2 Excel Controls
    • 7.3 Form Controls Demo
    • 7.4 Form Control Basics
    • 7.5 Scrollable Tables
    • 8.1 Excel Development Styles
    • 8.2 Information-Transformation-Presentation
    • 9.1 Introduction to Interactive Legends
    • 9.2 Setting Up The Interactive Legend
    • 9.3 Perfecting the Interactive Legend
    • 9.4 Maintaining the Interactive Legend
    • 10.1 Introduction
    • 10.2 Setting up the Interactive Toggle
    • 10.3 Formatting the Interactive Toggle
    • 10.4 Maintaining the Interactive Toggle
    • 11.1 Introduction
    • 11.2 Setting Up The Interactive Dashboard
    • 11.3 Formatting the Interactive Dashboard
    • 11.4 Maintaining the Interactive Dashboard
    • Downloadable Workbooks & LAB Notes
    • 12.1 Visual Peception
    • 12.2 Gestalts Law
    • 12.3 Preattentive Attributes
    • 12.4 The Problem with Pie Charts
    • 12.5 Data Viz vs Infographics
    • 13.1 Introduction
    • 13.2 Dual Axis Banding
    • 13.3 Area Chart Banding
    • 13.4 Limit Charts
    • 14.1 Introduction to Bullet Charts
    • 14.2 Bullet Chart Demo
    • 14.3 Horizontal Bullet Chart Trick
    • 15.1 Introduction to Infographics in Excel
    • 15.2 Progress Meter
    • 15.3 Donut Chart Demo
    • 15.4 Waffle Unit Chart Demo
    • 15.5 Bringing it Together with the Camera Tool - Demo
    • Downloadable Workbooks
    • Introduction to the Analysis of Health Systems Dashboard
    • Problem Description
    • Form Control Scroll Bar Mechanism
    • Create The Main Chart Using The LARGE, XLOOKUP, VLOOKUP & REPT Formulas
    • Drill Down On Your Data With The LEFT, INDEX, REPT Formulas
    • Create Top & Bottom Charts With The LARGE & XLOOLUP Formulas
    • Dashboard Maintenance
    • Downloadable Workbooks
    • Course Outline
    • Gannt Chart VBA Dashboard Overview
    • Rollover pop-ups explained using VBA
    • Lay out the data with the SUMIFS Formula
    • Bring the data into the Gannt Chart Dashboard using the INDEX Formula
    • Lay out the Gannt Chart Dashboard using Conditional Formatting
    • Create the Legend using Conditional Formatting
    • Set up the KPI Stacked Column Chart
    • Design the Rollover pop-up using the INDEX formula and the Camera Tool
    • Create the Rollover pop-up using VBA & Conditional Formatting
    • Show the Rollover pop-up using VBA
    • Test & Modify the Rollover pop-up using VBA
    • Format the Rollover pop-up using VBA
    • Unlock your Certificate of Completion
  • Advanced - Charts

    • Download Workbooks
    • Box and Whisker Chart
    • Histogram Chart
    • Pareto Chart
    • Sunburst Chart
    • Treemap Chart
    • Waterfall Chart
    • Area Chart: Highlight Chart Sections
    • Add an Interactive Vertical Column in Your Excel Line Chart
    • Add Marker Options in a Chart
    • Overlap Charts
    • Add Trendlines to Charts
    • Combine Column & Line Charts
    • Cycle Chart
    • Plot an Equation on a Chart
    • Process Map Chart
    • Project Milestones Chart
    • Draw a Logo with a Scatter Chart
    • Step Chart
    • Thermometer Chart
    • [Quiz] - Advanced - Charts
    • Unlock your Certificate of Completion
  • Advanced - Macros & VBA

    • Getting Started With Macros & VBA
    • Common VBA Programming Concepts You Can Use Today
    • 5 Awesome Worksheet Macros
    • Intro to VBA
    • Exercise Files
    • Downloadable Workbook
    • What Is VBA?
    • Object Structure
    • Developer Tab
    • Intro To VBA Window
    • Immediate Window Object Ref
    • Shorthand Object Ref
    • Object Props Methods
    • Download Workbook
    • Worksheet References
    • Worksheet Select Method
    • Worksheets Name Property
    • Worksheets Count Property
    • Worksheets Add Method
    • Worksheets Print Method
    • Worksheets Delete Method
    • Download Workbook
    • Range Object Intro
    • Selecting a Range
    • Range Value Property
    • Copy Paste Methods
    • Reference Other Worksheet Cell
    • Download Workbook
    • Differences between Relative & Absolute References
    • Active Sheet Object
    • Active Cell Ref
    • Current Region Property
    • Offset Command
    • What is a Module
    • Creating a Procedure
    • Adding VBA Code to your Procedure
    • Running a Procedure
    • Procedure Button
    • Calling Procedures
    • VBA Comments
    • Saving VBA Code
    • Download Workbooks
    • What are Variables
    • Declaring Variables
    • Using a Variable
    • Common Data Types
    • String Data Type
    • Integer & Long Data Type
    • Boolean Type
    • Download Workbooks
    • IF Statements
    • ElseIf and Else Statements
    • Understanding Loops
    • Do While Loop
    • For Each Loop & Debug
    • Download Workbook
    • Message Box Intro
    • Adding Buttons To Message Box
    • Handle Button Presses
    • Input Box
    • Downloadable Workbook
    • PROJECT #1: Intro
    • PROJECT #1: Create a VBA User Form
    • PROJECT #1: Adding Controls
    • PROJECT #1: Control Properties
    • PROJECT #1: Project Type Combo Box
    • PROJECT #1: Employee Combo Box
    • PROJECT #1: Date Default
    • PROJECT #1: Start Time Button
    • PROJECT #1: Show User Form with a Button
    • Downloadable Workbook
    • PROJECT #2: Intro
    • PROJECT #2: Submit Button Employee Sheet
    • PROJECT #2: Transfer Data to a Worksheet
    • PROJECT #2: Calculate Call Duration Formula
    • PROJECT #2: Generate Unique Call ID Procedure
    • PROJECT #2: Call Procedure From User Form
    • PROJECT #2: Validate User Form Data with a Message Box
    • PROJECT #2: Clear Data Button with a Loop
    • Downloadable Workbook
    • PROJECT #3: Intro
    • PROJECT #3: Creating Print Report Form
    • PROJECT #3: Opening a New Workbook Template
    • PROJECT #3: Looping Controls Worksheets
    • PROJECT #3: Copy & Paste Data to a New Workbook
    • PROJECT #3: Clean Up Your VBA Code (Screen Updating)
    • Downloadable Workbook
    • PROJECT #4: Intro
    • PROJECT #4: Create Temp Sheet - 01
    • PROJECT #4: Create Temp Sheet - 02
    • PROJECT #4: Create Call Stats
    • PROJECT #4: Call Stats Initialize
    • PROJECT #4: Create Send Email
    • Downloadable Workbooks
    • Course Introduction
    • Dealing With Raw Data
    • Excel Dashboard Magic
    • Get Started
    • Using Excels PROPER() Function on Text
    • Create Consistency with Excels UPPER() Function
    • Paste Special Values
    • Replace Meaningless Data with Excels CHOOSE() Function
    • Extract Date Values Using Excels TEXT() Function
    • Downloadable Workbook
    • Dashboard Overview
    • Preparing the Data Using Format As An Excel Table
    • Creating a Drop Down Menu with Data Validation
    • Looking Up Data with Excels VLOOKUP() Function
    • Cleaning Up Data with Excels IF() Function
    • INDEX() and MATCH() an Alternative to VLOOKUP()
    • Adding the Order History Table
    • Formatting Orders as a Table
    • Using Excels Advanced Filter Feature
    • Record a Macro for Advanced Filter
    • Filter Order Records On Change of Customer with VBA
    • Modify the VBA Filter Code
    • Why Use Excels SUBTOTAL() Function
    • Implementing the SUBTOTAL() Function
    • Downloadable Workbooks
    • Why Use Pivot Tables
    • Summarizing Order Info with Pivot Tables
    • Prepare Pivot Table for Customer Filter
    • Creating a VBA Procedure for your Pivot Table
    • Declaring VBA Variables for your Pivot Table
    • Assigning VBA Variables to your Pivot Table
    • Connecting the Filter to the Pivot Table with VBA
    • Update Pivot Chart Based on Customer Selected with VBA
    • Fix Customers with No Orders Error with VBA
    • Creating Interactive Charts with Slicers
    • Modifying the Chart Slicer
    • Hiding Extra Worksheets and Columns
    • Cleaning Up the Excel Default Settings
    • Hiding the Chart & Slicer with VBA
    • Protecting Your Dashboard
    • [Quiz] - Advanced - Macros & VBA
    • Unlock your Certificate of Completion
  • Advanced - Analysis & Financial Modeling

    • Download Workbooks - 1. Financial Modeling Introduction Course
    • Downloadable Financial Modeling Practice Templates
    • Financial Modeling Cheat Sheet
    • Quick Overview
    • What is a Financial Model?
    • Financial Model Design
    • Scenario Analysis
    • Documentation
    • Cell References
    • IF Formula
    • AND Formula
    • OR Formula
    • Nested Formulas
    • Conditional Formatting
    • Data validation
    • Inputs
    • Revenue
    • Expenses
    • Profit and Loss
    • Cashflow
    • Adding Scenarios
    • Charts
    • Conditional Formatting
    • Protect Workbook
    • Download Workbooks - 2. Financial Modeling Intermediate Course
    • Overview of the Intermediate Financial Modeling Course
    • Financial Model Design Principles
    • Aggregate Functions
    • Lookup Functions
    • Forecasting Functions
    • Mixed References and Named Ranges
    • External File Links
    • Building Error Checks
    • Goal Seek
    • WACC (Weighted Average Cost of Capital)
    • NPV (Net Present Value) & IRR (Internal Rate of Return)
    • Introduction to the Financial Model Business Case
    • Staff Costs and Inflation
    • Staff Expenses Summary
    • Forecasting Sales/Revenue
    • Market Analysis
    • Profit & Loss (P&L) and Additional Expenses
    • NPV & IRR Calculations
    • Payback Period
    • Scenario Analysis
    • [Quiz] - Financial Modeling
    • Unlock your Certificate of Completion

  • Microsoft Word

    • Downloadable Word Documents to Practice - Introduction
    • Open a New Word Document and Templates
    • Tabs, Ribbons and Groups in Word
    • Zoom, Rulers & Search your Word document
    • Edit the Word Document with Fonts & Styles
    • Insert Pictures & Icons in Word
    • Insert Shapes and a Text Box in Word
    • Review your Word document with Spelling, Word Count & Thesaurus
    • Layout your Word document with Double Spaces & Margins
    • Save, Print & Export your Word File
    • Close, Re-Open & Pin your Word document
    • Change the Views in Word
    • Table of Contents & Smart Lookup in Word
    • Print Settings in Word
    • Using Mail Merge to Create Dynamic Emails in Word
    • Using Mail Merge to Create Dynamic Labels in Word
    • Downloadable Word Documents to Practice - Advanced Techniques
    • Convert Speech to text (Dictate) in Word
    • Convert an Image with Text to Word
    • Drawing and Inking Tools in Word
    • Icons, Photos & Illustrations in Word
    • Insert Online Video in Word
    • Screenshot into Word
    • Compress Word Document
    • Save Word Document as PDF
    • Open PDF in Word
    • Resume Assistant with LinkedIn in Word
    • Transform Document to Web Page in Word
    • Translate a Word Document
    • Dark Mode in Word
    • Editor - Proofreading in Word
    • Focus Mode in Word
    • Immersive Reader in Word
    • How to Insert Page Numbers in Word
    • Side by side view in Word
    • Thumbnail view in Word
    • [Quiz] - Microsoft Word
    • Unlock Your Certificate of Completion
  • Microsoft Outlook

    • Setting Up Outlook with Accounts
    • Tabs, Ribbons and Groups in Outlook
    • Navigation Bar in Outlook
    • Organizing Outlook with Favorites and Folders
    • Additional Options inside Outlook Tabs
    • Reading, Writing and Receiving Emails
    • Attaching Items in Outlook Mails
    • The View Tab in Outlook
    • Create a Rule to move emails to a folder
    • Insert a screen shot from Excel
    • [Quiz] - Microsoft Outlook
    • Unlock Your Certificate of Completion
  • Microsoft PowerPoint

    • Downloadable PowerPoint Slides - Introduction
    • Open a New PowerPoint Presentation and Templates
    • Tabs, Ribbons and Groups in PowerPoint
    • Edit your First PowerPoint Slide and Designing the Slide
    • Exploring Home Tab and Updating in PowerPoint
    • Using Buttons in PowerPoint
    • Insert Pictures in PowerPoint
    • Presenting your Slides in PowerPoint
    • Animating your Slides in PowerPoint
    • Save, Print & Export your PowerPoint Presentation
    • Close, Re-Open & Pin your PowerPoint Presentation
    • Downloadable PowerPoint Slides - Advanced Tecniques
    • Design Ideas in PowerPoint
    • Templates in PowerPoint
    • Animation Images in PowerPoint
    • Remove Image Background in PowerPoint
    • Selection Pane in PowerPoint
    • Instant Slideshow in PowerPoint
    • Create a Video Recording in PowerPoint
    • Transitions & Morph in PowerPoint
    • Link to Excel in PowerPoint
    • Chart Animations in PowerPoint
    • SmartArt in PowerPoint
    • Duplicate Items in PowerPoint
    • Ink Equation in PowerPoint
    • Screen Recording in PowerPoint
    • Filler Text in PowerPoint
    • Translate Text in PowerPoint
    • Add-ins in PowerPoint
    • Compress Media in PowerPoint
    • Insights in PowerPoint
    • Recover Files in PowerPoint
    • [Quiz] - Microsoft PowerPoint
    • Unlock Your Certificate of Completion
  • Microsoft Teams

    • Microsoft Teams Course Overview
    • Links to set up Microsoft Teams
    • [PDF Download] Microsoft Teams Cheat Sheet
    • Introduction to Microsoft Teams
    • Free and Paid versions
    • Web or Desktop versions?
    • Managing Teams and Members
    • Inviting Members
    • Managing Channels
    • Chat
    • Collaboration with Word, Excel, PowerPoint...
    • Voice & Video Calls
    • Adding More Apps
    • Activity
    • Search bar
    • Settings
    • Installing the Desktop version
    • Multiple Organizations
    • Teams Mobile app
    • Meetings
    • TIP #1 - Forwarding Email
    • TIP#2 - Saving Items
    • TIP #3 - Naming Group Chats
    • TIP #4 - Connectors
    • TIP #5 - Live Captions in Meetings
    • TIP #6 - Top Shortcuts
    • TIP #7 - Customize the Environment
    • TIP #8 - Channel Notifications
    • TIP #9 - Private Channels
    • TIP #10 - Pin Channels
    • TIP #11 - Post Announcements
    • [Quiz] - Microsoft Teams
    • Unlock Your Certificate of Completion
  • Microsoft OneNote

    • DOWNLOAD LINKS
    • Get Started with OneNote
    • Organize Notebooks in OneNote
    • Settings and View Tab in OneNote
    • Work with Multiple Accounts in OneNote
    • Tell Me In OneNote in OneNote
    • Adding Text, Tags & Videos in OneNote
    • Insert Tables, Files, Printout, Draw & Audio in OneNote
    • Draw & Ink Tools in OneNote
    • Search Tool in OneNote
    • OneNote Web Clipper
    • Share Notebooks and Pages in OneNote
    • Print Pages in OneNote
    • OneNote online
    • OneNote 2016
    • [Quiz] - Microsoft OneNote
    • Unlock Your Certificate of Completion
  • Advanced - Access

    • Course Topics and Flow
    • Download Exercise - Northwind Access Database
    • Download Exercise - Modules 5 & 6 only
    • Cheat Sheet - Getting Started with Access
    • Opening Microsoft Access
    • Access Quick Access Toolbar
    • Working with the Access Ribbon
    • Access Object Panel
    • Access File Tab
    • Access Security Prompt
    • Understanding the Purpose of Access Tables
    • Building Relationships between Access Tables
    • Using Access Queries to Select Specific Data
    • Building a User Interface with Access Forms
    • Reporting on Access Data with Access Reports
    • Automate Access Tasks with Macros and VBA
    • Working in Datasheet View within an Access Table
    • Sorting the Datasheet View
    • Filtering the Datasheet View with Filter by Selection
    • Filter the Datasheet View with Advanced Filter
    • Preview the "Student Course" Database Tables
    • Creating an Access Database
    • Designing Access Tables in Design View
    • Adding Fields and Defining Common Data Types in an Access Table
    • Field Size Property
    • Field Caption Property
    • Default Value Property
    • Required Field Property
    • Input Mask Property
    • Custom Input Mask
    • Working with the Lookup Wizard Data Type
    • Edit a Table Field Drop Down
    • Adding Field Descriptions
    • Setting the Table's Primary Key Field
    • Adding Records in the Datasheet View
    • Table Exercise Introduction
    • Understanding Access Table Relationships
    • Creating Access Table Relationships
    • Setting Up "Better" Table Relationships
    • Setting the Relationship Properties
    • Table Relationships Cascade Update/Delete
    • Working with Sub Datasheets in Tables
    • Creating Table Relatioships with the Lookup Wizard
    • Creating an Access Select Query
    • Adding Criteria to an Access Select Query
    • Using AND Conditions in an Access Query
    • Using OR Conditions in an Access Query
    • Another OR Condition
    • Sorting Data within an Access Select Query
    • Multi-Level Query Sort
    • Working with Date Criteria in an Access Select Query
    • Using the "Between" Operator
    • Access Query Tip -- Using Table Fields within Query Criteria
    • Using Wildcards in Query Criteria
    • Access Query Tip --- DATA TYPE MISMATCH
    • Saving an Access Query
    • Creating a Calculated Field in an Access Query
    • Using the MONTH() and MONTHNAME() Functions
    • Using the IF() Function in a Query Calculated Field
    • Finding the Difference Between Two Dates Using the DateDiff() Function
    • Working with an Access Total Query
    • Grouping and Summarizing Data with a Total Query
    • Adding a Calculated Field to a Total Query
    • Saving a Total Query
    • Total Query Exercise -- Post in the QA Section
    • Total Query Example -- Products Table
    • Summarizing Data with a Crosstab Query
    • Introduction to Access Action Queries
    • Update Access Table Data with an Update Query
    • Update Table Data with a Calculation
    • Saving an Action Query
    • Creating a New Table with an Access Make Table Query
    • Deleting Table Data with an Access Delete Query
    • Appending Records to an Exisiting Table with an Access Append Query
    • Creating a Query with Multiple Tables
    • Working with Query Joins
    • Inner Join and Left Outer Join
    • Parameter Query Preview
    • Creating a Single Parameter
    • Saving the Parameter Query
    • Creating Date Parameters
    • Creating Multiple Parameters
    • Using Wildcards in Parameters
    • Run a Parameter with a Shortcut
    • Starting with a Blank Form
    • Adding Form Fields
    • Moving Form Fields
    • Resizing Form Fields
    • Aligning Form Fields
    • Spacing Form Fields
    • Saving a Form
    • Adding, Deleting and Editing Records
    • Sorting Form Records
    • Filtering Form Records using Filter by Selection
    • Filtering Form Records using Advanced Filter
    • Introduction to Form Controls
    • Adding a Header and Footer
    • Creating Calculated Form Fields
    • Working with Sub Forms
    • Working with the Option Group Control
    • Adding the Tab Control to a Form
    • Adding Buttons to a Form
    • Formatting Field Controls
    • Creating Separation with the Line Control
    • Changing the Form Background color
    • Preview an Access Switchboard
    • Start the Switchboard Manager
    • Adding Buttons to the Switchboard
    • Fomatting the Switchboard
    • Modify the Switchboard
    • Preview Filtering Query Data with a Form
    • Setting up the Query
    • Setting up the Form
    • Clean Up the Combo Box Control
    • Creating the Form Button to Run the Query
    • Adding Form Reference Criteria to the Query
    • Running the Query
    • Creating a Blank Report
    • Adding Fields
    • Field Layout
    • Working with Report Sections
    • Format Fields
    • Report Margins
    • Format Painter
    • Header & Footer
    • Report Saved
    • Calculated Field Text Box
    • Check Box Calculation
    • Grouping Report Data
    • Group Headers
    • Repeat Group Headers
    • Section Page Breaks
    • Group Footer
    • Group Calculation
    • Unlock Your Certificate of Completion

  • Excel Resources

    • Academy Course Curriculum - Interactive Excel Workbook
    • 101 Best Excel Tips & Tricks
    • [Download] 101 Ready Made Excel Templates!
    • [PDF DOWNLOAD] 333 Excel Keyboards Shortcuts Templates for Windows & Mac
    • Downloadable Practice Workbook
    • Cell Formatting Keyboard Shortcuts
    • Drag & Drop Keyboard Shortcuts
    • Formulas Keyboard Shortcuts
    • Macros & VBA Keyboard Shortcuts
    • Frequent Keyboard Shortcuts
    • Function Key Keyboard Shortcuts
    • Making Selections Keyboard Shortcuts
    • Ribbon Tab Keyboard Shortcuts
    • Cell Navigation Keyboard Shortcuts
    • Inside Ribbon Keyboard Shortcuts
    • Other Keyboard Shortcuts
    • Pivot Table Keyboard Shortcuts
    • Power BI Keyboard Shortcuts
    • Power Pivot Keyboard Shortcuts
    • Course Links
    • Job Interview Cheat Sheet
    • [Audio Interview] How To Prepare For An Excel Job Interview
    • Pro Level Support
    • 101 Most Popular Excel Formulas
    • 101 Ready To Use Excel Macros
    • Academy Welcome Pack + T-Shirt
    • Free Workshop: 19 Secret Excel Productivity Tips!
    • Excel Keyboard Shortcuts - US Version
    • FINANCIAL MODELING: Getting Started
    • POWER BI: Various Visualizations You Can Use!
    • ACCESS: Getting Started With Access
    • FORMULAS: Top 9 Formula Tips!
    • FORMULAS: VLOOKUP, INDEX, MATCH, IF, IFERROR, SUMIF, SUMIFS!
    • CHARTS & GRAPHS: Excel Charts Helper Guide!
    • MACROS & VBA: 5 Awesome Worksheet Macros
    • MACROS & VBA: Getting Started with Macros & VBA
    • MACROS & VBA: Common VBA Programming Concepts You Can Use Today
    • PIVOT TABLES: Getting Started with Pivot Tables
    • PIVOT TABLES: 5 Speedy Steps to an Excel Pivot Table
    • POWER QUERY: Getting Started with Power Query (Get & Transform)
    • POWER QUERY: M Functions
    • POWER PIVOT: Getting Started with Power Pivot
    • SQL: Logical Ordering & Keywords
    • POWER AUTOMATE: Flows Cheat Sheet
    • POWER APPS: Main Components
    • SHAREPOINT: Customizing SharePoint Sites
    • My Top 10 Excel Keyboard Shortcuts
    • Download Workbook
    • [Download] Datasets to practice data analysis
    • Get 20% OFF as a valued Academy member
    • Squirrel365 Easy & Quick Excel Dashboard Creation
    • How to Convert PDF to Excel, Word & PowerPoint
  • Webinar Replays

    • Pivot Table Webinar Recording
    • Download Workbooks
    • Macros & VBA Webinar
    • Download Workbooks
    • Formulas Webinar
    • Download Workbooks
    • Power Query Webinar
    • Download Workbooks
    • 2018-08-15: Downloadable Workbooks
    • 2018-08-15: Macros & VBA Live Q&A Webinar with Kyle Pew
    • 2019-02-27: Microsoft Access Live Q&A Webinar with Kyle Pew
    • 2019-02-27: Downloadable Workbooks
  • BECOME AN AFFILIATE
  • Support
  • Need Technical Help?
  • Terms & Conditions
  • Privacy Policy
  • LEGACY COURSES
© Copyright MyExcelOnline 2022