PN-excel2k7
We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.
Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the new Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Office Excel 2007, combined with Excel Services, a new technology that will ship with Microsoft Office SharePoint Server 2007, provides significant improvements for sharing data with greater security. You can share sensitive business information more broadly with enhanced security with your coworkers, customers, and business partners. By sharing a spreadsheet using Office Excel 2007 and Excel Services, you can navigate, sort, filter, input parameters, and interact with PivotTable views directly on the Web browser.
Expert Trainer
Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 10 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000,2003 and the new Exchange 2007. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.
Course Features:
* Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
* PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
* Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
* Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
* Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
* Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
* Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
* Labs
Gain hands-on knowledge through watching the instructor actually perform the lab in a video-based demonstration. Following the conclusion of the lab, students can mimic the previously performed actions and apply them in the \"real world\".
* Certificate of Completion
Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
Microsoft Excel 2007 : Level 1 Training
Product Code:PN-excel2k71
List Price
Sale Price
Quantity
$129.00 $99.00
Product Options:
Program Licensing
Microsoft Excel 2007
Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.
Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the new Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Office Excel 2007, combined with Excel Services, a new technology that will ship with Microsoft Office SharePoint Server 2007, provides significant improvements for sharing data with greater security. You can share sensitive business information more broadly with enhanced security with your coworkers, customers, and business partners. By sharing a spreadsheet using Office Excel 2007 and Excel Services, you can navigate, sort, filter, input parameters, and interact with PivotTable views directly on the Web browser.
Our reputation speaks for itself! See what others are saying... Testimonials
Package Includes:
* 1 DVD Featuring live instructor-led classroom sessions with full audio, video and demonstration components
* Step-by-step hands-on-labs Try out one of our labs...
* Focused on practical solutions to real-world development problems
* Free 1 Year Upgrade Policy
OURexpertText
Sandra Batakis
Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 10 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000,2003 and the new Exchange 2007. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.
Course Features:
* Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
* PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
* Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
* Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
* Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
* Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
* Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.
* Certificate of Completion
Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
Course Outline
Lesson 1 - Exploring the Excel Environment
Exploring the Excel Environment
Spreadsheets
Microsoft Office Excel 2007
The Excel Application Window
Worksheets
Workbooks
The Microsoft Office Button
Demo - Explore User Interface
Lab - Explore User Interface
The Ribbon
Demo - Ribbon
Lab - Exploring the Ribbon
The Quick Access Toolbar
Demo - Quick Access Toolbar
The Microsoft Office Window Frame
The Home Tab
The Insert Tab
The Page Layout Tab
The Formulas Tab
The Data Tab
The Review Tab
The View Tab
Dialog Box Launchers
The Excel Help Window
Demo - Help
Lab - Obtaining Help
The Excel Help Toolbar
Customization Options
Lab - Customizing the Quick Access Toolbar
Lesson 1 Review
Lesson 2 - Working with an Excel Worksheet
Working with an Excel Worksheet
Mouse Navigation Options
Demo - Navigation
Lab - Navigation in Excel
The New Workbook Dialog Box
The Mini Toolbar
Demo - Enter Data
Lab - Selecting an Entering Data
File Formats
Demo - Saving
Lab - Saving a Workbook
Lab - Converting an XLS Workbook to an XLSX Workbook
Lab - Saving a Workbook in XLS Format
Lesson 2 Review
Lesson 3 - Modify a Worksheet
Modify a Worksheet
Undo and Redo
Demo - Editing
Auto Fill
Demo - Auto Fill
The Find Command
The Replace Command
Demo - Find and Replace
Lab - Searching for Data in a Worksheet
Cell References
Cell Names
Demo - Insert cells
The Go To Command
Lab - Locating a Cell in a Worksheet
The Spelling Dialog Box
Demo - Spell Check
Lab - Spell Checking a Worksheet
Lesson 3 Review
Lesson 4 - Performing Calculations
Performing Calculations
Excel Formulas
The Formula Bar
Demo - Formula
Lab - Creating Basic Formulas
The Order of Operations
Functions
Formula AutoComplete
Demo - Functions Lab - Calculating with other Basic Functions
Relative References
Demo - Coping Formulas and Functions
Lab - Coping Formulas and Functions
Absolute Reference
Demo - Absolute
Lab - Creating an Absolute Reference
Mixed References
Lab - Creating a Mixed Reference
Lesson 4 Review
Lesson 5 - Formatting a Worksheet
Formatting a Worksheet
Fonts
Demo - Text to Column
Lab - Converting Text to Columns
Demo - Fonts
Lab - Modifying Fonts
The Format Cells Dialog Box
Lab - Adding Borders and Colors to Cells
Lab - Transposing Data While Pasting Content
Demo - Column Widths and Row Height
Lab - Changing Column Width and Row Height
Live Preview
Number Formats
Lab - Applying Number Formats
Lab - Aligning Cell Contents
Demo - Merge and Split Cells
Lab - Merging Cells
Demo - Format Number
Demo - Find and Replace Formats
Lab - Replacing Formats
Autoformats
Lab - Applying an AutoFormat
Cell Styles
Demo - Styles
Lab - Applying Cell Styles
Themes
Lab - Applying Themes
Lesson 5 Review
Lesson 6 - Developing a Workbook
Developing a Workbook
Worksheet Tabs
Demo - Format Worksheet Tabs
Lab - Formatting Worksheet Tabs
Insert and Delete Worksheets
Demo - Insert and Delete Sheets
Lab - Inserting and Deleting Worksheets
Lab - Copying and Pasting Worksheet
Lesson 6 Review
Lesson 7 - Printing Workbook Contents
Printing Workbook Contents
Headers
Demo - Print Titles
Footers
Demo - Headers and Footers
Lab - Creating a Header and Footer Header Dialog Box
Page Margins
Lab - Setting Page Margins
Page Orientation
Demo - Margins Orientation
Lab - Changing Page Orientation
Page Breaks
Demo - Page Breaks
Lab - Setting Page Breaks
Lesson 7 Review
Lesson 8 - Customizing Layout
Customizing Layout
Split Worksheet
Demo - Window Split
Lab - Splitting a Worksheet
Freeze and Unfreeze
Lab - Freezing and Unfreezing Rows and Columns
Demo - Arrange
Lab - Arranging Worksheets in New Windows
Lab - Hiding and Unhiding Worksheet
Lesson 8 Review
Closure
Level 2
Lesson 1 - Enhancing Workbooks
Enhancing Workbooks Personalize Options
Demo - Excel Options
Lab - Customizing the Excel Interface
Color Scheme
Modified Excel Environment in Windows Vistas (Black)
Built-In Theme Options
Create New Theme Colors Options
Create New Theme Fonts Options
Demo - Custom Worksheet
Lab - Customizing an Excel Worksheet
Lab - Enhancing Worksheets using Themes
Comments
Demo - Comments
Lab - Manipulating Comments
Hyperlinks
Demo - Creating Hyperlinks
Lab - Creating a Hyperlink to an Existing File
Lab - Editing and Removing Hyperlinks
Research Task Pane
Demo - Research
Lab - Using Web-Based Research Tools
Lesson 1 Review
Lesson 2 - Creating Workbooks Using Templates
Creating Workbooks Using Templates The Expense Template
Demo - Using Templates
Lab - Creating a Workbook from a Template
Types of Excel Templates
An Example of a Custom Template
Demo - Creating Templates
Lab - Creating a Custom Template
Lesson 2 Review
Lesson 3 - Organizing Data Using Tables
Organizing Data Using Table sAn Excel Table
Demo - Create Table
Lab - Creating a Table Using the Default Table Style
Demo - Table Styles
Lab - Creating a Table Using the Desired Table Style
Lab - Modifying a Table
Lab - Formatting a Table
Lab - Creating a Custom Table Style
Lesson 3 Review
Lesson 4 - Presenting Data Using Charts
Presenting Data Using Charts Create A Chart
Demo - Create A Chart
Lab - Modifying a Table
Modify Charts
Lab - Modify a Chart
Demo - Changing a Chart Type
Format Charts
Lab - Formatting a Chart
Lab - Creating a Chart Template
Share Charts
Demo - Move Chart
Lab - Sharing a Chart
Lesson 4 Review
Lesson 5 - Analyzing Data Using PivotTables and PivotCharts
Analyzing Data Using PivotTables and PivotChartsSource Data for a PivotTable
Summarizing Data with a PivotTable
A PivotTable Report
Demo - Create Pivot
Lab - Performing Calculations Using a PivotTable
A PivotChart
Demo - Pivot Chart
Lab - Creating a Pivot Chart
An Existing PivotTable and Corresponding PivotChart
Demo - Modify Pivot
Lesson 5 Review
Lesson 6 - Enhancing Visual Appeal Using Graphic Objects
Enhancing Visual Appeal Using Graphic Objects
Graphic Objects
Demo - Insert and Modify Picture
Lab - Inserting a Picture in a Worksheet
Lab - Modifying Pictures
Lab - Applying Picture Shape to a Graphic
Lab - Drawing and Modifying Shapes
Lab - Rotating Shapes
Layering
Lab - Layering Graphics
Demo - Smart Art
Lab - Inserting a SmartArt Graphic
Lab - Modifying a SmartArt Graphic
Grouping
Lab - Grouping Objects
Demo - Clipart
Lesson 6 Review
Lesson 7 - Calculating Data with Advanced Formulas
Calculating Data with Advanced Formulas Range Names
Demo - Create Name
Lab - Naming a Range
Lab - Renaming a Range
Lab - Using Named Regions in Formula Calculations
Lab - Adding Columns to a Worksheet Containing Page Names
Three-Dimensional Cell References
Demo - Calculate Data Across
Lab - Comparing a 360-Day vs. 365-Day Date Calculation System
Date and Time Function
Demo - Dates
Financial Function
Demo - Convert Text To Columns
Lab - Using Formulas to convert text data to individual columns
Demo - Statistical Function
Demo - Upper and Lower
Lab - Using the UPPER, LOWER, and PROPER Text Functions
Lookup and Reference Function
Demo - Hlookup
Lab - Looking up Part Numbers with the HLOOKUP Function
Lab - Looking up Part Numbers with the VLOOKUP Function
Logical Function
Demo - If Statement
Lab - Performing Conditional Calculations with SUMIFS, COUNTIFS, and AVGIFS Functions
Lab - Performing Conditional Calculations with SUMIF, COUNTIF, and AVERAGIF Functions
Lab - Calculating Sales Honors with IF Function and the AND Function
Lab - Calculating Sales Honors with IF Function and the OR Function
Lab - Eliminating Calculation Errors with the IFERROR Function
Demo - View and Print Formulas
Lab - Printing a Worksheet with the Formulas Displayed
Lesson 7 Review
Lesson 8 - Sorting and Filtering Data Sorting and Filtering Data Single-Level Sort in Ascending Order
Multiple-Level Sort in Both Ascending and Descending Order
Demo - Sort Data
Lab - Sorting Data
Filter
Lab - Filtering Data
Lab - Calculating Sums, Counts, and Averages on Filtered Data
Database Function
Subtotals
Demo - Subtotals
Lab - Applying Subtotals to a Sorted List
Lesson 8 Review
Course Closure
Level 3
Lesson 1 - Steamlining Workflow
Steamlining Workflow
Macro
Record Macro Procedure Reference
Demo - Macros
Editing Macros
Macro Settings
Demo - Edit Macros
Conditional Formatting
Conditional Formats
Conditional Formatting Procedure Reference
Demo - Conditional Formats
Data Validation
Data Validation Procedure Reference br /> Workbook Properties
Demo - Data Validation
Lesson 1 Review
Lesson 2 - Collaborating with Others
Collaborating with Others
The Collaboration Process
File Protection
The Changes Group
The Protect Workbook Options
Demo - Protection
Sharing Workbooks
Shared Workbooks
Sharing Workbooks Procedure Reference
Demo - Share Workbook
Revision Tracking
Revision Tracking Procedure Reference
The Highlight Changes Dialog Box
The Accept/Reject Changes Option
Demo - Changes
Merge Workbooks
Demo - Merge Workbooks
Digital Certificates
Digital Signatures
Demo - Digital Signature
Demo - Mark As Final
Lesson 2 Review
Lesson 3 - Auditing Worksheets
Auditing Worksheets
Tracer Arrows
Cell Precedents
Cell Dependents
Demo - Tracing
Invalid Data
Error Checking
Demo - Invalid Formulas
The Watch Window
Demo - Watch and Evaluate
Formula Evaluation
Outline
Demo - Group and Subtotals
Lesson 3 Review
Lesson 4 - Analyzing Data
Analyzing Data
Trendlines
Trendline Procedure Reference
Demo - Trendline
Scenarios
The Scenario Manager Dialog Box
Demo - Scenario
The Solver Parameters Dialog Box
Demo - Solver
Analysis ToolPak
Demo - Data Analysis
Lesson 4 Review
Lesson 5 - Working with Multiple Workbooks
Working with Multiple Workbooks
Workspaces
Demo - Workspace
Data Consolidation
The Consolidate Dialog Box
Link Cells
Demo - Consolidate Data
Demo - Edit Links
Lesson 5 Review
Lesson 6 - Importing and Exporting Data
Importing and Exporting Data
File Export
Demo - Export to Word
File Import
The Get External Data Group
Demo - Import Delimited Text File
Delimited Text Files
Lesson 6 Review
Lesson 7 - Using Excel with the Web
Using Excel with the Web
File Publish
The Publish As Web Page Dialog Box
Demo - Publish Data
Import Data From Web
Demo - Import Data from Web
The New Web Query Dialog Box
Lesson 7 Review
Lesson 8 - Structuring Workbooks with XML
Structuring Workbooks with XML
XML
XML Uses
XML Components
XML Schema
XML Schemas
XML Map
XML Maps
The XML Source Task Pane
The XML Group
Demo - XML Map
Demo - XML Data
Lesson 8 Review
Course Closure
