Blog • Page 3 of 24 • My Online Training Hub

January 9, 2024

Excel GROUPBY and PIVOTBY Functions

The GROUPBY and PIVOTBY functions are a significant breakthrough in Excel's toolbox of functions. They let you easily group or

January 2, 2024

Personal Budget in Excel

With the cost-of-living crisis affecting everyone, it's essential to get control of your finances. Having a personal budget can be

December 19, 2023

Copilot in Excel

Imagine having a tool that transforms the way you work, a tool so powerful it's valued at a minimum of

December 12, 2023

Excel LABS.GENERATIVEAI Function

With AI gradually making its way into every aspect of our lives, working in Excel has become much easier. You

December 4, 2023

Excel Checkboxes In Cells

New in October 2023, Microsoft introduced Excel checkboxes embedded directly within cells*. This enhancement is set to streamline data interaction

November 28, 2023

Import Data From Web to Excel

We now have a new, improved way to import data from the web to Excel. Just like in Power BI,

November 20, 2023

Slicers for Excel Tables

Slicers enable you to quickly and easily toggle filters on and off. They're best known for working with PivotTables, but

November 7, 2023

Descriptive Statistics in Excel

Descriptive statistics enable you to summarize, organize, and simplify large datasets to derive meaningful patterns and insights. For a long

October 31, 2023

Custom Sort Excel Slicers

Slicers are a fantastic tool to get a filtered view of your data and visuals. But by default, they get

October 3, 2023

Excel SUMPRODUCT Function

The SUMPRODUCT function is one of Excel's most versatile functions. But now that we have SUMIFS, COUNTIFS, AVERAGEIFS etc. it’s

September 26, 2023

Excel Formulas to Summarise Monthly Data into Quarters

Back in my accounting days I regularly prepared reports that summarized monthly data into quarters. Back then, we used the

September 17, 2023

Excel BYCOL and BYROW Functions

Excel BYCOL and BYROW functions fundamentally change the way we write formulas that calculate across columns and down rows. They

September 5, 2023

Built-in Excel AI Tools

Excel has a load of AI tools already built-in that we can use to improve productivity and make our lives

August 25, 2023

Interactive Python Charts in Excel

One of the best uses for Python in Excel is creating the amazing charts available through Python libraries like Seaborn

August 22, 2023

How to Use Python in Excel Natively

You can now use Python in Excel natively! Python runs securely in the cloud, and we write Python in Excel

August 15, 2023

Excel Dynamic Named Ranges

Excel dynamic named ranges bring flexibility and efficiency to your spreadsheets. Unlike static named ranges, dynamic named ranges automatically adjust

August 8, 2023

Excel Functions for Financial Modeling

Excel functions are the backbone of a financial modeler’s day to day work and as such, it’s essential to have

August 1, 2023

Excel Progress Circle Charts

Progress charts are a powerful way to track milestones and showcase achievements. However, there’s no built-in way to create Excel

July 25, 2023

Write Excel Office Scripts with ChatGPT

Excel Office Scripts: The Future of Automation, Replacing VBA Excel Office Scripts have ushered in a new era of automation,

July 18, 2023

Get Started with Power Query

Efficiencies gained from Power Query can be life changing. I’m not exaggerating. Power Query can reduce time spent gathering and

July 13, 2023

Excel Date and Time

Everything you need to know about how Excel handles date and time and all the tools you will need. Read

July 11, 2023

Pro Excel Chart Formatting

Charts provide a visual representation of data, making it easier to understand and interpret large amounts of information quickly. At

July 6, 2023

12 PivotTable Formatting Tips

One of the downsides of PivotTables is they have a very distinctive look. Some might even say they’re ugly. In

June 27, 2023

Images in Excel PivotTables

With Microsoft 365 we can now include images in Excel PivotTables, as well as built in data types like Stock

June 20, 2023

Center Across Selection Macro

Annoyingly, there’s a shortcut for Merge & Center on the Ribbon, but nothing for Center Across Selection which is far

June 13, 2023

Excel Scroll and Sort Table

Dashboards have limited space which is why an Excel scroll and sort table is super handy. Scroll and sort tables

10 mistakes to avoid when using excel formatting

June 6, 2023

10 Mistakes to Avoid With Excel Formatting

Excel Formatting Best Practices Proper use of Excel formatting can significantly impact the speed and clarity in which users can

May 30, 2023

Excel Formula by Example

Excel can now write formulas for you. Simply give it an example or two and it’ll suggest a formula to

May 9, 2023

Excel Linear Regression

Excel linear regression is easy with the built-in tools. In this tutorial, we'll explore what linear regression is, why it's

May 2, 2023

How to Improve Excel Performance

Do you find yourself frustrated by sluggish Excel files that take forever to load or recalculate? If so, you're not