Welcome to BIZTeL Products Pty Ltd

Office 2010 Advanced Courses
    These two day courses are designed for office staff who already create complex spreadsheets or documents and want much more sophistication and automation.
  • 10240 - Advanced Word 2010
  • COURSE OUTLINE
    • Working with Outlines
    • Using Outline View
    • Using Styles
    • Creating a Table of Contents
    • Using Section Breaks
    • Working with Headers and Footers
    • Using Footnotes and Endnotes
    • Inserting Graphics
    • Using SmartArt
    • Working with Drawing Objects
    • Using Newsletter-style Columns
    • Using Chart Creation Features
    • Editing a Table
    • Sorting Table Data
    • Using Templates
    • Customizing Word Preferences
    • Working with Lists
    • Using Macros
    • Using Mail Merge and Merge Mail Labels
    • Using Formulas in Tables
    • Using Bookmarks
    • Using Forms
    • Managing Files
    • Protecting a Document
    • Using Word HTML Features


  • 10250 - Advanced Excel 2010
    • Courses designed for people who can already create moderately complex spreadsheets and want to add greater sophistication and automation. These Excel courses examine advanced functionality such as: Pivot Tables, Goal Seeking, Macros, Conditional Formatting, Filtering, Outlines, Range Names and Advanced: Charting and Functions (incl. database functions).
  • COURSE OUTLINE
    • Working with Outlines
    • Using Multiple Workbooks
    • Using Range Names
    • Working with Tables
    • Working with Advanced Filters
    • Using Advanced Functions
    • Advanced Charting
    • Using Templates
    • Using Auditing Tools
    • Using Scenarios and Goal Seeking
    • Solving Problems
    • Using Automatic Formatting and Styles
    • Using Conditional and Custom Formats
    • Working with Views
    • Sharing Workbooks
    • Creating/Revising PivotTables
    • Using, Recording, Editing Macros
    • Creating a Macro Button


  • Advanced Courses can be delivered on-site with real world workshops and can be individually taylored for each customer's requirements.