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.
Sometimes, you may need to know what’s the first day of the month based on a given date. When there is no dedicated function to get the first day of a given month, you can easily use a workaround to find it. In this Excel tutorial, I’ll show you some really simple formula that you …
Microsoft Excel stores dates and times as numbers, which allows the user to easily add and subtract days to a date in Excel. It also makes it really easy when you want to find out the total number of days between two dates, as you can simply subtract one from the other. In this tutorial, …
Excel stores date and time values as serial numbers in the back end. This means that while you may see a date such as “10 January 2020” or “01/10/2020” in a cell, in the back-end, Excel is storing that as a number. This is useful as it also allows users to easily add/subtract date and …
A lot of Excel users hide rows and columns when they have some data that they don’t need visible. It’s a way to only keep useful data visible, and at the same time not have to delete the data you don’t need to be visible. And, if you have lots of such hidden rows/columns, it …
When working with text data in Excel, you may have the need to remove the text before or after a specific character or text string. For example, if you have the name and designation data of people, you may want to remove the designation after the comma and only keep the name (or vice-versa where …
Excel is an awesome tool. The more I learn about it the more I fall in love with it. The team that has built Excel has put in a lot of thinking behind it and they continuously work on improving the user experience. But there are still somethings that I find irritating and often need …
Excel has some wonderful formulas that can help you slice and dice the text data. Sometimes, when you have the text data, you may want to extract the first word from the text string in a cell. There are multiple ways you can do this in Excel (using a combination of formulas, using Find and …
Using VBA Macros in Excel can be a huge time saver. You can automate a lot of repetitive tasks and create new functions and functionalities in Excel with simple VBA macro codes. But in some cases, you may want to remove all the macros from an Excel workbook (or delete specific macros only). This may …
When you work with numbers in Excel, you often need to conditional add the data. One common example of this is when you have to sum the positive numbers in Excel (or only sum the negative numbers). And this can easily be done using the in-built formulas in Excel. In this tutorial, I will show …
©trumpexcel.com – Free Online Excel Training
