Advanced Office Applications specialized on Excel and Access

Course Overview/Objective
  • To Perform calculations using mathematical formulas in spreadsheets, perform data analysis, prepare a database system and Easily calculate salary/grade using  Spreadsheet
  • To create a database to store scientific or real-world data.
  • To Use computer tools to create scientific documents using equation editor, represent experimental data in tables, draw figures, and integrate charts and graphs.
  • To develop technical and scientific presentations, and embed charts, graphs, and equations using presentation tools
Requirements

HSC/Equivalent

Course Project
N/A
Used Tools
MS Office 2007
Course Outline

Introduction to Computer

  • Introduction to computer
  • Classification of different types of computer
  • Application of different types of computer
  • Basic components of  a computer
  • Basic Operation of Operating System

Basic use of computer

  • Turn on the pc
  • Identifying File-Folder-Drive
  • Open a new file
  • Search for an existing file
  • Find location of  a file
  • Change location of files
  • Change file installing  a new hardware
  • Antivirus and Computer Security

The Basics (Excel)

  • Creating a New Workbook
  • Navigating in Excel
  • Moving the Cell Pointer
  • Using Excel Menus
  • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
  • Entering Values in a Worksheet and Selecting a Cell Range
  • Previewing and Printing a Worksheet
  • Getting Help from the Office Assistant
  • Saving a Workbook & Re-opening a saved workbook

Formatting a Worksheet

  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page
  • Formatting Fonts & Values
  • Adjusting Row Height and Column Width
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit
  • Using AutoFill

Managing your workbooks

  • Switching Between Sheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming and Moving Worksheets
  • Protecting a Workbook
  • Hiding Columns, Rows and Sheets
  • Splitting and Freezing a Window
  • Inserting Page Breaks
  • Advanced Printing Options

Editing a Workbook

  • Entering Date Values and using AutoComplete
  • Editing, Clearing, and Replacing Cell Contents
  • Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells with Drag and Drop
  • Collecting and Pasting Multiple Items
  • Using the Paste Special Command
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo, Redo, and Repeat
  • Checking Your Spelling
  • Finding and Replacing Information
  • Inserting Cell Comments

Formulas

  • Creating a basic Formula
  • Calculating Value Totals with AutoSum
  • Editing & Copying Formulas
  • Fixing Errors in Your Formulas
  • Formulas with Several Operators and Cell Ranges

Working with the Forms Menu

  • Sorting, Subtotaling & Filtering Data
  • Copy & Paste Filtered Records
  • Using Data Validation

Creating & Working with Charts

  • Creating a Chart
  • Moving and Resizing a Chart
  • Formatting and Editing Objects in a Chart
  • Changing a Chart's Source Data
  • Changing a Chart Type and Working with Pie Charts
  • Adding Titles, Gridlines, and a Data Table
  • Formatting a Data Series and Chart Axis
  • Annotating a Chart
  • Working with 3-D Charts
  • Selecting and Saving a Custom Chart
  • Using Fill Effects
  • Mapping Data
  • Modifying a Map

Data Analysis & Pivot Tables

  • Creating a PivotTable
  • Specifying the Data a PivotTable Analyzes
  • Changing a PivotTable's Calculation
  • Selecting What Appears in a PivotTable
  • Grouping Dates in a PivotTable
  • Updating a PivotTable
  • Formatting and Charting a PivotTable

Working with Other Programs

  • Inserting an Excel Worksheet into a Word Document
  • Modifying an Inserted Excel Worksheet
  • Inserting a Linked Excel Chart in a Word Document
  • Inserting a Graphic into a Worksheet

Microsoft Access Course Outline

  • Access Basics
  • Design a Database
  • Build a Database
  • Work with Forms
  • Sort, Retrieve, Analyze Data
  • Work With Reports
  • Access with Other Applications
  • Manage an Access Database