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

Tag: 2016

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

15 Functions Every Aspiring Excel Pro Should Know

October 11, 2016 0 comments Article Excel, Intermediate

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

Improvements in how CSV File Saves are Handled in Excel

September 7, 2016 0 comments Article Easy, Excel

Microsoft have this month released an update which addresses a small, yet incredibly annoying ‘feature’ when working with csv files in Excel. Read on to learn more. Read More

Using TEXTJOIN and CONCATENATE for combining Text Strings in Excel

March 31, 2016 1 comment Article Easy, Excel

Learn about the different techniques for joining Text Strings in Excel, including the excellent new TEXTJOIN function Read More

Populating one Drop Down based on the Selection of Another in Excel – Without VBA

March 22, 2016 1 comment Article Excel, Intermediate

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

Showing Data Bars as a ‘Proportion to Total’ in Excel

March 17, 2016 2 comments Article Easy, 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 Read More

Using NETWORKDAYS to calculate the number of business days between two dates in Excel

March 14, 2016 0 comments Article Excel, Intermediate

NETWORKDAYS (That’s Net Work Days, not Network Days) is a versatile spreadsheet function that lets you calculate working days between two dates, allowing for weekends, public holidays and more. Read More

Creating Sunburst & TreeMap Charts in Excel 2016

February 29, 2016 0 comments Article Easy, Excel

Familiarise yourself with two of Excels fantastic new Chart Types – the Sunburst, and Treemap (collectively known as Hierarchical charts) Read More

Creating Waterfall Charts in Excel 2016

February 22, 2016 2 comments Article Easy, Excel

Excel 2016 has given us a plethora of useful – and long overdue – chart types for us to work with. One of these, is the Waterfall Chart I‘ve written before about how to create a Waterfall Chart in Excel – it has long been one of the more challenging chart types to re-create, so 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

Most Read Articles

How did Microsoft’s Power BI come to lead the Gartner Magic Quadrant?

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 2025 - Theme by ThemeinProgress