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 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 …
Excel has some useful chart types that can be used to plot data and show analysis. A common scenario is where you want to plot X and Y values in a chart in Excel and show how the two values are related. This can be done by using a Scatter chart in Excel. For example, …
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, …
Excel is an amazing tool to store and analyze data. And many of the times, you will have to deal with text data types such as names, regions, departments, or product names. In such cases, it’s good to know how to manipulate text data and get the desired result. One of the most common tasks …
Watch Video – Fill Down in Excel A lot of times, you may encounter a data set where only one cell is filled with data and the cells below it are blank till the next value. Something as shown below: While this format works for some people, the problem with this sort of data is …
When everything is working as expected, when you hit the up arrow key or the down arrow key in Excel, you would expect the cursor to go to the cell above or below. And since you’re reading this article, I can assume that it’s not happening with your Excel. One common issue with arrow keys …
Sometimes, when working with dates, you may want to know the date after a specific number of months. For example, you may want to know the date three months after a specific date. Thankfully, Excel has an in-built function (EDATE) that does exactly this. In this tutorial, I will show you how to use a …
Sometimes you may have dates in one column and time values in another column and you want to combine these to get one single date and time value in a cell. And if you’re thinking that you can do that by easily combining the two cells by using the concatenate formula or the & sign, …
©trumpexcel.com – Free Online Excel Training
