Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Custom number format conditions allow you to specify a different format based on the size of a number. In this tutorial we’ll look at the different ways we can use them, including some fun with emojis! In the examples below I’ve used emojis with custom number formats to visualise temperatures. And instead of boring old …
A new feature in the Excel mobile app (iPhone and Android) is the ability to take a photo of your data and import it to an Excel worksheet. The import data from a picture to Excel feature is available to all mobile app users. No 365 subscription is necessary! If you have a Mac with …
Excel Forms are super useful if you collate data manually, for example via email or PDF forms. Or even if you’ve set up an Excel template for your users to enter data into, that you then spend time converting into a layout suitable for use with formulas and PivotTables. Excel Forms don’t require any complex …
Office 365 users now have access to the Visio for Excel free add-in enabling you to create Excel flow charts linked to cells like this: And org charts like this: And because they’re linked to cells, you simply refresh the connection and the diagrams update! Watch the Visio for Excel Free Add-in Video Download Workbook …
Creating this searchable drop down list in Excel is so easy I’m wondering why I never thought of it before. It doesn’t require any formulas or VBA and it has all the bells and whistles you’d expect from a searchable drop down list, including automatic sorting, ignoring duplicates and an option to select ‘All’: Watch …
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 …
Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular cooking show, Chopped. The one where chefs are given a mystery box of four ingredients to make a meal from. 2018 was the inaugural year for Excel Hash and I was honoured to win! It’s …
One of my bugbears is opening an Excel workbook that has Split Panes set when it should have Freeze Panes set. They’re easily confused, so I thought I’d explain the difference. Watch the Video Excel Freeze Panes Freeze Panes is used when you want to fix the top row(s) and or left most column(s) in …
AI powered Excel Data Types will transform the way we work with Excel by enabling a cell to contain much more than text, numbers or formulas. There are currently two Excel data types available to Office 365 users*; Stocks and Geography. Let’s start with the Geography Data Type that can take a table of countries …
There is a new style of comment available in Excel for Office 365 users*. They’re technically called Threaded Comments, but they’ll be known as ‘Comments’ and they look like this: *Threaded comments are being made available to Office 365 users on a gradual basis over several weeks. Excel threaded comments allow you to string several …
