| Microsoft Excel 2000 Tutorials Online |
 |
|
Description 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. |
| Sample - Preview the First 3 chapters of Microsoft Excel 2000 video free. Free learning Microsoft Excel 2000 online. |
01 Introduction
0101 Getting Started
0102 The Interface
0103 Menus
0104 Toolbars
0105 Formula Bar
0106 Columns & Rows
0107 Scroll Bars
0108 Sheet Tabs
0109 Status Bar
0110 Interface Review
0111 Workbooks & Worksheets
0112 Open and Close Workbooks
0113 Save Workbooks
0114 Getting Help
02 The Basics
0201 Select and Navigate Cells
0202 Enter Data
0203 Edit and Delete Data
0204 Cut / Copy and Paste
0205 Undo and Redo
0206 Drag and Drop
0207 Auto Fill
0208 AutoCorrect
03 Working With Worksheets
0301 Zoom Control
0302 Views
0303 Resize Rows and Columns
0304 Insert Cells
0305 Delete Cells
0306 Insert and Delete Rows and Columns
0307 Rename Worksheets
0308 Insert and Delete Worksheets
0309 Move and Copy Worksheets
0310 Hide and Unhide
04 Formatting Cells
0401 Text Formats
0402 Align and Text Wrap
0403 Alignment Effects
0404 Format Painter
0405 Borders and Shading
0406 Numbers Formats
0407 Date and Time Formats
0408 Custom Formats
0409 Autoformat
0410 Conditional Formating
0411 Styles
05 Basic Formulas
0501 Formula Structure
0502 Operators
0503 Creating Formulas
0504 Autofill Formulas
0505 Autosum
0506 Relative Reference
0507 Absolute Reference
0508 Function Wizard
06 Ready for Printing?
0601 Headers and Footers
0602 Print Preview
0603 Scaling the Print Area
0604 Set Print Area
0605 Margins
0606 Printing
07 Charts and Maps
0701 Creating a Chart
0702 Chart Wizard
0703 Chart Options
0704 The Legend
0705 The Series
0706 Chart Toolbar
0707 3D Charts
0708 Creating Maps
0709 Customizing Maps
0710 Labeling Maps
08 Advanced Formulas
0801 If Functions
0802 And / Or
0803 Nested If Functions
09 Using Excel as a Databse
0901 Create a Database
0902 Sort Data
0903 Filter Data
0904 Advance Filter
0905 Data Forms
0906 Database Functions
10 Linking and Protecting
1001 Formula Links
1002 Range Names
1003 Paste Special
1004 Protect Cells
1005 Protect Worksheets and Workbooks
1006 Passwords
11 Analysis
1101 Goal Seek and Solver
1102 Scenarios
1103 Pivot Tables
1104 Validation
1105 Auditing
1106 Outlining
12 Toolbars and Macros
1201 Customizing Toolbars
1202 Create a Macro
1203 Edit a Macro
1204 Create a Macro Button
13 Graphics and The Drawing Toolbar
1301 Insert a Picture
1302 Move / Resize and Crop
1303 Creating Shapes and Lines
1304 Arranging and Grouping
1305 Fills and Line Color
1306 Arrows
1307 AutoShapes
1308 Flip and Rotate
1309 Text boxes
1310 WordArt
1311 Shadow and 3D Effects
sku |
|
