• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Blog

You are here: Home / Blog
excel formula by example

Excel Formula by Example

May 30, 2023 by Mynda Treacy

Excel can now write formulas for you. Simply give it an example or two and it’ll suggest a formula to complete the task. Remember how amazing Flash Fill was when you saw it for the first time? Well, Formula by Example is 10x better because it isn’t a one time and done solution. Being a …

Read moreExcel Formula by Example
linear regression

Excel Linear Regression

May 9, 2023 by Mynda Treacy

Excel linear regression is easy with the built-in tools. In this tutorial, we'll explore what linear regression is, why it's useful, and the Excel tools that enable you to do it with the click of a few buttons. Table of Contents Video - Excel Linear Regression Download the Workbook What is Linear Regression and its …

Read moreExcel Linear Regression
speed up slow excel files

How to Improve Excel Performance

May 2, 2023 by Mynda Treacy

Do you find yourself frustrated by sluggish Excel files that take forever to load or recalculate? If so, you're not alone. Slow Excel files can be a common headache for anyone who uses spreadsheets regularly. Fortunately, there are many tips and tricks you can use to improve Excel performance. In this tutorial, we'll identify the …

Read moreHow to Improve Excel Performance
excel project management dashboard custom periods

Project Management Dashboard Dynamic Periods

April 20, 2023 by Mynda Treacy

One of my most popular tutorials has been my Excel Project Management dashboard with nearly 2M views to date. However, I often get asked if there’s a way to switch between viewing the projects by day, week or month. The answer is yes and, in this tutorial I’m going to show you how we can …

Read moreProject Management Dashboard Dynamic Periods
Securely Share Excel Files

Securely Share Excel Files

April 5, 2023 by Mynda Treacy

In today's world, where remote work has become increasingly common, the need to securely share files with multiple people has never been greater. Whether your file is in the cloud or a local network drive, Microsoft has tools to enable you to prevent unauthorised opening, editing and downloading of your data. Table of Contents How …

Read moreSecurely Share Excel Files
excel check boxes

Interactive Excel Check Boxes

March 30, 2023 by Mynda Treacy

Excel check boxes are a type of form control that can be added to a spreadsheet with just a few clicks to create an interactive list of items that can be checked off. You can also link them to formulas to dynamically turn off and on items you want displayed in a chart or conditional …

Read moreInteractive Excel Check Boxes

Power Query if Statements incl. Nested ifs, if or, if and

March 23, 2023 by Mynda Treacy

Power Query if statements, nested if, 'if or' and 'if and' statements are a bit different to writing IF formulas in Excel, but once you get the hang of them they’re pretty easy. In fact, the Power Query IF formula, IF OR, and IF AND are even easier than the Excel equivalents. Table of Contents …

Read morePower Query if Statements incl. Nested ifs, if or, if and
tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

March 9, 2023 by Mynda Treacy

When working in multiple Excel files we can waste a lot of time flitting back and forth between them. In this tutorial you'll learn some game-changing tips that are guaranteed to streamline your workflow, making it easier than ever to navigate, arrange, and seamlessly work between multiple Excel files. Watch the Video Navigating Multiple Excel …

Read moreHacks for Working in Multiple Excel Files
picture fill excel charts

Picture Fill Excel Charts

March 2, 2023 by Mynda Treacy

When building reports, it's important that people not only understand what you're saying but also remember it. Picture fill Excel charts are a simple way to make your data visualizations more captivating and memorable. They’re suitable for infographics and fun reports, but I wouldn’t necessarily use them in corporate style reports. You can create them …

Read morePicture Fill Excel Charts
ai-aided excel formula editor

AI Aided Excel Formula Editor

February 23, 2023 by Mynda Treacy

Writing Excel formulas is one of the most important tasks to master in Excel, but it can be a mine field trying to get your head around all the functions available and knowing which one to use for the task at hand. But now with this free AI-aided formula editor you can have it write …

Read moreAI Aided Excel Formula Editor
chatgpt for excel

ChatGPT for Excel

February 16, 2023 by Mynda Treacy

