Excel

Slicers enable you to quickly and easily toggle filters on and off. They're best known for working with PivotTables, but Slicers also work with Excel Tables. I like to use them to save time applying filters I use regularly, but we can also create dynamic reports by leveraging formulas that can recognize when a row …

Descriptive statistics enable you to summarize, organize, and simplify large datasets to derive meaningful patterns and insights. For a long time there’s only really been one tool to get descriptive statistics in Excel, but in this tutorial, I cover 3 ways. They all have their pros and cons.   Table of Contents Download the Excel …

Excel has a load of AI tools already built-in that we can use to improve productivity and make our lives easier. There are Excel AI tools that will clean data, analyze it for you, create automatic forecasts and even write custom LAMBDA formulas. And that’s all before Copilot gets added! Let’s take a look at …

Everything you need to know about how Excel handles date and time and all the tools you will need. Read in conjunction with the accompanying Excel file, which you can download below. Download the Files Enter your email address below to download the comprehensive Excel workbook, cheat sheets and PDF. Get Files By submitting your …

Excel Formatting Best Practices Proper use of Excel formatting can significantly impact the speed and clarity in which users can work with and interpret your spreadsheets. It enables you to highlight essential information, direct users, and encode data. Effective formatting subtly enhances usability, while poor formatting can be a distraction. These are my top 10 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

New to Windows is the ability to import data from a picture to Excel*. No more typing data manually into spreadsheets. It works with image files or screen captures on your clipboard. It's available on the Data tab of the Ribbon > From Picture, as shown below: *Import data from a picture requires a Microsoft …

Microsoft are massively investing in Excel Online and as a result there are some features that are now better than they are in the desktop version of Excel. The great news is that anyone can use Excel Online for free. You don’t need an Excel license or 365 membership! Watch the Video Download Workbook Enter …

I’ve received a lot of Excel files from our members over the years and I see the same mistakes time and again. In this post I’m going to list the 10 things you should never do in Excel and what to do instead to avoid trouble when working in Excel. Watch the Video Download Workbook …

In this tutorial I’m going to highlight some cool new Excel features that might have slipped under your radar, a couple of which we’ve wanted forever. These are available to Microsoft 365 users, and some are so new that they’re only available to Office Insiders users on the Beta Channel. If ever there was a …

Before we had the luxury of dynamic array functions, creating dependent data validation lists typically required using multiple tables and named ranges, as shown here. Setting them up was laborious, however now that we have dynamic array functions, creating dynamic dependent data validation lists is much easier. Note: this technique requires a Microsoft 365 license …

We’ve been able to share and collaborate in Excel files simultaneously with our co-workers for quite some time. However, recently there have been some significant improvements to the Excel co-authoring experience that will blow you away. All you need to co-author in Excel is a Microsoft 365 subscription and an internet connection. You can even …

When you spend days crafting your latest report, the last thing you need are well meaning users messing with your file. In this tutorial I’m going to show you how to use Excel workbook protection which will allow your users to experience the report as you intended. They can: Click Slicer buttons Refresh data connections …

Custom number format conditions allow you to specify a different format based on the size of a number. In this tutorial we’ll look at the different ways we can use them, including some fun with emojis! In the examples below I’ve used emojis with custom number formats to visualise temperatures. And instead of boring old …

A new feature in the Excel mobile app (iPhone and Android) is the ability to take a photo of your data and import it to an Excel worksheet. The import data from a picture to Excel feature is available to all mobile app users. No 365 subscription is necessary! If you have a Mac with …

Excel Forms are super useful if you collate data manually, for example via email or PDF forms. Or even if you’ve set up an Excel template for your users to enter data into, that you then spend time converting into a layout suitable for use with formulas and PivotTables. Excel Forms don’t require any complex …

Office 365 users now have access to the Visio for Excel free add-in enabling you to create Excel flow charts linked to cells like this: And org charts like this: And because they’re linked to cells, you simply refresh the connection and the diagrams update! Watch the Visio for Excel Free Add-in Video Download Workbook …

One of my bugbears is opening an Excel workbook that has Split Panes set when it should have Freeze Panes set. They’re easily confused, so I thought I’d explain the difference. Watch the Video Excel Freeze Panes Freeze Panes is used when you want to fix the top row(s) and or left most column(s) in …

AI powered Excel Data Types will transform the way we work with Excel by enabling a cell to contain much more than text, numbers or formulas. There are currently two Excel data types available to Office 365 users: Stocks and Geography. Let’s start with the Geography Data Type that can take a table of countries …

There is a new style of comment available in Excel for Office 365 users*. They’re technically called Threaded Comments, but they’ll be known as ‘Comments’ and they look like this: *Threaded comments are being made available to Office 365 users on a gradual basis over several weeks. Excel threaded comments allow you to string several …