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 is an amazingly well-developed spreadsheet tool that has been designed to maximize the efficiency of its users. While it works as expected in most of the cases, in some cases, it can be a little counterproductive. One such area is when Excel decides to round-off numbers (arghhh). In this tutorial, I will show you …
When you’re working with data in Excel, most of the time you’ll have to deal with decimals (especially if you’re working with currency data or accounting numbers). In an attempt to make Excel a smart and more user-friendly tool, there are some in-built features that end up being a little bit of an irritation. Working …
I was recently working on a project where I had dates in Excel and I had to find out what quarter of the year it was based on the date. For the purpose of this tutorial, let’s consider the following: In case you’re working with financial data where the quarter starts from April, then you …
Formulas are the life and blood of Excel spreadsheets. And in most cases, you don’t need the formula in just one cell or a couple of cells. In most cases, you would need to apply the formula to an entire column (or a large range of cells in a column). And Excel gives you multiple …
When working with Excel, you spend most of your time on the worksheet (which is the area that has all the cells and everything that happens there). Working efficiently with Excel also means that you have to work with multiple worksheets within the same workbook. Excel allows you easily add multiple worksheets in the workbook, …
When I was working as a full-time analyst, one of my jobs was to prepare weekly reports for clients and stakeholders. As a part of it, I had to make sure my reports were easy to read and also take less screen space (apparently, clients hate scrolling back and forth). And the functionality of rotating …
When working with data in Excel and creating reports/dashboards, sometimes you would have a need to split a cell diagonally. This is helpful when you want to show two separate headings within the same cell – one for the row and one for the column (as shown below in cell A1). And being the super …
When using lookup formulas in Excel (such as VLOOKUP, XLOOKUP, or INDEX/MATCH), the intent is to find the matching value and get that value (or a corresponding value in the same row/column) as the result. But in some cases, instead of getting the value, you may want the formula to return the cell address of …
When you work with data in Excel, there is a handy feature that allows you to freeze the top row and header columns (or even lock multiple top rows or left columns). So when you scroll down, the headers are always visible. But that’s not the case when you print your reports. By default, a …
©trumpexcel.com – Free Online Excel Training
