Microsoft Excel 2010

$495.00

SKU: GC1702 Categories: ,

Microsoft Excel 2010

Our Microsoft Excel 2010 training materials provides you with a fully-customizable package of courseware content for delivering Microsoft Office training to your employees and/or students. Everything you need to run the course is included, just add trainer!


DOWNLOAD SAMPLE

All courseware print licences are perpetual – buy once and use forever!

  • Complete. Includes content at Foundation, Intermediate and Advanced levels.
  • Fully customizable. Sold on a site licence basis, you can tailor ALL content to meet specific learning or corporate requirements.
  • Digital download. Content is available to download after purchase.
  • Proven. Our course materials are used in hundreds of training centres around the world. Every course is fully beta tested and validated in the classroom before undergoing a full production release.
  • Simple… No need to invest in expensive DTP applications – all files are easily editable in any word processor.
  • Print on demand. You only need to print exactly what you need, when you need it.
  • Totally flexible. Courses can be modified to meet specific requirements. Sections can be removed. New content added. One or more titles can be combined. Whatever your training requirements, our courseware can help you meet that need.
  • Unlimited users. Content is sold on a site licence basis. You can train as many staff or employees at that location as you like. Forever!
  • Buy once. Use forever! You’re buying a perpetual licence. One payment gives you an unlimited site licence for use as long as you need it.
  • No limits! Unlike some content providers, our licence enables you to reprint the courseware as many times as you like. 1 student or 100,000. No limits…


DOWNLOAD SAMPLE

Student manual

Fully customisable. May be opened in any word processor and changed to meet your exact needs.

Student workbook

Fully customisable. Additional book includes series of practical tasks and review questions.

Student workbook exercises

Sample exercises to accompany the student workbook.

Trainer manual

Fully customisable with additional information for trainers.

Timetable and lesson plans

Detailed timetable and plans ensure you deliver the best possible course

PowerPoint presentations

PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.
  • Course contents: Foundation

    • Starting Out: What is Microsoft Office Excel 2010? • What’s New in Excel 2010? • Opening Excel • Interacting with Excel • Closing Excel
    • About Workbooks: Creating a New Workbook • Opening a Workbook • Saving a Workbook • About Excel File Types • Closing a Workbook
    • Exploring your Workbook: Using Worksheets • The Active Cell • Selecting Cells • Exploring a Worksheet • Using Zoom
    • 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
    • The Quick Access Toolbar and File Menu: The Default QAT Commands • Adding Commands • Removing Commands • Customizing the Toolbar • Using the File (Backstage) Menu
    • The Home Tab: Understanding Tabs and Groups • Clipboard Commands • Font Commands • Alignment Commands • Number Commands • Styles Commands • Cells Commands • Editing Commands
    • The Insert Tab: Tables Commands • Illustrations Commands • Charts Commands • Sparklines Commands • Filter Commands • Links Commands • Text Commands • Symbol Commands
    • The Page Layout Tab: Themes Commands • Page Setup Commands • Scale to Fit Commands • Sheet Options Commands • Arrange Commands
    • The Formulas Tab: The Functions Library • Defined Names Commands • Formula Auditing Commands • Calculation Commands
    • The Data Tab: Get External Data Commands • Connections Commands • Sort and Filter Commands • Data Tools Commands • Outline Commands
    • The Review Tab: Proofing Commands • Language Commands • Comments Commands • Changes Commands
    • Working with Excel: Columns, Rows, Cells, and Ranges • Creating Worksheet Labels • Entering and Deleting Data • Printing your Worksheet
    • Basic Excel Features: AutoFill • AutoSum • AutoComplete • Working with Basic Formulae
    • 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
    • Custom Actions and Options Buttons: What are Custom Actions? • Setting Custom Action Options • The Error Option Button • The AutoFill Option Button • The Paste Option Button
    • Editing Tools: Using AutoCorrect • Using Spell Check • Using Find and Replace • Adding Comments
    • Modifying Cells and Data: Changing the Size of Rows or Columns • Adjusting Cell Alignment • Rotating Text • Creating Custom Number and Date Formats
    • Cell Formatting: Conditional Formatting • The Format Painter • Cell Merging and AutoFit • Find and Replace Formatting
    • Enhancing a Worksheet’s Appearance: Adding Patterns and Colors • Adding Borders • Working with Styles • Working with Themes
    • 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
    • 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
    • Using the View Tab: Using Normal View • Using Full Screen View • Using Page Layout View • Page Break Preview
    • Managing a Single Window: Creating a New Window • Hiding a Window • Unhiding a Window • Freezing a Pane • Splitting a Worksheet
    • Managing Multiple Windows: Switching Between Open Workbooks • Arranging Workbooks • Comparing Workbooks Side by Side • Synchronous Scrolling and Resetting a Window • Saving a Workspace
    • Printing your Workbook: Print Commands • Print Preview • Using Basic Print Options • Other Print Options • Setting Printer Properties
    • Index

    Course contents: Intermediate

    • 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
    • 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
    • Using File Management Tools, Part One: Marking a Workbook as Final • Encrypting a Workbook • Digitally Signing a Workbook • Managing File Properties • Managing Versions
    • Using File Management Tools, Part Two: Viewing a Summary of Sharing Issues • Using the Document Inspector • Using the Accessibility Checker • Using the Compatibility Checker • Setting Compatibility Options
    • Using Formulas in Excel, Part 1: Understanding Relative and Absolute Cell References • Understanding Basic Mathematical Operators • Using Formulas with Multiple Cell References • Understanding the Formula Auditing Buttons
    • Using Formulas in Excel, Part 2: Fixing Formula Errors • Modifying Error Checking Options • Displaying and Printing Formulas
    • Exploring Excel Functions: What are Functions? • Finding the Right Functions • Inserting Functions • Some Useful and Simple Functions
    • Using Functions in Excel: Using the IF Function • Working with Nested Functions • Breaking up Complex Formulas • Using Functions and AutoFill to Perform Difficult Calculations
    • Working with Names and Ranges: What are Range Names? • Defining and Using Range Names • Defined Names Commands • Selecting Nonadjacent Ranges • Using AutoCalculate
    • Working with Array Formulas: What are Array Formulas? • Defining Basic Array Formulas • Using Functions within Array Formulas • Using the IF Function in Array Formulas
    • Working with Tables: What is a Table? • Creating Tables • Modifying Tables • Using the Table Tools – Design Tab • Adding a Total Row
    • 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
    • Working with Tables and Filters: Sorting Data in a Table • What is an AutoFilter? • Creating a Custom AutoFilter • Using an Advanced Filter • Using an Advanced Filter with Logical Statements • Copying Filtered Records
    • Using Excel as a Database: Filtering with Wildcard Characters • Validating your Data • Data Validation using Lists • Data Validation using Formulas • Using Database Functions
    • Research Tools: Checking Spelling • Using the Research Pane • Using the Thesaurus • Using the Translator • Setting your Language
    • Using Themes: Changing the Theme • Customizing Theme Colors • Customizing Theme Fonts • Customizing Theme Effects • Managing Theme Files
    • Adding Text Boxes: Drawing a Text Box • Using the Drawing Tools – Format Tab • Common Text Box Editing Tasks • Inserting WordArt • Common WordArt Editing Tasks
    • Inserting Pictures and ClipArt: Adding a Picture from a File • Adding Clip Art • Adding a Screenshot • Overview of the Picture Tools – Format Tab • Overview of the Pictures Mini Toolbar
    • Editing Pictures: Resizing Pictures • Moving Pictures • Cropping Pictures • Rotating and Flipping Pictures • Using the Format Picture Dialog
    • Inserting SmartArt: Inserting SmartArt • Adding Text • Adding Photos • About the SmartArt Tools Tabs • Editing SmartArt
    • Formatting SmartArt: Changing the Layout • Changing the Color Scheme • Changing the Style Scheme • Resetting the Graphic • Converting the Graphic
    • Adding Symbols, Equations, and Shapes: Inserting a Symbol or Special Character • Inserting an Equation • Using the Equation Tools – Design Tab • Drawing Shapes • Common Shape Editing Tasks
    • Adding Sparklines: What are Sparklines? • Adding Sparklines • About the Sparkline Tools Tab • Editing Sparkline Data • Removing Sparklines
    • Editing Sparklines: Showing and Hiding Data • Changing the Style • Changing the Sparkline and Marker Color • Setting Sparkline Options
    • Index

    Course contents: Advanced

    • Outlining and Grouping Data: Using Automatic Outlining • Displaying and Collapsing Levels • Grouping Data Manually • Creating Subtotals
    • Exploring Scenarios: What is a Scenario? • Creating a Scenario • Saving Multiple Scenarios • Merging Scenarios • Creating a Scenario Summary Report
    • Using Data Analysis Tools: Enabling Data Analysis Tools • An Overview of Excel’s Analysis Tools • An Overview of the Available Add-In Tools • Using a One or Two Input Data Table • Using Goal Seek
    • Using Solver: Setting up a Worksheet for Solver • Running Solver • Generating Reports and Scenarios with Solver • Changing Solver Values • Managing Solver Constraints • Choosing a Solving Method • Using Solver as a Goal Seek Tool
    • Excel and Hyperlinks: What is a Hyperlink? • Inserting Hyperlinks • Editing Hyperlinks • Formatting Hyperlinks
    • Getting Started with PivotTables: What is a PivotTable? • Creating a PivotTable • Using the PivotTable Tools Tabs • Adding and Removing Data with the Field List • Changing the Field List Layout • Pivoting Data
    • Working with PivotTable Data: Expanding and Collapsing Data • Filtering Data • Sorting Data • Grouping Data • Refreshing Data • Editing the Data Source
    • Formatting a PivotTable: Modifying Fields and Labels • Modifying Values • Using the Layout Group on the Design Tab • Applying a Style to a PivotTable • Changing PivotTable Style Options • Manually Formatting a PivotTable • Using the PivotTable Options Dialog
    • Using the Classic PivotTable Layout: Creating an Empty (Classic) PivotTable Frame • Switching an Existing PivotTable to a Classic Layout • Adding Data • Pivoting Data
    • Advanced PivotTable Tasks: Creating a PivotTable Based on External Data • Refreshing External Data • Creating a Slicer • Using the Slicer Tools Tab
    • Using PowerPivot: System Requirements • Downloading and Installing PowerPivot • Importing Access Data • Importing Excel Data • Integrating Data with Relationships • Creating a PivotTable with PowerPivot Data
    • Getting Started with PivotCharts: Creating a PivotChart from Scratch • Creating a PivotChart from Existing Data • Adding Data to your Chart • Pivoting Data
    • Using the PivotChart Tools Tabs: Using the Design Tab • Using the Layout Tab • Using the Format Tab • Using the Analyze Tab
    • Formatting a PivotChart: Renaming Fields • Changing the Chart Type • Applying a Chart Style • Manually Formatting Chart Elements • Changing the Layout of Chart Elements
    • Advanced PivotChart Tasks: Creating a PivotChart Based on External Data • Creating a Slicer • Creating a PivotTable and PivotChart from a Scenario • Creating PivotCharts with PowerPivot Data
    • Using Advanced Functions: Using the PMT Function • Using the FV Function • Understanding Logical Functions • Using Logical Functions • Using IFERROR with Array Formulas
    • Using the VLOOKUP Function: Understanding VLOOKUP and HLOOKUP • 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
    • Using Custom AutoFill Lists: What is an AutoFill List? • Creating a Custom AutoFill List • Using a Custom AutoFill List • Modifying a Custom AutoFill List • Deleting a Custom AutoFill List
    • Linking, Consolidating, and Combining Data: Linking Workbooks • Consolidating Workbooks • Combining Worksheets • Pivoting Consolidated Data
    • Creating a Basic Macro: Recording a Macro • Editing a Macro • Running a Macro • Understanding Macro Security
    • Visual Basic and Macros: Opening the Visual Basic Editor • Understanding the Visual Basic Editor • Adding Code to your Macro • Adding Comments to Visual Basic Code
    • More Macro Tasks: What are Relative References? • Recording a Relative Reference Macro • Running a Relative Reference Macro • Assigning a Keyboard Shortcut to a Macro • Copying a Macro from a Workbook or Template
    • Advanced Visual Basic Tasks: Declaring Variables • Iteration over a Range • Prompting for User Input • Using If, Then, and Else Statements
    • Index