The Ultimate Guide To VLOOKUP (2019 Edition)

Excel VLOOKUP Function Introduction Now, this is a long guide, which shouldn’t concern you as the VLOOKUP is a big but important subject. Now, if you are the sort of person who prefers video then you can get the concept and introduction from this video. After that, I strongly recommend you keep reading the guide as we get progressively more advanced on route to helping you master this Excel Function! [...]

Excel Formulas Ultimate Guide (2019)

The Excel Formulas Ultimate Guide 2019 Introduction to Excel Formulas In this guide, we are going to cover everything you need to know about Excel Formula. Learning how to create Excel formulas is the building block to the exciting journey to become an Excel Expert. So, let’s get started! What is an Excel Formula? Excel Formulas are often referred to as Excel Functions and it’s no [...]

How to Get the Most out of MS Excel

Master Your Excel Skills & Get Promoted From Just $29 Whatever your reasons are for using Excel, high are the chances that you still want to know more about it so you can use it for far wider applications. Business users are constantly looking for ways to use the program to help them improve their accounting and financial processes. If you want to transform yourself from a novice to an expert user [...]

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 to Use Microsoft Excel Auto Fill Function

Master Your Excel Skills & Get Promoted From Just $29 The Excel AutoFill feature enters data based on a pattern versus entering each cell manually. The AutoFill feature is turned on by default in Excel, but if it has been turned off you must go to the File tab and select Options.  In the advanced menu, make sure “enable autocomplete for cell values” has been checked. If for some reason, you do [...]

2019-05-30T06:01:07+00:00Excel Functions|