Line 28: |
Line 28: |
| |10.00 – 10.30 | | |10.00 – 10.30 |
| |1. Introduction to the workshop | | |1. Introduction to the workshop |
− | 2. Go through detailed Agenda | + | 2. Go through detailed Agenda |
| + | |
| 3. Participants expectation | | 3. Participants expectation |
| |Workshop page | | |Workshop page |
Line 43: |
Line 44: |
| |1. Introduction to spread sheet, navigating and interfaces | | |1. Introduction to spread sheet, navigating and interfaces |
| 2. Entering your data in spreadsheet and save | | 2. Entering your data in spreadsheet and save |
| + | |
| 3. Providing headings to the date | | 3. Providing headings to the date |
| + | |
| 4. Formatting rows, columns, cells, and data | | 4. Formatting rows, columns, cells, and data |
| + | |
| 5. Adjusting rows and columns | | 5. Adjusting rows and columns |
| + | |
| 6. Working with alignment and text wrap | | 6. Working with alignment and text wrap |
| | | | | |
Line 54: |
Line 59: |
| |1. Finding and replacing data, Freeze Panes | | |1. Finding and replacing data, Freeze Panes |
| 2. Use some basic short cut keys to make your work fast | | 2. Use some basic short cut keys to make your work fast |
− | 3. Sorting, filtering your entered data | + | |
− | 4. Formatting Numbers like date, currency | + | 3. Sorting, filtering your entered data |
− | 5. Inserting, naming and deleting sheets | + | |
| + | 4. Formatting Numbers like date, currency |
| + | |
| + | 5. Inserting, naming and deleting sheets |
| + | |
| 6. Printing and sharing worksheets - with headers and footers | | 6. Printing and sharing worksheets - with headers and footers |
| | | | | |
Line 70: |
Line 79: |
| |2.00 – 3.00 | | |2.00 – 3.00 |
| |1. Using basic operations – sum, substraction, division | | |1. Using basic operations – sum, substraction, division |
− | 2. Searching for formulas from the formula sections | + | 2. Searching for formulas from the formula sections |
− | 3. Password-protecting worksheets and workbooks | + | |
| + | 3. Password-protecting worksheets and workbooks |
| + | |
| 4. Working with worksheets – move, copy, hiding worksheets | | 4. Working with worksheets – move, copy, hiding worksheets |
| | | | | |
Line 79: |
Line 90: |
| |3.00 – 4.00 | | |3.00 – 4.00 |
| |1. Different types of charts | | |1. Different types of charts |
− | 2. Use your data to create charts | + | 2. Use your data to create charts |
− | 3. Use update Chart to customise your charts, labels | + | |
| + | 3. Use update Chart to customise your charts, labels |
| + | |
| 4. Creating PivotTables | | 4. Creating PivotTables |
| 6. Modifying PivotTable Data | | 6. Modifying PivotTable Data |