Excel 2007 Introduction

Name: Excel 2007 Introduction
Rating: 4.6 (35 reviews)

All you need to know to unleash the power of Excel spreadsheets

Created byIntellezy Trainers

Last updated 10/2016

English

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

Course content

9 sections • 57 lectures • 3h 2m total length

Introduction1: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.

Understanding the Three Primary Functions of Excel1:44
Understanding Spreadsheet Terminology3:23
Launching Excel1:20
Exploring the Excel Interface3:57
Opening a Workbook1:42
Open a workbook in Excel 2007 by using the Office button to access the open command, navigate drives and folders, and select a file such as sales by districts to open.
Examining Formulas1:08
Understanding Worksheets1:35
Using Zoom1:27
Changing Views1:40
Navigating Spreadsheets4:19

Creating a New Workbook2:17
Learn to create and manage a new workbook in Excel 2007, enter data, navigate and rename multiple worksheets, use autofill, delete ranges, undo or redo actions, and save the workbook.
Entering Data5:26
Selecting Parts of a Workbook1:21
Using Multiple Worksheets2:20
Using AutoFill9:26
Learn how autofill in Excel 2007 uses the fill handle to extend sequences like months, days, and dates, copy text with increments, and choose custom fill options.
Deleting Ranges3:53
Using Undo/Redo1:25
Deleting a Worksheet0:58
Saving a Workbook4:36
Use the office button to save or save as; for the first save, choose save as to name and locate the file, then save updates the current workbook.

Understanding Order of Operations2:21
Entering Simple Formulas2:22
Using SUM, MAX, and MIN8:38
Master using Excel functions such as sum, max, and min by entering formulas with equals and parentheses, selecting ranges with the mouse, and exploring the insert function dialog.
Using AutoSum3:10
Using AVERAGE3:07
Explore using the auto sum button to total data fast in Excel 2007, then compute the quarter's average with the average function by selecting the range B3 through B6.
Creating a Formula3:53
Working with Date Arithmetic2:45
Using AutoCalculate2:11
Relative vs. Absolute Cell Adressing4:45

Adjusting Column Width and Row Height5:56
Inserting and Deleting Rows and Columns2:15
Insert and delete rows and columns in Excel 2007 by selecting the target rows or columns, using the insert or delete commands, or right-clicking for quick shortcuts.
Hiding Rows and Columns1:58
Changing Number Formatting4:03
Changing Character Formatting3:03
Aligning Data5:58
Master horizontal and vertical alignment in Excel 2007, using merge and center to span across selected cells, adjust row height, and enable wrap text for long notes.
Adding Borders and Shading6:00
Discover how to apply borders and shading in Excel 2007, customizing border styles, thickness, and color, applying interior shading, and using quick table formats to enhance data presentation.
Using Format Painter5:31
Using Cell Styles3:19
Apply cell styles in Excel 2007 to quickly create consistent formatting with heading levels (heading 1, 2, 4), shading, and subtotals, enhancing readability.
Using Themes1:36
Apply themes across Excel and other Office 2007 apps to keep your spreadsheet in sync with Word and PowerPoint, changing the whole look on the fly.

Using Spell Check3:54
Inserting Page Breaks2:37
Using Page Break Preview1:40
Using Print Preview2:22
Changing the Orientation and Margins2:45
Switch from portrait to landscape orientation and adjust margins in page setup to fit wider spreadsheets, preview with print preview, and set print titles for first page in excel 2007.
Working With Print Areas2:18
Setting Print Titles1:58
Adding Headers and Footers2:55
Printing Gridlines and Comments0:58
Using the Print Dialog Box1:28
Use the Excel print dialog box to print the current sheet by default, with options to ignore the print area or print the entire workbook.

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.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.

Like most of our courses, closed caption subtitles are available for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.

This course aligns with the CAP Body of Knowledge and should be approved for 3 recertification points 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

Excel 2007 Introduction

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Getting Started10 lectures • 22min

Basic Worksheet Skills9 lectures • 32min

Creating Formulas9 lectures • 33min

Formatting the Worksheet10 lectures • 40min

Working with Large Worksheets5 lectures • 16min

Using Protection and Comment Boxes2 lectures • 13min

Using Page Setup and Printing10 lectures • 23min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: