Professor Teaches, the leading brand of training, provides realistic, interactive, and complete training for Excel 2010 Advanced. Build your skills and learn everything you need, from beginning to advanced topics. Each interactive tutorial is organized for fast and easy learning with practical exercises that build skills quickly and effectively. Find out how to create spreadsheets,
Professor Teaches, the leading brand of training, provides realistic, interactive, and complete training for Excel 2010 Advanced. Build your skills and learn everything you need, from beginning to advanced topics. Each interactive tutorial is organized for fast and easy learning with practical exercises that build skills quickly and effectively. 
Find out how to create spreadsheets, analyze data, and share information for critical business decisions!
Professor Teaches, the leading brand of training, provides realistic, interactive, and complete training for advanced topics in Excel 2010. Build your skills with Professor Teaches tutorials and learn everything you’ll need. Each interactive tutorial is organized for fast and easy learning with practical exercises that build skills quickly and effectively. Download a course and start learning today!
Excel 2010 offers a new features and improvements. It allows you to analyze, manage and share data in more ways than ever before. With the new analysis tools, you can track and highlight important data trends. Collaboration is also easier than ever.
Introductions, summaries, and end-of-chapter quiz questions all reinforce learning.
Practical exercises and examples make learning easy and step-by-step interactions help you retain the information you’ve learned.
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.
Find answers to your questions faster and easier than Help. Search and Browse are just one click away to help you locate specific lesson training you need, right when you need it.
Realistic simulations provide an accurate learning environment so your use of Excel 2010 is fast.
More than just videos, you’ll interact to perform the correct action during each exercise for better learning & retention.
Hundreds of learning lessons for beginner through advanced subjects are included. No other training is more complete.
Chapters are organized into specific learning objectives–easily available from the main menu.
Practice in a Realistic Simulation of the Software Hundreds of Learning Topics 4 to 8 Hours of Training per Course Realistic Simulations Beginner to Advanced Topics Self-Paced Learning Objectives Introductions and Summaries Interactive Exercises Professional Voice Narration End-of-Chapter Quiz Questions Checkmarks for Completed Topics Glossary, Index, and Search Professor Answers for Instant Training Chapter 1: Using Formatting and Functions Applying Formatting to Numbers Creating Custom Number Formats Applying Conditional Formats Using Formulas in Conditional Formats Absolute and Relative References Naming a Range Using a Named Range in a Formula Using Lookup Functions IF Functions Chapter 2: Using Templates and Workbooks Applying a Template Using a Template Creating a New Template Editing a Template Linking Between Workbooks Importing Data from Text Files Importing Data from Other Applications Importing an HTML Table Publishing Data to the Web Chapter 3: Working with Data What is a List? Validating Data Entries Sorting Data Subtotaling and Outlining Data Extracting Data with Filters Using Advanced Filters Using Query Querying the Web Using XML to Share Data Chapter 4: Analyzing Data Using PivotTable Add info about Slicers Managing PivotTable Reports Creating PivotChart Reports Using Charts and Trendlines Working with Scenarios Chapter 5: Using Macros and Auditing Tools What is a Macro? Recording a Macro Running a Macro Editing a Macro Auditing Workbooks Tracing Errors Chapter 6: Sharing Workbooks Creating a Shared Workbooks Consolidating Data Protecting Columns Protecting Worksheets Protecting Worksheet Content Protecting Cells Assigning a Password Tracking Changes Adding Comments Preparing a Workbook 
Professor Answers sits on your desktop–one easy click away!
