COUNTIF: Master This Amazing Formula (2019 Guide)

Excel Countif Function Introduction to Conditional Counting We all know that Excel has a variety of built-in functions. But did you know that the most used functions in Excel are the functions that count and sum? So today, I am happy to discuss and explain (the best I could!) these functions under the statistical category specifically those used for conditional counting – COUNTIF, COUNTIFS, COUNTBLANK. With these functions solely [...]

What is the OR Function in Excel, and How Do I Use it?

Master Your Excel Skills & Get Promoted From Just $29 The OR function in Excel is found in the formulas tab under “logical.” It checks whether any of the arguments are true and will yield either a true or false value. In our Excel classes, you will learn the functionality of this feature and many others. The syntax or formula is: =OR(logical1,logical2,logical3,…) The OR function in Excel can be used with logical operators, [...]

2019-05-30T03:37:33+00:00Excel Classes|

What do I Need to Know Before Taking an Excel Class?

Master Your Excel Skills & Get Promoted From Just $29 There are a lot of online Excel classes. A lot. How effective are they? Well, the majority of them are by teachers whose career backgrounds were in teaching Excel. Or they left their careers and have spent most of it since teaching Excel. That makes for a poor transformative experience in the case of most online Excel courses. The teachers who are [...]

2019-05-30T05:34:41+00:00Excel Classes|

How do I Find the Mean in Excel?

Master Your Excel Skills & Get Promoted From Just $29 In Excel, the mean is referred to as the average. To find the mean in Excel of a set of numbers you add all numbers within the group and divide the total by the count of those numbers. This is a concept that our Excel classes cover in great detail. In the business sector, the mean is the most commonly used measure [...]

2019-05-30T05:37:36+00:00Excel Classes|

What is the Lookup Function in Excel?

Master Your Excel Skills & Get Promoted From Just $29 Though there are a multitude of really great techniques to find information, the focus for today is the LOOKUP Function in Excel.  Our Excel classes cover this topic in great detail so that you can walk away with the greatest understanding of these concepts as possible. If you are not entirely sure how to work with these lesser known formulas, I recommend [...]

2019-05-30T05:37:30+00:00Excel Classes|

How May I Lock Columns in Excel?

Master Your Excel Skills & Get Promoted From Just $29 Learning how to lock columns in Excel allows users to enter or edit information into all other cells except for those which have been locked. Hiding or locking cells has no effect at all on the worksheet until you protect the worksheet. Our Excel classes offer a tutorial on how to do this. Just continue reading the content below. When sharing projects [...]

2019-05-30T05:33:43+00:00Excel Classes|

Why is the VLOOKUP Function in Excel So Important?

Master Your Excel Skills & Get Promoted From Just $29 This article will give you a solid introduction to the VLOOKUP function in Excel, but the first question to ask is “Why do we need to look up things?” You’ll find yourself looking up things a lot in your Excel classes, as well as during your practical applications of Excel in your daily life. Well, when I was a kid, I loved [...]

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

What if I Need to A Remove a Password from an Excel Workbook?

Master Your Excel Skills & Get Promoted From Just $29 Workbooks or worksheets can be protected to prevent the manipulation of data either intentionally or accidentally. Excel classes can help you learn how to protect your documents from this kind of ruin, but this Excel tutorial can offer the same information. Passwords can be put in place to ensure only those employees who have the password can access the workbook or worksheet. [...]

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

How do I Separate First and Last Names in Excel

Master Your Excel Skills & Get Promoted From Just $29 You will often receive spreadsheets containing usernames. Sometimes these spreadsheets have the first name and the last name in different columns. However, spreadsheets usually contain the full name in a single column. Excel classes can teach you the answer to the question of: “So, what do you do then?” Simply follow the options mentioned below to separate first and last name in [...]

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

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|