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 chart data labels are quite boring. While there is not much you can do with these, a bit of excel trickery can add some glamor to it. In this post, I will show you how to show trends in chart labels in a bar chart. Something as shown below: Show Positive/Negative Trend Arrows in Excel Chart …
If there is one thing that unites us all, it has to be the frustration to keep up with a slow excel spreadsheets. While the impact on the performance may be negligible when there is less data, it becomes more profound as you add more and more data/calculations to the workbook. 9 out of 10 …
If you are in the sales department and your life is all about targets, this charting technique is for you. And if you are not, read it anyway to learn some cool excel charting tricks. In this blog post, I will show you a super way to create a dynamic target line in an Excel …
Hyperlinks are Excel’s shortcut way to jump to the required data point in the same workbook, a different workbook, or an external URL. While hyperlinks are mostly static links, here is the way you can use to create dynamic hyperlinks. By Dynamic Hyperlinks, I mean links that change based on the selection (or any other …
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 …
©trumpexcel.com – Free Online Excel Training
