Mynda Treacy, Author at My Online Training Hub • Page 11 of 21

October 24, 2017

Convert Dates to Text

If you want to use a date in a chart label, or you want to concatenate a date with some

October 23, 2017

Fix Excel Dates Formatted as Text

Dates incorrectly entered or imported as text are a showstopper. We need our dates entered as date serial numbers to

October 20, 2017

Excel Date and Time Formatting

Even though dates and time are actually stored as a regular number known as the date serial number, we can

October 19, 2017

Excel NETWORKDAYS.INTL Function

The Excel NETWORKDAYS.INTL function (new in Excel 2010) returns the number of working days between two date serial numbers, excluding

October 12, 2017

Power Query Get Files from a Folder

If you receive your data in separate daily, weekly or monthly files then before you can even begin analyzing the

October 2, 2017

Label Excel Chart Min and Max

Highlighting the minimum and maximum in an Excel chart can help focus your readers’ attention. We can manually select points

September 26, 2017

Dynamically Label Excel Chart Series Lines

The default Excel chart legends can be awkward and time consuming to read when you have more than 2 series

September 19, 2017

Highlight Cells Referenced in Excel Formulas

In an ideal spreadsheet our formulas would always reference adjacent cells and columns and it would be obvious which cells

September 7, 2017

Excel Pivot Chart Drill Down Buttons

Excel Pivot Chart Drill down buttons are a new feature available in Excel 2016. You’ll find them in the bottom

August 22, 2017

Excel Extract a Unique List

As with most things in Excel, there are many ways to extract a list of unique or distinct values from

August 15, 2017

Excel Find and Remove Duplicates

Sometimes we want to find and remove duplicates in Excel, other times we just want to identify or highlight duplicates.

July 27, 2017

Excel Convert Dates to Fiscal Quarters and Years

If your company’s fiscal year runs in line with the calendar year then it’s easy to convert dates into quarters

July 20, 2017

Power Query Unpivot Scenarios

In this post I’m going to show you how to use Power Query’s Unpivot tool to fix 3 common data

July 11, 2017

Symbols in Excel Slicers

Did you know you can display symbols in Excel Slicers? That’s right, Slicers aren’t just limited to listing boring old

July 5, 2017

Excel Chart Secondary Axis Alternatives

Sometimes a secondary axis is a necessary evil. After all, most of the time you can’t plot big numbers and

June 29, 2017

Excel Chart Highlighting

One of the cool features of Power BI is the ability to cross filter and highlight charts. With a simple

June 13, 2017

Set Excel PivotTable Default Layout

New in Excel 2019 onward and Microsoft 365 is the ability to set a PivotTable default layout, which can save

June 1, 2017

Excel Dates Displayed in Different Languages

If you share Excel files and reports with users from different countries then you might want to give them a

May 24, 2017

Power Query Updates

The monthly update cycle for Excel’s Power Query sure keeps us on our toes. Power Query Updates for Excel 2010

May 17, 2017

Excel Themes

Excel Themes are a bundle of default colors, font styles and Shape effects. There are lots of built in Excel

April 26, 2017

Power Query Date Formats

Power Query* can easily take a column of dates and extract, or convert it into various handy date formats with

April 20, 2017

Excel Row and Column Shortcuts

Inserting, copying, moving, or cutting and pasting rows and columns is something we do every day in Excel. And there

April 14, 2017

Power Query Lists

In Excel we often need to work with lists. List of numbers, letters, dates, countries, products, you get the idea.

April 3, 2017

Excel PivotTable Distinct Count

With the integration of Power Pivot into Excel 2013 (known as the Data Model), we now have access to a

March 22, 2017

Excel TEXTJOIN Function

New in Excel 2019* is the TEXTJOIN Function. It's the grown-up sibling of CONCATENATE. Both TEXTJOIN and CONCATENATE join text

March 16, 2017

Excel Map Charts

New in Excel 2016 (for Office 365 subscription users only*) are Map Charts. *If you have Office 365 and can’t

March 1, 2017

Power Query Unpivot

Power Query’s Unpivot tool allows us to fix one of the most common mistakes (many) Excel users make when capturing

February 22, 2017

Excel Conditional Formatting Highlight Matches in List

In this tutorial we’re going to look at how we can use Excel Conditional Formatting to highlight rows in a

February 17, 2017

Excel Custom Number Format Guide

I’ve put together this Excel custom number format guide as a resource for our members. There are loads of ways

February 9, 2017

Excel Conditional Formatting to Highlight Matches

Using Excel Conditional Formatting to highlight matches is easy when you team it up with a data validation list like