How Can You Filter Duplicates in Microsoft Excel?

Duplicate values are bound to happen from time to time and you need to know how to find duplicates in Excel. Luckily for you, this online Excel training tutorial will help you understand how this is done. There are a few ways to find these duplicates. The easiest way to filter for duplicates is to use the advanced filter feature. However, you can also use conditional formatting and the countif function. How to [...]

2018-06-18T14:46:50+00:00 Excel Training|

What Are the Best Text Functions in Excel?

One of Excel’s strengths is the great job it does of working with text information. This is truly an invaluable section in your Excel training since dealing with text data and using text functions in Excel is fundamental to most professionals. In this article I’m going to give an explanation of them, some examples and marks out of 10 for all the formulas. First let’s look at formulas that cleanse text data. By [...]

2018-06-18T14:47:44+00:00 Excel Training|

Why Excel Shortcuts are Bad for Your Career

I am pretty darn good at Excel! I can solve any problem I need to, but one thing I am not good at is using Excel shortcuts. I know Ctrl + C (Copy), Ctrl + V (Paste) and the most important one on account of being a human being is Ctrl + Z (Undo!). Some methods of Excel training will teach you these shortcuts, but not mine. Not only do I not know [...]

2018-06-09T19:46:23+00:00 Excel Training|

What Does an Excel Crash Course Look Like?

If you want to get good at something, you have to invest time and effort. You can go away, grab some books, peruse Youtube, Google, forums and other sources, or you can let us help you get an Excel crash course. This is a great method of Excel training for those who have minimal time to spare. Let me first spend 90 minutes taking you from beginner to intermediate Excel. Over the course [...]

2018-06-09T19:40:34+00:00 Excel Training|

Not All Excel Training Courses Are Created Equally

If you are a professional like an analyst, controller, accountant, PMO/project manager looking to undertake Excel training, then you need to avoid putting your skills and your career into the hands of an Excel specialist who doesn’t get the bigger picture of how Excel fits in with your career. A quality online Excel class will teach you how to apply your newly-found knowledge within the context of your daily life. They will have you learning things you do not need and send you down time-wasting rabbit [...]

2018-06-18T14:48:57+00:00 Excel Training|

What are the Absolute and Relative References for The Dollar Sign in Excel?

Excel’s default is to use relative reference when using formulas. That means that when a formula is copied and pasted into another cell, the formula will change its reference points by the exact number of columns and rows that you moved the formula. Our Excel training will show you how to use this information to your benefit.  We achieve this by including or omitting the dollar sign in Excel. Demonstrated below in the [...]

2018-06-18T14:49:54+00:00 Excel Training|

How to Subtract Dates in Excel

If you want to know how to subtract dates in Excel, you need to know that there are two formulas. This segment of your Excel training will teach them both to you. The first is the days formula located under the date & time button in the formulas tab. This formula will only yield the number of days. The second formula, datedif, may also be used to find the exact number of days, [...]

2018-06-18T14:50:12+00:00 Excel Training|

What are the Day Of The Week Functions In Excel?

There are two types of functions associated with the day of the week in Excel. The first is concerned when you have a date (8/19/17, for example) and you want to know the day of the week (Saturday). We can achieve this result by customising the date format for the cell or another cell within the worksheet. Let our online Excel training show you how. The second is the weekday function. Like [...]

2018-06-18T14:50:57+00:00 Excel Training|

How Can I Modify the Date Format in Excel?

There are sixteen options to choose from when you want a date format in Excel-and this Excel training section is going to cover them all. All of these options can be found by right-clicking the cell that the date is in and selecting “format cells” from the menu and clicking “date” in the categories. A short date and long date shortcut are also located in the Home tab. In the number formatting box, [...]

2018-06-06T22:15:20+00:00 Excel Training|

How is VLOOKUP Used to Compare Two Columns in Excel?

This short and sweet Excel training session, I will reveal a very quick look at how you can compare two columns in Excel using the VLOOKUP function. How Can We Compare Two Columns in Excel? In my online Excel classes, you’ll likely come to appreciate how important making accurate comparisons is. Here we have two sheets, one in green and one in blue, with a list of references in both.  In column B [...]

2018-06-06T21:15:44+00:00 Excel Training|