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.
It’s easy to add sheet names to header or footer in Excel. Once done, the sheet name will appear In the header or the footer of the page when you print it. This is especially useful when you’re working with a large workbook and need to print multiple worksheets. Having the sheet name in the …
If your Excel application is crashing or causing issues, you can try opening it in the ‘Safe Mode’. When you open Excel in safe mode, it disables features such as add-ins and custom settings, which helps you troubleshoot and identify the issues. In this quick guide, I will show you two easy ways to open …
Need to find out which version of Microsoft Excel you have? It’s pretty easy to do and only takes a few clicks. Whether you’re fixing an issue, installing an add-on, or just curious, it’s good to know your Excel version. Knowing your Excel version also helps when you’re working with other people who have different …
One formatting option you can use when you want to highlight a specific text or cell is the underline option. As the name suggests, it applies an underline below some text in a cell or the entire cell. In this article, I will cover the different types of underlines in Excel (single, double, single accounting, …
Removing duplicates is a common task for most data workers. While in most cases, you would be working on removing duplicates from a range of cells, sometimes, you may need to remove duplicates from a cell. For example, below, I have a dataset with duplicate values in each cell and I want to remove the …
Remove asterisk (*) symbol In Excel is a little tricky as it’s a wildcard character and you cannot just use fine and replace to remove an ace risk symbol. But nothing to worry about – I’ll tell you a simple methods to quickly remove all the asterisk symbols from your data set using the Find …
Dates are stored as numbers in the backend in Excel and can easily be sorted. But what if you want to sort dates by month (irrespective of the year value)? For example, below, I have the birthday dates for some people, and I want to sort and get all the January birthdays together, all the …
It’s not uncommon for many people to protect worksheets in their Excel files and then forget the password. It has happened to me many times, and every now and then, I have people sending me their Excel files asking how to unlock the sheet without the password. The good news is that Excel password protection …
Conditional formatting in Excel allows you to format cells based on the values in the cells. The built-in formatting settings and Conditional Formatting are made to format cells based on the value in the cell itself. But what if you want to apply conditional formatting to a cell based on the value in some other …
©trumpexcel.com – Free Online Excel Training
