Looking for some awesome Excel tips and tutorials? You’re at the right place.
Here you’ll find a collection of amazing excel tips that will make you an Excel Ninja and save a lot of time.
All the Excel tips are covered in detail with supporting images and a video (in most of the cases).
If you’re a beginner in Excel, you can start from out Learn Excel section.
You also find tips and tutorials on various Excel topics such as charting, dashboards, and VBA. In addition to the tutorials, you will also find some useful Excel templates that you can download for free.
You will also find Excel formula tips to get common tasks done using the formulas. You can also visit the Excel Functions section to learn about most commonly used Excel functions such as VLOOKUP, INDEX, OFFSET, COUNTIF, IFÂ and so on..
Also check out our Online Excel Training courses on Excel (Basic to Advanced), Dashboard, and VBA.
Excel allows you to format dates in many different ways. You can choose to show the date in a short date format or in a long date format. You can also only show the day number, the month name, or the year from a given date. In this short Excel tutorial, I will show you …
If you want to flip data in Excel, there are a few ways to do it. By that I mean reversing the order of the data upside down in a vertical dataset or left to right in a horizontal dataset. Now, if you’re thinking that there must be an inbuilt feature to do this in …
When working with Excel spreadsheets, most people are either short on time or have a deadline to meet. And it could be a nightmare if, at that point in time, Microsoft Excel decides not to open (arghhhhh!). Unfortunately, this unexpected behavior is quite common where Excel refuses to open one of your important Excel files, …
When working with data in Excel, you’ll often have the issues of handling outliers in your data set. Having outliers is quite common in all kinds of data, and it’s important to identify and treat these outliers to make sure that your analysis is correct and more meaningful. In this tutorial, I’ll show you how …
Since dates and times are stored as numbers in the back end in Excel, you can easily use simple arithmetic operations and formulas on the date and time values. For example, you can add two different time values or date values or you can calculate the time difference between two given dates/times. In this tutorial, …
Excel is an amazingly well-developed spreadsheet tool that has been designed to maximize the efficiency of its users. While it works as expected in most of the cases, in some cases, it can be a little counterproductive. One such area is when Excel decides to round-off numbers (arghhh). In this tutorial, I will show you …
When you’re working with data in Excel, most of the time you’ll have to deal with decimals (especially if you’re working with currency data or accounting numbers). In an attempt to make Excel a smart and more user-friendly tool, there are some in-built features that end up being a little bit of an irritation. Working …
I was recently working on a project where I had dates in Excel and I had to find out what quarter of the year it was based on the date. For the purpose of this tutorial, let’s consider the following: In case you’re working with financial data where the quarter starts from April, then you …
Formulas are the life and blood of Excel spreadsheets. And in most cases, you don’t need the formula in just one cell or a couple of cells. In most cases, you would need to apply the formula to an entire column (or a large range of cells in a column). For example, if you have …
©trumpexcel.com – Free Online Excel Training
