Excel 2007 Introduction

All you need to know to unleash the power of Excel spreadsheets
4.7 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
186 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 57
  • Length 3 hours
  • Skill Level Beginner Level
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English Closed captions available

Course Description

 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.

What are the requirements?

  • Basic Microsoft Windows training or equivalent experience

What am I going to get from this course?

  • Understand the concepts of worksheet development and formula creation
  • Enter, edit and select data
  • Enter and edit formulas and functions
  • Understand relative v. absolute cell addressing
  • Format worksheet structure and cell contents
  • Manage large worksheets with zoom, freeze pane, and tiling and splitting windows
  • Add protection and comment boxes
  • Use print preview and page setup to prepare a workbook for printing

What is the target audience?

  • Students who need to create, modify and print basic spreadsheets including formulas and functions

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
01:09

If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.  

Section 2: Getting Started
Understanding the Three Primary Functions of Excel
Preview
01:44
Understanding Spreadsheet Terminology
Preview
03:23
Launching Excel
Preview
01:20
Exploring the Excel Interface
Preview
03:57
Opening a Workbook
Preview
01:42
Examining Formulas
Preview
01:08
Understanding Worksheets
01:35
Using Zoom
01:27
Changing Views
01:40
Navigating Spreadsheets
04:19
Section 3: Basic Worksheet Skills
Creating a New Workbook
Preview
02:17
Entering Data
Preview
05:26
Selecting Parts of a Workbook
01:21
Using Multiple Worksheets
02:20
Using AutoFill
09:26
Deleting Ranges
03:53
Using Undo/Redo
01:25
Deleting a Worksheet
00:58
Saving a Workbook
04:36
Section 4: Creating Formulas
Understanding Order of Operations
02:21
Entering Simple Formulas
02:22
Using SUM, MAX, and MIN
08:38
Using AutoSum
03:10
Using AVERAGE
03:07
Creating a Formula
03:53
Working with Date Arithmetic
02:45
Using AutoCalculate
02:11
Relative vs. Absolute Cell Adressing
04:45
Section 5: Formatting the Worksheet
Adjusting Column Width and Row Height
Preview
05:56
Inserting and Deleting Rows and Columns
02:15
Hiding Rows and Columns
01:58
Changing Number Formatting
04:03
Changing Character Formatting
03:03
Aligning Data
05:58
Adding Borders and Shading
06:00
Using Format Painter
05:31
Using Cell Styles
03:19
Using Themes
01:36
Section 6: Working with Large Worksheets
Using Zoom
Preview
02:16
Freezing and Unfreezing Panes
03:41
Splitting a Window
03:13
Tiling Multiple Workbooks
03:56
Using Synchronous Scrolling
03:21
Section 7: Using Protection and Comment Boxes
Adding and Deleting Comments
04:53
Locking and Unlocking Cell Ranges
08:33
Section 8: Using Page Setup and Printing
Using Spell Check
03:54
Inserting Page Breaks
02:37
Using Page Break Preview
01:40
Using Print Preview
02:22
Changing the Orientation and Margins
02:45
Working With Print Areas
02:18
Setting Print Titles
01:58
Adding Headers and Footers
02:55
Printing Gridlines and Comments
00:58
Using the Print Dialog Box
01:28
Section 9: Conclusion
Conclusion
01:18

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Ready to start learning?
Take This Course