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.
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 …
Most of the time, the data in Excel is arranged in columns, and it is more common to split the text in a cell into multiple columns rather than rows. But in some cases, you may want to split the text into multiple rows in Excel. For example, if you have multiple names in a …
Scientific notation is a format that allows us to write very large or very small numbers in a consistent decimal format. This can be useful when you are working with large numbers and you do not want them to take up a lot of space in your Excel worksheet. In such a case, you can …
©trumpexcel.com – Free Online Excel Training
