Office Fundamentals Diploma

7 Weeks



About this course

This program will familiarize the learner with the powerful features of an electronic office.

It is designed for learners with some knowledge of computers who wish to gain further practical skills in the most popular Microsoft Office software packages: Word, Excel, PowerPoint, and Access.

Program Outline

MS Windows 

  • Basic IT concepts
  • What’s new in Windows
  • Windows interface and navigation
  • Using Windows Apps
  • Desktop Applications
  • Files and folders
  • Customizing environments
  • Features, Help and tips

MS Word

  • Microsoft Word interface and navigation
  • Customizing your work-space
  • Editing a document (basic formatting)
  • Formatting text and paragraphs
  • Adding tables
  • Managing lists
  • Inserting objects, images and symbols
  • Proofing and printing documents

MS Excel

  • Microsoft Excel interface and navigation
  • Performing calculations
  • Modifying a Worksheet and Workbook
  • Formatting a Worksheet
  • Printing Workbooks
  • Managing Workbooks
  • Write formulas
  • Edit data, move and copy text and formulas
  • Creating charts and working with formulas as well as filtering and sorting data

MS PowerPoint

  • Microsoft PowerPoint interface & navigation
  • Developing a PowerPoint presentation
  • Advanced text editing and animation
  • Graphic elements & objects, tables and Charts

MS Access

  • Key concepts and Terminology
  • Designing a database and documentation
  • Working with existing databases (navigating, adding and editing data)
  • Creating a flat-file & relational database
  • Working with and creating Tables
  • Creating basic forms and subforms
  • Creating and editing Queries (including calculated queries)
  • Creating and editing Reports
  • Creating mailing labels