Overview

Introduction to Microsoft Excel woman analyzing spreadsheets
PDT-ComDP-20

Introduction to Microsoft Excel (Level 1)

This workshop provides hands-on instruction to understand and utilize the basic concepts and skills needed to be productive when using Microsoft Excel.

Topic covered will include:

  • Fundamentals: Getting around and workbook basics
  • Creating Worksheets: Entering data, formulas, functions, moving and copying data, and reference types
  • Formatting: Text and number formatting, alignment, borders, highlighting, and styles and themes
  • Manipulating Data: Data entry shortcuts, paste options, inserting, deleting, and hiding
  • Output: Manipulating worksheet windows, print layouts and printing options
  • Templates: Downloading and using templates

Prerequisites: Students should be comfortable using a computer keyboard and mouse, but typing speed is not required.

This class is hands-on. Students must bring a laptop (and mouse) with an installed, licensed copy of MS Office in a version no older than 2013 with them to class.  Please ensure that Microsoft Excel is working properly and that your laptop has downloaded and incorporated the latest Windows updates prior to class.  All students will receive sample files which will be emailed within a week prior to class. Please download those practice files to your laptop prior attending, if at all possible. During class, the accompanying home handouts will be distributed for continued practice.

The course will be presented in MS Office 365 on a Windows platform.  Those using a Mac will notice a few differences with course material presented in Windows.

Important Notice: Check the drop down menu in the enrollment section for additional dates.

What You Will Learn

PDT-ComDP-20

Introduction to Microsoft Excel (Level 1)

Workshop topics include:

Fundamentals

  • Getting around
  • Workbook basics

Creating Worksheets

  • Entering data
  • Formulas
  • Functions
  • Moving and copying data
  • Reference types

Formatting

  • Text formatting
  • Number formatting
  • Alignment
  • Boarders and highlighting
  • Styles and themes

Manipulating Data

  • Data entry shortcuts
  • Paste options
  • Inserting, deleting, and hiding

Output

  • Manipulating worksheet windows
  • Printing worksheets
  • Sharing workbooks

Settings and Templates

  • Workbook options and properties
  • Templates

Tools & Materials

PDT-ComDP-20

Introduction to Microsoft Excel (Level 1)

This class is hands-on. Students must bring a laptop (and mouse) with MS Office in a version no older than 2013 with them to class.Please ensure that Microsoft Excel is working properly and that your laptop has downloaded and incorporated the latest Windows updates prior to class.

All students will receive a Microsoft Excel workbook to use during class, and to take home with them for continued practice.

Instructor Bios

PDT-ComDP-20

Introduction to Microsoft Excel (Level 1)

  • Nancy Little

    Nancy has been working as a Microsoft Certified Trainer since 2002.  She has extensive experience in classroom, corporate, custom, and individual trainings with Excel, Word, Access, PowerPoint, and Windows.  Nancy's students describe her as professional, patient, and knowledgeable.

09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
UNHOCE Discount
0.6
PDT-ComDP-20
224269
09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
UNHOCE Discount
0.6
PDT-ComDP-20
224278
09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
UNHOCE Discount
0.6
PDT-ComDP-20
224281
09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
UNHOCE Discount
0.6
PDT-ComDP-20
224284