Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I’ll show you how to setup a series of drop-down menus were the list of available values is based on the value selected in the first dropdown Start by creating a new screen, and creating a Connection
15 Functions Every Aspiring Excel Pro Should Know
When you first start using Excel, you’ll quickly become familiar with using basic functions such as SUM, COUNT, MIN, AVERAGE Before long, you’ll be using VLOOKUP’s, IF’s and creating Pivot Tables in order to start bringing you data to life. However, it’s around this phase that I often see people plateauing in their Excel learning
Warning: Opening Excel Files with Array Formulas in Google Sheets
From time to time, you might have to work with both Excel and Google Sheets interchangeably. Generally, opening fairly standard Excel Files in Google Sheets works fine – Google has strong support for most Excel functions. More complex or large worksheets generally fail to open in Google Sheets – not ideal, but at least there’s no hiding from
EU Brexit Referendum – A Look Behind The Numbers
The EU Referendum has been a huge talking point, right around the world. Whatever happens next, the effects of this vote will be felt for generations to come. Taking the politics out for a moment, and returning to something a little more ‘my area’, I thought I’d take look at what proportion of registered voters
Determine if a file is open in Excel or Google Sheets
We currently use a mixture of Excel and Google Sheets. Not ideal, but it’s important that any output I create can behave with both platforms, there are inherent differences in the platforms. Some of these differences simply can’t be accommodated for. Others, however, can be worked around From time to time, I need my document
Using the same Named Range in multiple worksheets, but with different values, in Excel
Use this trick to create use the same Named Range across multiple worksheets, but with each worksheet holding a different value
Using TEXTJOIN and CONCATENATE for combining Text Strings in Excel
Learn about the different techniques for joining Text Strings in Excel, including the excellent new TEXTJOIN function
Populating one Drop Down based on the Selection of Another in Excel – Without VBA
This post will show you how to populate a drop-down menu in Excel with values, based on the value selected in another drop-down menu – all without touching VBA
Showing Data Bars as a ‘Proportion to Total’ in Excel
Use this trick to show Excel Data Bars (the in-cell micro-chart) as a ‘percentage to total’ rather than relative to the max value
Using stacked images for your Excel Charts
Create colourful, engaging charts using stacked images in this comprehensive Excel walk through.
Most Read Articles
