How Do I Sort Data in Excel?

Learning how to sort in Excel is vital in analysing data. In our Excel classes, we will teach the most effective ways to manage and read spreadsheets; the sorting function is vital in this process. In a large worksheet it makes the data easier to read and classify the data allowing the user to arrange the worksheet into a view that is pertinent to their specific tasks. The worksheet is a brief synopsis [...]

2018-09-19T15:49:49+00:00 Excel Classes|

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

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, nested within an “if” function, and used in conjunction with the [...]

2018-09-19T15:24:14+00:00 Excel Classes|

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

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 most capable are transferring skills and have a solid understanding of [...]

2018-09-19T15:15:26+00:00 Excel Classes|

How do I Find the Mean in Excel?

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 to find the average of a set of values. Take sales [...]

2018-09-19T15:08:52+00:00 Excel Classes|

What is the Lookup Function in Excel?

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 going to the formula tab in the ribbon under lookup & [...]

2018-09-19T15:00:49+00:00 Excel Classes|

How May I Lock Columns in Excel?

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 amongst several team members, sometimes it is necessary to lock certain [...]

2018-09-19T14:51:04+00:00 Excel Classes|

Why is the VLOOKUP Function in Excel So Important?

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 finding things out. I wanted to be the smartass know-it-all! I [...]

2018-09-19T14:42:17+00:00 Excel Classes|

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

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. The following article will detail how to remove password from Excel [...]

2018-09-18T21:00:35+00:00 Excel Classes|

How do I Separate First and Last Names in Excel

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 Excel into two columns. How Can You Separate First and Last [...]

2018-09-18T20:38:36+00:00 Excel Classes|

How Can I Remove Spaces in Excel?

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 unwanted spaces in your data or data strings. Read the Excel [...]

2018-06-18T14:37:14+00:00 Excel Classes|