This is a basic Microsoft Excel course. The learner, at the end of the course, will be able to enter data and present it different ways such as in graphs. It includes a special session on how to present data effectively.


It is wholly practical based and interactive. Participants will also learn how to present their data in interesting way, looking for trends and stories to pick up on and emphasize through graphs.

About the instructor

SOHOX INSTRUCTORS

SOHO Foundation

SOHOX provides pre-service and in-service teacher training for a group of SOHOX Instructors that can be assigned to their respective courses based on experience and expertise.

Course Curriculum

  • 1

    Parts of a Spreadsheet

    • Introduction and Definitions

    • Parts of the Excel Environment

    • About the Ribbon

    • Navigating Excel

    • Worksheet Navigation Keys Reference Chart
  • 2

    What is an Excel Spreadsheet?

    • What are Spreadsheets?

    • Entering Data in a Cell

    • Searching for Data

    • Data Entry

    • Moving the Active Cell in a Worksheet

    • Formulas and Functions

    • Functions

    • Practice Functions

    • Quick Reminder

    • Previewing and Printing a Worksheet

    • Tips and Tricks for Excel Users
  • 3

    Making Data Meaningful

    • Every Data Tells a Story

    • Manipulating Data

    • What's the Story?

    • Converting numbers into text.

    • Working with Formulas
  • 4

    Plotting Graphs: Another Way to Tell Stories

    • Entering the Graph Data

    • Labeling the Graph