My Online Training Hub
Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Keyboard shortcuts are great, but there are also hidden Excel double click features and shortcuts available for mouse users. Which means everyone, because we all use the mouse, even those hardcore keyboard shortcut fans. Watch the Video Download the Quick Reference Cheat Sheet [FREE] Enter your email address below to download the sample workbook. Get …
Writing DAX is hard enough. If there were some way to make the experience a little easier wouldn't that be great? To that end, below is a list of keyboard shortcuts you can use in the Power BI Desktop DAX Editor. Watch the Video To See What These Shortcuts Do Download DAX Editor Shortcuts PDF …
Below is a list of time saving keyboard shortcuts that you can use in Power Query, in both Excel and Power BI. Watch the video to see me demonstrate how to use them, and download a PDF containing all shortcuts. Watch the Video Download Power Query Shortcuts PDF Enter your email address below to download …
This post contains 20 Excel keyboard shortcuts used by Excel pros. I’m not talking about CTRL+Z, and the like, these are keyboard shortcuts that will take your skills to the next level of productivity. As you read through the list please make a note of the keyboard shortcuts that amaze you, then please share them …
On IBM compatible PC's, many characters that can't be typed on a keyboard can be entered by holding down the ALT key and then using the numeric keypad to type the ASCII or Unicode code for that character. For example, holding down ALT and then typing 184 on the numeric keypad, prints ©, the copyright …
An Excel Named Range is a powerful tool and something we should all be using to make our formulas quick and easy to write and read. I’m not going to cover the basics of creating a named range as I’ve done that elsewhere. However I want to remind you of the different types of names …
