|
Week - 1
|
|
Excel workspace, interface introduction; Title bar - Tabs - Address bar - Formula Bar - Scroll bars - Gridlines - Status Bar |
|
|
Week - 2
|
|
Workbook operations; Create New Workbook, save, close, open saved workbook, add sheet, name sheet, delete sheet |
|
|
Week - 3
|
|
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 |
|
|
Week - 4
|
|
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 |
|
|
Week - 5
|
|
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 |
|
|
Week - 6
|
|
Formulas in Excel; Formula Input, Calculation Operators, Copying Formulas, Cell and Range Naming, Absolute Reference, Error Checking in Formulas. |
|
|
Week - 7
|
|
Midterm |
|
|
Week - 8
|
|
Functions in Excel; Mathematical Functions: Add, Product, Sum, Max, Min. Statistical functions, Text functions, Date functions, If, Search and Reference functions, Information functions. |
|
|
Week - 9
|
|
Graphic operations; Creating charts, Chart types, Chart options, Chart formatting |
|
|
Week - 10
|
|
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. |
|
|
Week - 11
|
|
Data/Situation Analysis and Data/Target Search studies |
|
|
Week - 12
|
|
Pivot analysis explanation and sample applications in Excel. |
|
|
Week - 13
|
|
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. |
|
|
Week - 14
|
|
Final exams |
|