16 тысяч подписчиков
312 видео
Extract Outlook meeting data into Excel live. Timesheets ++
Fill down in
Be in your slides with PowerPoint Cameo: Zoom, Teams, Google Meet+
Link from another file in Google Sheets in 2 mins
11 evaluate formula tricks to check/audit in Excel NEW in 2023
24 Dynamic array functions in Excel in 10 minutes
Power BI % of parent total & % of total in DAX/Power BI
Automatically colour in Google Sheets based on criteria/table design
Dictate and Transcribe in Word & OneNote. NEW IN 2023
Excel/G-Sheets: Alternate sheet/filter views for simultaneous editors (NEW 2020)
Microsoft/SharePoint Lists: Successor to Excel?
Extract financial year in Excel
Fix multi row headers in Power Query & native Excel
REGEX in Excel and Google Sheets to fix messy text
TEAMS: Webinar/Live events
Power Query, Power BI, and Power Pivot demystified
Join text in Excel, without CONCATENATE
Extract weekday or month in
Reference a cell in Power Query for Excel or a parameter for Power BI
Many to many issues and alternatives in Power BI
Reorder overlapping line charts in Power BI (New 2021)
Excel's custom function editor: Create, & reuse LAMBDAs in new files
Insert & place images in Cell & options: 2023 new in Excel
Power query errors: Detect, prevent & fix them
Pivot Column in Power Query error free for Excel & Power BI
Combine & Split columns with Excel's AI-enabled Flash Fill tool
Relative date / today in Power Query IF / conditional column
Office mob app: Photo to text/table, scan & Excel, PowerPoint & Word combined
Lock cells in formulas: Absolute & mixed referencing in Excel/G Sheets
Automatically colour in Excel based on criteria/table headers
Using Sway for a Power BI COVID data story
Report page tooltips/pop up on hover charts in Power BI in 2 ways
From picture to Excel data, and handling issues
Visio online: New easy venn, flow charts now free with M365 for biz
PivotTables but better, using new Excel function: GROUPBY PIVOTBY
Podcast: Why Excel will never die & tax tech
Structured tables for Google Sheets
#Aprilfools
22 Word formatting hacks you need to know
ISBETWEEN and ISDATE in Google Sheets
7 Python Charts that Excel couldn't do before
#Filter
Inbox zero to save time for Outlook & Gmail users
Merge cells alternatives in
Sparklines: In cells charts in Google Sheets
Auto create calendar from event data in Excel or Google Sheets
Interactive dashboards in Google sheets
No PowerPoint copilot? Do this instead in Canva, Chat GPT AI ++
Excel copilot vs similar features (free or cheap)
2-way
