341 тысяч подписчиков
146 видео
How to show hidden data in an Excel chart | Excel Off The Grid
Power Query append | Combine many queries into 1
Interpolate with Excel | FORECAST function can interpolate | Excel Off The Grid
Top 10 with formulas in Excel | Automatically calculate Top 10 as data changes | Excel Off The Grid
Change number format based on cell value | Excel Off The Grid
Combine all the files in a folder using Power Query | Excel & CSV | Excel Off The Grid
Sum the same cell across multiple sheets in Excel | Excel time saving tip
How to fix the Formula Firewall in Power Query | Excel Off The Grid
Create Shareable, Interactive, View Only Dashboards from Excel | Excel Off The Grid
How to remove additional spaces in Excel (7 simple ways) | Excel Off The Grid
Declare data type when creating a Custom Column | Saving Power Query steps | Excel On The Go
Create Slopegraphs in Excel | Excel Off The Grid | Automate with a macro
Unblock macros downloaded from the internet | Excel Off The Grid | Microsoft macro security changes
Using slicers with formulas (2022 update) | Excel Off The Grid
Create a step chart in Excel | Excel Off The Grid | The fastest way
List all the files in a folder and subfolders with Power Query
Power Query - Combine rows into a single cell | Change data to readable format | Excel Off The Grid
How to create Multiple PDFs from Excel (Office Scripts + Power Automate) | Excel Off The Grid
Power Query: Get data when sheet/Table names change (2 ways) | Excel Off The Grid
7 METHODS to change source data location in Power Query | Excel Off The Grid
Reference items by position in Power Query | Transform reports into data | Excel Off The Grid
10 Power Query tips EVERY user should know! | Excel Off The Grid
Trigger a Power Automate Flow from Excel with Office Scripts or VBA | Excel Off The Grid
Move data between workbooks automatically with Office Scripts & Power Automate | Excel Off The Grid
Power Query: How to mass replace values based on a list | Excel Off The Grid
Power Query: Get data from SharePoint lists | Excel Off The Grid
Power Query made easy - learn the power of Quick Steps | Excel Off The Grid
Summarizing Data with Group By in Power Query
Advanced Formula Magic: Running total by row with dynamic arrays in Excel
Make Power Query refresh before PivotTables | Reduce refresh to one click | Excel Off The Grid
SORTBY function in Excel (with 6 examples) | Sorting without a single click | Excel Off The Grid.
Using dynamic arrays in a Table : 4 methods | Excel Off The Grid
4 METHODS to Filter by a List in Power Query | Excel Off The Grid
Dynamic chart legends in Excel | Make charts easier to read | Excel Off The Grid
The BEST Way to Calculate Moving Averages in Excel with Dynamic Arrays
Table slicers for advanced interactivity in Excel | Excel Off The Grid
Run macros from Power Automate Desktop | Excel Off The Grid
Excel’s Ultimate FILTER Hack - Multiple Columns, Multiple Values 😲
Create your own keyboard shortcuts in Excel | Excel Off The Grid
FILTER function in Excel (with 6 examples) | Best new Excel function in decades | Excel Off The Grid
Next level FILTER Function tricks | Excel Off The Grid
Dynamically insert blank rows between items in Excel | Make your analysis easier to read.
Easiest Multi-Level Drop-Down Lists in Excel!
Email or save Excel images with Power Automate | Excel Off The Grid
8 quick ways to open a new instance of Excel | Excel Off The Grid
Insert file path into a cell with Browse button | File dialog box in Excel | Excel Off The Grid
Promote headers in nested tables before expanding columns | Power Query | Excel Off The Grid
Power Query: Stop Excel Table columns resizing | Excel Off The Grid
Create worksheet for each item in a PivotField - AUTOMATICALLY!!! | Excel Off The Grid
Excel number formats for accounting & finance you NEED to know | Excel Off The Grid