|
You are bidding on 3 Microsoft Excel Training books used
by American Design Institute, These are the actual books used for all the Microsoft Excel Training classes. (Introductory, Intermediate, and Advanced)
American Design Institute is a State license School with an outstanding Job Placement Rate, we also are known for the largest and most complete PLC training simulators in the country. Get the books and find out why our students have no problems knowing Microsoft Excel
These books are brand new.
You Will Learn...
Getting Acquainted with Excel
1. The Excel Environment
2. The Title Bar
3. The Menu Bar
4. The Standard Toolbar
5. The Formatting Toolbar
6. Scroll Bars
7. The Formula Bar
8. The Workbook Window
9. The Status Bar
10. The Task Pane
Creating Basic Spreadsheets
1. Creating a New Workbook
2. Saving Workbooks
3. Closing Workbooks
4. Opening Workbooks
5. Selecting Cells
6. Entering Text Into Cells
7. Entering Numbers Into Cells
8. AutoComplete
9. Pick From List
10. Zooming the Spreadsheet
11. Managing Multiple Workbooks
12. Renaming Workbooks
Using Ranges
1. Using Ranges
2. Selecting Ranges
3. Selecting Multiple Non-
Adjacent Ranges
4. Entering Information Into a Range
5. Using AutoFill
Creating Formulas
1. Using Formulas
2. Formula Functions
3. Using AutoSum
4. Inserting Functions
5. Editing a Range
6. Using the Formula Palette
7. Using the Paste Function
8. Editing a Range
9. Formula AutoCorrect
10. AutoCalculate
Copying & Pasting Formulas
1. Absolute References and
Relative References
2. Cutting, Copying & Pasting
3. AutoFilling Cells
4. Drag & Drop Cutting, Copying & Pasting
5. Using Undo
6. Using Redo
Columns & Rows
1. Selecting Columns & Rows
2. Changing Column Width & Row Height
3. AutoFitting Columns & Rows
4. Hiding/Unhiding Columns & Rows
5. Inserting & Deleting Columns & Rows
Formatting Spreadsheets
1. Using the Formatting Toolbar
2. Using the Format Cells Dialog Box
3. The Number Tab
4. The Alignment Tab
5. The Font Tab
6. The Border Tab
7. The Patterns Tab
8. Clearing All Formatting from Cells
9. Copying All Formatting from
Cells to Another Area
Conditional Formatting & AutoFormatting
1. Conditional Formatting
2. AutoFormatting
Setting Spreadsheet Layout
1. Working with Page Breaks
2. Viewing the Header and Footer
3. The Page Setup Dialog Box
Printing Spreadsheets
1. Using Print Preview View
2. Printing Your Spreadsheet
Helping Yourself
1. Using Screen Tips
2. Using the Office Assistant
3. Using the Help Pane
Creating 3D Formulas
1. Creating 3D Formulas
2. 3D Formula Syntax
3. Creating 3D Range References
Named Ranges
1. Naming Ranges
2. Moving to a Named Range
3. Using Named Ranges in Formulas
4. Creating Names from Headings
5. Deleting Range Names
Spreadsheet Tools
1. Moving between Spreadsheets
2. Selecting Multiple Spreadsheets
3. Inserting and Deleting Spreadsheets
4. Renaming Spreadsheets
5. Coloring Spreadsheet Tabs
6. Switching to Full Screen View
7. Splitting the Screen
8. Freezing Panes
9. Copying and Moving Entire Worksheets
10. Cutting, Copying and
Pasting Data between Spreadsheets
11. Printing Multiple Spreadsheets
12. Hiding Spreadsheets
Using Workspaces
1. Creating Workspaces
2. Opening and Closing Workspaces
3. Selecting Workbooks in a Workspace
4. Organizing a Workspace
Paste Special
1. Paste Special Options
2. Pasting Linked Formulas
Sharing and Reviewing Workbooks
1. Sharing Workbooks
2. Highlighting Changes
3. Reviewing Changes
4. The Reviewing Toolbar
5. Inserting Comments
6. Managing Comments
7. Reviewing Comments
8. Printing Comments
9. Sending Spreadsheets for Review
10. Compare and Merge Workbooks
Auditing Spreadsheets
1. Auditing Spreadsheets
2. The Formula Auditing Toolbar
3. Tracing Precedent and Dependent Cells
4. Tracing Errors
5. Error Checking
6. Using the Watch Window
7. Cell Validation
Outlining Spreadsheets
1. Using Outlines
2. Applying and Removing Outlines
Consolidating Spreadsheets
1. Using Data Consolidation
2. Consolidation Types
Buyer pays shipping cost
| Shipping, payment details and return policy |
 |
|
|
| Shipping Cost |
|
Services Available |
|
Service Transit Time* |
|
Available to |
| US $5.50 |
|
US Postal Service Media MailTM |
|
Estimated delivery 2-9 days |
|
United States only |
| US $7.50 |
|
US Postal Service Priority Mail® |
|
Estimated delivery 2-3 days |
|
United States only |
| US $10.00 |
|
Standard Int'l Flat Rate Shipping |
|
|
|
Canada, Europe, Asia, Australia |
| US $14.00 |
|
Standard Int'l Flat Rate Shipping |
|
|
|
Worldwide |
|
| *Sellers are not responsible for service transit time. Transit times are provided by the carrier, exclude weekends and holidays, and may vary with package origin and destination, particularly during peak periods. |
|
| Will ship to Worldwide. |
Shipping insurance
US $1.00 Optional |
Seller's payment instructions
For International orders ONLY (non US address) - If the order is to be paid for by a non-US check or money order you must add $5 to the shipping price to cover the extra bank charge that is occured on my end. This policy is ONLY for non United States based orders. |
|
|
