MICROSOFT EXCEL TUTORIAL - HOW TO NAVIGATE EXCEL

MICROSOFT EXCEL TUTORIAL - HOW TO NAVIGATE EXCEL

1.  Introduction of Microsoft Excel
Uses of Microsoft Excel
 How to start Microsoft Excel
 Introduction of Microsoft Excel Screen
 Practical of Mark sheet
Microsoft Excel

2. What is Microsoft Excel
•The basic environment in Microsoft Excel is a
Workbook file that can contain one or more
worksheets.
•Electronic grid made up of rows and columns where
you can perform numeric calculations and formulas
•It consists of 65,536 rows and 256 columns.

3. Uses
–Mathematical tool which is formatted in columns and rows
to display numerical data
•Accounting
•Data Analysis
•Scientific Formulas
–Can display
•Calculations
•Charts
•Reports

4. File Conventions
•Files in Microsoft Excel are saved as Excel
Workbooks
•These files carry the .XLSX extension

5.  Title bar
 Menu bar
 Standard Toolbar
 Formatting Toolbar
 Formula bar
 Status bar
Introduction of Excel screen

6. Introduction of Excel screen
Title Bar
Menu bar
Standard
Toolbar
Formatting
Toolbar
Formula bar
Status bar

7. The Excel Cell
•Everything in Excel starts from the cell.
–A cell is a placeholder of data, numbers,
formulas
–Most entry is done in an active cell, the one
with a bold black frame around it.
–A cell is shown below:

8. Exercises 1
•Open Microsoft Excel Application
•Save and Rename Microsoft Excel Book 1
– mid term result

9. Make a New Work Sheet

10. Make a New Work Sheet

11. Make a Rename of work sheet

12. Save a Work sheet

13. Save a Work sheet

14. Exercises 2
•Column headers
–Cell A1 enter Result Of BS(IT)-1
–Cell A2 enter Sr.no
–Cell B2 enter Name
–Cell C2 enter Total marks
–Cell D2 enter Obtained Marks
–Cell E2 enter Percentage

15. Exercise 2 - completed

16. Exercise 3
•Merge cells A1 thru E1 into one cell
•Change font color to Blue and BOLD
•Center Header
•Enter the following data:
•Total marks=12
•Obtained marks=

17. Exercise 3 - completed

18. Exercise 4
•Formatting
–Center data in columns
–Formatting Numbers
–Borders
•Simple Functions (formulas)
–Percentage

19. Exercise 4 - completed

20.  To calculate total, Average & Grade
 First To make a New Work Sheet
Mark sheet

21. To make a Mark sheet

22. Visit: tshahab.blogspot.com

23. Visit: tshahab.blogspot.com

24. Sum

25. Total

26. Average

27. Visit: tshahab.blogspot.com

28. Grade

29. Visit: tshahab.blogspot.com

30. Result

31. Visit: tshahab.blogspot.com