Excel 2007 Advanced

What does this course offer you?

In this elearning course you will learn to professionally utilize advanced techniques in Excel 2007. You will learn how to manage large workbooks and how to reference values in other worksheets for calculations. After you have been introduced to the layout and print functions for spreadsheets, you will learn how to visualize the contents of your spreadsheet by means of professional charts. You will also be introduced to a number of valuable layout functions especially helpful with large spreadsheets.


What does this course include?

In addition to the instructional content, practice exercises and test questions are also included.

65
NUMBER OF LESSONS
7
LEARNING HOURS
 


Course Topics

  • Working with Workbooks
  • Selecting Several Worksheets (Group Mode)
  • Inserting and Deleting Worksheets
  • Moving and Copying Worksheets
  • Specifying how Worksheets are Displayed
  • Using Cell References to other Worksheets
  • Editing Links
  • Protecting Workbooks
  • Protecting Worksheets, Cells and Objects
  • Adjusting the Quick Access Toolbar

  • The SAVE AS and OPEN dialog box
  • Define Save Options for Workbooks
  • Defining Document Properties
  • Using the Recovery Feature
  • Importing and Exporting Data

  • Creating and Applying Styles
  • Editing Styles
  • Copying Styles from other Workbooks
  • Creating a Sample Template
  • Creating a New Workbook With a Sample Template

  • Creating Charts
  • Selecting From Various Chart Types
  • Basics of Chart Editing
  • Changing the Display or Structure of Charts
  • Editing Chart Elements
  • Printing Charts

  • Inserting Pictures
  • Editing Pictures
  • Object Basics
  • Creating Simple Objects
  • Creating Special Objects
  • Editing Objects

  • Tips for Creating Tables
  • Quickly Navigating to Certain Cells
  • Zooming in Tables
  • Dividing Table Windows into Sections
  • Freezing Rows and Columns
  • Sorting Tables
  • Using AutoCorrect
  • Using the Spelling Checker
  • Finding and Replacing Specific Cell Contents
  • Automatic and Manual Recalculation

  • Conditional Formatting
  • Formatting Cells Depending on Formula Results
  • Creating and Applying Custom Cell Formats
  • Using a Validation Formula For Data Entry
  • Checking Data for Validity
  • Allowing Data Entry From a List
  • Adding Comments to Tables
  • Using Hyperlinks

  • Inserting PivotTables
  • Assigning Pivot Fields
  • Defining the Layout for PivotTables
  • Filtering PivotTables
  • Updating PivotTables
  • Sorting PivotTables
  • Creating a Drill Down
  • Pivot Charts

Technical Specifications

Windows

  • Windows XP / Vista / 7 / 8
  • Internet Explorer 7 / 8 / 9* / 10* /11*
  • Firefox 10 or higher
  • “Script ActiveX controls marked safe for scripting” must be enabled

* In Internet Explorer 8 and higher, the Internet Explorer 7 "Compatibility Mode" is used to guarantee the optimal display of course content.


Interested in Pricing?

To receive pricing information for our MS Office and Windows E-Learning courses, please send us a Quotation Request and we will be touch with you shortly.

Receive a Quote ›

About Us

EXPAND Global provides learning technologies and content for the next generation workplace. We are experts in innovative learning tools, eLearning content development, off-the-shelf eLearning for Microsoft Office, microlearning, mobile learning, gamification and performance support.

 

GET IN TOUCH