|
Provided by: Sonic Training Microsoft Excel 2003 - Introduction / BeginningExcel |
 |
Training
Provided by Sonic Training
Course Description
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
create and apply templates.
create and modify charts.
work with graphic objects.
calculate with advanced formulas.
sort and filter data.
use Excel with the Web.
SEE DAY TWO BELOW FOR ADDITIONAL TOPICS
Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML, Access VBA, Excel VBA), MS Office (Excel, Access, PowerPoint, Word, Outlook, Project) instructor-led, classroom training at our location or your company location. Sonic Training blends the fun and challenge of learning into to a classroom environment. Since all we do is training, (see Why choose Sonic Training) we know what works best and what doesn't.
Here at Sonic Training, we take your technical education seriously...but not too seriously. With 12 years of design and training experience, our mix of learning in a fun environment makes understanding complex design applications, like Dreamweaver or Access VBA, easy to digest. We also realize each student is unique and the company they work is unique, so our small class sizes (never over 8 students) makes it easy to incorporate your project at work into our class. We actually encourage work-related scenarios to help give the other students another real-life perspective.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
create and apply templates.
create and modify charts.
work with graphic objects.
calculate with advanced formulas.
sort and filter data.
use Excel with the Web.
SEE DAY TWO BELOW FOR ADDITIONAL TOPICS
Welcome to Sonic Training!. (http://www.sonictraining.com 877-760-0078) Macromedia (Dreamweaver, Flash, Fireworks), Adobe (Photoshop, InDesign, Illustrator), Database (SQL, Access, Filemaker Pro, Goldmine), Programming (HTML, CSS, XML, Access VBA, Excel VBA), MS Office (Excel, Access, PowerPoint, Word, Outlook, Project) instructor-led, classroom training at our location or your company location. Sonic Training blends the fun and challenge of learning into to a classroom environment. Since all we do is training, (see Why choose Sonic Training) we know what works best and what doesn't.
Here at Sonic Training, we take your technical education seriously...but not too seriously. With 12 years of design and training experience, our mix of learning in a fun environment makes understanding complex design applications, like Dreamweaver or Access VBA, easy to digest. We also realize each student is unique and the company they work is unique, so our small class sizes (never over 8 students) makes it easy to incorporate your project at work into our class. We actually encourage work-related scenarios to help give the other students another real-life perspective.
|
|
||||||||||
Microsoft Excel 2003 - Introduction / Beginning
Course Content
Lesson 1: Creating and Applying Templates
Topic 1A: Create a Workbook from a Template
Topic 1B: Create a Custom Template
Topic 1C: Working with Comments
Topic 1D: Create a Hyperlink
Topic 1E: Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
Topic 2A: Create a Chart
Topic 2B: Format Chart Items
Topic 2C: Change the Chart Type
Topic 2D: Create a Diagram
Lesson 3: Working with Graphic Objects
Topic 3A: Insert Graphics
Topic 3B: Create AutoShapes
Topic 3C: Format Graphic Objects
Topic 3D: Change the Order of Graphic Objects
Topic 3E: Group Graphic Objects
Topic 3F: Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Topic 4A: Create and Apply a Name for a Range of Cells
Topic 4B: Calculate Across Worksheets
Topic 4C: Calculate with Date and Time Functions
Topic 4D: Calculate with Financial Functions
Topic 4E: Calculate with Statistical Functions
Topic 4F: Calculate with Lookup and Reference Functions
Topic 4G: Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
Topic 5A: Sort Data Lists
Topic 5B: Filter Data Lists
Topic 5C: Create and Apply Advanced Filters
Topic 5D: Calculate with Database Functions
Topic 5E: Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
Topic 6A: Export Excel Data
Topic 6B: Publish a Worksheet to the Web
Topic 6C: Import Data from the Web
Topic 6D: Create a Web Query
--------------------------------------------------------------------------------
DAY TWO
--------------------------------------------------------------------------------
Performance-based Objectives
Customize workbooks.
Creating Macros and Pivot Tables.
Audit worksheets.
Analyze data.
Work with multiple workbooks.
Import and export data.
Structure workbooks with XML.
Course Content
Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Customize Access to Excel Commands
Topic 1D: Apply Conditional Formatting
Topic 1E: Add Data Validation Criteria
Topic 1F: Update a Workbook's Properties
Topic 1G: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures
Lesson 3: Auditing Worksheets
Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Locate Errors in Formulas
Topic 3D: Locate Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Group and Outline Data
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Develop a PivotTable Report
Topic 4E: Develop a PivotChart Report
Topic 4F: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export to Microsoft Word
Topic 6B: Import a Word Table
Topic 6C: Import Text Files
Lesson 7: Structuring XML Workbooks
Topic 7A: Develop XML Maps
Topic 7B: Import, Add, and Export XML Data
Topic 7C: Manage XML Workbooks
Topic 7D: Apply XML View Options
Campbell
Cupertino
Fremont
Gilroy
Los Altos Hills
Los Gatos
Milpitas
Morgan Hill
Mt View
Palo Alto
Redwood City
San Jose
San Mateo
Santa Clara
Santa Cruz
Saratoga
Sunnyvale
Union City
National Regions:
=====================
Training regions include:
=========================
Alabama -- Montgomery, Birmingham
Arizona -- Phoenix, Tulsa
California -- San Jose, Santa Clara, Fremont, Orange County, Costa Mesa, Irvine, San Diego
Colorado -- Denver, Colorado Springs
Connecticut -- Hartford
DC -- Washington DC
Florida -- Orlando, Fort Lauderdale, Miami, Gainesville, Jacksonville, Saint Petersburg, Tampa
Georgia -- Alpharetta, Atlanta, Augusta , Savannah, Columbus
Illinois -- Bloomington, Chicago
Indiana -- Indianapolis
Kansas --Wichita
Kentucky -- Murray, Paducah, Louisville
Maryland -- Greenbelt , Silver Spring / Baltimore
Massachusetts -- Boston, Cambridge, Springfield
Ann Arbor / Farmington Hills / Detroit, Grand Rapids
Michigan -- Detroit, Saginaw, Flint, Bay City, Midland
Minnesota -- Saint Paul, Minneapolis
Mississippi -- Gulfport, Biloxi
Missouri -- Whiteman Air Force Base, Kansas City
Nevada -- Reno, Las Vegas
New Mexico --Carlsbad, Albuquerque
New Jersey, Newark, Princeton
Pennsylvania -- Philadelphia
New York -- New York City, Buffalo, Long Island
North Carolina -- Charlotte
Ohio -- Cleveland, Columbus
Oklahoma -- Tulsa, Oklahoma City
Oregon -- Portland, Salem
Pennsylvania -- Pittsburgh
Rhode Island -- Providence
South Carolina --Columbia, Charleston
Tennessee -- Memphis, Jackson, Nashville
Texas -- Houston, Dallas, Austin, San Antonio, El Paso
Utah -- Ogden, Salt Lake City
Vermont -- Burlington
Virginia -- Virginia Beach, Norfolk, Fairfax, Dulles, McLean, Herndon
Washington -- Tacoma, Seattle, Spokane
Wisconsin -- La Crosse
Lesson 1: Creating and Applying Templates
Topic 1A: Create a Workbook from a Template
Topic 1B: Create a Custom Template
Topic 1C: Working with Comments
Topic 1D: Create a Hyperlink
Topic 1E: Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
Topic 2A: Create a Chart
Topic 2B: Format Chart Items
Topic 2C: Change the Chart Type
Topic 2D: Create a Diagram
Lesson 3: Working with Graphic Objects
Topic 3A: Insert Graphics
Topic 3B: Create AutoShapes
Topic 3C: Format Graphic Objects
Topic 3D: Change the Order of Graphic Objects
Topic 3E: Group Graphic Objects
Topic 3F: Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Topic 4A: Create and Apply a Name for a Range of Cells
Topic 4B: Calculate Across Worksheets
Topic 4C: Calculate with Date and Time Functions
Topic 4D: Calculate with Financial Functions
Topic 4E: Calculate with Statistical Functions
Topic 4F: Calculate with Lookup and Reference Functions
Topic 4G: Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
Topic 5A: Sort Data Lists
Topic 5B: Filter Data Lists
Topic 5C: Create and Apply Advanced Filters
Topic 5D: Calculate with Database Functions
Topic 5E: Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
Topic 6A: Export Excel Data
Topic 6B: Publish a Worksheet to the Web
Topic 6C: Import Data from the Web
Topic 6D: Create a Web Query
--------------------------------------------------------------------------------
DAY TWO
--------------------------------------------------------------------------------
Performance-based Objectives
Customize workbooks.
Creating Macros and Pivot Tables.
Audit worksheets.
Analyze data.
Work with multiple workbooks.
Import and export data.
Structure workbooks with XML.
Course Content
Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Customize Access to Excel Commands
Topic 1D: Apply Conditional Formatting
Topic 1E: Add Data Validation Criteria
Topic 1F: Update a Workbook's Properties
Topic 1G: Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures
Lesson 3: Auditing Worksheets
Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Locate Errors in Formulas
Topic 3D: Locate Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Group and Outline Data
Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Develop a PivotTable Report
Topic 4E: Develop a PivotChart Report
Topic 4F: Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links
Lesson 6: Importing and Exporting Data
Topic 6A: Export to Microsoft Word
Topic 6B: Import a Word Table
Topic 6C: Import Text Files
Lesson 7: Structuring XML Workbooks
Topic 7A: Develop XML Maps
Topic 7B: Import, Add, and Export XML Data
Topic 7C: Manage XML Workbooks
Topic 7D: Apply XML View Options
Campbell
Cupertino
Fremont
Gilroy
Los Altos Hills
Los Gatos
Milpitas
Morgan Hill
Mt View
Palo Alto
Redwood City
San Jose
San Mateo
Santa Clara
Santa Cruz
Saratoga
Sunnyvale
Union City
National Regions:
=====================
Training regions include:
=========================
Alabama -- Montgomery, Birmingham
Arizona -- Phoenix, Tulsa
California -- San Jose, Santa Clara, Fremont, Orange County, Costa Mesa, Irvine, San Diego
Colorado -- Denver, Colorado Springs
Connecticut -- Hartford
DC -- Washington DC
Florida -- Orlando, Fort Lauderdale, Miami, Gainesville, Jacksonville, Saint Petersburg, Tampa
Georgia -- Alpharetta, Atlanta, Augusta , Savannah, Columbus
Illinois -- Bloomington, Chicago
Indiana -- Indianapolis
Kansas --Wichita
Kentucky -- Murray, Paducah, Louisville
Maryland -- Greenbelt , Silver Spring / Baltimore
Massachusetts -- Boston, Cambridge, Springfield
Ann Arbor / Farmington Hills / Detroit, Grand Rapids
Michigan -- Detroit, Saginaw, Flint, Bay City, Midland
Minnesota -- Saint Paul, Minneapolis
Mississippi -- Gulfport, Biloxi
Missouri -- Whiteman Air Force Base, Kansas City
Nevada -- Reno, Las Vegas
New Mexico --Carlsbad, Albuquerque
New Jersey, Newark, Princeton
Pennsylvania -- Philadelphia
New York -- New York City, Buffalo, Long Island
North Carolina -- Charlotte
Ohio -- Cleveland, Columbus
Oklahoma -- Tulsa, Oklahoma City
Oregon -- Portland, Salem
Pennsylvania -- Pittsburgh
Rhode Island -- Providence
South Carolina --Columbia, Charleston
Tennessee -- Memphis, Jackson, Nashville
Texas -- Houston, Dallas, Austin, San Antonio, El Paso
Utah -- Ogden, Salt Lake City
Vermont -- Burlington
Virginia -- Virginia Beach, Norfolk, Fairfax, Dulles, McLean, Herndon
Washington -- Tacoma, Seattle, Spokane
Wisconsin -- La Crosse
About The Training Provider: Sonic Training
Sonic Training - About Sonic Training
====================
Macromedia, Adobe, Database, Programming, MS Office instructor-led, classroom training in most major U.S. cities at our location or your company location. Sonic Training blends the fun and challenge of learning into to a classroom environment. Since all we do is training, we know what works best and what doesn"t. Classes include: Macromedia Dreamweaver,...
