Spreadsheets

Subtopics

• Introduction to spreadsheets
• Creating workbooks in Microsoft Excel (2010)
• Using basic formula and functions
• Editing and formatting worksheets
• Worksheet data management
• Generating Charts
• Printing Workbooks
• Excel Practical Questions

SPREADSHEETS (18 LESSONS)

• Definition of a Spreadsheet
• Components of a spreadsheet

i) worksheet

ii) database

iii) graphs

• Application areas of a spreadsheet
• Statistical analysis
• Accounting
• Data management
• Forecasting (what if analysis)
• Scientific application
• Creating a worksheet/workbook
• Getting started
• Worksheet layout
• Running the program
• Creating a worksheet
• editing a cell entity
• saving
• retrieving
• closing a worksheet exiting from spreadsheet
• Cell Data Types
• Labels
• Values
• Formulae
• Functions
• Cell referencing
• Cell addressing
• Absolute referencing
• Relative referencing
• Basic functions and Formulae
• Functions

i) statistical (average, count, max, mm)

ii) logical (If, count-if, sum-it)

iii) mathematical (Sum, Product, Div)

• Arithmetic formulae (using operators +, -, /,*, brackets)
• Worksheet formatting
• Text
• Numbers
• Rows and columns
• Global
• Data Management
• Sorting
• Filtering
• Total/subtotals function
• Forms
• Charts/graphs
• Types
• Data ranges
• Labels
• Headings and titles
• Legends
• Printing