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.
In this article, I will show you some simple Excel formulas you can use to get the end-of-year date in Excel. Now if you’re wondering why you may even want that, and of course the end of the year date is going to always be 31st December of that year, here is the thing: Dates …
Sometimes you may have a large dataset that you are working with in Excel and you want to select alternate columns, or every third or every fourth column in your dataset. While there is no inbuilt feature to do this in Excel, there are some easy workarounds. In this article, I’ll show you three ways …
Pivot Tables come with a lot of in-built sorting options that allow you to structure your data the way you want. While you can use the regular sorting options (sorting A-Z / Z-A or Smallest to Largest or Largest to Smallest), there are also options to sort based on a custom list and even specify …
If you work with phone numbers data in Excel, it would be useful to know how to properly format them. For example, if you’re working with phone numbers in the US, instead of just showing a 10-digit screen, you can format it to show in the following format: (123) 456-7890 If you are working with …
Do you know there’s a functionality to show a ruler in Excel that can help you align objects perfectly and set precise margins for printing? Just like you can show the ruler in Microsoft Word, you can also get that in Excel. Ruler is not one of the more used functionalities in Excel, which is …
If you work with Pivot Tables and also use slicers, you may sometimes wonder whether a slicer can be used to control multiple Pivot Tables. The answer is, of course, YES (otherwise I won’t be writing about it). This is useful when you have multiple Pivot Tables and you want all of them to update …
When working with Pivot Tables in Excel, I always ensure that my Pivot Tables are displayed in the tabular form. I don’t know why, but Microsoft has decided that any default Pivot Table would be shown in the Compact form. While powerful, the standard Compact Form in Pivot Tables can sometimes feel a bit… well, …
Working with percentages is a daily task for many Excel users. Now you cannot simply add a percentage value to a number to get the right result. For example, you cannot use 10 + 10% to get 11. Thankfully, Excel gives you a couple of really simple ways to do this. In this tutorial, I’ll …
When working with very large numbers in Excel, you often need to round them to the nearest thousand for better readability and analysis. This is especially helpful when you’re working with sales data, budget estimates, population data, or financial reports, etc. Rounding to the nearest thousand makes your data cleaner and easier to work with. …
©trumpexcel.com – Free Online Excel Training
