Microsoft Excel for Beginners

Microsoft Excel for Beginners


This Microsoft excel basic tutorial crash course is prepared to help you get started with electronic spreadsheets. MS Excel is one of the most popular spreadsheets that many people widely use.

Microsoft Excel is profound intelligent software used in school, accounting, finance, business, data analysis, organization, and what have you. Many offices use spreadsheets in one way or the other to automate their processes.

Course Objectives

In this Microsoft excel basic tutorial, you are going to learn the following topics:

Excel Introduction

Excel Uses and Benefits

Excel User Interface

Excel Operations

Excel Formatting

Excel Applications

Excel Chart and Graph

Excel Printing

Please use the START LEARNING button to begin the class. Also, use the NEXT and PREVIOUS buttons to navigate through the lessons.

Excel Introduction

Microsoft Excel is a spreadsheet application for recording and analyzing numerical and statistical data. Microsoft Excel includes a variety of functions for doing various tasks such as computations, pivot tables, graph tools, macro programming, and so on. It is OS-compatible with Windows, macOS, Android, and iOS.

An Excel spreadsheet is a table made up of columns and rows. Columns are often allocated alphabetical letters, whereas rows are typically assigned numerals. A cell is a location where a column and a row intersect. The address of a cell is represented by the letter for the column and the number for the row.

The reasons for learning Microsoft Excel

In some capacity, all of our work is with numbers. Everybody has everyday costs that they must cover from their monthly revenue. Knowing one's income vs. expenditures is necessary in order to spend money sensibly. When we need to capture, examine, and save such numerical data, Microsoft Excel comes in helpful. Let's use the image below to demonstrate this.

What is the location of Microsoft Excel?

Microsoft Excel is available in a variety of ways. A hardware computer store that also offers software is where you may get it. The Microsoft Office software package includes Microsoft Excel. A license key must be purchased if you choose to download it from the Microsoft website.



Excel Uses and Benefits

1. Accounting

Budgets, predictions, cost monitoring, financial reports, loan calculators, and more tools are available. Excel was essentially developed to suit these various accounting requirements. And, given that a larger majority of businesses use Excel for its different accounting capabilities, it clearly meets the description.

2. Education

MS Excel may be used in a variety of educational settings. Even Excel is making it simpler for instructors to teach. To convey the themes to the pupils, the professors employ tables, shapes, charts, and other tools in Excel. Furthermore, teachers use formulae to teach pupils about mathematical computations.

3. Human Resource Management

It is one of the most common applications of Excel in business. MS Excel is a wonderful tool for gathering information about individuals. Personal information of workers, customers, sponsors, and others may be conveniently saved and recovered using Excel. It can also be used to prepare payment vouchers for workers.

4. Office Management

MS Excel is used to store and enter administrative data. This information is then utilized for accounting and financial reporting, as well as business analysis and performance reporting. Furthermore, Excel assists office management in daily operations such as invoicing, bill payments, and so on.

5. Project management

Although project managers have access to project management (PM) software, an Excel worksheet is frequently a viable option. Projects are commercial operations with a budget and a start and finish date. Project plans may be entered into a workbook, which can be used to track progress and keep the project on track.

6. Charting

The number of pie charts, bar charts, column charts, line charts, and area charts is endless. If you need to portray data in a more visual and comprehensible manner, Excel's ability to turn rows and columns of figures into stunning charts will undoubtedly become one of your favorite features.

7. Task list

Say goodbye to your traditional pen and paper to-do list. With Excel, you can create a considerably more comprehensive task list—and even track your progress on those larger tasks that are already on your plate.


Excel User Interface

Because MS Excel is a spreadsheet. Gridlines are used to demarcate columns and rows in a table-like manner.

Worksheet

The Excel workplace is known as a worksheet. Each worksheet has up to 16 sheets. You can see this at the bottom of the worksheet before the status bar.

Sheet names can be renamed, you can also add or delete sheets.

Columns

Columns are the vertical alignment of cells. They are labeled with alphabets. A, B, C,…

Rows

Rows are the horizontal alignment of cells. They are numbered with Arabic figures. 1, 2, 3, …

Cells

Cells are the intersections between columns and rows. The small rectangles in a worksheet are known as cells.

Cell Address

Each cell in Microsoft Excel has its own address. For instance, the first cell is known as cell A1. This is because it is under column A and in row 1.

Excel Formatting

Formatting document in Microsoft Excel is as basic as doing so with every other computer application package. Let’s look at it.

Typing

To type in Excel, place the cell pointer (ie. the tick rectangular box) where you want your text to appear, and then start typing.

