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.
A lot of people use dates in Excel for planning and keeping track of tasks and activities. For example, below I have a data set where I have the tasks in column A and their due dates in column B. It would be useful if there was a way to automatically highlight dates before today, …
If you want to convert seconds values to minutes in Excel, it is not as straightforward as dividing it by 60. This is because Excel has a specific way of storing date and time values in Excel. While a full day is stored as a whole number in Excel, time values are stored as fractions/decimals. …
Excel has 450+ functions that can do a range of awesome things. If you’ve used Excel even for a few days, I am sure you have heard of functions like VLOOKUP, SUMIF, COUNTIF, and so on. And what is more awesome is that one Excel function – a formula that consists of two, three, or …
By default, all the sheet tabs in Excel are of the same color (white when the sheet tab is active and gray for all the non-active tabs). People who work with a lot of worksheet tabs find it useful to give a specific color to a sheet tab. This could be useful in showing the …
If you need to get the sum across multiple worksheets, you can use one of the less-known Excel feature called 3D referencing. With 3D referencing, you can refer to the same cell in multiple worksheets, and can also use this in formulas such as the SUM or AVERAGE, or COUNT. In this short tutorial, I …
The drop-down feature in Excel is quite useful when doing data entry. Using it, you can create a drop-down in a cell that will show you all the pre-populated options that you can choose from. It saves time as you can simply choose from the list instead of entering it manually, and it also helps …
Excel ribbon is the area at the top of the worksheet that contains most of the frequently used commands. In the ribbon, we have different tabs (such as the ‘Home’ tab or the ‘Insert’ tab), and within each tab, we have the relevant commands. Most Excel users would find everything they need somewhere in the …
Since Excel is used by people in different professions and across industries, Excel allows you to show numbers in many different formats. When working with financial data and creating accounting reports, one common number format that needs to be used is to show negative numbers in brackets (parentheses). While the default setting in Excel is …
Excel ribbon was introduced in Excel 2007, which allowed users to access all the important tools and functionalities from one single place. Personally, I think the Excel ribbon was a huge improvement over the earlier menu option, as it made it more user-friendly for people to find useful options in one place. While it wasn’t …
©trumpexcel.com – Free Online Excel Training
