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

Category: Excel

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

Using stacked images for your Excel Charts

February 23, 2016 0 comments Article Excel, Intermediate

Create colourful, engaging charts using stacked images in this comprehensive Excel walk through. 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

Using Ranking Functions in Excel

October 2, 2015 0 comments Article Easy, Excel

Master the available options in Excel for ranking you data, including the updated Rank.Eq functions. Read More

Pie Charts – how not to use them!

September 24, 2015 1 comment Article Easy, Excel

I originally posted this to my LinkedIn Profile, which you can find here, but thought I’d share it on here as well!

~

Plenty has been said before about whether or not you should use Pie Charts to present your data.

A good article covering their main pitfalls can be found here;

and a slightly lighter take on them can be found here;

Yet, it was my own father who reminded me that Pie Charts can be put to good use, as was the case with Florence Nightingale. (Though, they were of the somewhat more useful Rose Diagram type than bog standard Pie chart, but I take the point!)

Having said that, I came across this little gem, on the BBC news website of all places, which really must be the single worst usage of Pie Charts I’ve ever come across

Read More

Ways to Manage Large Excel Files (through zip, xls, xlsx, xlsb, pivot table caching)

August 21, 2015 1 comment Article Easy, Excel, Intermediate

Managing the file size of Excel files can seem a challenge, but there are some fairly simple steps you can take to make it a bit easier.

This post will take you through file management through File Formats, File Formatting and File Content, before finishing with some file sharing tips. Read More

Add Labels to Outliers in Excel Scatter Charts

August 4, 2015 1 comment Article Excel, Intermediate

 

Scatter charts are a great way to present the relationship between two data points

In my example, I’m using a scatter charts to monitor student test results – I want to compare their latest test score against how that score has changed from their last test.

 

Read More

Using Excel to Calculate Repayments & Interest using PMT, IPMT & PPMT Functions

April 10, 2015 0 comments Article Easy, Excel

If you’re borrowing or saving money, and want to compare rates, perhaps perform some What If analysis, there are built in function in Excel which can quickly help you PMT() The main one is PMT() This function takes a value, a rate and a ‘number of periods’ value and gives you the repayment. There are also Read More

« 1 2 3 4 5 »

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