High 30 MS Excel Formulation One Should Know

Introduction

Welcome to the world of Excel, the place numbers come to life and calculations turn out to be a breeze! Whether or not you’re a seasoned Excel person or simply beginning out, realizing a couple of key formulation could make your life a lot simpler. On this weblog, we’re going to discover some important excel formulation that may take your analtyical abilities to the following stage.

On this weblog, we’ll stroll you thru a few of these important formulation step-by-step. We’ll present excel ideas and tips alongside the way in which to make your studying expertise interactive and fascinating. By the tip, you’ll have a stable basis in Excel formulation and be geared up with the talents to deal with any information problem that comes your approach.

So, let’s dive in and unleash the total energy of Excel formulation collectively. Get able to impress your colleagues, supercharge your productiveness, and turn out to be an Excel wizard very quickly!

Take a look at this Excel course to upskill your self with the fundamentals of excel.

Additionally Learn: High 6 Free On-line Excel Programs With Certificates

Excel formulation Checklist

Right here’s a listing of some generally used Excel formulation that may significantly improve your information evaluation and manipulation talents:

1. SUM: Provides up a spread of numbers.
2. AVERAGE: Calculates the typical of a spread of numbers.
3. COUNT: Counts the variety of cells that include numbers.
4. MAX: Finds the very best worth in a spread of numbers.
5. MIN: Finds the bottom worth in a spread of numbers.
6. IF: Performs a logical check and returns completely different values primarily based on the outcome.
7. VLOOKUP: Searches for a worth within the first column of a desk and returns a corresponding worth from one other column.
8. HLOOKUP: Works like VLOOKUP however searches horizontally.
9. CONCATENATE: Joins the contents of a number of cells into one cell.
10. LEFT: Extracts a specified variety of characters from the start of a textual content string.
11. RIGHT: Extracts a specified variety of characters from the tip of a textual content string.
12. LEN: Calculates the variety of characters in a textual content string.
13. TODAY: Returns the present date.
14. NOW: Returns the present date and time.
15. COUNTIF: Counts the variety of cells that meet a particular situation.
16. SUMIF: Provides up the cells that meet a particular situation.
17. AVERAGEIF: Calculates the typical of the cells that meet a particular situation.
18. SUMIFS: Provides up the cells that meet a number of circumstances.
19. AVERAGEIFS: Calculates the typical of the cells that meet a number of circumstances.
20. DATE: Creates a date primarily based on the required yr, month, and day.

Excel Formulation and Capabilities

In Microsoft Excel, there are a lot of formulation and capabilities that rely on the kind of its use. The formulation and capabilities are very helpful and save us time in performing these calculations manually. Capabilities make us lives simpler to carry out calculations with out doing any guide calculations. As an example, we used a formulation within the higher part so as to add values of the cells A1, A2, and A3 manually by putting a + signal between them. And if we use the perform so as to add them, we simply want to make use of the =SUM() perform, and contained in the parentheses, we have to incorporate the cell numbers solely. We may give a spread of cells, or we will additionally enter particular cells contained in the parentheses. It can work the identical for each circumstances and return the results of the addition of these values. 

On this part, we are going to see some principally used and customary formulation and capabilities for mathematical operations, conditional calculations, time-based calculations, and different essential capabilities. In case you are somebody who already has some fundamental information about Excel however needs to study extra, you possibly can take up the Excel Intermediate Stage course or free on-line excel programs with certificates and acquire a complete understanding of Excel.

Allow us to see some essential formulation and capabilities in Microsoft Excel: 

1. Multiplication

Performing multiplication operations in Microsoft Excel may be very straightforward. However to do this, we have to create a formulation. As we simply mentioned, we have to add an equal signal earlier than we write any formulation, due to this fact you’ll want to add an equal signal first and the remaining formulation after that. As an example, we will use the ‘*’ operator to carry out multiplication between values of any two or extra cells. 

For e.g.

= A1*B1

Within the above instance, A1 and B1 are two cells and the ‘*’ operator is used to carry out multiplication amongst them. To make use of the Multiplication Perform, we have to use the PRODUCT perform. 

For e.g.

= PRODUCT(A1,A2)

Within the above instance, we used the PRODUCT perform after an equal signal that may carry out multiplication between the cell values included inside parentheses. 

2. Division

To do that activity, we have to use the forward-slash (/) in our formulation. After utilizing the equal signal, we have to use two cell references or values in our formulation bar in Microsoft Excel. After giving the primary worth or cell reference, you’ll want to add ‘/’ (ahead slash) as a way to carry out a division between these two values. 

E.g.

=A1/B1 or =8/4 will give 2 because of this.

Within the above instance, the formulation will divide the worth of the A1 Cell by the worth of cell B1. It ought to be famous that there’s no DIVIDE perform in Microsoft Excel. 

3. SUM

The identify of the perform is self-defining as it can add the values offered or the vary of cell values and return the Sum of these values. To carry out this perform, you possibly can add particular person cell references, values, vary of cells, or a mixture of these three. 

The syntax of the SUM perform in Excel is as follows:

“=SUM(num-1, num-2, ……, num-n)”

The place num-1 and num-2 are the primary and second numbers that we wish to be added and it could take as much as n instances such that num-n the place n will be any constructive quantity. The primary argument num-1 is obligatory and the remaining arguments are non-obligatory. 

For e.g.

=SUM(A2:A10)

The above instance will return the addition of cell values from A2 to A10 the place SUM is a perform. 

Additionally Learn: Excel Suggestions and Methods to Take Your Profession Forward

4. Subtraction

To carry out subtraction, we will immediately enter the values or use cell references. We have to use the ‘-‘ signal between two or extra values or cell references. The syntax for the Subtraction formulation in excel is as follows:

=number1-number2

The equal signal is all the time obligatory whether or not you declare any perform or formulation, you all the time want to make use of the equal signal first. After that number one is the quantity from which you wish to subtract any worth. And quantity 2 is the worth that you simply wish to subtract from the primary quantity. On this case, the values of each numbers are obligatory.

Allow us to see an instance for immediately coming into the values for subtraction:

For e.g.

= 10-7

Right here the ‘-‘ operator will subtract 7 from 10 and return the outcome as 3. To make use of cell references for subtraction, see the next instance:

=A3-D3

The place the values of D3 will likely be subtracted from the worth of A3 and the outcome will likely be returned to the specified cell the place we put this formulation. 

5. IF

The IF perform in Excel is among the most helpful and hottest capabilities. It permits you to make logical comparisons between a worth and the anticipated worth. So the IF assertion can have two outcomes comparable to True or False. True is when the comparability is true and False when the comparability is False. 

Allow us to see the syntax to make use of this Perform correctly:

=IF(logical_condition, statement_if_true, statement_if_false)

Within the above syntax, the logical assertion is obligatory and it’s that assertion that we have to examine in our worksheet or desk. The second argument is the return assertion that we would like if the situation is true and this assertion is obligatory. Nonetheless, the final assertion for the false situation is just not obligatory. 

For e.g.

=IF(C2=”Sure”,1,2) 

The place IF (C2 = Sure, then return a 1, in any other case return a 2). So, if the worth of cell C2 is Sure and it matches, it can return 1, else it can return 2. 

Additionally Learn: Microsoft Excel Interview Questions

6. DATE

The DATE perform in Excel can be utilized when we have to take three separate values and mix them to make a date. The DATE perform returns the sequential serial quantity similar to a selected date. 

For e.g.

=DATE(yr, month, day)

Within the above instance, all three parameters comparable to Yr, Month, and Day are obligatory and required. You want to present cell references instead of Yr, Month, and Day contained in the parentheses. It can take values from these cells and return them within the type of a date. 

7. Array

Array formulation are very helpful and highly effective that allow us to carry out advanced calculations which frequently can’t be performed in easy worksheet capabilities. In Excel, there are two sorts of Array formulation such because the formulation that carry out numerous calculations to generate a single worth within the outcome and a few which require an array of values as an argument. 

For e.g. {=B2:B8*C2:C8}

Within the above instance, the curly brackets are used to indicate that it’s an array. It may be utilized after writing the Method comparable to:

=B2:B8*C2:C8

After scripting this formulation, after we press CTRL + SHIFT + ENTER, it can add curly brackets making it an array. And It can execute accurately solely after we use these key mixtures. 

8. COUNT

The COUNT() perform is used to rely the variety of cells for a spread that incorporates a quantity. The rely perform doesn’t embody clean cells and the cells which have values in one other format than numeric. 

For e.g.

