About WebMaster

This author has not yet filled in any details.
So far WebMaster has created 27 blog entries.

What if I Need to Highlight Every Other Row in Excel?

Master Your Excel Skills & Get Promoted From Just $29 You will commonly find it in good practice to highlight every other row in Excel. It is a common practice for better aesthetics. It’s more of a visual trick to improve readability so that when one scans through some data, it can prevent them from getting lost. My beginner Excel classes teach the benefits of this, as well as how to apply [...]

2019-05-30T05:25:03+00:00Excel Classes|

How Do I Filter Records in Excel?

Master Your Excel Skills & Get Promoted From Just $29 Nowadays, Excel files are loaded with numerous records. In such cases, it is very difficult to find specific information quickly. My Excel classes are here to help you learn how to most efficiently navigate these spreadsheets. The Excel filter will help hide unwanted records and lets us view only necessary records on the worksheet. Can you Filter Records with Excel’s Built-In Filter? [...]

2019-05-30T05:24:50+00:00Excel Functions|

How do I Delete Duplicates in Excel?

Master Your Excel Skills & Get Promoted From Just $29 When you are collating spreadsheets from several other spreadsheets, there are higher chances that the final master spreadsheet will have duplicate records. My Excel classes will teach you not only how to find these duplicates, but how to delete them as well. You must delete duplicates in Excel; failure to do so will result in wrong data representations in your reports. How [...]

2019-05-30T05:24:40+00:00Excel Functions|

Why Do Good Excel Classes Suggest Avoiding the Excel HLOOKUP Feature?

Master Your Excel Skills & Get Promoted From Just $29 Here’s a question I got from one of my Excel classes subscribers, Joseph: ‘Sohail, can you kindly explain how best to use the Excel HLOOKUP?’ Yes, Joseph, here’s my explanation, although it may not be very kind: ‘Never use HLOOKUPs. Never ever.’ Is that, okay Joseph? Did I cover all the points you wanted me to? Wouldn’t life be easier if I [...]

2019-05-30T05:54:49+00:00Excel Functions|

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|