Mynda Treacy, Author at My Online Training Hub • Page 12 of 20

January 12, 2016

Excel ROWS and COLUMNS Functions

You'll typically find the ROW(S) or COLUMN(S) functions nested inside other functions because they make formulas more efficient to write.

December 15, 2015

Use Excel Slicer Selection in Formulas

Slicers are a great tool for incorporating interactivity into your reports but we don’t always want to analyse our data

December 8, 2015

Creating Excel Charts from Multiple PivotTables

In an ideal world our data will be in one table so we can easily analyse it in a PivotTable

November 24, 2015

Excel Advent Calendar 2015

Around this time last Year I created an Advent Calendar in Excel: To Count Up or To Count Down? Now,

November 17, 2015

Excel Pivot Cache

Updated 16 May 2023 Note: This does not apply to Power Pivot aka Data Model PivotTables. When you create a

November 10, 2015

Excel User Voice

I bet there's been the odd time you've said to yourself "wouldn't it be nice if Excel had..." Or maybe

October 27, 2015

Calculating MEDIAN in PivotTables

Unfortunately there’s no built in way to calculate the median in a PivotTable. The approach is different depending on whether

October 20, 2015

Combine Excel Worksheets with Power Query

A recurring task in my previous life as an accountant was to analyse actual vs budget figures. However the figures

October 13, 2015

Excel Slicer Trick

That’s a rubbish title, I know. I couldn’t think of a succinct way to describe what I’m about to show

October 6, 2015

Excel AGGREGATE Function

The AGGREGATE Function is the Swiss Army Knife of functions; it’s so versatile it can replace these 19 Excel functions

September 15, 2015

New Charts in Excel 2016

With Office 2016 officially launching on September 22, 2015 I thought I’d give you a sneak peek at a few

September 11, 2015

Excel End of Period Dates

“Funny” days versus funny “Days” Guest post by Roger Govier, Microsoft Excel MVP Do you ever have “Funny” days? You

August 25, 2015

Excel Flash Fill

Excel’s Flash Fill tool is so cool that you’ll be looking for reasons to use it! Introduced in Excel 2013

August 11, 2015

Excel Fill Series

The Excel Fill Series tool is like having a bundle of tricks at your fingertips. It can help with one

August 4, 2015

Excel Copy and Paste Visible Cells Only

Have you ever wanted to only copy or paste visible cells? For example, below I have a table containing outstanding

July 28, 2015

Excel PivotTable Calculated Items by Position

A while back I wrote about how to create Excel PivotTable Calculated Items using the conventional approach of referencing the

July 23, 2015

Excel Sparklines

Put some spark in your chart! Excel Sparklines were introduced in Excel 2010 and are great for displaying the trend

June 23, 2015

Excel Named Range Shortcut

An Excel Named Range is a powerful tool and something we should all be using to make our formulas quick

June 9, 2015

Customize Default Excel Workbook

Did you know that when Excel opens a new workbook it uses a template called ‘Book’ to create the new

June 2, 2015

Excel Fill Value Down Rows based on Criteria

A few weeks ago one of our members, Kylie, sent me this question: “How can I fill column E

May 26, 2015

Pivot Charts

I’ve always thought after inserting a PivotTable that Excel should ask “would you like a PivotChart with that?”. I think

May 12, 2015

Excel PivotTable Calculated Items

Inserting Excel PivotTable Calculated Items is a great way to analyse your data and automatically incorporate that analysis in your

May 6, 2015

Excel Slicers for Fiscal Years

There’s no built-in way to create Excel Slicers for fiscal years, however the solution is easily achieved by adding an

May 6, 2015

Excel Slicers for Rolling Periods

Excel Slicers for rolling periods, for example; the last 12 months, requires a column in your source data that looks

April 28, 2015

Create a Single Excel Slicer for Year and Month

In this tutorial we’re going to look at how we can create a single Excel Slicer for Year and Month,

April 20, 2015

Excel Worksheet Protection

Excel worksheet protection is a great way to prevent people accidentally messing up the reports you’ve spent hours creating. However,

April 14, 2015

Excel Chart Vertical Axis Text Labels

In this tutorial we’re going to look at how we can twist Excel’s arm into putting text labels on the

April 1, 2015

Charting Variances in Excel

In my previous life as an accountant one of my main tasks was to analyse budget vs actual variances and

March 24, 2015

Excel Quick Analysis

A new feature in Excel 2013 is called Quick Analysis – it’s data analysis made easy, so easy my 6

March 17, 2015

Give me a SIGN, Excel

The Excel SIGN function returns a 1 if the number is positive, a zero if it’s zero and a -1