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.
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. …
Sometimes when you download data from external sources or import information from other systems, you end up with fractions that are stored as text instead of actual numbers. You might see values like “17/76” or “1/4” sitting in your cells, and Excel treats them as text rather than mathematical expressions you can work with. This …
Creating barcodes in Excel can be useful for inventory management, product labeling, or any scenario where you need to generate scannable codes directly from your spreadsheet data. While Excel doesn’t have a built-in barcode generator, this can be done by using the IMAGE function or by installing a barcode form. In this article, I will …
If you want to repeat rows in your dataset N number of times (say 5 or 7 times), or based on a value in a column, Power Query is the easiest way to do that. In this article, I’ll walk you through two methods to repeating all rows the same number of times, and repeating …
A common complaint of many Excel users is that they can’t directly use Excel table’s structured references in data validation to create drop-down lists. If you try, Excel would give you an ugly pop-up and refuse to play along. But what if you still want to (somehow) use Excel table as the source in data …
Getting Dark Mode has been one of the most requested features for Microsoft Excel and finally the dark lords in the Microsoft office has decided to give it to us. With this new feature release, you can easily enable the dark mode in most Microsoft applications such as Excel, Word, PowerPoint, or Outlook. In this …
Recently I was working on a project where I had to filter all the cells that had strikethrough formatting applied to it. The issue is… There is no built-in way to filter cells that have strikethrough applied to them. So we need in a workaround. In this article, I will cover two simple ways you …
Sometimes you may want to write text vertically in Excel to save space and make your data more presentable. This could specially be useful if you are planning on printing your work. While, by default whenever you write anything in Excel it’s written horizontally, it’s very easy to convert it into vertical writing. Below is …
©trumpexcel.com – Free Online Excel Training
