This video tutorial offers a step-by-step guide on how to merge two columns in Excel. In our example, we’ll merge a person’s first name and surname in a separate column in a quick and easy way. The same way works if you’d like to merge larger amounts of data to avoid tedious typing and copy-pasting. How to Use CONCATENATE...
This video tutorial offers the simplest way how to transpose data in Excel. We can easily switch from having data organized in columns to presenting them in rows and vice versa. How to Select Data for Transposing In the first step to transpose data in Excel, we need to select the relevant area we want...
In this video tutorial, we’re going to have a look at how to use a shortcut key for Paste Special in Excel. So, here we go! How to Copy the Data There are a number of ways thanks to which we can quickly and easily access the Paste Special option in Excel. Here, we’ll have a look at one...
In today’s video tutorial, we’re going to talk about how to autofill dates in Excel. You’ll see how Excel can quickly create a series of dates of any length with no tedious typing needed on your side. Getting curious? Join us now! How to Enter the Starting Date To create a series of dates of any length...
Today we’ll be talking about how to use a shortcut key to insert a column in Excel. Let’s get to it now, shall we? First Way: How to Insert a Column Using a Shortcut Key To insert a new column in a data table, first we need to click and select the column to the right of where we want to...
In this video tutorial, we’re going to have a look at how to add the dollar sign in Excel. Quick and easy – let’s get started! How to Select Cells for Formatting To add the dollar sign to numbers in an Excel spreadsheet, first let’s select all the numbers next to which we want to display...
Today we’ll be talking about how to make all cells the same size in Excel. Let’s start! How to Select All Cells in One Click To make all cells in the spreadsheet the same size, first click into the top left corner of the sheet to select all columns and rows. How to Resize All...
This video tutorial goes through how to create a radar chart in Excel in a quick and easy way. The radar chart provides a neat visualization of data which is ideal for data comparison. Let’s start! How To Create a Radar Chart in Excel To see how to create a radar chart, we’ll have a look at the following example where...
In this video tutorial we’re going to talk about how to create a line graph with multiple lines in Excel. First, we’ll be going through how to create a line graph with two lines in a quick and easy way. Then we’ll be talking about how to add or remove lines from the graph to have the...
This video tutorial offers two quick and easy ways how to copy a formula down a column in Excel. The first way works great with smaller data tables, whereas the other way helps more with large ones, especially when you need to copy the formula instantly throughout many entries. Shall we start? How to copy a formula down...
