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.
Excel users often need to compare cells or columns to check if the same text is available in the cells/columns or not. A very common example of this is when you have names in two columns and you want to check if the names are exactly the same or what names are missing in one …
When I was working as a data analyst years ago, part of my job was to download data from financial databases and then clean this data. And one of the things I had to do while cleaning the data was to delete any blank columns in the data set. While you can always manually select …
Excel allows you to sort your data set based on numeric values, text values, dates, as well as colors in the cell. However, there is no inbuilt functionality in Excel to sort the cells based on the length of the text in the cells. In one of my Excel training sessions, I was asked whether …
Working with dates is a common task for many Excel users. And sometimes, you can come across dates that are formatted as text (or look like dates but are not in the acceptable date formats, so Excel treat them as text strings). Since dates are stored as numbers in the backend in Excel, it allows …
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 …
©trumpexcel.com – Free Online Excel Training
