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.
By default, the lookup value in the VLOOKUP function is not case sensitive. For example, if your lookup value is MATT, matt, or Matt, it’s all the same for the VLOOKUP function. It’ll return the first matching value irrespective of the case. Making VLOOKUP Case Sensitive Suppose you have the data as shown below: As you …
Have you heard of the Waffle Chart (also called the square pie chart)? I have seen these in a lot of dashboards and news article graphics, and I find these really cool. A lot of times, these are used as an alternative to the pie charts. Here is an example of a waffle chart (shown below): …
Excel VLOOKUP function, in its basic form, can look for one lookup value and return the corresponding value from the specified row. But often there is a need to use the Excel VLOOKUP with multiple criteria. How to Use VLOOKUP with Multiple Criteria Suppose you have a data with students name, exam type, and the Math …
If you work with currency/sales data, it comes in handy to know how to insert dollar and cent symbols with the numerical/sales values in Excel. While the dollar sign is right there on the keyboard, cent symbol is a little more difficult to find and insert. How to Insert a Cent Symbol in Excel In this …
Using a combination of Excel functions and the date of birth, you can easily calculate age in Excel. You can either calculate the age till the current date or between the specified period of time. The technique shown here can also be used in other situations such as calculating the duration of a project or the tenure …
When we calculate a simple average of a given set of values, the assumption is that all the values carry an equal weight or importance. For example, if you appear for exams and all the exams carry a similar weight, then the average of your total marks would also be the weighted average of your …
A lot of times, we need to work with text data in Excel. It could be Names, Address, Email ids, or other kinds of text strings. Often, there is a need to combine cells in Excel that contain the text data. Your data could be in adjacent cells (rows/columns), or it could be far off …
Excel has a set of TEXT Functions that can do wonders. You can do all kinds of text slice and dice operations using these functions. One of the common tasks for people working with text data is to extract a substring in Excel (i.e., get psrt of the text from a cell). Unfortunately, there is …
We often create and work on multiple Excel worksheets. These could be separate sheets in the same workbook (for example different worksheets for different years, products, departments, etc.). Sometimes, you may need to send a part of the worksheet or a single excel worksheet from the workbook to your colleague or boss. While there can …
©trumpexcel.com – Free Online Excel Training
