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

Comments