Use Excel tutorials within 'Excel 2007 Beginner/Intermediate/Advanced Training' to learn Excel 2007.'
CBT Training IT Training Course Specialists
 
home
products
services
information
resellers
contact
articles
sitemap
Computer Based Training Classroom Training Distance Learning / Correspondence Courses eBooks Kid's CDs Learning Management System Reference Material Web Based Training
 Excel 2007 Beginner/Intermediate/Advanced Training (Prices exclude VAT)
[to previous page]   [other products in "MS Office 2007 Courses"]
Excel 2007 Beginner/Intermediate/Advanced Training or a generic image.   larger image of Excel 2007 Beginner/Intermediate/Advanced Training (if available)
   Product: Excel 2007 Beginner/Intermediate/Advanced Training
Price:
  on DVD - Single User Lic.    £136.67 
  on DVD - Lending Lib. Lic.    £303.33 
 
Details:

Microsoft Excel 2007: Beginner

  • 1.0 Getting Started
  • 1.1 Launching Excel 2007
  • 1.2 Touring the Excel Window
  • 1.3 Using the Office Menu
  • 1.4 Using the Quick Access Toolbar
  • 1.5 Save vs. Save As
  • 1.6 File and Folder Management
  • 1.7 Opening and Closing Files
  • 1.8 Getting Help
  • 2.0 Entering Data
  • 2.1 Navigation and Selection Techniques
  • 2.2 Data Entry Techniques
  • 2.3 AutoFill
  • 2.4 AutoComplete
  • 2.5 Undo and Redo
  • 2.6 Exiting Excel
  • 3.0 Changing Worksheet Layout
  • 3.1 Inserting Rows, Columns and Cells
  • 3.2 Deleting Rows, Columns and Cells
  • 3.3 Adjusting Column Widths and Row Heights
  • 3.4 Hiding Columns and Rows
  • 3.5 Moving and Copying Data
  • 3.6 Create, Modify and Delete Named Ranges
  • 3.7 Go To, Find and Replace
  • 4.0 Entering Formulas
  • 4.1 Anatomy of a Formula
  • 4.2 Using the Formula Tab
  • 4.3 AutoSum
  • 4.4 Basic Functions
  • 4.5 Copying Formulas
  • 5.0 Formatting
  • 5.1 Using the Home Tab
  • 5.2 Using the Quick Format Mini Toolbar
  • 5.3 Number Formats
  • 5.4 Format as a Table
  • 5.5 Merging and Splitting Cells
  • 5.6 Applying Worksheet Backgrounds
  • 6.0 Using Themes and Styles
  • 6.1 Applying Themes
  • 6.2 Creating Custom Themes
  • 6.3 Applying Styles
  • 6.4 Creating Custom Styles
  • 7.0 Printing
  • 7.1 Using the Page Layout Tab
  • 7.2 Changing Margins and Page Orientation
  • 7.3 Exploring Worksheet Views
  • 7.4 Adding Headers and Footers
  • 7.5 Adding Print Titles and a Print Area
  • 7.6 Viewing and Setting Page Breaks
  • 7.7 Printing
  • 8.0 Charts
  • 8.1 Using the Insert Tab
  • 8.2 Creating a Chart
  • 8.3 Using the Chart Contextual Tabs
  • 8.4 Creating a Chart Sheet
  • 8.5 Adding and Removing Chart Data
  • 8.6 Format and Resize Charts
     

Microsoft Excel 2007: Intermediate

  • 1.0 Managing Workbooks
  • 1.1 Creating New Workbooks from a Template
  • 1.2 Rename and Move Workbook Tabs
  • 1.3 Insert and Delete Worksheets
  • 1.4 Copy and Paste Worksheets
  • 1.5 Using the View Tab
  • 1.6 Splitting Your Worksheet View
  • 1.7 Freezing and Unfreezing Your View
  • 2.0 Tables and Data Management
  • 2.1 Table Guidelines
  • 2.2 Using the Data Tab
  • 2.3 Sorting
  • 2.4 Grouping and Outlining Data
  • 2.5 AutoFilter
  • 2.6 Advanced Filter Using Single Criteria
  • 2.7 Advanced Filter Using Multiple Criteria
  • 2.8 Automatic Subtotals
  • 3.0 Using Cell References
  • 3.1 Using Relative Cell References
  • 3.2 Using Absolute Cell References
  • 3.3 Using Mixed Cell References
  • 4.0 Auditing
  • 4.1 About Auditing
  • 4.2 Tracing Precedents
  • 4.3 Tracing Dependents
  • 4.4 Tracing Errors
  • 5.0 Creating Web Pages from Workbooks
  • 5.1 Publishing a Web Page
  • 5.2 Viewing Your Published Web Page
  • 6.0 Using Excel with Other Applications
  • 6.1 Importing Data to Excel
  • 6.2 Exporting Data from Excel
  • 6.3 About XML
  • 7.0 Customizing Excel
  • 7.1 Customizing the Quick Access Toolbar
  • 7.2 Modifying Excel Options
  • 8.0 Using Scenarios and Watching Cells
  • 8.1 Creating and Displaying Scenarios
  • 8.2 Editing and Removing Scenarios
  • 8.3 Summarizing Scenarios
  • 8.4 Using the Watch Window
  • 9.0 PivotTables and PivotCharts
  • 9.1 About PivotTables and PivotCharts
  • 9.2 Creating a PivotTable
  • 9.3 Modifying a PivotTable
  • 9.4 Creating a PivotChart
  • 9.5 Modifying a PivotChart

