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 am a big fan of using Excel templates to plan and manage work. I regularly use to-do lists and calendars to plan my days in advance. In this post, I am sharing an Excel calendar template that you can use in Excel or even take a printout and stick it at home or at …
What happens when you type the word ‘Drnik’ instead of ‘Drink’ in Excel? You would notice that Excel will autocorrect that misspelled word to Drink (as shown below). Somehow, Excel knew that this is not the correct spelling and autocorrected it to the right one. Now, it won’t autocorrect all the misspelled words. Just a few! …
When it comes to inserting symbols in Excel, things can get a bit complicated. You either need to know the keyboard shortcut, or use the methods that are not very straightforward. And there are a lot of symbols that many people need to insert regularly, such as the degree symbol, cent symbol, delta symbol, etc. …
Excel workbooks have been known to become painfully slow and heavy as more data/formulas/images are added to it. Sometimes, it’s easy to get rid of the extra flab and keep the excel file size in check, and sometimes, it isn’t. And since Excel is not a web-based tool, most of us work and collaborate by …
Sometimes when working with data in Excel, you may have a need to move rows and columns in the dataset. For example, in the below dataset, I want to quickly move the highlighted row to the top. Now, are you thinking of copying this row, inserting the copied row where you want it, and then …
Watch Video – Search and Highlight Data Using Conditional Formatting If you work with large datasets, there can be a need to create a search functionality that allows you to quickly highlight cells/rows for the searched term. While there is no direct way to do this in Excel, you can create search functionality using Conditional …
In case you prefer reading written instruction instead, below is the tutorial. Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it. But sometimes, instead of just getting the cell highlighted, you may want to highlight the entire row (or column) based on the value in one cell. …
A histogram is a common data analysis tool in the business world. It’s a column chart that shows the frequency of the occurrence of a variable in the specified range. According to Investopedia, a Histogram is a graphical representation, similar to a bar chart in structure, that organizes a group of data points into user-specified ranges. The …
The one query that I get a lot is – ‘how to compare two columns in Excel?’. This can be done in many different ways, and the method to use will depend on the data structure and what the user wants from it. For example, you may want to compare two columns and find or …
©trumpexcel.com – Free Online Excel Training
