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, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. For example, in the below example, the value in column A and B is the same, but these are displayed differently because of the format. And one …
Excel allows you to display data in many different formats. And there are way too many to choose from when it comes to dates and time data in Excel. And since there are so many formats, there are also ways to edit and modify these. One common thing many people need to do often in …
While there are many different ways to run a macro in Excel, none of those methods can be as easy and user-friendly as clicking on a button. And for that to work, you need to assign a macro to a button first. In this tutorial, I will show you a couple of ways to insert …
Working with text data would often require slicing and dicing it. And one such common thing people often have to do is to remove the first characters from a string in Excel. Suppose you have a dataset as shown below (in column A) and you want to remove only the first characters from each cell …
To be able to reference cells and ranges is what makes any spreadsheet tool work. And Excel is the best and most powerful one out there. In this tutorial, I will cover all that you need to know about how to reference cells and ranges in Excel. Apart from the basic referencing on the same …
If you have an Excel workbook with many worksheets, there is no easy way to split each of these sheets into separate Excel files and save separately. This could be needed when you have sheets for different months or regions or products/clients, and you want a separate workbook for each sheet (as an Excel file …
To get the sum of an entire column is something most of us have to do quite often. For example, if you have the sales data to date, you may want to quickly know the total sum in the column to the sales value till the present day. You may want to quickly see what …
People who work with large data sets often need simple things such as inserting/deleting rows or columns. While there are already many different (and simple) ways to add rows in Excel, when it comes to inserting a blank row after every other row (or every third or fourth row), things get a bit complicated. Insert …
Like many of my Excel tutorials, this one is also inspired by one of the queries I got from a friend. She wanted to calculate the moving average in Excel, and I asked her to search for it online (or watch a YouTube video about it). But then, I decided to write one myself (the …
©trumpexcel.com – Free Online Excel Training
