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 allows having hyperlinks in cells which you can use to directly go to that URL. For example, below is a list where I have company names which are hyperlinked to the company website’s URL. When you click on the cell, it will automatically open your default browser (Chrome in my case) and go to …
If you prefer written instruction instead, below is the tutorial. Hidden rows and columns can be quite irritating at times. Especially if someone else has hidden these and you forget to unhide it (or even worse, you don’t know how to unhide these). While I can’t do anything about the first issue, I can show …
Excel has a lot of functions – about 450+ of them. And many of these are simply awesome. The amount of work you can get done with a few formulas still surprises me (even after having used Excel for 10+ years). And among all these amazing functions, the INDEX MATCH functions combo stands out. I …
Looking to recover unsaved Excel file, click here to jump to all the possible options you have to get the file back. Let me tell you the shortest horror story ever. Excel Crashed! Imagine working on that urgent report or that extremely important dashboard where you have done such a fantastic job. You are proud …
Below is the written tutorial, in case you prefer reading over watching the video. In Excel, there are two kinds of tick marks (✓) that you can insert – a check mark and a checkbox. And no… these are not the same. Let me explain. Check Mark Vs Check Box While a check mark and …
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 …
©trumpexcel.com – Free Online Excel Training
