Changes

Jump to navigation Jump to search
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

Navigation menu