Excel 2007 Introduction
4.4 (31 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
262 students enrolled

Excel 2007 Introduction

All you need to know to unleash the power of Excel spreadsheets
4.4 (31 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
262 students enrolled
Last updated 10/2016
English
English
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • Basic Microsoft Windows training or equivalent experience
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.




This IAAP-certified counts for 3 recertification points for the CAP certification under the Technology and Information Distribution content area.

Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Who this course is for:
  • Students who need to create, modify and print basic spreadsheets including formulas and functions
Course content
Expand all 57 lectures 03:02:03
+ Introduction
1 lecture 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.  

Preview 01:09
+ Basic Worksheet Skills
9 lectures 31:42
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
+ Creating Formulas
9 lectures 33:12
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
+ Formatting the Worksheet
10 lectures 39:39
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
+ Working with Large Worksheets
5 lectures 16:27
Freezing and Unfreezing Panes
03:41
Splitting a Window
03:13
Tiling Multiple Workbooks
03:56
Using Synchronous Scrolling
03:21
+ Using Protection and Comment Boxes
2 lectures 13:26
Adding and Deleting Comments
04:53
Locking and Unlocking Cell Ranges
08:33
+ Using Page Setup and Printing
10 lectures 22:55
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