|
|
Excel 2000 Complete Training (10 levels) |
|
|
|
[to previous page]
[other products in "No Longer Available"]
|
| |
|
| Product: |
Excel 2000 Complete Training (10 levels)
Maximize your understanding of the world's top spreadsheet program while helping you prepare for MOUS Certification. Learn formulas, formatting, layout, commands, functions, charts, database shortcuts, pivot tables, files and reports and much more.
|
Price:
excl. VAT |
|
|
|
Beginner 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
Charts Creating a Chart: Data Selection, Single-click Chart Creation, Chart Wizard, Copying a Chart
The Charting Toolbar: Features of the Charting Toolbar
Printing a Chart: Printing a Chart Located on a Separate Sheet, Printing a Chart Located on a Worksheet
Shortcuts: Creating a Shortcut on the Worksheet with Two Clicks, Add & Remove Data from an Embedded Chart, Change Row/Column Orientation
Chart Types: Line Charts, Column Charts, Cone, Pie Charts, Other Chart Types
Formatting the X & Y Axes: Adjusting the Scale on Column Charts, Adjusting the Scale on Line Charts
Annotation Features: Adding Text & Arrows
Special Topics Naming Ranges: Naming a Single Cell, Naming Multiple Cells, Using Existing Names, Paste a List of Range Names in a Worksheet, Deleting Range Names
Conditional Formatting: Formatting Based on Values & Multiple Conditions, Avoiding Overlapping Conditions, Using a Formula to Control Formatting
Cell Protection Techniques: Unlocking Selected Cells Changes, Protecting the Worksheet to Restrict Entry to Unlocked Cells, Unprotecting the Worksheet
Annotating a Worksheet with Comments & Drawing Tools: Inserting, Options for Printing Comments, Show/Hide Comments with the Tools Options Command, Using Drawing Toolbar
Multiple Workbooks: Opening & Displaying Multiple Workbooks, Moving & Copying Sheets Across Workbooks, Linking Formulas Across Workbooks, Locating & Maintaining Links
Customizing Toolbars: Adding & Removing Buttons, Economizing Buttons & Resetting Toolbars, Creating New Toolbars
Find & Replace: Matching Entire Cells
Using Goal Seek: Features of Goal Seek
Numeric Formatting: The Custom Category, The Special Category, Formatting with IMPLIED-IF
| Databases Data Form: Setting up a Single Record with Formulas, Adding Records to a Database, Finding Records & Avoiding Cells Below
Data Validation: Establishing Data Entry Criteria, Using Data Validation on Existing Data
Data Sort: Sorting from the Menu, Sorting from the Toolbar, Multiple-Key Sorting, Sorting with Custom Lists
Data Subtotals: Single Level Subtotals, Multiple Level Subtotals
Data Filter: Criteria, Top-ten, Advanced Filter
Data Functions: Sumif, Array Functions & Formulas
Tips, Tricks & Shortcuts Navigation Shortcuts: Navigating Around a Worksheet, Navigating Multiple Workbooks, Some Useful Keyboard Shortcuts, Navigating to the Bottom of a Column
Selection Shortcuts: Selecting a Range, Selecting an Entire Worksheet, Selecting Non-contiguous Ranges & Go to Special
Data Entry Shortcuts: Entering System Date & Time, Copying Formulas & Results, Entering Data in a Range of Cells Data Validation, Multi-line Entries
Formula Shortcuts: Displaying Formulas, Dependent & Precedent Cells, VLookup
Formatting Shortcuts: Numerical Formatting, Numerical Keyboard Shortcuts, Dealing with Large Numbers
Operational Shortcuts: Undoing & Repeating, File Management Shortcuts, Inserting
Data Expansion Shortcuts: Numerical Series, Dates
Drag & Drop: Moving, Copying & Inserting, Moving, Copying & Inserting to a Different Sheet, Moving, Copying & Inserting using a Mouse
Display Shortcuts: Split Screens
Listing Unique Entries: Data Filter Advanced, Capturing a Picture
Pivot Tables Background: An Example
Creating a Pivot Table: Using the Pivot Table & Pivot Chart Wizard, Viewing Pivot Tables & Pivot Charts
Manipulating the Layout: Interchanging Fields, Adding & Removing Fields, Page Axis
Content & Formatting: Numeric Formatting, Selecting Specific Information & AutoFormat
The Refresh Button: Changing Original Data, Changing Field Names
Pivot Table Chart Sources: Selecting & Manipulating Chart Data, The Pivot Chart & Pivot Table Relationship, Pivot Chart Formatting, Creating a Pivot Chart & Table Together from the Original Data
Sorting Items: Sorting by Field Order & Numeric Information
Hiding & Revealing Data: Drop Arrows, Hiding Inner Fields
Grouping & Ungrouping: Grouping Data, Grouping by Date
Totals: Displaying Totals, Adding & Removing Totals
Functions Statistical Functions: Median & Rank, Small & Large, Count, Using Functions in a Range, Average
Analysis ToolPak: Accessing more Functions
Financial Functions: PMT & FV, PV & Rate
Math Functions: Round, Ceiling & Floor, Odd & Even, Fact, Mod, Rand & Randbetween, Roman
Text Functions: Find & Mid, Left & Concatenation, Len & Right, An Example, Upper, Trim
The Indirect Function: The Indirect Function
Files & Reports Workbook Management: Workspaces, Assigning Passwords, Hiding Workbooks
Formatting Workbooks: AutoFormat, Styles
Outlining: Group & Outlining Capabilities
Templates: Creating a Default Workbook Template, Creating a Custom Template
Report Manager: Printing & Views
Scenario Manager: Creating Scenarios, Solver
The Drawing Toolbar: WordArt, Shapes, Coloring Objects & Adding Text, ClipArt
Using Excel with Other Applications: Text Files, Access, Word
Hyperlinks: Types of Links
|
|
|
 |
|
|
|
|
| Quick Links |
|
|
|
| RCS Newsletter |
|
|
|
| Our Customers |
excellent:
"The CBT product is easy to use and an excellent combination of reading material, video on CD and interactive labs. "
thank you :
"Thank you! i have received the complete order today.
thank you for your swift service and i hope to be in touch soon with regards further training.
Once again thank you very much"
glad:
"I am glad to report that the CBT packages arrived successfully.
I really appreciate all the help and assistance you gave me since my initial enquiry with yourselves"
More testimonials
IT Training
Settings/Tips/Tricks
Computer Articles
Biodiesel Energy
PPE Safety Equipment
Learn English Language |
|
|
