Excel 2007 Introduction
4.7 (14 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.
201 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2007 Introduction to your Wishlist.

Add to Wishlist

Excel 2007 Introduction

All you need to know to unleash the power of Excel spreadsheets
4.7 (14 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.
201 students enrolled
Last updated 10/2016
English
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
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.

Who is the target audience?
  • Students who need to create, modify and print basic spreadsheets including formulas and functions
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 57 Lectures Collapse 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
+
Getting Started
10 Lectures 22:15
+
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
+
Conclusion
1 Lecture 01:18
Conclusion
01:18
About the Instructor
Intellezy Trainers
4.4 Average rating
2,746 Reviews
19,241 Students
133 Courses
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.