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

Tag: Conditional

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

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 “Transparent” option in SSRS, and prevent the ‘Not a Valid BackgroundColor’ Error

July 31, 2015 1 comment Article Intermediate, SSRS

  In SSRS, if you’re building an expression to manage, for example, the background colour of a cell / shape, it’s easy to fall into the ‘Transparent Trap’ When building an expression, it’s easy to use the expression builder to add constants and built-in values. This is particularly true of the colour pallet, given you 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

Showing a Picture Based on the Value of another Cell in Excel

March 24, 2015 11 comments Article Advanced, Excel

In this walk-through ,I will show you how to use Excel to make a specific image show depending on a cells value, or by having a drop-down list Read More

Creating Waterfall Charts in Excel [2007,2010,2013]

March 20, 2015 3 comments Article Advanced, Excel, Microsoft Office

Update: Feb 2016 – If you’re using Excel 2016, be sure to check out the new Waterfall Chart Type, which makes waterfall charts a breeze. Learn more here

Waterfall Charts are another one of those charts that’s much harder to put together than it should be, particularly as they’re a great way to understand the sequential impact of positive & negative values to a total.

That being said, they’re really not as bad as to put together as they’re sometime perceived to be. As with most of the chart techniques I’ve demonstrated, it’s really about tricking excel to show the bits of data you want it to show.

We’re going to go through the process to create the below chart – a simple income & expenditure chart for a shop.

I’m using excel 2013, but the approach is almost identical for previous versions of Excel

Read More

Highlighting Duplicate Values in Excel – [Excel 2007, 2010, 2013]

March 13, 2015 0 comments Article Easy, Excel

 

One of the most common questions I hear, is around how to manage duplicate values in Excel.

I’ve already covered off how to remove duplicate values in this post.

I personally feel the ability to remove and highlight duplicates should grouped together, but whilst removing duplicates forms part its own ‘feature’, highlighting duplicates forms part of the wider Conditional Formatting functionality.

Since Excel 2007, highlighting duplicates has been very straightforward, with a pre-defined option to enabling it. So it’s this approach I will cover in this post. It can still be achieved in 2003 using a simple formula, but hopefully by now everyone is using 2007+ Read More

Using SUMPRODUCT to create a Conditional Weighted Average in Excel

April 4, 2014 3 comments Article Easy, Excel, Intermediate

Follow this article to learn how to use this resourceful function to create a Conditional Weighted Average in Excel Read More

Using Hlookups to bring back results in Excel

January 31, 2014 0 comments Article Easy, Excel

  Today I want to do a quick page on using Hlookups in Excel. Hlookups work in much the same way as a Vlookup (H being Horiztonal Lookup rather than V being Vertical Lookup) but often people forget about it or afraid to use it, instead favouring a more complex approach to the problem. For Read More

« 1 2 3 »

Most Read Articles

Showing a Picture Based on the Value of another Cell in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Showing Data Bars as a 'Proportion to Total' in Excel
Format or Remove Borders from a Slicer or Timeline in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Using the same Named Range in multiple worksheets, but with different values, 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