Excel 2007 Beginner/Intermediate/Advanced Training
CBT Training IT Training Course Specialists
 
home
products
services
information
resellers
contact
sitemap
 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
Product: Excel 2007 Beginner/Intermediate/Advanced Training
Price:
  on DVD - Single User Lic.    £113.47 
  on DVD - Lending Lib. Lic.    £268.91 
 
Jobs:
Similar    
Products:		Access 2007 Beginner/Int/Adv/Expert CBT Training
OneNote 2003/2007 Essentials Training (PRE-SALE)
Whats New in Office 2007 Training
Excel 2007 Beginner/Intermediate/Advanced 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
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 (PRE-SALE)
Whats New in Office 2007 Training
Excel 2007 Beginner/Intermediate/Advanced 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

1Gb USB 2.0 Flash Drive on Special Offer.

Paypal, Verified By Visa, Mastercard SecureCode, Cheques or Invoice

RCS Newsletter
*Verify: 1499228

Quick Links
 ***Special offers ***
 Bookmark this Site
 Books / eBooks
 CBT Courses
 Classroom Courses
 CompTIA Courses
 Find A Course
 Distance Courses
 Contact Us
 FAQs
 Jobs
 LMS (Enterprise)
 Online/Web Courses
 **Recent Additions**
 Testimonials
 Terms & Conditions
Recent Pages

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
Copyright 2002-2006 RCS Limited. All rights reserved. More ...
RCS Limited for home study/ self study/home learning/CBT/Computer Based Training SSL