Microsoft Office Excel 2007: Level 1 (Second Edition)
Course Content

Lesson 1: Creating a Basic Worksheet
Topic 1A: Explore the User Interface and the Ribbon
Topic 1B: Navigate and Select in Excel
Topic 1C: Obtain Help
Topic 1D: Enter Data and Save a Workbook

Topic 1E: Customize the Quick Access Toolbar

Lesson 2: Performing Calculations
Topic 2A: Create Basic Formulas
Topic 2B: Calculate with Functions
Topic 2C: Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic 3A: Manipulate Data

Topic 3B: Insert and Delete Cells, Columns, and Rows
Topic 3C: Search for Data in a Worksheet
Topic 3D: Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
Topic 4A: Modify Fonts
Topic 4B: Add Borders and Color to Cells
Topic 4C: Change Column Width and Row Height
Topic 4D: Apply Number Formats
Topic 4E: Position Cell Contents
Topic 4F: Apply Cell Styles

Lesson 5: Printing Workbook Contents
Topic 5A: Print Workbook Contents Using Default Print Options
Topic 5B: Set Print Options
Topic 5C: Set Page Breaks

Lesson 6: Managing Large Workbooks
Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets in a Workbook
Topic 6C: Manage the View of Large Worksheets

Microsoft Office Excel 2007: Level 2 (Second Edition)

Course Content

Lesson 1: Calculating Data with Advanced Formulas
Topic 1A: Manage Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data
Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Worksheet or Table Data
Topic 2D: Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts
Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts
Topic 4A: Create a PivotTable Report
Topic 4B: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects
Topic 5A: Insert and Modify Pictures and ClipArt
Topic 5B: Draw and Modify Shapes
Topic 5C: Illustrate Workflow Using SmartArt Graphics
Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment
Topic 6A: Customize the Excel Environment
Topic 6B: Customize Workbooks
Topic 6C: Manage Themes
Topic 6D: Create and Use Templates

Microsoft Office Excel 2007: Level 3 (Second Edition)
Course Content

Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook's Properties
Topic 1F: Modify Excel's Default Settings

Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Administer Digital Signatures
Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets
Topic 3A: Trace Cells
Topic 3B: Troubleshoot Errors in Formulas
Topic 3C: Troubleshoot Invalid Data and Formulas
Topic 3D: Watch and Evaluate Formulas
Topic 3E: Create a Data List Outline

Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data
Topic 6A: Export Excel Data
Topic 6B: Import a Delimited Text File

Lesson 7: Using Excel with the Web
Topic 7A: Publish a Worksheet to the Web
Topic 7B: Import Data from the Web
Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML
Topic 8A: Develop XML Maps
Topic 8B: Import and Export XML Data

Microsoft Office Excel 2007: New Features
Course Content

Lesson 1: Exploring the Excel Environment
Topic 1A: Explore the User Interface
Topic 1B: Work with the Ribbon
Topic 1C: Work with Contextual Tabs
Topic 1D: Use the Excel Galleries
Topic 1E: Customize the Excel Interface

Lesson 2: Organizing Data
Topic 2A: Explore the Enhancements in Excel 2007 Spreadsheets
Topic 2B: Insert Tables
Topic 2C: Format Tables

Lesson 3: Analyzing Data
Topic 3A: Apply Conditional Formatting
Topic 3B: Sort Data in a Spreadsheet
Topic 3C: Filter Data in a Spreadsheet
Topic 3D: Apply a Formula

Lesson 4: Presenting Data
Topic 4A: Create Charts
Topic 4B: Format Charts
Topic 4C: Work with Illustrations
Topic 4D: Create PivotTables and PivotCharts
Topic 4E: Share Excel Charts
Topic 4F: Save Data in Presentable Formats

Check out our new blog

Keep up to date with all the latest news and topics of interest.

News

2010-07-15 10:37 by Genesis

We are on the Radio!!

2010-07-06 11:19 by Genesis

Calling Aspiring Wexford Students to Apply for Scholarship

Genesis Business College in conjunction with Wexford Chamber is calling all aspiring students to apply for a scholarship placement for the forthcoming academic year.

2010-06-28 12:25 by Genesis

Facebook promotion

Become a fan of the Genesis Business College Facebook Page and you could win a free course.....

2010-06-22 09:17 by Genesis

Carlow Scholarship Programme Launched....

Genesis Business College in conjunction with the Carlow Business Network and our media partner the Nationalist is delighted to announce its annual scholarship scheme for the forthcoming academic year.

2010-06-09 17:01 by Genesis