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 has some really amazing functions, but it doesn’t have a function that can sum cell values based on the cell color. For example, I have the dataset as shown below, and I want to get the sum of all orange and yellow color cells. Unfortunately, there is no in-built function to do this. But …
Conditional formatting allows you to apply a format to a cell based on the value in it. in most cases, you will apply conditional formatting to the same cell for which you are analyzing the value. But in some cases, you may want to apply conditional formatting to a cell or column based on values …
When writing formulas in Excel, most Excel users prefer to type the formula directly within the cell. However, when working with large complex formulas, typing or editing the formula in the cell becomes a bit hard. In such cases are usually do this in the formula bar. A formula bar is a bar below the …
When working with dates in Excel, you may sometimes have a need to highlight only specific days of the week. For example, you may have a list of dates where you want to highlight all the weekend dates. This can easily be done using Conditional Formatting with a little bit of formula know-how. In this …
Excel has some really useful features that can help you be a lot more efficient in your day-to-day work. One of the common tasks many people have to do is to compare data in the same sheet. This is especially useful for people who work with large data that requires a lot of back and …
If you work with measurement data and there is a need to convert the data from one length measurement unit to another, you can use some inbuilt formulas in excel to do that. For example, you may have a need to convert data in centimeters/millimeters to inches or feet. In this short tutorial, I will …
If you have a list of items or names or numbers, you can use simple formulas in Excel to randomize this list. I often need to use this when I’m creating tutorials where I need a random set of numbers or items. It could also be useful if you’re creating a random team in your …
When working with dates in Excel, sometimes you may want to know what day the date is (whether it’s a Monday or a Tuesday, or any other weekday). This could especially be useful in project planning, where some days could be for a specific task (such as having a project meeting or sending the progress …
If you’re working with large datasets in excel, getting Descriptive Statistics for this data set could be useful. Descriptive Statistic quickly summarizes your data and gives you a few data points that you can use to quickly understand the entire data set. While you can also calculate each of these statistical values individually, using the …
©trumpexcel.com – Free Online Excel Training
