Career Vision Training Computer Training Courses
* call us on 0121 248 2400
To receive updates and new
releases, subscribe today
*
* HOME * CONTACT US
* ABOUT US * HOW TO ORDER * PURCHASE ORDERS * RESELLERS * ARTICLES * VIEW BASKET
*
Featured Courses

IT CERTIFICATION & TECHNICAL
IT Helpdesk Career Track
IT Security Career Track
Network Engineer Career Track
MCSE 2003
MCSE 2008 Upgrade (70-649)
MCSE 2003 Corp Training Suite
Microsoft .NET 2005 Power Suite
MCPD.NET 2.0 Web C# Bundle
MCPD.NET 2.0 Web VB Bundle
MCPD.NET 2.0 Windows C#
MCPD.NET Windows VB
MCITP: Database Administrator
MCITP: Database Developer
A+ Certification Bundle
Cisco CCNA
Cisco CCNP
CISSP 2007
Certified Ethical Hacker (CEH)

View Complete List...
*

DESKTOP & OFFICE
Office 2007 Training Bundle
Office 2003 Training Bundle
Acrobat 9 Essentials
Project 2007
PRINCE2 Foundation

View Complete List...
*

GRAPHICS & LAYOUT
Photoshop CS4 Essentials
Creative Suite 3: Design Bundle
Total Training Online Courses
Illustrator CS3 Essentials
CorelDRAW Graphics Suite X3

View Complete List...
*

MULTIMEDIA & ANIMATION
After Effects CS3 Essentials
CS3: Production Bundle
Encore DVD Pro 2.0
Final Cut Studio
Premiere Pro CS3 Essentials

View Complete List...
*

CAD & 3D
AutoCAD 2009
AutoCAD LT 2009
Civil 3D 2009
Inventor 2009
Revit Architecture 2009 Essentials

View Complete List...
*

SOFT SKILLS TRAINING
Better Business Writing
Customer Satisfaction
Excellence in Supervision
How to Get Things Done
Team Leadership

View Complete List...
*

WEB DESIGN & INTERNET
Dreamweaver CS4 Essentials
Expression Studio 2 Bundle
Flash CS4 Pro Essentials
Creative Suite 3: Web Bundle
E-Commerce Introduction

View Complete List...
*
*
Computer Training Courses
*
CareerVision is one of Europe's leading suppliers of self-paced computer training courses.
*
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

Excel 2000
By LearnKey
MS Excel 2000 Set of 3 Training CDs
Excel 2000
Single User CD Course £100.00 + VAT
Buy Now
Multi User CD Course £350.00 + VAT
Buy Now
 

More on Single User & Multi User Licences

View all Training Courses by LearnKey


COURSE INTRODUCTION

In LearnKey's Excel 2000 training course, expert Reed Jacobson, guides you through spreadsheet fundamentals and provides inside tips for powerful business applications. You'll learn valuable features such as, formatting, summarizing, and charting methods, along with some little-known techniques that will help you get up to speed and working efficiently. At the conclusion of this training course, you will be confident in your ability to create meaningful spreadsheets.