Turn on the Caps lock button to type in capital letters or, hold down the shift key to type special characters.

Fonts

After typing, you can format your text by clicking on the cell that contains the text in order to highlight it. Then apply any of the font formatting actions such as font style, font size, bold, italic, underline, etc.

Color

Another interesting formatting is color. You can apply color to a text or to the background of the cell. All you need to do is to highlight the range of cells to which you will like to apply the color. Then click on your desired color.

Border

When it comes to the cell border, it should be noted that the gridlines are different from the border. As a matter of fact, the gridlines will not show during printing.

To apply a border to your worksheet, highlight the range of cells and choose the border style of your choice.

Excel Operations

Now, let us look at the basics of Excel operations.

Addition

Let us look at this data in this table



A


B

C

D

E

1

YEARS

QUATER 1

QUATER 2

QUATER 3

QUATER 4

TOTAL

2

YR 2022

200

320

150

650


3

YR 2023

350

550

400

900


To add numbers in Excel, there is a variety of ways you can do that. First, you can add up numbers by highlighting a range of cells, then click on the autosum button.

This can also be performed with a formula by placing the cell pointer under total and typing the following formula.

Example 1: =SUM(B2:E3) Then press the enter key from the keyboard.

Example 2: =(B2+C2+D2+E2) press enter.

Both examples 1 and 2 will yield the same result.

Subtraction

To subtract numbers, you will also need to use the cell address to identify the numbers you will like to work on.

Example: =(D2-E2) press enter.

Multiplication

To multiply numbers, use the cell address to identify the numbers.

Example: =(A4*A5) press enter.

Division

The same rule applied to division. Just identify the numbers you would like to divide.

Example: =(A3/B3) press enter.

Average

Excel makes it easy to find the average of two or more numbers. This is also known as MEAN number.

Example: =AVERAGE(B2:E3) press enter.

Excel Applications

Now, let us apply what we have learned with real-life examples.

Daily Sales Book

Now, let us use the formula that we learned in the previous lesson to solve this problem.



A

B

C

D

E

1

NO

ITEMS

QUANTITY

COST

AMOUNT

2

1

Exercise Book

3

650


3

2

Calculator

1

2300


Solution: Place the cell pointer in cell E2 and type =SUM(D2*C2) press enter.

Payment Voucher

To calculate workers' payment, the grade level and/or other parameters will be used to determine the take home.



A

B

C

D

E

1

NO

NAMES

GENDER

G/LEVEL

SALARY

2

1

Peter Smith

Male

6


3

2

Miracle Akanne

Female

5


Solution: 

=IF(D2>=6,”75,000”,IF(D2>=5,”58,000”,IF(D2>=4,”51,000”,IF(D2>=3,”44,000”,”38,000”))))

Result Computation

To perform student result computation, you will need to know if you are computing a single result, or the result for all subject. In this example, we shall work on a single result.


A

B

C

D

E


1

NO

NAMES

ASSESS. 

(30 %)

EXAM 

(70 %)

TOTAL

REMARKS

2

1

Peter Smith

24

61



3

2

Miracle Akanne

27

67



Solution for Total:

=SUM(C2:D2) press enter

Solution for Remarks:

=IF(E2>=40,”PASS”,”FAIL”)

Excel Chart and Graph

In Microsoft Excel, a chart is commonly referred to as a graph. It is a graphical representation of data from a spreadsheet that can provide more insight into the data than simply looking at the numbers.

  1. Select data for the chart.

  2. Select Insert > Recommended Charts.

  3. Select a chart on the Recommended Charts tab, to preview the chart.

  4. Select a chart.

  5. Select OK.

Chart Type

Commonly used chat types are

1. Column Chart

2. Line Chart

3. Bar Chart

4. Area chart

Sample of a pie chart.


Excel Printing

You may print whole or partial worksheets and workbooks individually or in batches. You may also print simply the Excel table if the data you wish to publish it in a Microsoft Excel table.

You may also use a file instead of a printer to print a worksheet. This is important when you need to print the workbook on a different printer from the one you initially used.

Print a partial sheet, an entire sheet, or an entire workbook

  1. Do one of the following:

    • To print a partial sheet, click the sheet, and then select the range of data that you want to print.

    • To print the entire sheet, click the sheet or the sheet tab.

    • To print a workbook, click any of its sheets.

  2. On the File menu, click Print.

  3. On the Printer menu, select the printer that you want.

  4. The default is to print all active sheets. To change what is printed, select Show Details.

In the Print drop-down menu, select the option that corresponds to what you want to print (Selection, Active Sheets, or Entire Workbook) and then select Print.

Microsoft Excel for Beginners


This Microsoft excel basic tutorial crash course is prepared to help you get started with electronic spreadsheets. MS Excel is one of the most popular spreadsheets that many people widely use.

Microsoft Excel is profound intelligent software used in school, accounting, finance, business, data analysis, organization, and what have you. Many offices use spreadsheets in one way or the other to automate their processes.

Course Objectives

In this Microsoft excel basic tutorial, you are going to learn the following topics:

Excel Introduction

Excel Uses and Benefits

Excel User Interface

Excel Operations

Excel Formatting

Excel Applications

Excel Chart and Graph

Excel Printing

Please use the START LEARNING button to begin the class. Also, use the NEXT and PREVIOUS buttons to navigate through the lessons.

Excel Introduction

Microsoft Excel is a spreadsheet application for recording and analyzing numerical and statistical data. Microsoft Excel includes a variety of functions for doing various tasks such as computations, pivot tables, graph tools, macro programming, and so on. It is OS-compatible with Windows, macOS, Android, and iOS.

An Excel spreadsheet is a table made up of columns and rows. Columns are often allocated alphabetical letters, whereas rows are typically assigned numerals. A cell is a location where a column and a row intersect. The address of a cell is represented by the letter for the column and the number for the row.

The reasons for learning Microsoft Excel

In some capacity, all of our work is with numbers. Everybody has everyday costs that they must cover from their monthly revenue. Knowing one's income vs. expenditures is necessary in order to spend money sensibly. When we need to capture, examine, and save such numerical data, Microsoft Excel comes in helpful. Let's use the image below to demonstrate this.

What is the location of Microsoft Excel?

Microsoft Excel is available in a variety of ways. A hardware computer store that also offers software is where you may get it. The Microsoft Office software package includes Microsoft Excel. A license key must be purchased if you choose to download it from the Microsoft website.



Excel Uses and Benefits

1. Accounting

Budgets, predictions, cost monitoring, financial reports, loan calculators, and more tools are available. Excel was essentially developed to suit these various accounting requirements. And, given that a larger majority of businesses use Excel for its different accounting capabilities, it clearly meets the description.

2. Education

MS Excel may be used in a variety of educational settings. Even Excel is making it simpler for instructors to teach. To convey the themes to the pupils, the professors employ tables, shapes, charts, and other tools in Excel. Furthermore, teachers use formulae to teach pupils about mathematical computations.

3. Human Resource Management

It is one of the most common applications of Excel in business. MS Excel is a wonderful tool for gathering information about individuals. Personal information of workers, customers, sponsors, and others may be conveniently saved and recovered using Excel. It can also be used to prepare payment vouchers for workers.

4. Office Management

MS Excel is used to store and enter administrative data. This information is then utilized for accounting and financial reporting, as well as business analysis and performance reporting. Furthermore, Excel assists office management in daily operations such as invoicing, bill payments, and so on.

5. Project management

Although project managers have access to project management (PM) software, an Excel worksheet is frequently a viable option. Projects are commercial operations with a budget and a start and finish date. Project plans may be entered into a workbook, which can be used to track progress and keep the project on track.

6. Charting

The number of pie charts, bar charts, column charts, line charts, and area charts is endless. If you need to portray data in a more visual and comprehensible manner, Excel's ability to turn rows and columns of figures into stunning charts will undoubtedly become one of your favorite features.

7. Task list

Say goodbye to your traditional pen and paper to-do list. With Excel, you can create a considerably more comprehensive task list—and even track your progress on those larger tasks that are already on your plate.


Excel User Interface

Because MS Excel is a spreadsheet. Gridlines are used to demarcate columns and rows in a table-like manner.

Worksheet

The Excel workplace is known as a worksheet. Each worksheet has up to 16 sheets. You can see this at the bottom of the worksheet before the status bar.

Sheet names can be renamed, you can also add or delete sheets.

Columns

Columns are the vertical alignment of cells. They are labeled with alphabets. A, B, C,…

Rows

Rows are the horizontal alignment of cells. They are numbered with Arabic figures. 1, 2, 3, …

Cells

Cells are the intersections between columns and rows. The small rectangles in a worksheet are known as cells.

Cell Address

Each cell in Microsoft Excel has its own address. For instance, the first cell is known as cell A1. This is because it is under column A and in row 1.

Excel Formatting

Formatting document in Microsoft Excel is as basic as doing so with every other computer application package. Let’s look at it.

Typing

To type in Excel, place the cell pointer (ie. the tick rectangular box) where you want your text to appear, and then start typing.

Turn on the Caps lock button to type in capital letters or, hold down the shift key to type special characters.

Fonts

