Microsoft Excel

محاور الدورة التدريبية:
1-Introduction
2-Fundamental Terminology
3-Formatting
- Tables (insert or borders)
- Editing data in cells
-Color (Fill color or text)
-Font size and type
-Freeze panes
4- Sorting and Filtering Data
5- Create Charts and Plots
6- Building Mathematical Formulas
7- Autofill Capabilities
8-Relative and Absolute Cell References
9-Internal Mathematical Function Library 10- Spreadsheet Logic Function
11- Excel Shortcuts
12- Numerical Analysis
i- Matrix Functions
ii- Curve Fitting
1.Linear
2.Exponential
3.Logarithmic
4.Polynomial
5-Power
iii- Correlation Coefficients R2
iv- 45 deg. Line
Solver in Excel-13