= COUNT(C1:C4)

Within the above instance, the COUNT perform will rely the variety of cells which have numeric values and return the entire variety of cells within the desired cell. Once we are wanted to rely all of the cells with numerical values, textual content, and another format of information, we will use COUNTA() and it’ll return the entire variety of cells excluding the empty cells solely.  

9. COUNTIF

COUNTIF() Perform is among the helpful statistical capabilities that rely the variety of cells with a given situation. If the situation meets, it counts the cells that include that particular worth. 

For e.g.

=COUNTIF(A2:A5, “apples”)

Within the above instance, the perform COUNTIF counts the cells that include the worth ‘apples’ inside it. And returns the entire variety of cells that incorporates the worth. As an example, if two of the cells between the vary A2:A5 include “apples” as values inside it, it can return 2 because of this. 

10. AVERAGE

The AVERAGE() perform calculates the typical of the vary of cell values. This perform is among the most helpful capabilities as every time we have to calculate the Common of any vary of cell values, we will immediately calculate it with the assistance of this perform. We don’t must manually write all values and formulation. We simply have to offer the vary of cells and it’ll take the values of that cell vary and calculate the typical. 

For e.g.

=AVERAGE(A2:A6)

The instance above exhibits that the Common perform will calculate the typical worth of the cell values starting from A2 to A6. We are able to additionally give particular cell references contained in the parentheses to search out out the typical of these cell values. As an example, if we wish to calculate the typical of solely 3 cells comparable to C1, C2, and C3. Then now we have to jot down like this: =AVERAGE(C1, C2, C3). And it’ll calculate the typical of those three cell values. 

11. Share

There are other ways to calculate percentages in Excel. For instance, you possibly can calculate the proportion of appropriate solutions in a check, the discounted worth on any merchandise utilizing proportion and for different use circumstances. In terms of calculating percentages, it’s a two-step course of. First, we have to format the cell to point the worth is a per cent and after that, we have to write the Share formulation contained in the formulation bar. 

For e.g.

=B2/C2

Right here, after altering the format of the cell for proportion, the formulation that we utilized right here is Dividing the worth of B2 by the worth of cell C2 and it’ll return the outcome within the type of a proportion. 

12. SUMIF

The SUMIF perform is used to sum the values in a spread of cells that meets the factors we specified as an If situation. 

The syntax for SUMIF perform is as follows:

=SUMIF(range_of_cells, logical_condition)

Right here within the syntax, the vary of cells is used to offer the perform a spread which we wish to be added and within the second argument, a Logical assertion is given to carry out the situation inside that vary of cells and return the ultimate outcome. 

For instance, if we give a situation that the numbers which can be bigger than 5 are wanted so as to add to a column, then we will use the next instance:

For e.g. =SUMIF(A2:A20,”>5”)

Within the above instance, the SUMIF perform will discover the numbers within the vary A2:A20 that are bigger than 5 and can return the sum of these numbers within the desired cell. 

13. TRIM

The TRIM perform removes all areas from the textual content besides the only areas between phrases. The TRIM perform may be very helpful when now we have copied any textual content from different purposes and wish to take away irregular spacing from the textual content. The TRIM perform makes it simpler to take away irregular spacing from the textual content. 

The syntax of the TRIM perform is as follows:

=TRIM(“   any string is offered   right here”)

Within the above syntax, as we will see the undesirable areas are there within the string which should be eliminated and to do this, we will use the TRIM perform that may take away the undesirable areas from the string and make our textual content in that string extra clear. 

For e.g. = TRIM(“  First Quarter Gross sales “)

The above instance will take away the undesirable area from the textual content and provides the outcomes as “First Quarter Gross sales”. We are able to specify the Cell reference or a spread of cells from which we wish to take away irregular areas. 

14. LEFT, MID, and RIGHT

The LEFT() perform is used to search out the characters of a string from the left or begin of a textual content string. The MID() perform is used to get the character from the center of a textual content string. Lastly, the RIGHT() perform will give the results of characters from the tip of a textual content string. To raised perceive these capabilities, you must fastidiously have a look at these examples:

For e.g.

=LEFT(‘Apple’,3)

The above instance will return ‘App’ for 3 characters that we laid out in our formulation as 3. We are able to present the cell references or vary of cells instead of the textual content string.

