Career Vision Training
call us on 0121 248 2400
 
To receive updates and new releases, subscribe today


Save up to 30%
Off Publishers Retail Prices
courses / products

DESKTOP & OFFICE
Office 2007 Training Bundle
Office 2003 Training Bundle
Access 2007
Excel 2007
Word 2007

View Complete List...

IT CERTIFICATION
A+ Certification 2009 Bundle
MCSE 2003/2008
MCSE 2003/2008 with A+
MCSE 2003/2008 with CCNA
MCITP 2008 Server Admin
MCITP 2008 Enterprise Admin
Cisco CCNA (640-802)
MCTS: Windows 7 Configuration
MCPD.NET 2.0 Web VB Bundle
MCTS.NET 2.0 Windows C#

View Complete List...

SECURITY & NETWORKING
EC Council - CEH v6
EC Council - CHFI v4
EC Council - ESCA/LPT
CISSP Training Suite
Cisco CCNA Security
Security+ 2008

View Complete List...

PROJECT MANAGEMENT
PMP 2008 Exam Prep
Project 2007
Project Management Intro
Managing Project Teams
ITIL v3 Foundation

View Complete List...

CAD & 3D
Revit Structure 2010
AutoCAD 2010
AutoCAD Map 3D 2010
AutoCAD Mechanical 2010
Inventor 2010
Microstation XMJ 10
Navisworks Manage 2010
Revit Architecture 2010

View Complete List...

GRAPHICS & LAYOUT
Creative Suite 4 Design Essentials Bundle
Photoshop CS4 Essentials
Adobe CS4 Master Bundle
Illustrator CS4 Essentials
Total Training Online Courses

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...

MULTIMEDIA & ANIMATION
Adobe CS4 Production Bundle
After Effects CS4 Essentials
Premiere Pro CS4 Essentials
MOTU Digital Performer 6
Encore DVD Pro 2.0

View Complete List...

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

View Complete List...

PROGRAMMING
ASP.Net 3.5
C Programming 2007
C# for Developers
VB.Net 3.5
Visual Studio 2008: Essentials

View Complete List...

DATABASES
MCITP Database Administrator
Oracle 10g PL/SQL
SQL Server 2005 Training Suite
Visual Basic for Excel
Data Modeling

View Complete List...

OPERATING SYSTEMS
Windows XP End User
Windows Vista for End Users
Windows 7 by VTC
Mac OSX 10.4 Tiger

View Complete List...

COURSES BY EXAM NUMBER
A+ Essentials 2009 Training
Cisco CCENT (640-822)
Exchange Server 2007
MCITP Exam 70-441
MCTS: Windows 7 Configuration

View Complete List...

BOOKS
A+ 2009 Review Guide
Cisco CCNA Study Guide
MCSE 2003 Training Kit
MCDST Training Kit

View Complete List...
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST, FREE UK DELIVERY
Order Today, Learn Tomorrow!


SECURE PAYMENT
PROCESSING

We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted




* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

Excel 2000

 
Bookmark and Share
MS Excel 2000 Set of 3 Training CDs
Excel 2000
 

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  

    MCITP Training Courses   MCPD Training Courses   MCTS Training Courses
    MCITP Database Developer Training Courses   MCITP Database Administrator Training Courses
    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