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.
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, …
When you printing your work in Excel, it would help if there is a system to decide how much content goes on one page and what’s then printed on the next page, and so on. By default, Excel does this by inserting page breaks at regular intervals in the worksheet while printing. This is done …
Excel is a powerful tool that has some amazing functions and functionalities when working with statistics. Finding a correlation between two data series is one of the most common statistical calculation when working with large datasets, I was working as a financial analyst a few years ago, and although we were not heavily involved in …
Running total (also called cumulative sum) is quite commonly used in many situations. It’s a metric that tells you what’s the sum of the values so far. For example, if you have the monthly sales data, then a running total would tell you how much sales have been done till a specific day from the …
The XML file format is quite commonly used on the web, and there is a possibility that sometimes you may have to work with the data in the XML file. Now you can’t use the XML file directly, as it’s not meant to be read by humans (but machines). In such a case, it would …
Excel allows you to format dates in many different ways. You can choose to show the date in a short date format or in a long date format. You can also only show the day number, the month name, or the year from a given date. In this short Excel tutorial, I will show you …
Sometimes, you may have a need to flip the data in Excel, i.e., to reverse the order of the data upside down in a vertical dataset and left to right in a horizontal dataset. Now, if you’re thinking that there must be an inbuilt feature to do this in Excel, I’m afraid you’d be disappointed. …
When working with Excel spreadsheets, most people are either short on time or have a deadline to meet. And it could be a nightmare if, at that point in time, Microsoft Excel decides not to open (arghhhhh!). Unfortunately, this unexpected behavior is quite common where Excel refuses to open one of your important Excel files, …
When working with data in Excel, you’ll often have the issues of handling outliers in your data set. Having outliers is quite common in all kinds of data, and it’s important to identify and treat these outliers to make sure that your analysis is correct and more meaningful. In this tutorial, I’ll show you how …
©trumpexcel.com – Free Online Excel Training
