Introduction to Microsoft Excel

BEGINNER BEGINNER
GROUP 4-10 participants [preregistration open]
12 Hours
What you will learn

Create basic worksheets using Microsoft Excel 2016.
Perform calculations in an Excel worksheet.
Modify an Excel worksheet.
Modify the appearance of data within a worksheet.
Manage Excel workbooks.
Print the content of an Excel worksheet.
Learn how to use handy features new in 2016.

Course Description

In this course we teach people how to use Excel spreadsheet to organize information into nice, neat rows and columns, then format, sort, analyze and do math right on the sheets. Useful for financial records, address books, to do lists, too many things to mention.

Module 1: Essential Skills

  • Intro to Windows 10
  • Excel user interface
  • Printing
  • Organizing files
  • Saving your documents
  • Screen resolution
  • Backstage view
  • Organizing files
  • Windows Help

Module 2: Creating a Worksheet and Chart

  • Entering text and sum
  • Formatting a cell and worksheet
  • Add a chart
  • Auto calculate area
  • Correcting errors

Module 3: Formulas, Functions, and Formatting

  • Titles & fill
  • Entering formulas
  • Formatting the Worksheet
  • Checking spelling
  • Printing the worksheet