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

Category: Easy

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

Battery Health Status Report in Windows (8,8.1 and 10)

September 23, 2016 0 comments Article Easy, Windows

Anyone who routinely uses a laptop knows that the batteries in them don’t last forever. This is an inherent part of the Lithium-ion batteries used in much of today’s tech. It can therefore be helpful to get a better understanding of the current health of the battery – especially if you’re selling, or have just 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 the New Shape Maps in Microsoft PowerBI

July 21, 2016 0 comments Article Easy, PowerBI, Visual Insight

Could the new Map Shapes visualisation be a game-changer for PowerBI? I’m going to look at what the new feature does, and why it could well be. Although this is, I think, the first time I’ve written about Microsoft’s PowerBI, anyone who knows me personally will know I’ve been a huge fan, following its progress 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 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

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

March 17, 2016 1 comment 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

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

1 2 3 … 5 »

Most Read Articles

Format or Remove Borders from a Slicer or Timeline in Excel
Showing a Picture Based on the Value of another Cell in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Creating Virtual Tables in Power BI Using DAX
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 2021 - Theme by ThemeinProgress