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 has so many unique features that sometimes, some of the features don’t get the credit they deserve. One such tool is the Status Bar in Excel. The Status Bar, as the name suggests, allows us to check the status of a few things (such as the cell mode or the macro recording status, or …
Coefficient of Variation (CV) is a common statistical metric used to understand the variability in your data set. While there is no inbuilt formula to calculate the coefficient of variation in Excel, it can easily be done by first calculating the mean and the standard deviation of the data set separately and then calculating the …
When I was working as a financial analyst a few years ago, we used to send our work as Excel files to our clients. One of the steps we were required to do before sending any file to the client was to mark it as final. When you mark a file as final, the file …
It’s common for Excel users to sort their data set when they’re analyzing. Sometimes, you may want to revert to the original data that you had before you did the sorting. In this tutorial, I will cover four techniques you can use to undo the sorting you have done on a dataset. The method you …
When working on an extensive Excel worksheet, you can avoid getting confused and overwhelmed by organizing columns into groups. This will enable you to easily show and hide different areas of the worksheet so that only relevant data is visible. In this tutorial, I will show you three methods to group columns in Excel. Note: …
As you scroll horizontally across a worksheet with many columns, the columns at the beginning of the worksheet scroll out of view. Usually, the first column (or the first few columns) has the headers for each row. And when you scroll to the right of your worksheet, it would be helpful if the headers in …
Tell me if this has happened to you – you’re working on an Excel spreadsheet, and as soon as you press any of the arrow keys, the entire page moves instead of moving the cursor to the next cell. This happens because, somehow, the Scroll Lock has been enabled, and you need to turn off …
What do you do when you have to get the sum of cells in a column? Do you use the SUM function? While that’s the right way to do this, I hope you’re not manually entering the SUM formula and selecting the range to get the sum of all the values in the column (or …
When working with name data sets in Excel, you may want the names to be in a specific format. Usually, the names are either in the ‘First Name Last Name’ format (such as Joe Davis or Sumit Bansal). In some specific situations, you may want the names data to be formatted as Last Name, First …
©trumpexcel.com – Free Online Excel Training
