# Excel 2013

Home/Excel 2013

## Excel Dependent Drop Downs

Dependent Drop Down Box   How to do one of those trickier tasks in Excel: set up a drop down box that is dependent on the result of another drop down box. The scenario If coffee is selected from drop down A then I want a list of coffee types to appear in drop down [...]

2017-03-08T03:53:54+00:00 Data Handling, Excel 2013, Excel 2016, Productivity|

## Easy Cumulative totals in Tables

Easy Cumulative totals in Tables The single greatest advancement in Excel in the last 10 years was the introduction of Tables.  Yet although Tables were introduced in Excel 2007 there is still a huge number (I'd even say the majority) of Excel users that don't know how to create tables or understand what they do. This [...]

2017-03-08T03:53:54+00:00 Data Handling, Excel 2013, Excel 2016, Productivity|

## When one Excel session just isn’t enough!

By Wyn Hopkins This simple tip may save you a lot of time and effort, but it must be used carefully. With the arrival of Excel 2013 we were finally able to easily split Excel between two screens and happily copy and paste between the two with full paste capability and without the worry of worksheet [...]

2017-03-08T03:53:54+00:00 Excel 2013, Excel 2016, Productivity|

## If you’re not Modelling Depreciation like this, you’re doing it the hard way!

Depreciation is one of those concepts that sounds easy and simple … until you try to put it into a financial model! In this blog, we start with Excel’s standard depreciation functions, then show two much better, more functional and more elegant ways to calculate depreciation. 1. Excel Functions Excel has some [...]

2017-03-08T03:53:55+00:00 Excel 2013, Excel 2016, Financial Modelling, Functions|

## SUBTOTAL Strangeness

Introducing SUBTOTAL SUBTOTAL is an incredibly useful function for producing reports … yet it’s relatively unknown. If you have a list of values that are in categories and you want a subtotal for each category, then a grand total at the bottom, it’s so much better & far more reliable than using SUM. The key [...]

2017-03-08T03:53:55+00:00 Data Handling, Excel 2007, Excel 2013|

## Label … not Le Cow

Apologies for the Dad joke above (not really), but in this article, I’ll show you how you can easily get data labels on all your data series, even if you have LOTS. All it takes is a little VBA code. In the data set below, I’ve made up some stats about how [...]

2017-03-08T03:53:55+00:00 Excel 2013, Excel 2016, VBA – Macros|

## Feeling Bloated? How to fix inexplicably large spreadsheets

Sticking with the theme of the health of your spreadsheet, have you ever notice spreadsheet become inexplicably bigger? Suddenly becoming 20MB instead of 2MB. One cause is unused rows and columns. How do I check and how do I fix it? Simple, on each worksheet in your file press End then Home. Your cursor will [...]

2017-03-08T03:53:56+00:00 Data Handling, Excel 2007, Excel 2013, Formatting|

## Excel 2013

Excel 2013 New Features of Excel 2013 By Sean Vincent Dual Screen Use One of the simplest updates to Excel in the latest version is the ability to now have 2 separate Workbooks open on shared screens. This allows much greater flexibility in the work environment. Rather than having to Tab between workbooks (potentially [...]

2017-03-08T03:54:06+00:00 Excel 2013|