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.
In Excel, there are two ways to combine the contents of multiple cells: If you’re using Excel with Office 365 subscription, I suggest you click here to skip to the part where the TEXTJOIN function is covered. If you’re not using Office 365, keep reading. In its basic form, CONCATENATE function can join 2 or …
This is the fifth and final article of the five-part series on Data Analysis in Excel. In this section, I will show you how to use Solver in Excel. Download Example File Other articles in this series: Watch Video – Using Solver in Excel Solver in Excel is an add-in that allows you to get an optimum solution …
This is the fourth article of the five-part series on Data Analysis in Excel. In this section, I will show you how to use Goal Seek in Excel. Download Example File Other articles in this series: Watch Video – Goal Seek in Excel Goal Seek in Excel, as the name suggests, helps you in achieving a value …
This is the third article of the five-part series on Data Analysis in Excel. In this section, I will show you how to use the Scenario Manager in Excel. Download File Other articles in this series: Watch Video – Scenario Manager in Excel Scenario Manager in Excel can be the tool of choice when you …
I was going through the questions on the Microsoft Excel Community, and one of the questions was on generating random numbers in Excel between 1 to 10, where none of the numbers repeat (i.e., there are no duplicates). My first instinct was to use the RANDBETWEEN function. I did a quick check with some random data …
This is the second article of the five part series on Data Analysis in Excel. In this section, I will show you how to use Two Variable Data Table in Excel. Download Example File Other articles in this series: Watch Video – Two-variable Data Table in Excel Two-variable data table is best suited in situations when you want to see how …
This is the first article of the five-part series on Data Analysis in Excel. In this section, I will show you how to create and use a One Variable Data Table in Excel. Download Example File Other articles in the Data Analysis series: Watch Video – One-Variable Data Table in Excel One variable Data Table in …
If you are addicted to using the Excel Quick Access toolbar (QAT), this tip is for you. As you add many icons to the Excel QAT, there is also a way to group related icons together. Here is a snapshot of my Quick Access Toolbar: These vertical line separators can be used to group similar icons together. …
When it comes to the Excel world, it’s divided into two factions – the VLOOKUP brigade and the INDEX/MATCH regiment. If you’re wondering which one scores higher in the VLOOKUP vs INDEX/MATCH battle, this article will try and answer it. But before I do that, let me make a few things clear – this article …
©trumpexcel.com – Free Online Excel Training
