Dynamic Power Query Cross Tab Reports – Pivot n Rows to n Columns 2 Ways!
Microsoft Excel Tips and Tricks Pivoting a variable number of rows into a variable number of columns into a cross[…]
Read more
Tag: excel
Create a Map Chart in Excel
Microsoft Excel Tips and Tricks Learn how to create your own map chart in Excel! Map charts are a great[…]
Read more
Excel Hash Sign Operator – What is it + ADVANCED Tricks!
Microsoft Excel Tips and Tricks The hash sign spill operator enables you to reference spilled arrays returned by dynamic array[…]
Read more
Top 3 Excel 2021 Tips and Tricks // BEST Microsoft Excel Tips & Tricks // Amazing Tips and Tricks
Microsoft Excel Tips and Tricks Top 3 Excel 2021 Tips and Tricks // BEST Microsoft Excel Tips & Tricks //[…]
Read more
NEW Navigation Pane in Excel
Microsoft Excel Tips and Tricks Excel for Microsoft Office 365 gets a new navigation pane! This makes it easy to[…]
Read more