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.
If you have worked with formulas in Excel for some time, I am sure you have already met the #REF! Error (reference error). Since this is quite common, I thought of writing a tutorial just to tackle the #REF! error. In this Excel tutorial, I will cover what is the #REF! error, what causes it, …
Comments are quite useful when you want to add some information about a cell/data point without changing the content of the cell. I often use these when I am using formulas and I need to specify what a formula does and what a cell value means. If you’re collaborating with others, you can also add …
When working with multiple worksheets in Excel, sometimes you may have a need to edit the same cell in all the worksheets (or apply certain formatting the same cell/range in all the sheets). You can easily group worksheets in Excel so that you can make the changes at one go (instead of going to each …
With financial data, you would often see the use of two metrics – Average Annual Growth Rate (AAGR) and Compound Annual Growth Rate (CAGR). While there are some existing formulas in Excel that can help you calculate growth rates, for calculating AAGR and CAGR, you would need a little bit of workaround (nothing too complex …
When you’re working with datasets that have dates, you would often find yourself trying to do calculations based on the dates. For example, if you have the sales data for a month, you may want to know the total sales that have happened between two given dates or the total sales made on weekends vs …
Excel gives you a lot of options when you’re trying to print your work. You can choose to print the entire worksheet, a specific area in the worksheet, print multiple sheets, or all sheets at one go. In this tutorial, I will show you how you can print multiple sheets in Excel at one go. …
Adding or removing columns in Excel in a common task when you’re working with data in Excel. And just like every other thing in Excel, there are multiple ways to insert columns as well. You can insert one or more single columns (to the right/left of a selected one), multiple columns (adjacent or non-adjacent), or …
If you work with data that is imported from databases or salesforce, you’ve probably already dealt with line breaks. A line break is something that allows you to have multiple lines in the same cell in Excel. Below is an example of a name and address dataset wherein a single line, name and different parts …
While Excel has been continuously improved with each new version, there are still times when you may find it crashing once in a while (especially if you’re working with a large dataset). And sometimes, it could be a factor outside of Excel – such as a power failure or your system hanging because of an …
©trumpexcel.com – Free Online Excel Training