Benefits

  • Gain valuable skills and improve personal productivity.
  • Acquire knowledge that will add credibility for future career prospects.
  • Increase marketability by using the latest information technology.

    		•

    COURSE OUTLINE

    Session 1

    Section A: Introduction
    · Uses for a Spreadsheet
    · Understanding the Excel Workspace
    · Selecting a Range of Cells

    Section B: Entering Values
    · Entering Text, Numbers & Dates
    · Formatting Dates & Editing Values
    · Sorting a List

    Section C: Managing Workbooks
    · Saving a Workbook
    · Opening & Closing Workbooks
    · Workbook Add, Delete, Rename & Move

    Section D: Creating a Form or Document
    · Creating a Form or Document
    · Changing Fonts, Color & Alignment
    · Formatting Dates
    · Resizing Columns & Rows
    · Creating Backgrounds & Borders
    · Inserting Columns
    · Merging Cells

    Section E: Summarizing Numbers
    · Using Auto Fill
    · Using Tab to Enter Values
    · Creating Totals Automatically
    · Understanding the SUM Function
    · Creating & Validating Formulas

    Section F: Formatting Numbers
    · Currency Style
    · Auto Formatting Regions & Moving Cells

    Section G: Creating Charts
    · Adding a Chart
    · Adding New Values to a Chart
    · Creating a Custom Chart
    · Using the Chart Toolbar & Menu
    · Chart Location

    Section H: Creating Charts
    · Print Preview & Page Setup Options
    · Preview Color in Black & White
    · Selecting Multiple Sheets
    · Printing

    Section I: Customizing Excel
    · Changing Workbook Options
    · Using Adaptive Menus & Toolbars
    · Context Sensitive Toolbars

    Section J: Discovering More
    · Screen Tips
    · Use Help in Dialogue Boxes
    · Using the Office Assistant
    · Help Context

    Session 2

    Section A: Managing References
    · Relative References
    · Using Auditing Toolbar
    · Mixed & Absolute References
    · Saving Workbooks

    Section B: Named Ranges
    · Naming Cells
    · Naming Ranges
    · Applying Names

    Section C: Manipulating Ranges
    · Importing Files
    · Special Formatting Features
    · Find/Replace

    Section D: Basic Functions
    · Summarizing Functions
    · 3D Formulas
    · Logical Functions
    · Date Functions

    Section E: Look-up Functions
    · Types of Look-ups
    · Vertical Look-up
    · Applying Names to Vertical Look-up

    Section F: Financial Functions
    · Types of Financial Functions
    · Calculating Payments

    Section G: Considering Alternatives
    · Using Scenarios
    · Report Manager
    · Using Goal Seek
    · Using the Solver

    Section H: Enhanced Formatting
    · Formatting Numbers
    · Formatting Text
    · Applying Styles

    Section I: Dynamic Formatting
    · Applying Conditional Formats
    · Using Data Validation

    Section J: Graphical Objects
    · Using the Drawing Toolbar
    · Adding Comments
    · Inserting Pictures

    Session 3

    Section A: Managing Workbooks
    · Introduction
    · Adding a File Password
    · Protecting a Workbook
    · Freezing Row & Column Headers
    · Changing Page Breaks
    · Printing Portions of a Worksheet
    · Setting Workbook Properties
    · Creating a Workspace

    Section B: Using Templates
    · Saving & Editing a Template
    · Changing the Default Template
    · Changing the Default Worksheet Template

    Section C: Sharing a Workbook
    · Sharing a Workbook
    · Editing a Shared Workbook
    · Tracking Changes to a Shared Workbook
    · Merging Workbooks

    Section D: Query a Database
    · Retrieving Data from a Database
    · Filtering the Data using Microsoft Query

    Section E: Working with Lists
    · Sorting Lists
    · Using a Form to View/Search a List
    · Using AutoFilter
    · Using the Advanced Filter
    · Adding Subtotals to a List
    · Tracing Errors

    Section F: Working with PivotTables
    · Creating a PivotTable
    · Formatting a PivotTable
    · Creating a PivotChart

    Section G: Excel & the Internet
    · Saving a Workbook as HTML
    · Saving HTML with Interactivity
    · Saving an Interactive PivotTable as HTML
    · Importing Values from a Web Site
    · Creating Hyperlinks in a Worksheet
    · Using the Office Clipboard
    · Round Tripping to HTML & Back Again

    Section H: Creating Macros
    · Creating & Running a Macro
    · Looking at a Macro's Code
    · Creating Another Macro
    · Editing the Macro
    · Creating a Button to Run a Macro

    Section I: Preparing for Certification
    · The Testing Method
    · Tips for the Exam
     
    Print Image Printer friendly version   
    Top of page
    *
    *
    A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CONTACT US   SITEMAP  
    *

    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk
    red arrow Website design by Aimpro UK red arrow Terms