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.
You may need to convert formulas to Values in Excel if you work with a lot of dynamic or volatile formulas. For example, if you use the Excel TODAY function to insert the current date in a cell, and you leave it as a formula, it will update itself if you open the workbook the next …
Want to insert the degree symbol in Excel? If you don’t know how to do this already, you may scratch your head and look for options. Unfortunately, it’s not as straightforward as you want it to be. There is no key on the keyboard to do this, or any direct option to do this using …
In this tutorial, you will learn how to count unique values in Excel using formulas (COUNTIF and SUMPRODUCT functions). How to Count Unique Values in Excel Let’s say we have a data set as shown below: For the purpose of this tutorial, I will name the range A2:A10 as NAMES. Going forward we will use …
There are various ways you can merge cells in Excel. One of the most used ways is using the Merge & Center option in the Home tab. The issue with using Merge & Center is that it can merge the cells, but not the text within these cells (i.e., you lose some data when you …
Excel is more than a data entry tool. But if you only talk about data entry in Excel, it’s a damn good one. Using the data validation, you can enable data entry in cell(s) based on a predefined condition. Conditional Data Entry in Excel Using Data Validation Here are a few examples of conditional data …
You start your day. Plan some tasks. Write it down somewhere and start working on it. When it’s way past your work time, you think about that to-do list (stare at it if you have it written) and curse the world for not having enough time in the day. Sounds familiar? If you are nodding …
What comes to your mind when you see text with a strikethrough in Excel (something as shown below)? In most cases, it means that the task or activity has been completed and has been checked off. Those who work with Microsoft Word use this extensively, and there is a strikethrough icon right there in the …
Watch Video – Start a New Line in a Cell in Excel (Shortcut + Formula) In this Excel tutorial, I will show you how to start a new line in an Excel cell. You can start a new line in the same cell in Excel by using: Start a New Line in Excel Cell – …
Excel has many functions where a user needs to specify a single or multiple criteria to get the result. For example, if you want to count cells based on multiple criteria, you can use the COUNTIF or COUNTIFS functions in Excel. This tutorial covers various ways of using a single or multiple criteria in COUNTIF …
©trumpexcel.com – Free Online Excel Training
