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.
What’s in the name? If you are working with Excel spreadsheets, it could mean a lot of time saving and efficiency. In this tutorial, you’ll learn how to create Named Ranges in Excel and how to use it to save time. Named Ranges in Excel – An Introduction If someone has to call me or …
If your work involves applying the same type of formatting to data sets, using Format Painter in Excel will save you a lot of time. What is Excel Format Painter? Excel Format Painter is a nifty tool that allows you to copy formatting from a range of cells and paste it somewhere else in the …
Flash Fill is an amazing tool that was added in Excel 2013 and is available in all version after that. You can use Flash Fill in Excel to make data entry easy. It’s a smart tool that tries to identify patterns based on your data entry and does that for you. Some simple examples of …
Watch Video – How to Lock Formulas in Excel Excel formulas are easy to create and edit in Excel. You can easily edit a formula through the formula bar or directly in the cell. While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well. Consider this. You are …
When you copy and paste formulas in Excel, it automatically adjusts the cell references. For example, suppose I have the formula =A1+A2 in cell B1. When I copy the cell B1 and paste it in B2, the formula automatically becomes =A2+A3. This happens as Excel automatically adjusts the references to make sure the rows and columns now …
As soon as you type a formula in Excel and hit enter, it would return the calculated result, and the formula would disappear. That’s how it’s supposed to work. But what if you want to show formulas in the cells and not the calculated values. In this Excel tutorial, I will cover the following topics: …
*This is a guest post by Puneet Gogia, a fellow Excel blogger from India.* Excel has a Quick Access Toolbar that gives you instant access to your favorite/important options. However, not many people use the QAT efficiently. Last month I have asked 15 excel users about it, and only 7 were using it on frequent …
Often, once you create a Pivot table, there is a need you to expand your analysis and include more data/calculations as a part of it. If you need a new data point that can be obtained by using existing data points in the Pivot Table, you don’t need to go back and add it in …
When you work with Excel charts, it rarely happens that you use the same default chart that Excel creates for you. In most of the cases, you have to change its formatting based on your brand, project, or audience. Now, if there is a fixed format that you have to use for many charts, it …
©trumpexcel.com – Free Online Excel Training
