Handling HTTP Errors in Power Query and Power BI
Excel Tips & Tricks Create your own custom error messages to help users know how to troubleshoot and fix errors[…]
Read more
Tag: exceltips
Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!)
Excel Tips & Tricks You can create your own free video library with Power Query Custom Data Types. You’ll learn[…]
Read more
Properly Create Surveys with Microsoft Forms & Export to Excel
Excel Tips & Tricks With Microsoft Forms you can collect data from different people with fillable forms you can control[…]
Read more
How to use Excel Index Match (the right way)
Excel Tips & Tricks How to do Index Match in Excel: The basics. Watch this video tutorial to find out[…]
Read more
PivotTables – Set Default Layouts & Formatting and SAVE TIME!
Excel Tips & Tricks Tired of changing the layout of each new PivotTable? With default PivotTable layouts you can eliminate[…]
Read more