Microsoft Excel 2013

$495.00

SKU: GC1902 Categories: ,

Microsoft Excel 2013

Our Microsoft Excel 2013 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: Core

  • The Basics • Getting Started • Signing In • Creating a New Workbook • Parts of a Workbook • Saving a Workbook • Opening a Workbook • Review Questions
  • Your First Workbook • Selecting Data • Entering and Deleting Data • Using Undo and Redo • Using Cut, Copy, and Paste • Review Questions
  • Working with Data • Inserting Rows and Columns • Merging and Splitting Cells • Moving Cells • Using Paste Special • Using Find and Replace • Hiding and Unhiding Cells • Review Questions
  • Using Basic Excel Tools • Understanding Cell References and Formulas • Using Basic Formulas • Using Basic Functions • Using Advanced Functions • Using Spell Check • Using Sort and Filter • Review Questions
  • Using Timesaving Tools • Using AutoFill • Using Flash Fill • Using AutoSum • Using AutoComplete • Using AutoCalculate • Review Questions
  • Formatting Text • Changing the Font Face, Size, and Color • Applying Text Effects • Applying Borders and Fill • Using the Font Tab of the Format Cells Dialog • Clearing Formatting • Review Questions
  • Formatting Data • Wrapping Text • Changing the Size of Rows and Columns • Adjusting Cell Alignment • Changing Text Direction • Changing Number Format • Review Questions
  • Formatting the Workbook • Using Cell Styles • Formatting Data as a Table • Changing the Theme • Inserting Page Breaks • Adding a Background • Review Questions
  • Inserting Art and Objects • Inserting SmartArt • Inserting Text Boxes • Inserting Pictures • Inserting Equations • Drawing Shapes • Review Questions
  • Charting Data • Creating Sparklines • Inserting Charts • Inserting PivotTables • Inserting PivotCharts • Using Slicers • Creating Timelines • Review Questions
  • Viewing, Printing, and Sharing Your Workbook • Using Views • Saving a Workbook as PDF or XPS • Printing a Workbook • E-Mailing a Workbook • Sharing Your Workbook on SkyDrive • Review Questions
  • Customizing the Interface • Changing Ribbon Display Options • Customizing the Quick Access Toolbar • Hiding and Showing Ribbon Tabs • Creating Custom Ribbon Tabs • Resetting Interface Changes • Review Questions

Course contents: Advanced

  • Advanced Formula Tasks • Understanding Relative and Absolute Cell References • Using Multiple Cell References • Using 3D References • Using Array Formulas • Review Questions
  • Working with Named Ranges • Understanding Named Ranges • Defining Named Ranges • Editing Named Ranges • Deleting Named Ranges • Using Named Ranges in Formulas • Review Questions
  • Using Advanced Functions • Using the PMT Function • Using the FV Function • Using VLOOKUP and HLOOKUP Functions • Using IF, AND, OR Functions • Review Questions
  • Resolving Formula Errors • Tracing Formula Precedents and Dependents • Showing Formulas • Evaluating Formulas • Setting Error Checking Options • Using Error Option Buttons • Running an Error Check • Review Questions
  • Managing Data • Consolidating Information • Removing Duplicates • Configuring Data Validation • Transposing Data • Converting Text to Columns • Review Questions
  • Outlining and Grouping Data • Outlining Data • Showing and Hiding Outline Details • Grouping Data • Creating Subtotals • Removing Outlining and Grouping • Review Questions
  • Working with Scenarios • Creating Scenarios • Loading Scenarios • Merging Scenarios • Editing Scenarios • Creating a Scenario Summary Report • Deleting Scenarios • Review Questions
  • Using Solver • Setting up the Worksheet • Running Solver • Generating Reports and Scenarios with Solver • Modifying Constraints • Setting Solver Options • Review Questions
  • Analyzing Data • Enabling the Analysis ToolPak • Using Data Analysis Tools • Using Goal Seek • Using Data Tables • Review Questions
  • Advanced PivotTable Features • Creating a Basic PivotTable • Creating a Basic PivotChart • Using the PivotTable Fields Pane • Adding Calculated Fields • Sorting Pivoted Data • Filtering Pivoted Data • Review Questions
  • Using PowerPivot • Enabling PowerPivot • Importing Access Data • Importing Excel Data • Integrating Data with Relationships • Creating a PivotTable with PowerPivot Data • Review Questions
  • Using Macros • Recording a Macro • Writing a Macro using the Visual Basic Editor • Editing a Macro • Running a Macro • Review Questions

Course contents: Expert

  • Using Conditional Formatting — Applying Conditional Formatting — Applying Multiple Rule Sets — Creating Custom Rule Sets — Viewing and Managing Rules — Clearing Custom Rules — Review Questions
  • Working with Slicers — Inserting and Using a Slicer — Renaming the Slicer — Changing Slicer Settings — Formatting a Slicer — Clearing the Slicer — Review Questions
  • Using Power View, Part One — Enabling Power View — Creating a Power View — Adding and Removing Fields — Arranging Fields — Filtering Data — Sorting Data — Review Questions
  • Using Power View, Part Two — Refreshing Data — Choosing a Visualization — Changing Tile Display — Setting Display Options — Review Questions
  • Using the Inquire Add-In — Installing Inquire — Generating a Workbook Analysis Report — Viewing Workbook and Worksheet Relationships — Viewing Cell Relationships — Comparing Two Workbooks — Review Questions
  • Working with Tables — What is a Table? — Creating Tables — Resizing the Table — Choosing a Table Style — Clearing the Table — Review Questions
  • Working with Records and Fields — What are Records and Fields? — Adding Fields by Inserting Columns — Adding Records by Inserting Rows — Deleting Records or Fields — Review Questions
  • Using Excel as a Database — Filtering with Wildcard Characters — Validating Your Data — Data Validation Using Lists — Data Validation Using Formulas — Using Database Functions — Review Questions
  • Using Custom AutoFill Lists — Creating a Custom AutoFill List — Using a Custom AutoFill List — Modifying a Custom AutoFill List — Deleting a Custom AutoFill List — Review Questions
  • Using Comments — Inserting Comments — Editing Comments — Navigating Through Comments — Deleting Comments — Review Questions
  • Tracking Changes — Tracking Changes — Reviewing Changes — Setting Options for Tracking Changes — Stopping Tracking Changes — Review Questions
  • Linking, Consolidating, and Combining Data — Linking Workbooks — Consolidating Workbooks — Consolidating Worksheets — Pivoting Consolidated Data — Review Questions