=MID(‘Apple’, 2, 2)

The MID perform will return ‘pp’. As the primary argument 2 is taken to pick the character and the second argument takes the following 2 characters from the textual content string and returns the outcome. 

=RIGHT(‘Apple’, 3)

For the RIGHT perform, it takes 3 characters from the tip of the string and returns because of this. For the above formulation, it can return ‘ple’ because of this. 

15. VLOOKUP

VLOOKUP is a perform that lets you discover issues in a desk or a spread of cells by row. For instance, when we have to discover if a worth exists in our desk or not, then we use the VLOOKUP perform. The VLOOKUP perform takes numerous arguments comparable to if we’re discovering any worth or if we wish to return a corresponding worth to that worth we have to discover within the desk. So right here, we are going to have a look at some examples to higher perceive this perform. 

e.g.1 

=VLOOKUP(B3, B2:E7,2, FALSE)

Within the above instance, VLOOKUP finds the worth of the B3 cell within the desk starting from B2:E7 and offers the corresponding worth of B2 within the 2^nd column, lastly FALSE is used to offer the precise match of the worth we’re in search of. 

e.g.2 

=VLOOKUP(102,A2:D6,2,FALSE)

The two^nd instance exhibits that the VLOOKUP perform is looking for 102 inside the desk starting from A2:D6 and can return the worth from the two^nd column within the vary if it finds a precise match within the desk (False perform is used). 

e.g.3

= IF(VLOOKUP(102,A1:E6,2,FALSE)=”Sousan”, “Location”, “Not discovered”)

Within the above instance, the LOOKUP perform is used with the situation utilizing the IF assertion the place the worth ‘Sousan’ within the 2^nd column is comparable to the worth 102 or not. Whether it is discovered at that location, it can return Situated, in any other case, Not discovered.

Allow us to perceive the VLOOKUP perform in a quite simple language. The finances of dwelling provides within the sheet has a serial quantity column that uniquely identifies any particular merchandise within the finances. And suppose you probably have that serial variety of an merchandise and also you wish to know the merchandise description contained in the desk. At the moment you need to use the VLOOKUP perform. 

16. RANDOMIZE

This perform is used to return the random actual numbers that are larger than or equal to 0 and fewer than 1. Each time the sheet is calculated, it can return a brand new random quantity every time. The perform RAND() may be very helpful when we have to discover any random roll variety of college students or another data in our worksheet. 

For e.g.

=RAND()

This perform will return a random quantity between 0 and 1.

If we use =RAND()*100, it can return a quantity between 0 and 100. For recalculation within the worksheet or to get a brand new random quantity in our perform, the F9 perform secret’s used. It can run the perform once more returning a brand new worth because of this for the required vary. 

17. INDEX-MATCH

This perform may be very helpful to discover a worth in a column to the left. Once we use VLOOKUP and get caught whereas returning an appraisal from a column in the direction of the precise, you need to use the INDEX-MATCH perform as an alternative of VLOOKUP which can think about the lookup column and the return column. 

For e.g.

=INDEX(A1:D11, MATCH(“America”, B1:B11,0),4)

On this instance, we’re in search of America in our desk starting from B1:B11 and suppose it’s present in row 4 utilizing the MATCH perform. Then, INDEX will lookup for the argument and discover the corresponding worth within the 4^th column as we used 4 because the final argument within the formulation. So, it can return the worth comparable to America in that particular column. You must give it a try to discover how it may be used successfully. 

18. HLOOKUP

This perform searches for a worth within the high row of the desk or vary of cells that we offered. It returns the worth in the identical column from the row that we specified within the desk. The HLOOKUP() perform is much like LOOKUP(). The distinction is simply that within the HLOOKUP perform, it searches for the worth horizontally whereas within the VLOOKUP perform, it searches for the worth Vertically. 

The syntax of HLOOKUP perform is as follows:

=HLOOKUP(lookup_value, array_table, index_no_of_row, [lookup_range])

Right here within the syntax above, we will clearly see the arguments the place all of the arguments besides lookup_range are obligatory and should be given contained in the parentheses. The lookup worth is the worth that we’re in search of within the cells. The array desk is the desk of data wherein our information is appeared up. And index_no_of_row is the row quantity within the desk array wherein we’re looking for the lookup worth. 

For e.g. =HLOOKUP(“Axles”, A1:C4, 2, TRUE)

