BASIC TRAINING OFMicrosoft-Excel-101.pptx

BASIC TRAINING OF MICROEXCEL

1. Microsoft Excel 101 Basic Microsoft Excel Training in   Alternative Learning School

2. Objectives At the end of the session, the learners will be able to:  Students will be able to perform basic arithmetic functions (SUM, AVERAGE, MIN, MAX), format tables, name ranges, sort and filter data, ensure data validation, and create and customize charts and graphs using spreadsheet software.

3. Course content Session 2 Basic Arithmetic Functions (SUM, AVERAGE, MIN, MAX) Formatting Tables/Name Ranges Sorting and Filtering Data Data Validation Creating and Customizing Charts and Graphs

4. BASIC ARITHMETIC FUNCTION (ADDITION, SUBTRACTION, MULTIPLICATION, DEVISION, SUM, AVERAGE, MIN, MAX)

5. KEY IDEAS Addition (+): Used to add numbers. For example, if you want to add the values in cell A1 and B1, you'd type =C3+C4 Subtraction (-): Used to subtract numbers. For example, = D10-D11. Multiplication (*): Used to multiply numbers. For example, =A1*B1 . Division (/): Used to divide numbers. For example, =A1/B1 . SUM(): Used to add a range of numbers. For example, =SUM(A1:A10) adds all the numbers from A1 to A10. AVERAGE(): Used to find the average of a range of numbers. For example, =AVERAGE(A1:A10) . MIN(): Used to find the smallest number in a range. For example, =MIN(A1:A10) . MAX(): Used to find the largest number in a range. For example, =MAX(A1:A10) .

6. Session 3 Working with tables (creating and formatting) Sorting and filtering data Return demonstration of the learned skills in using Microsoft Excel Creation of basic tables and charts for data presentation: Budget tracking Record keeping Course content