How Can I Remove Spaces in Excel?

Master Your Excel Skills & Get Promoted From Just $29 Many times, data is entered into Excel workbooks with spaces. These unwanted spaces might be at the beginning of the data or at the end, or even sometimes in between strings. These spaces can cause issues when you try to analyse the data and create reports out of it. My Excel classes will help you figure out the best ways to remove [...]

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

How Can I Password Protect My Important Excel Files?

Master Your Excel Skills & Get Promoted From Just $29 Excel workbooks might contain sensitive information like bank account numbers, employee addresses, social security numbers, critical weekly reports a or company’s financial reports. My online Excel classes will not only teach you how to create these spreadsheets, but also how to protect them in the Excel tutorial below. In this article, you will learn to password protect an Excel file. This can [...]

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

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|