Mynda Treacy, Author at My Online Training Hub • Page 7 of 19

April 9, 2020

Searchable Drop Down List in Excel

Creating this searchable drop down list in Excel is so easy I’m wondering why I never thought of it before.

April 2, 2020

Import Multiple Files Containing Multiple Sheets with Power Query

In this post we’re going to look at how you can import multiple files containing multiple sheets with Power Query,

March 25, 2020

Excel Project Management Dashboard

Managing projects or tasks can be improved with a visual representation of progress and milestones. Thankfully, an Excel project management

March 5, 2020

20 Pro Excel Keyboard Shortcuts

This post contains 20 Excel keyboard shortcuts used by Excel pros. I’m not talking about CTRL+Z, and the like, these

February 20, 2020

Custom Excel Chart Label Positions

When you plot multiple series in a chart the labels can end up overlapping other data. A solution to this

February 13, 2020

Lookup Pictures in Excel

We can use a data validation list or a Slicer to lookup pictures in Excel. This ability to lookup pictures

February 6, 2020

Cross Highlight Excel Charts

One of the cool features in Power BI is the ability to cross highlight from one chart to another by

January 23, 2020

List First Monday Date in Each Month

With Excel formulas we can easily list the first Monday date in each month, or the last Sunday, or whatever

January 8, 2020

Excel XLOOKUP Function

Oh, how I wish I’d had the fortune of the new Excel XLOOKUP function back in my accounting days. The

December 11, 2019

Excel Hash 2019 – Dynamic Playoffs Table

Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular

December 3, 2019

Excel XOR Function

The Excel XOR function, or ‘exclusive OR’ as it’s known in the programming world, performs a test on an array,

November 28, 2019

Extract Start and End Dates with Power Query

A few weeks ago, Matt asked if we could extract start and end dates with Power Query. He has a

November 19, 2019

Excel Small Multiple Charts

Reduce clutter in busy line charts by plotting your data in small multiple charts, or panel charts as they’re sometimes

November 12, 2019

Overlay Line Chart Labels

Labeling charts is useful if the reader needs to know the exact value for each point. We can position labels

November 6, 2019

Excel Actual vs Target Chart

Often, you’ll find Actual vs Target charts based on categorical data in the form of a column chart, however they’re

October 22, 2019

Extract Values Present in Two Lists

Comparing two lists is easily done with Power Query, but maybe you prefer to use a formula to extract values

October 15, 2019

Reducing Data Validation List

Creating a reducing Data Validation list is easy with the new dynamic array formulas. Let’s say we have a list

September 19, 2019

Excel Data Tables

Excel Data Tables are one of the What-if Analysis tools that we have available to aid our decision making. They

September 12, 2019

Excel CONCAT Function

The Excel CONCAT function, new in Excel 2019, replaces the legacy CONCATENATE function*. It’s a simple function that joins the

August 22, 2019

Segmented Survey Data Chart

Charting survey data can be tricky, and when you want a segmented survey data chart it adds another layer of

August 14, 2019

Year on Year Charts

Year on year charts or data over time is one of the most common data visualisations you’ll see. However, the

August 8, 2019

Excel Bar Chart with Vertical Line

In this post I’m going to show you a way to create an Excel bar chart with a vertical line.

July 16, 2019

Excel PivotTable Field List Tips

The Excel PivotTable field list automatically appears in the task pane on the right-hand side of the Excel window when

July 9, 2019

Referencing the Next Row in Power Query

Unlike Excel, referencing the next row in Power Query, or even the previous row, is not as simple as we

June 25, 2019

Excel Calendar Template Date Formulas Explained

There are many Excel Calendar templates available and if you look at them closely, you’ll see they have some mind-boggling

June 3, 2019

Excel Freeze Panes vs Split Panes

One of my bugbears is opening an Excel workbook that has Split Panes set when it should have Freeze Panes

May 21, 2019

Scrape Data from Multiple Web Pages with Power Query

Previously we looked at scraping data from the web by example, where the website paginated the data. That is, it

May 14, 2019

Power Query Get Data from Web by Example

Getting data from the web is possible with Power Query in both Excel and Power BI. However, Excel is a

May 6, 2019

Include Grand Totals in Pivot Charts

If you work with PivotTables, then you’ve probably found that you can’t include grand totals in Pivot Charts, or subtotals

April 16, 2019

Power Query Approximate Match VLOOKUP

A while ago I wrote about to how perform the equivalent of an Excel exact match VLOOKUP formula with Power