Font size:

Interactive Instructor-Based Excel 2000 Essentials Video Training Course on DVD-ROM. Computer Based Training (CBT) and Video Based Training (VBT) have emerged as the premier training tools in recent years. KeyStone Self-Paced CBT/VBT courses are known for their high quality in-depth content. Compared to traditional training methods, KeyStone courses cost less and users can learn faster while taking advantage of some of the best trainers in the industry. They are easy to use, comfortable to follow, perfect for training at the office, on the road, or at home.

Levels included: • Beginner • Intermediate • Advanced

Course Outline: The Excel Screen The Excel Workbook & Worksheets Title Bar & Menu Bar Toolbars Formula Bar Columns & Rows Navigation Sheet Names & the Status Bar Mouse Pointers & Shortcut Menus Entering Data into a Worksheet Data Entry Techniques Auto-Fill Entry Techniques Erasing Data Auto Complete Entering Formulas Three Methods of Entering Formulas Repeating a Formula Formulas Beyond Addition & Subtraction Basic Functions Summation Recalculating Effects Averages Formatting The Formatting Toolbar Adjusting Column-width & Row-height Numeric Formatting Saving File Save or File Save as Opening a File Closing a File Creating a new Workbook Intermediate Changing Worksheet Layout Inserting Columns Deleting Columns Moving Cells Copying Cells Additional Formatting Formatting Cell Attributes & Alignment Borders Numeric Formatting Center Text across Columns Hiding & Unhiding Columns & Rows Printing Using Print Preview & Page Setup Printing Controls Using Page Break Preview Using Cell References Absolute References Mixed References Tools Options Command Show/Hide Gridlines Show/Hide Formulas Recently used Files List Sheets in New Workbook Default Settings Advanced Adjusting Worksheet Views Freeze/Unfreeze Panes Horizontal & Vertical Split screen Auditing Techniques Using the Auditing Toolbar Tracing Dependant Cells Tracing Precedent Cells Using Functions Paste Function The PMT Function Expanding the use of standard functions Logical Functions IF Functions & Relational Operators (> < >= <= = <> ) Using Words in IF Functions Using IF Functions with Arithmetic Operators (* / + -) Using Logical Operators (AND & OR) with the IF Function Nested IF Functions Using the VLOOKUP Function to overcome Limitations of the IF Functions Date & Time Functions Using Dates as Values Entering a Series of Dates Date/Time entry Techniques Multi-Sheet Workbooks Re-Naming & Re-Ordering Sheets Inserting & Deleting Sheets Moving Formulas across multiple sheets
Register Now
Microsoft Excel 2000 Essentials Beginner/Intermediate/Advanced Instructor-based Video Training Online course
  • Course ID:
  • Duration:
  • Price: