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 need to get the sum across multiple worksheets, you can use one of the less-known Excel feature called 3D referencing. With 3D referencing, you can refer to the same cell in multiple worksheets, and can also use this in formulas such as the SUM or AVERAGE, or COUNT. In this short tutorial, I …
If you want to fill a column with Yes or No answers, typing them by hand gets slow, and someone will eventually make a mistake and type “yes ” or “Y”. A Yes/No drop-down list fixes this. You simply pick Yes or No from the list, so there’s no room for misspelled words. In this …
Excel ribbon is the area at the top of the worksheet that contains most of the frequently used commands. In the ribbon, we have different tabs (such as the ‘Home’ tab or the ‘Insert’ tab), and within each tab, we have the relevant commands. Most Excel users would find everything they need somewhere in the …
When you’re preparing a profit or finance report, you might want negative numbers in parentheses, but Excel shows them with a minus sign by default. For example, if you type -182029, Excel shows -182029 even though your report needs (182029). There are a few ways to fix this: the built-in Format Cells option, Accounting format, …
Excel ribbon was introduced in Excel 2007, which allowed users to access all the important tools and functionalities from one single place. Personally, I think the Excel ribbon was a huge improvement over the earlier menu option, as it made it more user-friendly for people to find useful options in one place. While it wasn’t …
I love using Conditional Formatting in Excel. It allows me to quickly highlight and format cells based on specified conditions. While Conditional Formatting is great, it’s also volatile – which means that if you have a lot of conditional formatting rules applied to large data sets, it can slow down your Excel file. So, I …
Cells are the building blocks of a worksheet in Excel. Most Excel users spend the majority of their time working with the cells in Excel – be it entering data or formulas or editing the already entered formulas/text. In this tutorial, I will cover everything you need to know about editing cells in Excel. While …
The Pivot Table feature is used by many Excel users – beginners as well advanced. One thing that often troubles new Pivot Table users is when they find that a Pivot Table Fields list (some people call this Pivot Table Fields menu) goes missing. You can’t do much with a Pivot table if you do …
Pivot tables are very easy to create and even easier to move to some other worksheet or a new worksheet in the same Excel workbook. Many Excel users often end up creating multiple Pivot tables in the same worksheet, which is not a very organized way of doing things. But thanks to a readily available …
©trumpexcel.com – Free Online Excel Training
