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.
There are multiple ways you can display a number in a cell in Excel. And one of the ways you can format a number is to show it as a date (for that corresponding serial number) When you see a date in a cell in Excel, in the back end it is still stored as …
The default setting in Excel is to show all the tabs (also called sheets) below the working area. But if you can’t see any tabs and are wondering where has it disappeared, worry not. There are some possible reasons that may have been the cause of missing tabs in your Excel workbook. In this article, …
Working with a large Excel workbook that has multiple sheets could be challenging. Even advanced Excel users feel overwhelmed when trying to switch between multiple worksheets in the same workbook. Imagine working on an Excel workbook with 15 worksheets, and having to constantly switch between worksheets #3 and #12. There are multiple ways to switch …
Excel Quick Analysis Tool allows you to quickly analyze data. It gives you quick access to some of the commonly used data analysis functionalities in Excel so that you don’t have to go into the ribbon and find the correct option (hence saving some clicks and a little bit of time). In this tutorial, I …
If you enter a number that has more than 11 digits in a cell in Excel, it will automatically be converted into the scientific notation (as shown below). While the number in the back end would still remain the same, Excel changes the way it shows you that number. Sometimes that’s what you want, and …
Most Excel users, including many advanced Excel users, have no idea what the R1C1 and A1 notation means in Excel. In almost all of the situations, you don’t need to know what this is, and the default settings in Excel would be enough for you. But since you are here reading this article, I’m assuming …
Cleaning text data is often the most time-consuming task for many Excel users. Unless you’re among the few lucky ones, you’ll most likely get your data in a format that would need some cleaning. One common use case of this would be when you get a dataset and you have to remove some characters from …
Data analysis in Excel often involves working with dates. A common thing many Excel users need to check when working with dates is whether a date is between two given dates. A simple use case of this could be when you need to check whether the date of submission of a report was within the …
One area that often troubles Microsoft Excel users is working with dates. This is mostly because dates can be formatted in many different ways in Excel. So while you may see two dates in Excel and think those are the same, there is a possibility that these might be different values in the back end …
©trumpexcel.com – Free Online Excel Training
