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.
We all know how important it is to be able to see the data in our spreadsheets clearly. I find the functionality to zoom in on a specific section of the data set in Excel quite useful when I used to present my work in calls and meetings. Once you know how to zoom in …
Most of us work with tabular data in Excel where the data is arranged in columns. And one of the common tasks most Excel users have to do is to go to the end of the data in the column (i.e., the last filled cell). While you can quickly go to the end of the …
Working with Excel often involves rearranging the data in the worksheets. And one common task many Excel users have to do is to cut the cell values from one cell and paste it to some other cell in the same worksheet or in another worksheet/workbook. While this is a basic operation that most Excel users …
One of the worst things that can happen to you when using an Excel file is to lose your work. This is why almost all Excel experts recommend saving your work frequently (now Excel even has an autosave feature where it saves files automatically). While this is good practice, I recommend going even further and …
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 …
©trumpexcel.com – Free Online Excel Training
