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...
Today we’ll be speaking about how to create a bubble chart in Excel in a quick and easy way. The bubble chart is a great way to visually represent a relationship between three different sets of numerical values. Let’s start! What should I know before creating a bubble chart? Before we start creating a bubble chart in Excel, there are two important...
Today’s video tutorial offers a quick and easy way how to create a simple doughnut chart in Excel, through which you can make a clear visual representation of data. So, let’s have a look at how to do that! How to Create a Doughnut Chart in Excel First step to create a doughnut chart in Excel is to select data to be...
In this video tutorial you’ll see the easiest way how to start a new line in an Excel cell. You can easily divide a text of any length placed within one cell into several lines to make it all visible. We’ll also be talking about how to remove the entered line breaks and get the whole text...
Today we’re going to go through the easiest way how to remove a formula in Excel. First, we’re going to have a look at how to remove a formula in a selected area, for example in a specific column.