Course Title: Microsoft Excel 2000
With Microsoft Excel 2000, you can take advantage of comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. Excel allows you to easily analyze data with charts, Microsoft PivotTable, and graphs. You can even use automatic formatting to create data-rich spreadsheets. In this tutorial, you are guided from basic thorough advanced techniques by author Lorie Flenner. She easily explains need-to-know topics such as columns and rows, workbooks and worksheets, basic and advanced formulas, and even how to insert graphics. If you need to know Excel, why not start now? Simply click a topic below.
Course Author/Expert: Lorie Flenner/NMG
Language: english
Full Online Training Available: Yes
Number of Course Movies: 157
Course Duration: 8 hours
Never has it been so easy to learn Microsoft Excel 2000.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.
Course Outline:
The FIRST THREE chapters of this online training course can be viewed right now!
Click Here Now To View the First Three Chapters of Microsoft Excel 2000 Online Training For Free
If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.
Introduction
Getting Started
The Interface
Menus
Toolbars
Formula Bar
Columns & Rows
Scroll Bars
Sheet Tabs
Status Bar
Interface Review
Workbooks & Worksheets
Open and Close Workbooks
Save Workbooks
Getting Help
The Basics
Select and Navigate Cells
Enter Data
Edit and Delete Data
Cut / Copy and Paste
Undo and Redo
Drag and Drop
Auto Fill
AutoCorrect
Working With Worksheets
Zoom Control
Views
Resize Rows and Columns
Insert Cells
Delete Cells
Insert and Delete Rows and Columns
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide
Formatting Cells
Text Formats
Align and Text Wrap
Alignment Effects
Format Painter
Borders and Shading
Numbers Formats
Date and Time Formats
Custom Formats
Autoformat
Conditional Formating
Styles
Basic Formulas
Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard
Ready for Printing?
Headers and Footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing
Charts and Maps
Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps
Advanced Formulas
If Functions
And / Or
Nested If Functions
Using Excel as a Databse
Create a Database
Sort Data
Filter Data
Advance Filter
Data Forms
Database Functions
Linking and Protecting
Formula Links
Range Names
Paste Special
Protect Cells
Protect Worksheets and Workbooks
Passwords
Analysis
Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining
Toolbars and Macros
Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button
Graphics and The Drawing Toolbar
Insert a Picture
Move / Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects
To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.
or
Click Here and we'll send you the training CD itself for Microsoft Excel 2000 at £79.95
|
|
Add latest courses to Google Toolbar