The above instance appears for ‘Axles’ in row 1 of the desk and returns the worth from row 2 which is in the identical column of Axles. 

19. DATEDIF

This perform returns the distinction between two dates after calculating the distinction primarily based on days, months, or years. The Perform turns into very helpful when calculating the Age of individuals in a desk. 

The syntax for the DATEDIF perform is as follows:

=DATEDIF(start_date, end_date, unit)

Within the above syntax, the arguments are obligatory the place the start_date is the primary date of a given interval and could also be entered as textual content strings inside citation marks. End_date is the final or finish date to calculate the variety of days, months, or years between these two dates. The final Unit is used to get the end in a particular method comparable to if we wish to calculate solely the years between two dates, we use “Y” as a unit or if we wish to calculate the month’s distinction between these dates, we have to use “M” for items. The identical can be utilized for Days as “D”. Any mixture of those may also be used as a single unit. 

Allow us to see an instance under to higher perceive the idea of the DATEDIF perform.

For e.g. =DATEDIF(A2, B2, “Y”)

Right here within the instance above cell A2 offers the beginning date whereas B2 offers the tip date and Y is the unit wherein we would like our outcome to be. Such that “Y” is used for Years, “M” can be utilized for Months, and “D” is used for Days in that interval. 

20. TIME()

The TIME perform returns the decimal quantity for any particular time. The results of this perform codecs the cell as a date even when the cell format was Normal earlier than coming into the perform. 

The syntax for the TIME() perform is as follows:

=TIME(hour, minute, second)

Within the above syntax, all of the three arguments are required the place the numerical values for all three arguments differ from 0 to 32767 primarily based on the time. 

For e.g.

=TIME(A3,B3,C3)

The TIME perform will mix the cells within the format of TIME as Hours, Minutes, and Seconds. And the outcome will likely be a decimal quantity primarily based on the time. 

21. TODAY()

When we have to use the present date in our worksheets, we will use the TODAY() perform. It returns the serial variety of the Present date the place the serial quantity is the code for date-time utilized by Microsoft Excel for calculations of date and time. TODAY() perform can be useful to search out the intervals. Allow us to see an instance of the TODAY() perform.

For e.g.

=TODAY()

The perform will return the present date within the format MM/DD/YEAR

One other instance may also be as follows: 

=TODAY() + 5

On this instance, 5 days are added to the present date comparable to if the date of at present is 4/18/2022, then 5 days will likely be added to this date and the ensuing reply will likely be 4/23/2022.

22. SUBSTITUTE

This perform is used to interchange any current textual content with a particular textual content in a textual content string. The SUBSTITUTE perform takes two arguments, first is the textual content or cell reference with which we wish to Substitute characters, second is the Outdated textual content that you simply wish to substitute and lastly New textual content that you simply wish to substitute the previous textual content with. 

Allow us to see the syntax for utilizing SUBSTITUTE perform under:

=SUBSTITUTE(textual content,old_text,new_text,[instance])

Within the above syntax, all of the arguments besides occasion are obligatory the place textual content is the cell reference wherein we wish to change the textual content, previous textual content is the textual content which we wish to be modified with the brand new textual content that we specified within the subsequent argument. And lastly, the occasion is to interchange the textual content. 

For e.g.

= SUBSTITUTE(A2, “SALE”, “DISCOUNT”)

Within the instance, the textual content “SALE” in cell A2 will likely be changed with the textual content “DISCOUNT”.

23. REPLACE

The REPLACE perform replaces part of a textual content string with a unique string primarily based on the variety of characters that we specify with that string. 

The syntax for REPLACE perform is as follows:

=REPLACE(old_text, start_num, num_of_chars, new_text)

Within the above syntax, the previous textual content is the textual content which we wish to get replaced, we will additionally specify the cell reference over there. After that, the second argument takes the variety of beginning areas within the textual content and the third argument is the variety of characters from the beginning variety of the textual content and lastly, the brand new textual content that we wish to get replaced instead of that textual content from beginning quantity as much as the variety of characters of subsequent arguments. 

For e.g.

=REPLACE(A3,6,5,”*”)

Within the above instance, the perform replaces 5 characters within the string from A3 Cell from the 6^th character with a single ‘*’ and returns the outcome.

24. CONCATENATE