Everyone’s talking about using ChatGPT for Excel and how it can improve your productivity with claims it’ll make you n times more productive and the like. I can tell you it’s not all it’s cracked up to be! If you want to be more productive in Excel, learn Power Query. That’s not to say ChatGPT …

Read moreChatGPT for Excel
excel infographic tools

Excel Infographic Tools

February 9, 2023 by Mynda Treacy

In this tutorial I’m going to share with you some hidden Excel chart techniques that will make your reports stand out and draw your readers in. These techniques are often used for infographic style reports, but that’s not to say you can’t use them in dashboards or even PowerPoint presentations. Infographics are a one off …

Read moreExcel Infographic Tools
ai dashboard design

AI Dashboard Design

February 2, 2023 by Mynda Treacy

Designing dashboards and reports can be a time consuming task, particularly if you’re not artistically inclined. In 60 seconds, AI generated four dashboard designs for me for free! All I had to do was give it a sentence worth of instructions and it returned the four bicycle sales dashboards you see below. I think you’ll …

Read moreAI Dashboard Design
excel templates

Where to Find Free Excel Templates

January 26, 2023 by Mynda Treacy

Excel templates can save you time designing, setting up and standardising forms and reports. There are hundreds of free templates covering many types of documents and themes available for all Excel users. Excel templates work in the Excel desktop app and Excel Online. Watch the Video Free Excel Templates You’ll find free Excel templates via …

Read moreWhere to Find Free Excel Templates
excel speedometer charts

Excel Speedometer Charts

January 19, 2023 by Mynda Treacy

Excel Speedometer charts or gauge charts as they’re also known, have a worse reputation in data visualization circles than the disdained pie chart. It’s primarily because they take up a huge amount of space and ink relative to the amount of information they convey. In this tutorial we’re going to learn how to build Excel …

Read moreExcel Speedometer Charts
top excel functions for data analysts

Top Excel Functions for Data Analysts

January 12, 2023 by Mynda Treacy

A data analyst gathers, cleans, models, analyses, and interprets data. The gathering and cleaning should be done with Power Query. The modelling and analysis can be done with a combination of PivotTables/Power Pivot and functions. The other day I stumbled upon a post claiming to list the top Excel functions for data analysts. I disagreed …

Read moreTop Excel Functions for Data Analysts
excel advanced formula environment

Excel Advanced Formula Environment

December 15, 2022 by Mynda Treacy

Excel’s new Advanced Formula Environment (AFE) is still in its early stages of development, but it’s already very useful, particularly if you’re scared to write your own LAMBDA functions, as you’ll see it can write them for you! You may have seen me use it a few times in tutorials lately, but recently it has …

Read moreExcel Advanced Formula Environment
Pro Excel Formula Writing Tips

Pro Excel Formula Writing Tips

November 30, 2022 by Mynda Treacy

Excel Formula Writing Tips, Tricks and Tools that will change how you work in Excel Formulas are THE MOST IMPORTANT EXCEL SKILL you can master, but when you start nesting functions, things can quickly get out of hand. In this lesson I’m going to cover some little known Excel formula writing tips, tricks and tools …

Read morePro Excel Formula Writing Tips
dark theme dashboards

Dark Themed Excel Dashboards

November 17, 2022 by Mynda Treacy

If you’re going to build dark themed Excel dashboards, then you need to have some tricks up your sleeve in order to give them that wow factor. In this tutorial I’m going to show you some techniques that work well with dark colours that will have your data popping. In the video below I build …

Read moreDark Themed Excel Dashboards
double click shortcuts thumbnail

Hidden Excel Double Click Shortcuts

November 10, 2022 by Mynda Treacy

Keyboard shortcuts are great, but there are also hidden Excel double click features and shortcuts available for mouse users. Which means everyone, because we all use the mouse, even those hardcore keyboard shortcut fans. Watch the Video Download the Quick Reference Cheat Sheet [FREE] Enter your email address below to download the sample workbook. Get …

Read moreHidden Excel Double Click Shortcuts
burn up burn down charts

Excel Project Management Burn Down and Burn Up Charts

November 3, 2022 by Mynda Treacy

