Microsoft Excel quick and easy
New Excel tutorial every week
This video tutorial offers a quick and easy guide on how to remove the dollar sign in Excel. We’re going to have a look at two different scenarios, so you’ll see what to do if the dollar sign has been entered as part of formatting and how to remove the sign if it’s part of text. Shall we...
Today we’re going to see the quickest and most convenient way how to copy a sheet in Excel. Are you ready? How to Copy a Single Sheet To quickly copy a sheet in Excel, we first click down here on the name of the sheet we want to copy. Let’s say we want to copy the sheet ‘2025’,...
In this video tutorial we’re going to cover the quickest way how to copy formatting in Excel. Thanks to these couple of steps, you’ll be able to copy formatting from one cell or range of cells to another – all this without any manual intervention, like setting the colour, fonts, or borders. Let’s do this! How...
This video tutorial shows how to merge cells in Excel in a super quick and easy way thanks to a hot key combination. And we surely won’t stop at that. We’ll have a look at how to unmerge cells using a shortcut key, too! Let’s get started now! How to Merge Cells in Excel Using a Shortcut Key To merge...
Today we’re going to go through a quick and easy guide on how to change the currency in Excel. These simple steps will make sure that the financial figures in a data table show in the right format – just as you need! Ready to start? So, let’s get into it! How to Select Cells for Currency...
Welcome! In this tutorial, we’re going to have a look at how to extract numbers from a cell easily, without the use of a complicated formula or VBA. Let’s start! How to Use Flash Fill for Quick Extraction To extract numbers from data in Excel may be easier than you think. The best way is to use Flash...
Welcome! In this tutorial, we’ll be talking about how to add a slicer in Excel in a quick and easy way. Slicers provide an interactive way to filter data and obtain the information you need promptly. Let’s see how it’s done then! How to Insert a Slicer in a Table To start with, I’d like to mention that we...
Pivot tables are amazing tools to summarise and analyse data. But as soon as anything changes in the source data, we’ve got to refresh them to keep them up to date. This video tutorial offers an ultimate guide on how to refresh a pivot table in Excel to make sure the pivot table shows the right,...
Today we’ll be talking about how to filter in a pivot table in a quick and easy way. Get ready to start! How to Insert a Filter in a Pivot Table To filter data in a pivot table, first click anywhere within the pivot table area. The section with ‘PivotTable Fields’ appears on the right, where we can find the...
In this video tutorial, we’re going to have a look at how to sort data in a pivot table. You’ll see a simple way to easily sort data in a pivot table smallest to largest or vice versa, depending on what you need. So, let’s get into it! How to Sort a Pivot Table by Number To sort data in...
