Courseware and Training Materials

What's included?
What’s included?
Available for delivery as a download from our web server or provided on CD, this courseware package includes the following resources to make your trainer’s life much, much easier.

This courseware package includes:

	Student Manual. Fully customisable. May be opened in any wordprocessor and changed to meet your exact needs.
	Student workbook. Fully customisable. Additional book includes series of practical tasks and review questions.
	Student workbook exercises. Fully customisable. Sample exercises to accompany the student workbook.
	Trainer manual. Fully customisable with additional information for trainers.
	Timetable and lesson plans. Fully customisable. Detailed timetable and plans ensure you deliver the best possible course.
	PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

To get started, just open this ‘Microsoft Excel 2010′ training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered ‘off-the-peg’ and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.

Course outline
Course outline

Course contents: Foundation Level

• Starting Out — What is Microsoft Office Excel 2010? — What’s New in Excel 2010? — Opening Excel — Interacting with Excel — Closing Excel — Step-By-Step — Skill Sharpener
• About Workbooks — Creating a New Workbook — Opening a Workbook — Saving a Workbook — About Excel File Types — Closing a Workbook — Step-By-Step — Skill Sharpener
• Exploring your Workbook — Using Worksheets — The Active Cell — Selecting Cells — Exploring a Worksheet — Using Zoom — Step-By-Step — Skill Sharpener
• Getting Help with Excel — Opening Help — Using the Help Screen — The Help Toolbar — Searching for Help — Online Help vs. Offline Help — Using the Table of Contents — Getting Help in a Dialog Box — Step-By-Step — Skill Sharpener
• The Quick Access Toolbar and File Menu — The Default QAT Commands — Adding Commands — Removing Commands — Customizing the Toolbar — Using the File (Backstage) Menu — Step-By-Step — Skill Sharpener
• The Home Tab — Understanding Tabs and Groups — Clipboard Commands — Font Commands — Alignment Commands — Number Commands — Styles Commands — Cells Commands — Editing Commands — Step-By-Step — Skill Sharpener
• The Insert Tab — Tables Commands — Illustrations Commands — Charts Commands — Sparklines Commands — Filter Commands — Links Commands — Text Commands — Symbol Commands — Step-By-Step — Skill Sharpener
• The Page Layout Tab — Themes Commands — Page Setup Commands — Scale to Fit Commands — Sheet Options Commands — Arrange Commands — Step-By-Step — Skill Sharpener
• The Formulas Tab — The Functions Library — Defined Names Commands — Formula Auditing Commands — Calculation Commands — Step-By-Step — Skill Sharpener
• The Data Tab — Get External Data Commands — Connections Commands — Sort and Filter Commands — Data Tools Commands — Outline Commands — Step-By-Step — Skill Sharpener
• The Review Tab — Proofing Commands — Language Commands — Comments Commands — Changes Commands — Step-By-Step — Skill Sharpener
• Working with Excel — Columns, Rows, Cells, and Ranges — Creating Worksheet Labels — Entering and Deleting Data — Printing your Worksheet — Step-By-Step — Skill Sharpener
• Basic Excel Features — AutoFill — AutoSum — AutoComplete — Working with Basic Formulae — Step-By-Step — Skill Sharpener
• Moving your Data — Dragging and Dropping Cells — How to Cut, Copy, and Paste Cells — How to Cut, Copy, and Paste Multiple Cells — Using the Clipboard — Using Paste Special — Inserting and Deleting Cells, Rows, and Columns — Using Undo, Redo, and Repeat — Step-By-Step — Skill Sharpener
• Smart Tags and Options Buttons — What are Smart Tags? — Setting Smart Tag Options — The Error Option Button — The AutoFill Option Button — The Paste Option Button — Step-By-Step — Skill Sharpener
• Editing Tools — Using AutoCorrect — Using Spell Check — Using Find and Replace — Adding Comments — Step-By-Step — Skill Sharpener
• Modifying Cells and Data — Changing the Size of Rows or Columns — Adjusting Cell Alignment — Rotating Text — Creating Custom Number and Date Formats — Step-By-Step — Skill Sharpener
• Cell Formatting — Conditional Formatting — The Format Painter — Cell Merging and AutoFit — Find and Replace Formatting — Step-By-Step — Skill Sharpener
• Enhancing a Worksheet’s Appearance — Adding Patterns and Colors — Adding Borders — Working with Styles — Working with Themes — Step-By-Step — Skill Sharpener
• Working with Charts, Part 1 — Creating a Chart — Styling Charts with the Design Tab — Modifying Charts with the Layout Tab — Additional Styling with the Format Tab — Manipulating a Chart — Step-By-Step — Skill Sharpener
• Working with Charts, Part 2 — Changing the Type of Chart — Changing the Source Data — Working with the Chart Axes and Data Series — Saving a Chart as a Template — Absolute and Relative Cell References — Step-By-Step — Skill Sharpener
• Using the View Tab — Using Normal View — Using Full Screen View — Using Page Layout View — Page Break Preview — Step-By-Step — Skill Sharpener
• Managing a Single Window — Creating a New Window — Hiding a Window — Unhiding a Window — Freezing a Pane — Splitting a Worksheet — Step-By-Step — Skill Sharpener
• Managing Multiple Windows — Switching Between Open Workbooks — Arranging Workbooks — Comparing Workbooks Side by Side — Synchronous Scrolling and Resetting a Window — Saving a Workspace — Step-By-Step — Skill Sharpener
• Printing your Workbook — Print Commands — Print Preview — Using Basic Print Options — Other Print Options — Setting Printer Properties — Step-By-Step — Skill Sharpener
• Case Study
• Review Questions

