Excel Lecture 2

1. How to name a Sheet, delete a sheet
2. Insert a Row & Delete a Row
3. Change the color of font
4. Using Example1; how to Copy & Paste
5. Discuss about Functions
6. Using Example1; how to use some functions such as sum, average etc.
7. Sum, Average, Max, Min form the Horizontal bar
8. Using Example2; What is function and what is formula
9. Using Example2; how to do absolute cell referencing
10. Using Example3; how to sort numbers and text
11. Using Example4; how to do multiple columns sorting DataàSorting
12. Using Example5; how to do if Statement
1. Example: =if(cell>89, “A”, if(cell>79, “B”))
13. Using Example5; Conditional Formatting; FormatàConditional Formatting
14. Different functions such as Date, PMT etc.
15. Using Example6; how to use PMT functions
16. Ask for functions in Excel
17. How to use some more functions
18. Using Example7; how to add dates by using Date function
1. Example: =DATE(YEAR(A1),MONTH(A1)+6, DAY(A1)+10)
2. =DATE(YEAR(A1),MONTH(A1)-6, DAY(A1)-10)
19. Using Example6; how to display formula ToolsàOptionàFormulas