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 …
I often use scatter chart with many data points. One of the most irritating things is to spot the data point in Excel chart. Excel does not give you a way to display the names of the data points. While there are many add-ins available to do this, I will show you a super cool (without add-in) …
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 …
If you work involves reporting the actual and target data, you may find it useful to present the actual values versus the target values in a chart in Excel. For example, you can show the actual sales values versus the target sales values, or the satisfaction rating achieved versus the target rating. There can be …
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 …
Apart from being super cool, Excel dynamic charts are really helpful in presenting a comparative analysis from the data. Suppose you have the financial data for a company ABC Ltd, and you want to see how the revenue has grown over the quarters. At the same time, you also want to compare the growth with …
©trumpexcel.com – Free Online Excel Training
