In Advanced Spreadsheet subject you can learn how to create, format, analyze data information and applying formula and function in spreadsheet or worksheet using spreadsheet software.
Advanced Spreadsheet Topic:
(Prelim Period)
- Building Database and Creating a data form
- Sorting Data and Freeze or lock rows and columns
- Autoformat and Filtering Database
- Consolidating Data
(Midterm Period)
- Inserting, Moving, Resizing and Deleting Objects and Apply, Create or Remove a cell style
- Insert a Pivot Table and Pivot Chart
- Hands On
- Recitation
(Final Period)
- Using HLOOKUP
- Activity No. 1 (HLOOKUP)
- Using VLOOKUP
- Activity No. 2 (VLOOKUP)
Walang komento:
Mag-post ng isang Komento