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.
The fastest way to select an entire column in Excel is the keyboard shortcut Control + Space, and Shift + Space does the same for a row. Both shortcuts work on a Mac too. Working with Excel means working with cells and ranges in the rows and columns in it. And if you work with …
Working with MS Excel means working in the worksheets in Excel. A worksheet is an area that has all the cells where you can store data, enter formulas, insert charts and create reports and dashboards. When you open a new Excel workbook file, by default there is only one worksheet. Earlier versions of Excel (2013 …
Excel is a great tool which can be used for data entry, as a database, and to analyze data and create dashboards and reports. While most of the in-built features and default settings are meant to be useful and save time for the users, sometimes, you may want to change things a little. Converting your …
Percentile is a statistics metric is that is often used when working with data. It gives you an idea of where a value lies in the dataset (i.e., its position/rank in the dataset). In practical life, I have seen the percentile value being used in competitive exams, where on the given score, you get the …
If you want to find the percentage increase or decrease between an old and a new number, you can use a simple Excel formula. Whether you’re working with professional sales data, resource management, project management, or personal data, knowing how to calculate percentage change would help you make better decisions and do better data analysis …
The slope of the regression line is a measure of the steepness of the line. It’s a numeric value that tells us how two variables are correlated. It tells us how much the dependent variable will change in case there is a change in the independent variable. There are three ways to find the slope …
If you have worked with Excel formulas for a while, I am sure you must have encountered the #NAME error. Just like any other error in Excel, the #NAME error also occurs in specific situations (which I will cover in this tutorial), and there are some simple ways to find and fix the #NAME error. …
When working with data in Excel, you would often have a need to copy some tables from Excel into an MS Word document. While there is no built-in option in Excel to convert an entire Excel file to Word, you can easily copy and paste the data from an Excel document to Word. In this …
While Excel is an amazing tool for data analysis, many people use it for basic arithmetic calculations such as addition, subtraction, multiplication, and division. If you’re new to Excel and wondering how to subtract in Excel, you’re at the right place. In this tutorial, I will show you how to subtract in Excel (subtract cells, …
©trumpexcel.com – Free Online Excel Training
