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.
The one query that I get a lot is – ‘how to compare two columns in Excel?’. This can be done in many different ways, and the method to use will depend on the data structure and what the user wants from it. For example, you may want to compare two columns and find or …
Below is a detailed written tutorial about Excel Data Entry form in case you prefer reading over watching a video. Excel has many useful features when it comes to data entry. And one such feature is the Data Entry Form. In this tutorial, I will show you what are data entry forms and how to …
Sparklines feature was introduced in Excel 2010. In this article, you’ll learn all about Excel Sparklines and see some useful examples of it. What are Sparklines? Sparklines are tiny charts that reside in a cell in Excel. These charts are used to show a trend over time or the variation in the dataset. You can …
In this tutorial, you’ll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel where I had a list of people and the dates on which they acted as the ‘Meeting Chair’. …
Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For something that is so popular, it makes sense to have a decent knowledge on how to use these applications efficiently. In some job roles, a major part of the …
I recently had to get myself registered under Goods and Services Tax (GST) so that I can file for GST on my earnings. Once you have a GST number, you need to file your tax return every month (in India). So every month, my Charted Accountant would reach out to me asking for sales invoices …
Want to convert a PDF to Excel? Here is a tool that you can use to extract data from PDF to Excel with a high accuracy and format. You also don’t need to give your email address or upload your PDF files anywhere. This tools is completely secure and convert PDF to Excel in seconds.
In this tutorial, I’ll show you how to unpivot data using Power Query (Get & Transform). Pivot Table needs the data in a specific format so that it can analyze it and create different views from it. In case you don’t have the data in a Pivot Table ready format, you can use Power Query to unpivot the data set.
Power Query can be of great help when you want to combine multiple workbooks into one single workbook. For example, suppose you have the sales data for different regions (East, West, North, and South). You can combine this data from different workbooks into a single worksheet using Power Query. If you have these workbooks in …
©trumpexcel.com – Free Online Excel Training
