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
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.
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.
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.
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.
Select data for the chart.
Select Insert > Recommended Charts.
Select a chart on the Recommended Charts tab, to preview the chart.
Select a chart.
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
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.
On the File menu, click Print.
On the Printer menu, select the printer that you want.
The default is to print all active sheets. To change what is printed, select Show Details.