Login






Shopping Cart

VirtueMart
Your Cart is currently empty.

Policies
PrintE-mail

Microsoft Excel 2007 : Level 2 Training

  		Microsoft Excel 2007 : Level 2 Training
View Full-Size Image
Microsoft Excel 2007 : Level 2 Training Online $175.00  $99.00

:

Microsoft Excel 2007 : Level 2 Training DVD CBT $175.00  $99.00

:


Microsoft Office Excel 2007 : Level 2


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.

Package Includes

  • The Online course features 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
  • *This product options are only available in the DVD/CD CBT format and not available in the On-Line Delivery.

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 were.
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.

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
    • vLesson 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
    • vLab - 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
    • vLab - 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
    • vLab - 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
    • VLab - Calculating Sums, Counts, and Averages on Filtered Data
  • Database Function
  • Subtotals
  • Demo - Subtotals
    • VLab - Applying Subtotals to a Sorted List
  • Lesson 8 Review
  • Course Closure

You may also be interested in this/these product(s)

Microsoft Excel 2007 Training
Microsoft Excel 2007 Training
$299.00
$199.00
You Save: $100.00 		Microsoft Office 2007 Training
Microsoft Office 2007 Training
$795.00
$595.00
You Save: $200.00 		Microsoft Excel 2007 : Level 1 Training
Microsoft Excel 2007 : Level 1 Training
$175.00
$99.00
You Save: $76.00 		Microsoft Excel 2007 : Level 3 Training
Microsoft Excel 2007 : Level 3 Training
$175.00
$99.00
You Save: $76.00


Last Updated: Friday, 30 July 2010 17:53
RocketTheme Joomla Templates