|
Provided by: Last Minute Training Excel Intermediate - Level 2Excel |
 |
Training
Provided by Last Minute Training
This course provides competency in organizing and consolidating data from multiple worksheets, adjusting the screen display, working with advanced functions, using advanced formatting features, using advanced print options, filtering data, using comments, naming worksheet ranges and formulas, creating and modifying charts, protecting data, importing and exporting data, saving worksheets and workbooks as Web pages, and publishing worksheets and workbooks to the Web.
|
|
||||||||||
Excel Intermediate - Level 2 Seminar Schedule
| October, 2008 | ||||
| Date | Location | |||
|---|---|---|---|---|
| [Register] | ||||
Excel Intermediate - Level 2
Unit 1 : Working with large worksheets
Topic A: 0 Viewing options
A-1: Zooming in and out on a large worksheet
A-2: Using the Freeze Panes command
A-3: Splitting a worksheet into panes
Topic B: 0 Hiding, displaying, and outlining data
B-1: Hiding and unhiding columns and worksheets
B-2: Creating an outline
Topic C: 0 Printing large worksheets
C-1: Setting print titles
C-2: Setting page breaks
C-3: Using Page Break Preview
Unit 2 : Using multiple worksheets and workbooks
Topic A: 0 Using multiple worksheets
A-1: Navigating between multiple worksheets
A-2: Naming worksheets and coloring tabs
A-3: Working with multiple worksheets
A-4: Previewing and printing multiple worksheets
Topic B: 0 Linking worksheets by using 3-D formulas
B-1: Creating 3-D formulas
B-2: Adding a Watch window
Topic C: 0 Consolidating data
C-1: Using the Consolidate command
Topic D: 0 Linking workbooks
D-1: Switching between workbooks
D-2: Examining external links in a worksheet
D-3: Creating external links in a worksheet
D-4: Editing links
Topic E: 0 Managing workbooks
E-1: Creating a workspace
Unit 3 : Customizing Excel
Topic A: 0 Using the Options dialog box
A-1: Changing view options
A-2: Changing general options
A-3: Changing calculation options
Topic B: 0 Customizing toolbars and menus
B-1: Showing and hiding toolbars
B-2: Moving and docking toolbars
B-3: Customizing and restoring toolbars
B-4: Customizing a menu
B-5: Exploring short menus and smart menus
Unit 4 : Advanced formatting
Topic A: 0 Borders and shading
A-1: Adding borders to a cell or range
A-2: Adding shading to a cell or range
Topic B: 0 Using special number formats
B-1: Using special formats
B-2: Controlling the display of zero values
B-3: Creating custom formats
B-4: Applying conditional formatting
Topic C: 0 Working with dates
C-1: Using date and time formats
C-2: Using the NOW and DATE functions
C-3: Performing calculations on dates
Topic D: 0 Working with styles
D-1: Observing built-in styles
D-2: Creating and applying styles
D-3: Modifying styles
Topic E: 0 Other advanced formatting
E-1: Merging cells
E-2: Changing a cell's orientation
E-3: Splitting cells
Unit 5 : List management
Topic A: 0 Examining lists
A-1: Examining the structure of a list
Topic B: 0 Sorting and filtering lists
B-1: Sorting a list by using the Standard toolbar
B-2: Sorting a list by using the Sort command
B-3: Filtering a list by using AutoFilter
Topic C: 0 Advanced filtering
C-1: Using the Custom AutoFilter criteria
C-2: Using the Advanced Filter dialog box
C-3: Copying filtered results to another range
Unit 6 : Advanced charting
Topic A: 0 Chart formatting options
A-1: Adjusting the scale of a chart
A-2: Formatting a data point
Topic B: 0 Using combination charts
B-1: Creating a combination chart
B-2: Creating a trendline
Topic C: 0 Using graphic elements
C-1: Adding graphic elements
C-2: Formatting a graphic element
C-3: Adding a picture to a worksheet
Unit 7 : Documenting and auditing
Topic A: 0 Auditing features
A-1: Tracing precedent and dependent cells
A-2: Tracing errors
Topic B: 0 Comments and text boxes
B-1: Viewing comments in a worksheet
B-2: Adding a comment
B-3: Managing comments
B-4: Creating a text box
Topic C: 0 Protection
C-1: Password-protecting a worksheet
C-2: Protecting part of a worksheet by unlocking cells
C-3: Discussing digital signatures
Topic D: 0 Workgroup collaboration
D-1: Sharing a workbook
D-2: Merging workbooks
D-3: Tracking changes in a workbook
Unit 8 : Using templates
Topic A: 0 Built-in templates
A-1: Using the Sales Invoice template
A-2: Using the ExpenseStatement template
Topic B: 0 Creating and managing templates
B-1: Creating a template
B-2: Modifying a template
B-3: Using an alternate template location
Appendix A : Web discussions
Topic A: 0 Creating and responding to Web discussions
Appendix B : MOS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
Topic A: 0 Viewing options
A-1: Zooming in and out on a large worksheet
A-2: Using the Freeze Panes command
A-3: Splitting a worksheet into panes
Topic B: 0 Hiding, displaying, and outlining data
B-1: Hiding and unhiding columns and worksheets
B-2: Creating an outline
Topic C: 0 Printing large worksheets
C-1: Setting print titles
C-2: Setting page breaks
C-3: Using Page Break Preview
Unit 2 : Using multiple worksheets and workbooks
Topic A: 0 Using multiple worksheets
A-1: Navigating between multiple worksheets
A-2: Naming worksheets and coloring tabs
A-3: Working with multiple worksheets
A-4: Previewing and printing multiple worksheets
Topic B: 0 Linking worksheets by using 3-D formulas
B-1: Creating 3-D formulas
B-2: Adding a Watch window
Topic C: 0 Consolidating data
C-1: Using the Consolidate command
Topic D: 0 Linking workbooks
D-1: Switching between workbooks
D-2: Examining external links in a worksheet
D-3: Creating external links in a worksheet
D-4: Editing links
Topic E: 0 Managing workbooks
E-1: Creating a workspace
Unit 3 : Customizing Excel
Topic A: 0 Using the Options dialog box
A-1: Changing view options
A-2: Changing general options
A-3: Changing calculation options
Topic B: 0 Customizing toolbars and menus
B-1: Showing and hiding toolbars
B-2: Moving and docking toolbars
B-3: Customizing and restoring toolbars
B-4: Customizing a menu
B-5: Exploring short menus and smart menus
Unit 4 : Advanced formatting
Topic A: 0 Borders and shading
A-1: Adding borders to a cell or range
A-2: Adding shading to a cell or range
Topic B: 0 Using special number formats
B-1: Using special formats
B-2: Controlling the display of zero values
B-3: Creating custom formats
B-4: Applying conditional formatting
Topic C: 0 Working with dates
C-1: Using date and time formats
C-2: Using the NOW and DATE functions
C-3: Performing calculations on dates
Topic D: 0 Working with styles
D-1: Observing built-in styles
D-2: Creating and applying styles
D-3: Modifying styles
Topic E: 0 Other advanced formatting
E-1: Merging cells
E-2: Changing a cell's orientation
E-3: Splitting cells
Unit 5 : List management
Topic A: 0 Examining lists
A-1: Examining the structure of a list
Topic B: 0 Sorting and filtering lists
B-1: Sorting a list by using the Standard toolbar
B-2: Sorting a list by using the Sort command
B-3: Filtering a list by using AutoFilter
Topic C: 0 Advanced filtering
C-1: Using the Custom AutoFilter criteria
C-2: Using the Advanced Filter dialog box
C-3: Copying filtered results to another range
Unit 6 : Advanced charting
Topic A: 0 Chart formatting options
A-1: Adjusting the scale of a chart
A-2: Formatting a data point
Topic B: 0 Using combination charts
B-1: Creating a combination chart
B-2: Creating a trendline
Topic C: 0 Using graphic elements
C-1: Adding graphic elements
C-2: Formatting a graphic element
C-3: Adding a picture to a worksheet
Unit 7 : Documenting and auditing
Topic A: 0 Auditing features
A-1: Tracing precedent and dependent cells
A-2: Tracing errors
Topic B: 0 Comments and text boxes
B-1: Viewing comments in a worksheet
B-2: Adding a comment
B-3: Managing comments
B-4: Creating a text box
Topic C: 0 Protection
C-1: Password-protecting a worksheet
C-2: Protecting part of a worksheet by unlocking cells
C-3: Discussing digital signatures
Topic D: 0 Workgroup collaboration
D-1: Sharing a workbook
D-2: Merging workbooks
D-3: Tracking changes in a workbook
Unit 8 : Using templates
Topic A: 0 Built-in templates
A-1: Using the Sales Invoice template
A-2: Using the ExpenseStatement template
Topic B: 0 Creating and managing templates
B-1: Creating a template
B-2: Modifying a template
B-3: Using an alternate template location
Appendix A : Web discussions
Topic A: 0 Creating and responding to Web discussions
Appendix B : MOS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...