Excel Burn Down and Burn Up Charts are easy to make with line or scatter charts. If you’re familiar with Agile Project Management, then you’ll know that these charts are useful for monitoring the progress of a project against expectations. While the terminology is specific to Agile Project Management, the concept is relevant to managing …

Read moreExcel Project Management Burn Down and Burn Up Charts
wee people font charts

Excel WeePeople Font Charts

October 27, 2022 by Mynda Treacy

Excel WeePeople font charts enable you to build interesting variations on waffle, bar and column charts, to name a few. They’re great for visualising demographic data, survey data and more. The free WeePeople font, courtesy of ProPublica, consists of 20 different people silhouettes hand drawn by Alberto Cairo. The last 6 letters of the alphabet …

Read moreExcel WeePeople Font Charts
excel dot map charts

Excel Dot Map Charts

October 20, 2022 by Mynda Treacy

One of the things that makes Excel stand apart from other reporting tools is its immense flexibility. With some tinkering you can make charts and graphics that don’t look anything like Excel. In this post I’m going to take you through the steps to create Excel dot map charts. And while there’s no built in …

Read moreExcel Dot Map Charts
excel shaping arrays

New Array Shaping Excel Functions

October 6, 2022 by Mynda Treacy

Microsoft recently released 11 new Excel functions for shaping arrays (data). I already covered VSTACK and HSTACK which was super popular, and in this post I’m going to use some of the other new functions to do things that used to require ninja level function wrangling. You can see the individual tutorials covered in the …

Read moreNew Array Shaping Excel Functions
excel dashboards custom backgrounds

Custom Excel Dashboard Backgrounds

September 29, 2022 by Mynda Treacy

Custom Excel dashboard backgrounds are super easy to create and can bring a level of polish and professionalism to your reports. Taking your reports from this: To this: And the good news is they’re super easy to create using PowerPoint. Watch the Video Custom Excel Dashboard Backgrounds Step by Step The first step is to …

Read moreCustom Excel Dashboard Backgrounds
excel nested if functions what not to do

Excel IF Formulas and What Not To Do

September 22, 2022 by Mynda Treacy

We can learn a lot from looking at what others do in Excel, both the good and the not so good. Last week one of my course members asked me to help them understand what a nested IF formula was doing in a file they’d inherited in their new job. It contained 15 nested IF …

Read moreExcel IF Formulas and What Not To Do
excel image function

Excel IMAGE Function

September 8, 2022 by Mynda Treacy

The new Excel IMAGE function enables you to insert images into cells with a formula. From there you can resize them, sort, filter and more. The IMAGE function supports BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP file types. The IMAGE function is currently in the beta testing phase so the function arguments may change …

Read moreExcel IMAGE Function

Excel VSTACK and HSTACK Functions

September 1, 2022 by Mynda Treacy

Excel VSTACK and HSTACK functions are just two of a raft of new text manipulation functions available to Microsoft 365 users. I wrote about text splitting functions, TEXTSPLIT, TEXTBEFORE and TEXTAFTER a while back. The new VSTACK and HSTACK functions work to combine arrays arranged vertically (VSTACK) or horizontally (HSTACK) into a new single array. …

Read moreExcel VSTACK and HSTACK Functions
Excel S Curve Charts

Excel S-Curve Charts

August 25, 2022 by Mynda Treacy

S-curve charts are a common tool used in project management to track the cumulative costs, hours, sales etc. over time. The chart forms the shape of an S because typically progress starts slow and ends slow, with acceleration in the middle periods. For example, in the s-curve chart below you can see progress is slow …

Read moreExcel S-Curve Charts
Easily Remove Password Protection from Excel Files

Easily Remove Excel Password Protection

August 11, 2022 by Mynda Treacy

In most cases you can easily remove Excel password protection if you’ve forgotten the password. However, the likelihood of your success depends on which password protection method was used, as some of the four options below are more robust than others. Excel password protection is available for: Sheets Workbooks File Open File Edit Each method …

Read moreEasily Remove Excel Password Protection
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 22
  • Next

Sidebar

More results...

launch excel macros course excel vba course

Featured Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x