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 - Exploring the Excel Environment
Exploring the Excel Environment
The Microsoft Office Button
Demo - Explore the User Interface
The Ribbon
Demo - The Ribbon
Demo - Excel Options
ScreenTip Enhancements
The Quick Access Toolbar
Demo - The Quick Access Toolbar
The Microsoft Office Window Frame
The Page Layout View
The Home Tab
The Insert Tab
The Page Layout Tab
The Formulas Tab
The Data Tab
The Review Tab
The View Tab
The Developer Tab
Dialog Box Launchers
Contextual Tabs
Program Tabs
The Mini Toolbar
Galleries
The Live Preview Feature
Demo - Galleries and Live Previews
The Excel Options Dialog Box
Lesson 1 Review
Lesson 2 - Organizing Data
Organizing Data
Excel Spreadsheet Enhancements
New Workbook Dialog Box
Excel Template Enhancements
Themes
Demo - Enhancements and Themes
The Enhanced Excel Table
Table Tools
Demo - Insert a Table
Demo - Using Table Styles
Lesson 2 Review
Lesson 3 - Analyzing Data
Analyzing Data
The Conditional Formatting Button
Conditional Formatting Categories
The Conditional Formatting Rules Manager Dialog Box
Demo - Conditional Formatting
Enhanced Sort Options
Demo - Sort Data
The Enhanced Formula Bar
The Formula AutoComplete Feature
The Enhanced Function Wizard
The Function Library
The Name Manager Dialog Box
Calculation Options
Demo - Range, Name, and Formula
Lesson 3 Review
Lesson 4 - Presenting Data
Presenting Data
Enhanced Charts
Demo - Create a Chart
The SmartArt Graphics Gallery
The Enhanced Shapes Gallery
Demo - Smart Art
Enhanced PivotTables
Demo - Create a PivotTable
Demo - Create a PivotChart
Enhanced Save As Options
The Prepare Options
Demo - Mark as Final
Lesson 4 Review
Course Closure