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.
I was recently working on a project where I had some dates and had to classify each date into its fiscal year (also sometimes called the financial year). While Excel does not have a dedicated function to do this, it can quickly be done using a combination of functions. In this article, I will show …
When working with dates and making project plans in Excel, you may come across a situation where you want to know how many weeks there are between two dates. While there is no built-in function to do this in Excel, this can easily be done using other simple functions. In this article, I will show …
Sometimes, when working with text data in Excel, you may want to add parentheses around the text in a cell or range of cells. For example, below, I have a data set with the region name in column A, and I want to put these names in parentheses or brackets. As always, Excel offers multiple …
Sometimes, in my work, I have to check if a cell or a range of cells contains the partial text I’m looking for. For example, suppose I want to check whether a cell contains the text string “ABC” or not. The cell may have additional strings or characters, but as long as it has the …
The Pi symbol (Ï€) represents a mathematical constant that is used when calculating the area circumference of a circle. I’m sure you must have seen and worked with the Pi symbol in your geometry and math classes, and it also has a lot of practical applications in the real world. In this article, I will …
Interquartile Range (IQR) is often used in statistics to identify outliers and understand the spread of the middle 50% of the data set. Interquartile Range allows you to analyze data without it getting skewed by outliers and extreme values. This helps us get a better view of the variability of the data as compared to …
If you want to get the highest value in a column or a range, you can easily do that using the built-in MAX function in Excel. But what if you want to get the second largest value, the third largest value, or the nth largest value from the same data set? In this scenario, you …
Once you’re done using formulas to get the desired results, you may want to remove the formulas and keep the data you got as a result of these formulas. This is often done to remove formulas you no longer need and save processing power (as formulas recalculate every time you make a change in the …
Sometimes, when you’re organizing data, creating charts, or analyzing information, you may need to swap two cells (i.e., change the position of two cells). While there is no built-in feature in Excel to swap cells, this can easily be done using a simple mouse drag-and-drop technique or the old and traditional Cut-Paste method. In this …
©trumpexcel.com – Free Online Excel Training
