SPREADSHEETS

Content

Weeks	Topics
1. Weeks	Excel workspace, interface introduction; Title bar - Tabs - Address bar - Formula Bar - Scroll bars - Gridlines - Status Bar
2. Weeks	Workbook operations; Create New Workbook, save, close, open saved workbook, add sheet, name sheet, delete sheet
3. Weeks	Data operations in Excel; Changing data, different selection techniques, Data and Cell Deletion, Row and Column Operations; Add Row and Column, Delete Row and Column, Hide Row and Column, Move and Copy, Paste Special, AutoFill, AutoFill, Month, Day and Date Fill, Custom Lists, Annotate, Find/Replace/Go to
4. Weeks	Formatting operations in Excel; Format Cells, Quick Format, Format Painter, Font Format, Align, Format Numbers, Border Format, Cell Styles, Table AutoFormat, Conditional Formatting, Conditional Format Using First/Last Rules, Conditional Formatting Using Data Bars, Conditional Formatting Using Color Scales , Conditional Formatting Using Symbol Sets, Clearing Conditional Format, Defining New Rule, Managing Rules
5. Weeks	Page settings and printing; Print Preview. themes, Header and Footer, Page Orientation, Adjusting Margins, Specifying Print Area, Printing Headers, Fitting Data to Page, Window Settings, Splitting and Freezing Windows, Docking and Hiding Windows, Print Settings
6. Weeks	Formulas in Excel; Formula Input, Calculation Operators, Copying Formulas, Cell and Range Naming, Absolute Reference, Error Checking in Formulas.
7. Weeks	Midterm
8. Weeks	Functions in Excel; Mathematical Functions: Add, Product, Sum, Max, Min. Statistical functions, Text functions, Date functions, If, Search and Reference functions, Information functions.
9. Weeks	Graphic operations; Creating charts, Chart types, Chart options, Chart formatting
10. Weeks	Data analysis in Excel; Sort, Sort by Multiple Fields, Filter, Subtotal, Validate data, Pivot table, Group the Pivot table, Create a pivot table by more than 3 fields, create a pivot chart, Group data, Convert text to columns, Import external data, Scenarios, Target search.
11. Weeks	Data/Situation Analysis and Data/Target Search studies
12. Weeks	Pivot analysis explanation and sample applications in Excel.
13. Weeks	Customize window and menu layout in Excel; Customizing Quick Access Toolbar, Sending Files by E-Mail, Receiving addresses created in Excel for mail merge in Word.
14. Weeks	Final exams