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.
You can combine a first name and a last name into one cell in Excel with a simple formula, or with features that don’t need a formula at all. 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 …
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 …
If you press the down arrow key in Excel and the cursor stays put, or the whole sheet scrolls instead, it can feel like the keyboard has stopped working. In most cases, the keyboard is fine. Excel has a few modes and settings that take over the arrow keys, and each one shows a clue …
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, …
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 …
©trumpexcel.com – Free Online Excel Training
