Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 15 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, 2007 and the
new Exchange 2010. She has delivered numerous Microsoft, CompTIA and
Adobe classroom-based as well as online Boot Camps and Seminars across
the United States.
Explore our Training Features
Click on a Feature for more information! (popups must be enabled)
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