logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Tag: Functions

Transferring Data & Parameters Between Screens in PowerApps

November 27, 2016 1 comment Article Advanced, PowerApps

If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I want to show you how to transfer data between screens. This assumes you have created a data connection (See also: Creating a connection to an Enterprise Gateway), and have brought some data into your app (in Read More

Populate a Dropdown Based on the Value of Another Dropdown in PowerApps

November 27, 2016 1 comment Article Advanced, 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 Read More

Connecting PowerApps to an Existing Enterprise Gateway

November 27, 2016 0 comments Article Advanced, PowerApps

If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE In this session, I want to show you how to connect to an existing Enterprise Gateway. If you already use Microsoft’s PowerBI, there’s a good chance you already use an Enterprise Gateway to connect PowerBI to your on-premises SQL Server Read More

Creating Virtual Tables in Power BI Using DAX

November 26, 2016 0 comments Article Advanced, PowerBI

In this session, I want to show you how to use DAX / M expressions to create virtual tables. You may want to do this to create an aggregated view of your data to then work with, or perhaps filter down a dataset. I’ll show you examples of both, including doing both together. Once you’ve Read More

Using Formula Tracing in Excel

October 22, 2016 0 comments Article Easy, Excel

Formula tracing is a fantastic visual tool in Excel you can use to understand 1) which cells a given formula is referencing and 2) whether a given cell (or range of cells) is used by a formula elsewhere. Both have their uses, but it’s certainly the latter I get the most use from. Read on Read More

Using the Undocumented DATEDIF() Function in Excel

October 4, 2016 0 comments Article Easy, Excel

I’ve written before (albeit briefly, as more of a footnote) about finding the difference between two dates in Excel. This approach, of subtracting one date from another is fine if you want to know the number of days between two dates – and of course you can go one step further and use NETWORKDAYS to Read More

Warning: Opening Excel Files with Array Formulas in Google Sheets

September 23, 2016 2 comments Article Google Apps, Google Sheets, Intermediate

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 Read More

Using EOMONTH() to get the First and Last Date of a Given Month in Excel & Google Sheets

July 4, 2016 0 comments Article Easy, Excel

This update shows a quick and simple example of how to use the EOMONTH function to get the first, and last, date of a given month. Read More

Determine if a file is open in Excel or Google Sheets

June 21, 2016 0 comments Article Easy, Excel

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 Read More

Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016

February 21, 2016 1 comment Article Excel, Intermediate

Learn about 2 of the exciting new functions released as part of the Excel 2016 January update Read More

1 2 »

Most Read Articles

Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016
Populate a table by looping through items in a list / another table
Format or Remove Borders from a Slicer or Timeline in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Showing Data Bars as a 'Proportion to Total' in Excel

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2022 - Theme by ThemeinProgress