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.
If you want to count the numbers that fall between two given numbers in Excel, it can easily be done using the COUNTIFS function (or COUNTIF and SUM if you’re on an older version). For example, if you’re analyzing the sales data of your sales reps, you may want to know how many of them …
It’s a common task to calculate ratios when working with financial data or doing other data analysis work in Excel. Even in our day-to-day life, we use ratios in areas such as screen size (in specifying resolutions such as 16:9) or cooking (in specifying proportions such as using two ingredients in 2:3 proportion). While there …
Deleting a row or deleting multiple rows is a regular part of most Excel users. Sometimes you need to delete rows when cleaning up your dataset or when you make a mistake and want to start over. Whatever your reasons, deleting rows in Excel is super easy (just like ordering a Pizza). It only takes …
If you want to count filtered rows in Excel, you can do that using the SUBTOTAL function. The SUBTOTAL function allows you to perform a regular count on a column with the ability to exclude those rows that have been filtered out. In this short tutorial, I will show you how to use the SUBTOTAL …
Most of my time working in Excel is spent cleaning data that I get from different sources. One common task that I have to do quite often is to remove parentheses (or brackets) from the cells in a dataset. As with almost everything else in Excel, there are multiple ways you can remove the parenthesis …
I’m a huge fan of using shortcuts in Excel to speed up my work While there are many shortcuts that I use on a daily basis, one that I find particularly useful is the ability to repeat the last performed action in Excel. This is useful when you have to do the same thing repeatedly …
In many situations, you may want to quickly highlight all the cells with formulas in Excel. When I was working as a financial analyst a few years ago, this is something I used to do often to mark the cells that contain formulas. Another situation where this may be useful is when you want to …
If you work with date values in Excel, it would be useful to know the different formatting options you can use with dates. Any date or time value in Excel would be a number in the back end that would represent that date or time. for example, 1 represents 1 Jan 1900, 2 represents 2 …
Page orientation can be important when planning to print your work in Excel. While the default page orientation in Excel is the Portrait mode (where the length of the page is more than the width), if you have a data set where there are more columns than rows, you may want to change the orientation …
©trumpexcel.com – Free Online Excel Training