Microsoft Excel 2007: Advanced

  • 1.0 Collaborating
  • 1.2 Inserting and Deleting Comments
  • 1.3 Viewing and Printing Comments
  • 1.4 Protecting Workbooks, Worksheets and Cells
  • 1.5 Enabling Workbook Security
  • 1.6 Sharing Workbooks
  • 2.0 Advanced Formulas and Functions
  • 2.1 IF Functions
  • 2.2 Nested IF Functions
  • 2.3 Using the VLOOKUP Function
  • 2.4 Using the HLOOKUP Function
  • 2.5 Using the DSUM Function
  • 3.0 Data Consolidation
  • 3.1 About Data Consolidation
  • 3.2 Three Dimensional Formulas
  • 3.3 Data Consolidation by Position
  • 3.4 Data Consolidation by Category
  • 4.0 SmartArt
  • 4.1 About SmartArt
  • 4.2 Creating a List
  • 4.3 Creating a Hierarchy
  • 4.4 Creating a Pyramid
  • 4.5 Editing SmartArt
  • 5.0 Track Revisions
  • 5.1 Tracking Changes
  • 5.2 Accepting and Rejecting Changes
  • 6.0 Data Validation and Conditional Formatting
  • 6.1 Working with Data Validation Rules
  • 6.2 Set Conditional Formatting
  • 6.3 Use Expressions in Conditional Formatting
  • 7.0 Creating Templates
  • 7.1 Using Excel Pre-Defined Templates
  • 7.2 Creating and Modifying a Template
  • 8.0 Macros
  • 8.1 Create a Macro
  • 8.2 Run a Macro
  • 8.3 Edit a Macro
 

Similar    
Products:		Access 2007 Beginner/Int/Adv/Expert CBT Training
OneNote 2003/2007 Essentials Training
Whats New in Office 2007 Training
Office 2007 Essentials CBT Training
Outlook 2007 Beginner/Intermediate/Advanced Training
Powerpoint 2007 Beginner/Intermediate/Advanced Training
Publisher 2007 Essentials Training
Word 2007 Beginner/Intermediate/Advanced Training
MS Office 2000 (MOS) CD Training (CBT) COMPLETE Course
MS Office XP (MOS) CD Training (CBT) Course
MS Office 2003 (MOS) CD Training (CBT) Course

2Gb USB 2.0 Flash Drive on Special Offer.
What's Hot
 ***Special offers ***
•  A+ 2009 Training
•  Office 2010 Training
•  Project 2007 Training
•  Network+ 2009 Training
•  Office 2007 Essentials Training
•  Office 2003 Essentials Training
•  Project 2003 Essentials Training
•  CCNA Training (640-802)
•  Sage Line 50 Training
•  ITIL v3 Foundation Training
 **Recent Additions**
RCS Newsletter
*Verify: 2664298

New Articles

Child Care Courses
MCSE Training Courses
Dedicated Servers
Accounting Software
Choosing Software
Backup Software

Settings, Tip & Tricks
ComputerArticles
Biodiesel Energy
Computer Training
PPE Safety Equipment
Learn English (Basic)

From the Best Seller List : ITIL v3 Foundation Training - The ITIL v3 Foundations training course maps directly to the exam objectives and offers numerous features such as exam tips, case studies, and practice exams.

CBT Training | Distance Learning | LMS (Enterprise) | Online Learning
Best Sellers | Classroom Courses | Special Offers | MCSE Courses
Copyright 2002-2011 RCS Limited. All rights reserved. More ...
RCS Limited for home study/ self study/home learning/CBT/Computer Based Training SSL