Page 96 - Excle-En-V3

Second Day

First session:
Training objectives
1. How to write equations.
2. Functions and formulas
3. The difference between relative reference and absolute reference
4. Range
5. General functions
6. Text functions
7. Mathematical functions
8. Date and time functions
9. Simple and complex IF function
10. Common mistakes

Second session:
Training objectives
11. Calculate the sub-total
12. Arithmetic operations on more than three worksheets
13. Formula Auditing
14. Correlation coefficient
15. Data Analysis: (Data Analysis)
16. Page layout options. (Margins - orientation of the worksheet - printing titles).
17. Printing options
(The number of copies - specifying what should be printed - changing the page
orientation - margins - changing the fit of the paper
To print "a; Sizing "a ;)
18. Print one or many worksheets - Print one or many workbooks
19. Create a database using Excel

88 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024