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.
Wherever there is data, there is a need to filter it. Excel Data Filter feature gives you many ways to filter the data – based on text, value or date. Excel Data Filter Suppose you have the data as shown below: To activate Excel data filter for this data, select the entire data and click …
Data Validation in Excel lets you control the data that can be entered in a cell. You can restrict the user to enter only a specified range of numbers or text or date. You can also use data validation functionality to create an Excel drop down list (which is definitely one of the coolest and …
Working with data all day long in Excel could be boring. Sometimes, there is no alternative to it, however, you can still bring in some colors and zing to it by using Excel features to format the data. Formatting the data in Excel can increase its readability tremendously. Let me introduce you to some of …
A line break in Excel can be used to end the current line and start a new line in the same cell (as shown below). Notice that in the pic above, Morning is in the second row in the same cell. You may want to insert a line break in Excel when you have multiple …
Imagine you have created a super long formula in Excel. While you are proud of yourself, there is a minor glitch. It is returning an error or an unexpected value. Now you have two options: Excel Formula Debugging Method #1 – F9 Key Here is how this works: For example, suppose you have the text …
When you have a big dataset with blank cells scattered through it, manually clicking each one is a waste of time. Excel has a few quick ways to grab every blank cell at once so you can fill them, delete them, format them, or do whatever else you need. In this article, I’ll show you …
I often use scroll bars in an Excel dashboard, which gives a user the freedom to change its values and play with the data. If you have multiple scroll bars in your dashboards, it is helpful to display the current value of each scroll bar. Something as shown below: The idea is to display the value …
Excel Custom Number formatting is the clothing for data in excel cells. You can dress these the way you want. All you need is a bit of know-how of how Excel Custom Number Format works. With custom number formatting in Excel, you can change the way the values in the cells show up, but at the …
Someone recently asked me if it was possible to get a main category and subcategory in a drop-down list in Excel, (something as shown below): My first thought was to do this using VBA (if possible), but the answer is so easy, it surprised me. Creating Subcategory in Drop Down List in Excel All you need …
©trumpexcel.com – Free Online Excel Training
