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 is an amazing tool when it comes to slicing and dicing text data. There are so many useful formulas as well as functionalities you can use to work with text data in Excel. One of the very common questions I get about manipulating text data is – “How to separate first and last names …
Watch Video – How to Unhide All Sheets In Excel In case you prefer reading a tutorial over watching a video, below is a detailed written tutorial on unhiding sheets in Excel. When you work with data that is spread across multiple worksheets in Excel, you may want to hide a few worksheets. This could …
In case you prefer reading over watching a video, below is the complete written tutorial. Sometimes in Excel, you may want to hide zero values in your dataset and show these cells as blanks. Suppose you have a dataset as shown below and you want to hide the value 0 in all these cells (or …
Sometimes you may have a need to delete every other row (i.e., alternate rows), or every third/fourth/fifth row in Excel. One use-case of this could be when you have weekly data and you only want the data for even weeks or odd weeks. Another could be when you get a data dump from a database …
When you enter a text string in Excel which exceeds the width of the cell, you can see the text overflowing to the adjacent cell(s). Below is an example where I have some address in column A and these address overflow to the adjacent cells as well. And in case you have some text in …
When working with large data sets, you may have the need to quickly delete rows based on the cell values in it (or based on a condition). For example, consider the following examples: There are multiple ways to skin this data cat in Excel. The method you choose to delete the rows will depend on …
Want some Excel files to open automatically when you start Excel? These could be files the that you open every day in the morning (such as tracking sheet or timesheet), or some project related files that you need to open as soon as you start Excel. While you always have the option to open these …
Sorting data in Excel has been made quite easy with all the in-built options. You can easily sort your data alphabetically, based on the value in the cells, or by cell and font color. You can also do multi-level column sorting (i.e., sorting by column A and then by column B) as well as sorting …
Excel has a lot of options when it comes to sorting data. And one of those options allows you to sort your data based on the color of the cell. For example, in the below dataset, you can sort by color to get the names of all the students who scored above 80 together at …
©trumpexcel.com – Free Online Excel Training