Course contents: Intermediate Level

• Using Windows Explorer within Excel — Navigating using Windows Explorer — Performing Basic Tasks with Windows Explorer — Using Views with Windows Explorer — Using the Windows Explorer Navigation Pane — Step-By-Step — Skill Sharpener
• Saving your Files — Using AutoRecover — Publishing to PDF or XPS — Protecting an Entire Workbook — Protecting the Current Sheet — Opening and Converting Files in XLS Format — Saving Spreadsheets in XLS Format — Step-By-Step — Skill Sharpener
• Using File Management Tools, Part One — Marking a Workbook as Final — Encrypting a Workbook — Digitally Signing a Workbook — Managing File Properties — Managing Versions — Step-By-Step — Skill Sharpener
• Using File Management Tools, Part Two — Viewing a Summary of Issues — Using the Document Inspector — Using the Accessibility Checker — Using the Compatibility Checker — Setting Compatibility Options — Step-By-Step — Skill Sharpener
• Using Formulas in Excel — Understanding Relative and Absolute Cell References — Basic Mathematical Operators — Using Formulas with Multiple Cell References — Understanding the Formula Auditing Buttons — Fixing Formula Errors — Displaying and Printing Formulas — Step-By-Step — Skill Sharpener
• Exploring Excel Functions — What are Functions? — Finding the Right Function — Inserting Functions — Some Useful and Simple Functions — Step-By-Step — Skill Sharpener
• Using Functions in Excel — Using the IF Function — Working with Nested Functions — Breaking up Complex Functions — Using Functions and AutoFill to Perform Difficult Calculations — Step-By-Step — Skill Sharpener
• Working with Names and Ranges — What Are Range Names? — Defining and Using Range Names — Defined Names Commands — Selecting Nonadjacent Ranges — Using AutoCalculate — Step-By-Step — Skill Sharpener
• Working with Array Formulas — What are Array Formulas? — Defining Basic Array Formulas — Using Functions with Array Formulas — Using the IF function in Array Formulas — Step-By-Step — Skill Sharpener
• Working with Tables — What is a Table? — Creating Tables — Modifying Tables — The Table Tools Tab — About the Total Row — Step-By-Step — Skill Sharpener
• Working with Records and Fields — What are Records and Fields? — Adding Fields by Inserting Columns — Adding Records by Inserting Rows — Quickly Adding Records to a Data table — Deleting Records or Fields — Cleaning up Duplicate Records — Step-By-Step — Skill Sharpener
• Working with Tables and Filters — Sorting Data in a Table — What is an AutoFilter? — Custom AutoFilters — Using an Advanced Filter — Copying Filtered Records — Step-By-Step — Skill Sharpener
• Using Excel as a Database — Filtering with Wildcard Characters — Validating Your Data — Data Validation using Lists — Data Validation using Formulas — What are Database Functions? — Step-By-Step — Skill Sharpener
• Research Tools — Checking Spelling — Using the Research Pane — Using the Thesaurus — Using the Translator — Setting Your Language — Step-By-Step — Skill Sharpener
• Using Themes — Changing the Theme — Customizing Theme Colors — Customizing Theme Fonts — Customizing Theme Effects — Managing Theme Files — Step-By-Step — Skill Sharpener
• Adding Text Boxes — Drawing a Text Box — Using the Drawing Tools Tab — Common Text Box Editing Tasks — Inserting WordArt — Common WordArt Editing Tasks — Step-By-Step — Skill Sharpener
• Inserting Pictures and ClipArt — Adding a Picture from a File — Adding ClipArt — Adding a Screenshot — Overview of the Picture Tools Tab — Overview of the Pictures Mini Toolbar — Step-By-Step — Skill Sharpener
• Editing Pictures — Resizing Pictures — Moving Pictures — Cropping Pictures — Rotating and Flipping Pictures — The Format Picture Dialog — Step-By-Step — Skill Sharpener
• Inserting SmartArt — Inserting SmartArt — Adding Text — Adding Photos — About the SmartArt Tools Tabs — Editing SmartArt — Step-By-Step — Skill Sharpener
• Formatting SmartArt — Changing the Layout — Choosing a Color — Choosing a Style — Resetting the Graphic — Converting the Graphic — Step-By-Step — Skill Sharpener
• Adding Symbols, Equations, and Shapes — Inserting a Symbol or Special Character — Inserting an Equation — Using the Equation Tools Tab — Drawing Shapes — Common Shape Editing Tasks — Step-By-Step — Skill Sharpener
• SparkLines — What are SparkLines? — Adding Sparklines — About the SparkLine Tools Tab — Editing SparkLine Data — Removing Sparklines — Step-By-Step — Skill Sharpener
• Editing SparkLines — Showing and Hiding Data — Changing the Style — Changing the SparkLine and Marker Color — Setting Options — Step-By-Step — Skill Sharpener
• Case Study
• Review Questions

