Group rows on multiple tabs at once
Excel with Lee
Group rows on multiple tabs at once
4:06
Change all Worksheet Names with a MACRO
Excel with Lee
Change all Worksheet Names with a MACRO
2:14
Freeze Panes on All Worksheets
Excel with Lee
Freeze Panes on All Worksheets
4:54
Delay email Delivery in Outlook
Excel with Lee
Delay email Delivery in Outlook
2:14
Outlook can convert words to dates!
Excel with Lee
Outlook can convert words to dates!
1:53
Quickly add HOLIDAYS to your Outlook Calendar
Excel with Lee
Quickly add HOLIDAYS to your Outlook Calendar
1:26
Outlook Shortcuts!
Excel with Lee
Outlook Shortcuts!
3:52
Adding Time Zones to Outlook Calendar
Excel with Lee
Adding Time Zones to Outlook Calendar
1:38
Account Reconciliations -- Why do they matter!?
Excel with Lee
Account Reconciliations -- Why do they matter!?
4:53
Understanding and Using the Statement of Cash Flows
Excel with Lee
Understanding and Using the Statement of Cash Flows
7:44
How to review the balance sheet
Excel with Lee
How to review the balance sheet
6:54
How to review a P&L
Excel with Lee
How to review a P&L
4:59
Creating a loan amortization schedule and understanding balloon payments
Excel with Lee
Creating a loan amortization schedule and understanding balloon payments
7:32
IRR and ROI - calculating and understanding profitability metrics
Excel with Lee
IRR and ROI - calculating and understanding profitability metrics
6:00
Adding a calculated item and conditional formatting to your pivot tables
Excel with Lee
Adding a calculated item and conditional formatting to your pivot tables
3:31
Page level filters in Power BI
Excel with Lee
Page level filters in Power BI
4:48
Cross-filtering vs using a slicer in Power BI
Excel with Lee
Cross-filtering vs using a slicer in Power BI
4:31
Conditional Formatting in Power BI
Excel with Lee
Conditional Formatting in Power BI
4:22
Fill Merged Cells
Excel with Lee
Fill Merged Cells
2:43
Text List in Value section of Pivot Table
Excel with Lee
Text List in Value section of Pivot Table
3:26
Power BI Formatting Tips
Excel with Lee
Power BI Formatting Tips
4:12
Power BI -- Drilldown Functionality Introduction
Excel with Lee
Power BI -- Drilldown Functionality Introduction
3:36
Creating Percentage Based PivotCharts in Excel
Excel with Lee
Creating Percentage Based PivotCharts in Excel
2:49
Creating a PivotChart in Excel
Excel with Lee
Creating a PivotChart in Excel
4:20
Publishing Power BI Dashboards Online
Excel with Lee
Publishing Power BI Dashboards Online
4:00
Introduction to creating Dashboards in Power BI
Excel with Lee
Introduction to creating Dashboards in Power BI
16:19
Automating recurring tasks using Power Query in Excel
Excel with Lee
Automating recurring tasks using Power Query in Excel
15:41
Complex Unpivoting Using Microsoft Excel's built-in Power Query Editor
Excel with Lee
Complex Unpivoting Using Microsoft Excel's built-in Power Query Editor
8:58
Preserving Contextual Header Information using Microsoft Excel's built-in Power Query Editor
Excel with Lee
Preserving Contextual Header Information using Microsoft Excel's built-in Power Query Editor
3:30
Appending Tables with Inconsistent Header Names
Excel with Lee
Appending Tables with Inconsistent Header Names
9:45
Appending Tables using Microsoft Excel's built-in Power Query Editor
Excel with Lee
Appending Tables using Microsoft Excel's built-in Power Query Editor
4:16
Merging Tables using the Power Query Editor
Excel with Lee
Merging Tables using the Power Query Editor
4:20
Introduction to the Power Query Editor's M programming language
Excel with Lee
Introduction to the Power Query Editor's M programming language
6:09
UNPIVOT data using Microsoft Excel's built-in Power Query Editor
Excel with Lee
UNPIVOT data using Microsoft Excel's built-in Power Query Editor
4:21
Cleansing Data using Microsoft Excel's built-in Power Query Editor
Excel with Lee
Cleansing Data using Microsoft Excel's built-in Power Query Editor
4:11
Convert a PDF into Excel using the built-in POWER QUERY
Excel with Lee
Convert a PDF into Excel using the built-in POWER QUERY
12:11
Using Slicers to easily filter pivot tables in Microsoft Excel
Excel with Lee
Using Slicers to easily filter pivot tables in Microsoft Excel
3:30
Showing Percentage of Total in Microsoft Excel Pivot Table using Show Value As settings
Excel with Lee
Showing Percentage of Total in Microsoft Excel Pivot Table using Show Value As settings
3:03
Creating Tables in Microsoft Excel to AUTOMATICALLY update the range picked up in a Pivot Table
Excel with Lee
Creating Tables in Microsoft Excel to AUTOMATICALLY update the range picked up in a Pivot Table
5:31
Pivot Table Default Settings
Excel with Lee
Pivot Table Default Settings
4:56
Microsoft Excel Power Query: Get and Transform data from the web
Excel with Lee
Microsoft Excel Power Query: Get and Transform data from the web
3:51