Microsoft Excel quick and easy
New Excel tutorial every week
Today we’re going to talk about the easiest way how to convert currency in Excel. First, we’re going to have a look at how we can conveniently obtain the information on the current exchange rates for various currencies. Then, we’re going to make a simple currency exchange calculator to convert any amount from one currency to another....
In this video tutorial, we’ll have a look at how to add Data Validation in Excel in a quick and easy way. Through this useful feature, we can set what data can and what can’t be entered into a cell with the result being exact, reliable and consistent data tables. We’re going to use this simple example to...
Today’s video tutorial shows how to find a circular reference in Excel. A circular reference is an error which can completely block your calculations. Once you’ve watched this tutorial, you’ll be able to locate circular references in a spreadsheet and fix them in a quick and easy way. What is a Circular Reference (Explained with Example) A circular reference in...
In this video tutorial, we’re going to work through a specific example to demonstrate how to calculate the standard deviation in Excel in a quick and easy way. We’re also going to talk about the difference between the functions STDEV.S and STDEV.P and how to use both correctly in a data analysis. What is Standard Deviation Let’s now...
Today we’ll be talking about how to use the TREND function in Excel. This interesting feature provides a realistic forecast based on past data. Let’s have a look! How to Choose the Right Data for the TREND function To begin with, it’s important to note that the TREND function is great when the data you’re working with...
In this video tutorial, we’re going to have a look at how to use the function Goal Seek in Excel in a quick and easy way. It comes very handy when you’ve got to calculate a value needed to achieve a set goal. So, let’s see how it works using a specific example. To better understand what Goal Seek in...
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...