After typing, you can format your text by clicking on the cell that contains the text in order to highlight it. Then apply any of the font formatting actions such as font style, font size, bold, italic, underline, etc.

Color

Another interesting formatting is color. You can apply color to a text or to the background of the cell. All you need to do is to highlight the range of cells to which you will like to apply the color. Then click on your desired color.

Border

When it comes to the cell border, it should be noted that the gridlines are different from the border. As a matter of fact, the gridlines will not show during printing.

To apply a border to your worksheet, highlight the range of cells and choose the border style of your choice.

Excel Operations

Now, let us look at the basics of Excel operations.

Addition

Let us look at this data in this table



A


B

C

D

E

1

YEARS

QUATER 1

QUATER 2

QUATER 3

QUATER 4

TOTAL

2

YR 2022

200

320

150

650


3

YR 2023

350

550

400

900


To add numbers in Excel, there is a variety of ways you can do that. First, you can add up numbers by highlighting a range of cells, then click on the autosum button.

This can also be performed with a formula by placing the cell pointer under total and typing the following formula.

Example 1: =SUM(B2:E3) Then press the enter key from the keyboard.

Example 2: =(B2+C2+D2+E2) press enter.

Both examples 1 and 2 will yield the same result.

Subtraction

To subtract numbers, you will also need to use the cell address to identify the numbers you will like to work on.

Example: =(D2-E2) press enter.

Multiplication

To multiply numbers, use the cell address to identify the numbers.

Example: =(A4*A5) press enter.

Division

The same rule applied to division. Just identify the numbers you would like to divide.

Example: =(A3/B3) press enter.

Average

Excel makes it easy to find the average of two or more numbers. This is also known as MEAN number.

Example: =AVERAGE(B2:E3) press enter.

Excel Applications

Now, let us apply what we have learned with real-life examples.

Daily Sales Book

Now, let us use the formula that we learned in the previous lesson to solve this problem.



A

B

C

D

E

1

NO

ITEMS

QUANTITY

COST

AMOUNT

2

1

Exercise Book

3

650


3

2

Calculator

1

2300


Solution: Place the cell pointer in cell E2 and type =SUM(D2*C2) press enter.

Payment Voucher

To calculate workers' payment, the grade level and/or other parameters will be used to determine the take home.



A

B

C

D

E

1

NO

NAMES

GENDER

G/LEVEL

SALARY

2

1

Peter Smith

Male

6


3

2

Miracle Akanne

Female

5


Solution: 

=IF(D2>=6,”75,000”,IF(D2>=5,”58,000”,IF(D2>=4,”51,000”,IF(D2>=3,”44,000”,”38,000”))))

Result Computation

To perform student result computation, you will need to know if you are computing a single result, or the result for all subject. In this example, we shall work on a single result.


A

B

C

D

E


1

NO

NAMES

ASSESS. 

(30 %)

EXAM 

(70 %)

TOTAL

REMARKS

2

1

Peter Smith

24

61



3

2

Miracle Akanne

27

67



Solution for Total:

=SUM(C2:D2) press enter

Solution for Remarks:

=IF(E2>=40,”PASS”,”FAIL”)

Excel Chart and Graph

In Microsoft Excel, a chart is commonly referred to as a graph. It is a graphical representation of data from a spreadsheet that can provide more insight into the data than simply looking at the numbers.

  1. Select data for the chart.

  2. Select Insert > Recommended Charts.

  3. Select a chart on the Recommended Charts tab, to preview the chart.

  4. Select a chart.

  5. Select OK.

Chart Type

Commonly used chat types are

1. Column Chart

2. Line Chart

3. Bar Chart

4. Area chart

Sample of a pie chart.


Excel Printing

You may print whole or partial worksheets and workbooks individually or in batches. You may also print simply the Excel table if the data you wish to publish it in a Microsoft Excel table.

You may also use a file instead of a printer to print a worksheet. This is important when you need to print the workbook on a different printer from the one you initially used.

Print a partial sheet, an entire sheet, or an entire workbook

  1. Do one of the following:

    • To print a partial sheet, click the sheet, and then select the range of data that you want to print.

    • To print the entire sheet, click the sheet or the sheet tab.

    • To print a workbook, click any of its sheets.

  2. On the File menu, click Print.

  3. On the Printer menu, select the printer that you want.

  4. The default is to print all active sheets. To change what is printed, select Show Details.

In the Print drop-down menu, select the option that corresponds to what you want to print (Selection, Active Sheets, or Entire Workbook) and then select Print.

Akanne

Akanne Academy is an online learning platform that provides educational lecture materials, software tutorials and digital skills training.

Post a Comment

Previous Post Next Post