How Can You Filter Duplicates in Microsoft Excel?

Master Your Excel Skills & Get Promoted From Just $29 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 [...]

2019-05-30T05:54:56+00:00Excel Training|

What Are the Best Text Functions in Excel?

Master Your Excel Skills & Get Promoted From Just $29 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 [...]

2019-05-30T05:55:06+00:00Excel Training|

Why Excel Shortcuts are Bad for Your Career

Master Your Excel Skills & Get Promoted From Just $29 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 [...]

2019-05-30T05:55:17+00:00Excel Training|

What Does an Excel Crash Course Look Like?

Master Your Excel Skills & Get Promoted From Just $29 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 [...]

2019-05-30T05:55:34+00:00Excel Training|

Not All Excel Training Courses Are Created Equally

Master Your Excel Skills & Get Promoted From Just $29 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. [...]

2019-05-30T05:56:40+00:00Excel Training|

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

Master Your Excel Skills & Get Promoted From Just $29 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 [...]

2019-05-30T05:59:57+00:00Excel Training|

How to Subtract Dates in Excel

Master Your Excel Skills & Get Promoted From Just $29 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, [...]

2019-05-30T06:00:11+00:00Excel Training|

What are the Day Of The Week Functions In Excel?

Master Your Excel Skills & Get Promoted From Just $29 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 [...]

2019-05-30T06:00:19+00:00Excel Training|

How Can I Modify the Date Format in Excel?

Master Your Excel Skills & Get Promoted From Just $29 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 [...]

2019-05-30T06:00:28+00:00Excel Training|

How is VLOOKUP Used to Compare Two Columns in Excel?

Compare Two Columns In Excel Using VLOOKUP Okay, let’s establish the goal. We want to see if one ‘bunch’of data exists within another bunch of data. Now unless you are prepared to spend some time using VBA to do complex scripting, you won’t get a precise result. But that’s okay. Often we just want to confirm if data exists for investigative reasons. It’s not some complex report or analysis we are building, just a [...]

2019-08-18T09:43:27+00:00Excel Training|