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.
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 …
Excel has a lot of useful in-built charts and you can also combine and create some amazing combination charts as well. Excel charts are a great way to show your data visually and are often the most used ones when you have to present it to your manager/clients. While your charts may be in Excel, …
Excel Table is an amazing feature that makes working with data a lot easier. And as more advanced tools such as Powe Query and Power Pivot now rely on Excel tables to be the data source, Excel tables are going to become even more important. But this tutorial is not about the awesomeness of Excel …
Comparing two Excel files (or comparing two sheets in the same file) can be tricky as an Excel workbook only shows one sheet at a time. This becomes more difficult and error-prone when you have a lot of data that needs to be compared. Thankfully, there are some cool features in Excel that allow you …
If you manage multiple projects, you would have a need to know how many months have passed between two dates. Or, if you’re in the planning phase, you may need to know the same for the start and end date of a project. There are multiple ways to calculate the number of months between two …
If you work with names datasets, sorting it is one of the common tasks you would have to do often. It’s quite easy to sort data alphabetically based on the full name, where Excel uses the first character of the name to sort. But what if you want to sort data by the last name …
©trumpexcel.com – Free Online Excel Training