The CONCATENATE() perform is used to affix or merge a number of textual content strings right into a single textual content string. 

The syntax for this perform is as follows:

=CONCATENATE(text1, text2,…)

The place text1 and text2 are the arguments of two strings that we wish to be a part of or merge right into a single string. We are able to additionally use greater than two arguments or strings to affix all of them in a single string. 

There are some other ways to carry out this perform described with some examples under:

e.g1.

=CONCATENATE(A12, “ ”, B12)

The instance above will concatenate two strings from cells A12 and B12 and provides the joined string because of this.

e.g2.

=CONCATENATE(A12&” “&B12)

The above instance is one other methodology to affix two strings and provides the brand new merged string because of this. 

25. CEILING

The CEILING perform may be very helpful in that it returns rounded up numbers to the closest a number of of significance. As an example, if we wish to keep away from decimal numbers in our desk and take the spherical off of the numbers, we use the CEILING perform that rounds the quantity to the related a number of of significance. When utilizing the CEILING perform, it rounds the quantity away from zero.

The syntax for the perform CEILING is as follows:

=CEILING(quantity, significance)

Within the above syntax, the argument quantity is that quantity which we wish to be rounded and the importance is a number of to make use of when rounding. See the instance under for a greater understanding of the perform. 

For e.g.

=CEILING(2.5,1)

The above instance rounds 2.5 for the closest a number of of 1 which is 3. 

26. FLOOR

The FLOOR perform rounds the quantity down, from zero to the closest a number of of significance. Allow us to higher perceive the usage of the FLOOR perform with the assistance of an instance under:

For e.g.

=FLOOR(3.4,2)

Within the above instance, the FLOOR perform rounds the quantity 3.4 down in the direction of zero to the closest a number of of two which can be 2. So, it can give 2 because of this. 

27. POWER

The Energy perform returns the results of exponentiation of a quantity to a sure energy. For instance, you’ll want to discover the results of 5 raised to the facility of two, then you’ll want to use the Energy perform and provides these two arguments that may return the sq. of 5 i.e. 25. Allow us to see an instance under:

For e.g.

=POWER(5,2)

The above instance will return a results of 25 as the facility 2 of 5 is 25. We are able to discover the facility of any quantity whether or not it’s in fraction, it all the time offers an correct outcome after we use the POWER perform. 

28. MODULUS

The MODULUS perform returns the rest of a quantity after division. The ensuing quantity has the identical signal because the divisor. It turns into very helpful when we have to discover the rest of any quantity after division. Allow us to see an instance under:

For e.g.

=MOD(5,2)

The MOD perform will return a worth of 1 as a result of after we divide 5 by 2 it can give a the rest of 1 and the constructive signal is as a result of the divisor can be constructive. 

29. LEN

The LEN() perform is beneficial when we have to discover the entire variety of characters in a string. So, the LEN() perform counts the variety of characters within the string and returns it because of this. It additionally counts areas and particular characters. The instance under exhibits how the LEN() perform can be utilized.

For e.g.

=LEN(A7)Within the above instance, the LEN perform will rely all of the characters within the string in Cell A7 and return the entire variety of characters because of this. 

Conclusion

Microsoft Excel is a really helpful and highly effective software when we have to analyze information and stories for numerous functions. The formulation and capabilities that we mentioned on this article are of nice significance in our each day lives, whether or not we wish to do some easy calculations or analyze information or stories. The formulation and capabilities are of nice use in our on a regular basis life. On this article, we checked out textual content, numeric, date-time, and a few superior formulation and capabilities of Microsoft Excel. As you may have seen the usefulness of those formulation and capabilities that we mentioned on this article at present, it can assist you out every time you might be caught in any calculations in Microsoft Excel. 

The capabilities and formulation in Excel allow customers to carry out easy and complicated calculations like discovering totals for a row or column of numbers and so on. These formulation and capabilities turn out to be very helpful in additional advanced conditions comparable to calculating math issues, fixing engineering maths, creating monetary fashions, calculating mortgage funds, and so on. So, that is all about Microsoft Excel Formulation and capabilities on this article. Hope you’ll have realized one thing new. On the lookout for some extra wonderful Excel ideas? We now have bought you lined.

In case you discovered this text useful, then share it with others too. Additionally, take a look at these free excel programs on-line to get began with Microsoft Excel.