Course contents: Advanced Level

• Outlining and Grouping Data — Using Automatic Outlining — Displaying and Collapsing Levels — Grouping Data Manually — Creating Subtotals — Step-By-Step — Skill Sharpener
• Exploring Scenarios — What is a Scenario? — Creating a Scenario — Saving Multiple Scenarios — Merging Scenarios — Creating a Scenario Summary Report — Step-By-Step — Skill Sharpener
• Using Data Analysis Tools — Enabling Data Analysis Tools — An Overview of the Available Add-In Tools — Using a One or Two Input Data Table — Using Goal Seek — Using Solver — Step-By-Step — Skill Sharpener
• Excel and Hyperlinks — What is a Hyperlink? — Inserting Hyperlinks — Modifying Hyperlinks — Using Hyperlinks in Excel — Step-By-Step — Skill Sharpener
• PivotTables — What is a PivotTable? — Creating a PivotTable — Using the PivotTable – Tools Tabs — Adding and Removing Information with the Field List — Changing the Field List Layout — Expanding and Collapsing Data — Pivoting Data — Step-By-Step — Skill Sharpener
• Working with PivotTable Data — Filtering Data — Sorting Data — Grouping Data — Refreshing Data — Step-By-Step — Skill Sharpener
• Formatting a PivotTable — Modifying Fields, Labels, and Values — Using the Layout Group — Changing PivotTable Style Options — Applying a Style to the PivotTable — Manually Formatting a PivotTable — Step-By-Step — Skill Sharpener
• Advanced PivotTable Tasks — Creating a PivotTable Based on External Data — Creating a Slicer — Slicer Tool Options — Using PowerPivot — Step-By-Step — Skill Sharpener
• Using the Classic Layout — Creating an Empty PivotTable Frame — Switching an Existing PivotTable to Classic Layout — Adding Data — Pivoting Data — Step-By-Step — Skill Sharpener
• Advanced Functions — Creating a PivotChart — Adding Data to Your Chart — Pivoting Chart Data — Step-By-Step — Skill Sharpener
• Using the PivotChart Tools Tabs — Using the Design Tab — Using the Layout Tab — Using the Format Tab — Using the Analyze Tab — Step-By-Step — Skill Sharpener
• Formatting a PivotChart — Renaming Fields — Changing the Chart Type — Applying a Chart Style — Manually Formatting Chart Elements — Changing the Layout of Chart Elements — Step-By-Step — Skill Sharpener
• Advanced PivotChart Tasks — Creating a PivotChart Based on External Data — Creating a Slicer — Scenario PivotCharts — PowerPivot and PivotCharts — Step-By-Step — Skill Sharpener
• Using Advanced Functions — Using Financial Functions — Understanding Logical Functions — Using Logical Functions — Using IFERRROR with Array Formulas — Step-By-Step — Skill Sharpener
• Using the VLOOKUP Function — Using VLOOKUP to Find Data — How to Find an Exact Match with VLOOKUP — Finding an Approximate Match with VLOOKUP — Using VLOOKUP as an Array Formula — Step-By-Step — Skill Sharpener
• Using Custom AutoFill Lists — What is an AutoFill List? — Creating a Custom AutoFill List — Using a Custom AutoFill List — Modifying a Custom AutoFill List — Step-By-Step — Skill Sharpener
• Linking, Consolidating, and Combining Data — Linking Workbooks — Consolidating Workbooks — Combining Worksheets — Pivoting Consolidated Data — Step-By-Step — Skill Sharpener
• Case Study
• Review Questions

