Excel 2007 - Beginner

Duration
3 Hours, 0 Minutes

 

Delivery Method
Self-Paced

Educate 360 Pro from New Horizons

This class is part of a 12‑month Educate 360 Pro Subscription

Course Overview

This class teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Next, you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. Additionally, you will move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, managing large worksheets, and printing.

Course Objectives

Getting Started, Basic Worksheet Skills, Creating Formulas, Formatting the Worksheet, Working with Large Worksheets, Using Protection and Comment Boxes, Using Page Setup and Printing Options

Course Prerequisites

There are no prerequisites for this course.

Agenda

1 - Introduction

  • Introduction

2 - Getting Started

  • Understanding the Three Primary Functions of Excel
  • Understanding Spreadsheet Terminology
  • Launching Excel
  • Exploring the Excel Interface
  • Opening a Workbook
  • Examining Formulas
  • Understanding Worksheets
  • Using Zoom
  • Changing Views
  • Navigating Spreadsheets

3 - Basic Worksheet Skills

  • Creating a New Workbook
  • Entering Data
  • Selecting Parts of a Workbook
  • Using Multiple Worksheets
  • Using AutoFill
  • Deleting Ranges
  • Using Undo and Redo
  • Deleting a Worksheet
  • Saving a Workbook

4 - Creating Formulas

  • Understanding the Order of Operations
  • Entering Simple Formulas
  • Using SUM, MAX, and MIN
  • Using AutoSum
  • Using AVERAGE
  • Creating a Formula
  • Working with Date Arithmetic
  • Using AutoCalculate
  • Relative vs. Absolute Cell Addressing

5 - Formatting the Worksheet

  • Adjusting Column Width and Row Height
  • Inserting and Deleting Rows and Columns
  • Hiding Rows and Columns
  • Changing Number Formatting
  • Changing Character Formatting
  • Aligning Data
  • Adding Borders and Shading
  • Using Format Painter
  • Using Cell Styles
  • Using Themes

6 - Working with Large Worksheets

  • Using Zoom
  • Freezing and Unfreezing Panes
  • Splitting a Window
  • Tiling Multiple Workbooks
  • Using Synchronous Scrolling

7 - Using Protection and Comment Boxes

  • Adding and Deleting Comments
  • Locking and Unlocking Cell Ranges

8 - Using Page Setup and Printing Options

  • Using Spell Check
  • Inserting Page Breaks
  • Using Page Break Preview
  • Using Print Preview
  • Changing the Orientation and Margin
  • Working with Print Areas
  • Setting Print Titles
  • Adding Headers and Footers
  • Printing Gridlines and Comments
  • Using the Print Dialog Box

9 - Conclusion

  • Course Recap

What is Educate 360 Pro?

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of an Educate 360 Pro Subscription

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.