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.
I’ve been a big fan of Excel drop-down lists since I learned about them. It makes data entry fast It also allows me to create dashboards and reports that are interactive (where a user can choose an option from the drop-down in the entire dashboard updates). It’s also a useful tool when I’m sharing my …
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 …
If you want to fill a column with Yes or No answers, typing them by hand gets slow, and someone will eventually make a mistake and type “yes ” or “Y”. A Yes/No drop-down list fixes this. You simply pick Yes or No from the list, so there’s no room for misspelled words. In this …
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 …
When you’re preparing a profit or finance report, you might want negative numbers in parentheses, but Excel shows them with a minus sign by default. For example, if you type -182029, Excel shows -182029 even though your report needs (182029). There are a few ways to fix this: the built-in Format Cells option, Accounting format, …
©trumpexcel.com – Free Online Excel Training
