SkillPath Seminars
Call us: 1-800-873-7545
Learn to master Excel 2007 by watching a master reveal how easy it is to use the most popular and practical features of the world’s most powerful spreadsheet program. Start wherever and whenever you want—these 50 mini-programs add up to over 5 1/2 hours of training for beginning, intermediate and advanced Excel users.

Beginning Level Topics
  • Customizing AutoFill Options – Runtime: 7:45
  • Customizing the QAT – Runtime: 5:30
  • Entering Formulas & Functions – Runtime: 6:01
  • Entering Data Efficiently – Runtime: 7:34
  • Exploring Excel Options – Runtime: 7:49
  • Exploring Status Bar Tools – Runtime: 4:42
  • Formatting & Aligning Cells – Runtime: 6:24
  • Formatting with Cell Styles – Runtime: 6:06
  • Getting Started in Excel 2007 – Runtime: 5:49
  • Grouping Worksheets – Runtime: 5:50
  • Naming Cells and Ranges – Runtime: 6:33
  • Pasting Your Data – Runtime: 5:27
  • Printing Your Worksheet – Runtime: 6:16
  • Sorting Your Data – Runtime: 7:25
  • Using Paste Special – Runtime: 5:49
  • Working with Templates – Runtime: 5:25
Intermediate Level Topics
  • Annotating Your Workbook – Runtime: 8:22
  • Applying Themes – Runtime: 4:27
  • Bringing Charts to Life – Runtime: 7:27
  • Calculating Time – Runtime: 8:15
  • Charting Data – Runtime: 7:23
  • Conditional Formatting – Runtime: 8:43
  • Consolidating Data – Runtime: 5:19
  • Counting Functions – Runtime: 6:07
  • Creating Subtotals – Runtime: 6:45
  • Decision-Making Formulas – Runtime: 5:04
  • Defining Named Constants – Runtime: 6:47
  • Editing Charts – Runtime: 6:41
  • Extracting Text Strings – Runtime: 6:44
  • Filtering Your Data – Runtime: 6:32
  • Introducing Excel Tables – Runtime: 6:50
  • Joining Text Strings – Runtime: 6:18
  • Pasting Links Between Workbooks – Runtime: 7:52
  • Preventing Formula Errors – Runtime: 6:21
  • Protecting Your Worksheet – Runtime: 5:01
  • Removing Duplicate Records – Runtime: 6:58
  • Saving Time with Shortcuts – Runtime: 9:17
  • Summing Functions – Runtime: 6:34
  • Validating Your Data – Runtime: 7:26
Advanced Level Topics
  • Auditing Formulas – Runtime: 6:43
  • Grouping & Charting in Pivot Tables – Runtime: 5:50
  • Importing External Data – Runtime: 7:31
  • Introducing Pivot Tables – Runtime: 8:23
  • Looking Up Information – Runtime: 6:39
  • Performing "What-if" Analysis – Runtime: 5:29
  • Producing Financial Reports – Runtime: 7:21
  • Solving Problems with Goal Seek – Runtime: 5:57
  • Using Conditional Sum Wizard – Runtime: 7:36
  • Using Lookup Wizard – Runtime: 5:50
  • Using New PivotTable Features – Runtime: 7:46

dvd-rom; 1 DVD-ROM
ISBN: 9781608110896

PRICE: $99.95