Course contents: Expert Level

• Saving Workbooks as Web Pages — Saving a Workbook as a Web Page — Saving a Worksheet as a Web Page — Saving a Chart as a Web Page — Saving a Range as a Web Page — Step-By-Step — Skill Sharpener
• Getting Data from the Internet — Importing data from an External Data Source — Creating a Web Query — Saving a Web Query — Refreshing a Web Query — Step-By-Step — Skill Sharpener
• Creating and Using Shared Workbooks — Sharing a Workbook — Opening and Editing a Shared Workbook — Tracking Changes — Resolving Conflicts in a Shared Workbook — Step-By-Step — Skill Sharpener
• Creating a Basic Macro — Recording Macros — Editing a Macro — Playing a Macro — Understanding Macro Security — Step-By-Step — Skill Sharpener
• More Macro Tasks — Recording a Relative Reference Macro — Running a Relative Reference Macro — Assigning a Keystroke to a Macro — Copying a Macro from a Workbook or Template — Step-By-Step — Skill Sharpener
• Visual Basic and Macros — Opening the Visual Basic Editor — Understanding the Visual Basic Editor — Adding Code to your Macro — Adding Comments to VBA Code — Step-By-Step — Skill Sharpener
• Advanced Visual Basic Tasks — Declaring Variables — Prompting for User Input — Iteration over a Range — Using IF Then Else Statements — Step-By-Step — Skill Sharpener
• Using Objects — Creating New Embedded Objects — Embedding Existing Files — Editing Embedded Objects — Embedding Parts of Files — Step-By-Step — Skill Sharpener
• Using Excel in Word — Inserting Excel Data in Word — Linking Excel Data in a Word Document — Modifying Excel Data after Insertion — Inserting an Excel Chart into a Word Document — Step-By-Step — Skill Sharpener
• Using Excel and Access — Understanding Data Connections — Linking an Excel Workbook to an Access Database — Importing Table, PivotTable, and PivotChart Data from Access — Transforming an Excel Workbook into an Access Database — Step-By-Step — Skill Sharpener
• Using Excel with other Programs and Files — Opening an Excel File in a Different Format — Importing Data from a Text File — Importing Data from External Data Sources — Step-By-Step — Skill Sharpener
• Case Study
• Review Questions

FAQs

No FAQs specifically for this title have been uploaded yet. Please check out the Product FAQs for general questions about the products.