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...
This video goes through the simplest way how to delete a pivot table in Excel. Shall we have a look? To remove a pivot table completely, click anywhere within the pivot table area. Then right-click and choose the option ‘Delete PivotTable’. And that’s all it takes! The pivot table’s gone. Don’t miss out a great opportunity to learn: If...
This video tutorial offers a comprehensive guide for beginners on how to create a pivot table in Excel. The pivot table serves as a powerful tool through which we can analyse and summarise even large amounts of data in a quick and very convenient way. All that without the necessity to know complicated Excel functions. How great is that?...
Today we’re going to have a look at how to copy a PDF table to Excel. You’ll be able to import a data table of any size from a PDF file right into an Excel spreadsheet in a super quick and super simple way. Let’s start! How to Select and Load Data from a PDF in Excel The first step to...
In this video tutorial, we’re going to see how to copy and paste formulas in Excel without changing cell references. First, we’ll be talking about how to simply copy and paste a single formula without changing cell references and then we’ll move to a whole range of cells containing a formula and see how it works there. Shall...
