Home / Online Training

Online Training

Avancer Corporate Webinars

Schedule your own online workshop with as little as 5 participants! 
Yes! That's right. If you have 5 participants or more, you can schedule an online course at a convenient date and time and pay per participant attending.

Less than 5 participants?
No problem, your participants can join any of the scheduled open-group workshops on our calendar of scheduled courses on the right. Receive group discounts for 3 or more participants!

Want an exclusive closed-group customized course?
You've got it! Contact us to schedule your next course.

Choose from these popular titles or have us customize them for you

Featured PowerPoint Courses

Effective PowerPoint Online - 4-hour, Live, Hands-on Online Workshop

About this course: This course is best suited for those who have some experience with PowerPoint and understand the basics of creating and using slides manually. It is especially suitable for those who need to create professional slide decks and make presentations at short notice as well as those who use slide decks as printed reports.   

More
Duration: 2 sessions of 2 hours each

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: Productivity in developing slide decks, Conforming to Corporate Identity Guidelines, Working with Tables and Charts, Editing Tips and Tricks, Smart Art, Masters, Templates, Tips and Tricks

Customizable: Partial
Duration: 4 hours
Level: Intermediate to Advanced

Full Course Outline

Key Techniques in efficiency – Productivity and quality in focus

  • Understanding masters, templates and presentation outlines, and using these techniques together for distributed effort in presentation development while maintaining consistent design and identity
  • Create presentations quickly - work with Outlines for building content-heavy presentations rapidly – develop professional looking presentations in minutes if you have your content ready.
  • Efficiency in inserting files from external sources – like Excel documents, Tables, and spreadsheets to embed and interact with
  • Productivity techniques in developing presentation structure, editing, distributing content across multiple slides – speed up deck development

Key Techniques in effectiveness – Add strength to your presentation while maintaining professionalism

  • Working with Smart Art – using the new Smart Art feature with outlines for quick and professional business diagrams
  • Create Linked dynamic presentations that update when the data they reference from spreadsheets changes.
  • Working with views, shows and sections – using your presentation as a printed report – managing the look and the dissemination of varying pages to different recipients

Productivity module – Tips, Tricks and Techniques to increase your speed while working with slide decks

  • Powerful Keyboard shortcuts for editing a presentation
  • Powerful Keyboard shortcuts while presenting – make your presentation seamless
  • Using multiple monitors and the presenter-view

Data Focused Presentations with PowerPoint & Excel Online - 8 hour, Live, Hands-on, Online Workshop

About this course: This is a course that is designed with data-intensive presentations in mind. It combines key charting and data techniques in Excel with the power of embedding, linking and data animation in PowerPoint. Ideal for financial, strategic, and sales presentations.

More
Duration: 4 sessions of 2 hours each

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: Data and Information concepts, Key charting concepts, Object linking, Data Linking, Embedded data, Organizing data for presentations, Building data-intensive presentations, animation, tips and tricks

Customizable: Partial
Duration: 7 hours
Level: Advanced

Full Course Outline:

  • Understanding object linking and embedding and how linking can take place both to PowerPoint and from PowerPoint. Create Linked dynamic presentations that update when the data they reference from spreadsheets changes.
  • Excel: Effective visual data presentation using advanced charting techniques in Excel - things you can do in Excel to make your charts data stand out and be more presentation oriented.
    • Charts that combine a conventional chart with informational graphical annotations
    • Adding conditionality to charts for flagging decision rules
    • Linking multiple Excel graphs or objects to PowerPoint as one object
  • Learning how to make data-referenced flowcharts and drawings in Excel and introduce them into PowerPoint
  • Working with Tables – deciding on Excel or PowerPoint for creating, managing and formatting Tables for a Presentation
  • Formatting techniques for consistency in visual formats across spreadsheet data and PowerPoint slides – understanding the Presentation Theme (template) and how it affects all Office documents
  • Inserting external objects and documents into the presentation and using object actions to activate or edit objects during a presentation show (for onscreen presentations only)
  • Many more tips and tricks for efficiencies in slide deck creation and creating effective business visuals for presentations and reports
  • Extras - Short discussion and Instructor demonstration of:
    • A brief look at advanced techniques in managing notes and the notes master to understand the potential for data-heavy presentations and reports
    • Short Discussion and Demonstration on using PowerPoint animation to introduce chart and tabular data gradually (applies to onscreen presentations)

Featured Excel Courses

Excel Accelerated Beginner Essentials Online - 4-hour, Live, Hands-on Online Workshop

About this course: An Accelerated Fundamentals course - most suitable where staff has some basic exposure to Excel. This course will bring participants up to an Intermediate level in 4 hours. Also very effective for bringing groups of new entrants up to the organization standard. IMPORTANT: This course is NOT suitable for participants who have no or minor exposure to Excel.

More
Duration: 2 sessions of 2 hours each

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: Productivity in spreadsheet management, Formulas and Formula References, Introduction to Functions, Beginning with Function based formulas, Formatting, Auto series, Output, Tips and Tricks

Customizable: Partial
Duration: 4 hours
Level: Beginner

Full Course Outline

Building good Foundations & Understanding Data

  1. Examining KEY elements in the Excel Interface
  2. Understanding different kinds of cell selections
  3. Mouse Actions for speedy copying, selecting, erasing
  4. Understanding Data Types
  5. Working with Numbers and Understanding Number Formatting

Working with Formulas. Building good formulas and introduction to Functions

  • UNDERSTANDING KEY CONCEPTS IN FORMULA BUILDING
  1. Exploring data referencing, referencing constants, correctly using arithmetical operators
  2. How to Copy Formulas and Copy Values
  3. Good practice in cell referencing – Relative and Absolute References
  4. Linking data and building formulas across spreadsheets
  • INTRODUCING FUNCTIONS – FIRST STEPS TOWARDS FUNCTION-BASED FORMULAS
  1. Introduction to Functions and the function library buttons
  2. Introducing key functions – Sum, Min, Max, Average and a few others.
  3. Introducing the IF function – one of the most used functions in Excel

Putting it together - tips, tricks, output

  1. Understanding Paste-Special
  2. Understanding AutoFill
  3. Managing Output - Print or PDF

Accelerated Intermediate Excel Online - 4-hour, Live, Hands-on, Online Workshop

About this course: This is an intensive fast-paced course that is designed to give participants a focused grounding in the most widely used analysis and reporting formulas and tools and includes Data consistency measures, Popular functions and formulas, and an introduction to Pivot Tables. IMPORTANT: To take this course, participants MUST be familiar with basic formulas, basic math functions of Excel, and other common spreadsheet tasks. 

More
Duration: 2 sessions of 2 hours each

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: Managing Data inconsistencies, Dynamic Data, Conditional and Lookup Formulas, Pivot Tables (Int), Tips and Tricks for Productivity.

Customizable: Partial
Duration: 4 hours
Level: Intermediate

Full Course Outline:

  • Understand data types, and the options for handling dates, times and other kinds of data, and how to use them in formulae – learn tools like Text to Column for managing data inconsistency, and functions to clean up data
  • Understand the newer TABLE feature and its importance as a dynamic dataset for manually entered as well as queried data
  • Introducing important Functions – The COUNTIF and SUMIF functions for conditional calculations
  • Understand the VLOOKUP Function (Intermediate Applications only) for extracting information and merging tables
  • Working with PIVOT TABLES
    1. Maintaining Data discipline
    2. Creating Pivot Tables
    3. Manipulating Pivot Table Fields
    4. Pivot Table tips and tricks for effective work
  • Tips and Tricks for reporting and speedy working – keyboard shortcuts, Printing techniques, and more (spread over all modules)

Advanced Excel Functions and Formulas Online - 4-hour or 8-hour Live, Hands-on, Online Workshop

About this course: This is an concentrated course of some of the most advanced formula techniques and application of functions in complex formulas for analysis and dynamic reporting. It covers important formula concepts like Dynamic Arrays as well as powerful functions like Offset and Sumproduct and more.

More
Duration: 2 sessions of 2 hours each (or 4 sessions of 2 hours each)

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

NOTE: This course is also available as an 8-hour course on request. See Full Course Outline below for details.

Key Topics include: Advanced Lookups, Error Trapping, Rolling and Dynamic Formulas, Slicing and Dicing of Data, Understanding Logic, Array Formulas

Customizable: Partial
Duration: 4 hours or 8 hours
Level: Advanced

Full Course Outline

 TOPICS:

  • Using names and useful techniques with names for building complex formulas easily and effectively
  • Understand complex formulas using functions like Sumproduct, Offset, and many more
  • Using Logical functions together with conditional functions for useful ways to analyze data
  • Learn about handling errors efficiently in Lookup-based formulas.
  • Explore the power of Array formulas and the amazing flexibility of Dynamic Arrays
  • Understand how to build interactivity and conditional elements into your spreadsheets

NOTE: This course is also available as a full day course (8 hours) on request

Optional Add-ons for 8-hour Course:

  • Explore large dataset analysis through structured query building and D-functions
  • Explore advanced formulas with Index Arrays
  • Work with Excel's Dynamic Array formulas (Office 365 and later)
  • Move towards automated reporting with re-routing of formulas
  • Learn how to use Structured Referencing with Excel Tables
  • Use formula rules with spreadsheet tools for visual analysis
  • Using formula rules with charting applications

Advanced Charts and Dashboards Online - 8-hour, Live, Hands-on, Online Workshop

About this course: This workshop focuses on various features in Excel to make powerful charts, build non-standard and advanced chart types, work with popular charts like waterfall charts, Map charts, bullet charts, slice large datasets, build management dashboards, and bring interactivity to spreadsheets.

More
Duration: 4 sessions of 2 hours each

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Note: This training may also be split into parts. See details in full course outline below

Key Topics include: Core concepts in charting, building advanced non-standard charts, working with primary and secondary data, setting up dashboards, creating custom templates, exploring new chart types like 3D charts, maps and more.

Customizable: Partial
Duration: 8 hours
Level: Advanced

Full Course Outline: 

  • Explore critical concepts in chart selection and development for effectiveness in charting
  • Effective data configuration for creating non-standard charts – benchmark charts, thermometers, pictorial charts, Advanced Gantt charts, ring charts, waterfall charts, and more
  • Combine key functions like Sumproduct, with data validation, for data slicing and creating interactive secondary dashboard tables
  • Learn creative dashboard concepts by creating a dashboard of various charts, sparklines, and numerical data, with professional look and feel
  • Combine annotations, functions and formulas for charts that display conditional elements based on decision rules
  • Explore some of the newer chart types in Excel version 2016+ like heirarchy charts, waterfall charts, Maps and 3D charts.
  • Many more tips and tricks in chart development and dashboard creation

What options are available for splitting this into parts?

This workshop can be split into two parts and combined with other workshops like PowerPoint or other Excel workshops as follows:

  • Part 1 - All about Advanced Charting Techniques - creating and customizing non-standard charts, creative charts, and conditional charts, and developing reusable templates from them
  • Part 2 - All about Dashboarding - working with large datasets, slicing data with formulas, building interactivity into dashboards, linking of Dashboards across Office applications. (Knowledge of chart creation is assumed)

Introduction to Pivot Tables Online - 2-hour Live, Hands-on, Online Workshop

About this course: A High-intensity course that is aimed at participants who have a working knowledge of Excel and would like to get productive with creating, deploying and reporting with Pivot Tables. The course covers data discipline, data dynamism, Pivot Table fundamentals, Pivot Table manipulation and troubleshooting. 

More
Duration: 2 hours

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: Data Discipline, Dynamic Tables, Pivot Table creation, Pivot Table Options, Filters and Tools, Designs and Styles for Reporting, Pivot Table Tips and Tricks.

Customizable: Partial
Duration: 2 hours
Level: Intermediate

Full Course Outline

  • Understanding Pivot tables
  • Setting up data to create Pivot Tables effectively
  • Creating Pivot Tables
  • Important Pivot Table options – ensuring Pivot Table effectiveness
  • Some key features in manipulating Pivot Tables – Drilling to Detail (multi-tiered tables), Formatting Pivot Tables, arranging Pivot Table fields
  • More tips and tricks as time permits

Advanced Techniques with Pivot Tables Online - 2-hour Live, Hands-on, Online Workshop

About this course: This is an concentrated course that is aimed at participants who have a working knowledge of Excel and have at least some familiarity with creating and reporting with Pivot Tables. It is an ideal course for anyone working with large amounts of dynamic data. 

More
Duration: 2 hours

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: Managing Pivot Tables, Field Analysis, Field Manipulation, Formula Fields, Analytical Techniques, Using the Data Model, Data Relationships, Pivot Table Tips and Tricks.

Customizable: Partial
Duration: 2 hours
Level: Advanced

Full Course Outline

  • Quick refresher on Dynamic Data Sets, Creating Pivot Tables, Field Manipulation, Table Options, Table filters, Auto sort and filter.
  • Building multi-tiered Pivot Tables and exploring more options in field manipulation including drilling to details, and value field summarization options
  • Adjusting Pivot Tables for reporting requirements using techniques like Field Grouping, Date field grouping, Table and field filters
  • Exploring the use of  Grouping with field summarizations together with Pivot Charts for powerful analysis
  • Working with formula fields in Pivot Tables using Calculated fields and Calculated Items for powerful analysis of summarized data
  • Understanding the Data Model in version 2013+ and how to make Pivot Tables from multiple related datasets using Data Relationships (version 2013+ only)
  • Many more tips and tricks including GETPIVOTDATA references, Filter Pages, Connected Slicers and more, to make the most of Pivot Tables in your spreadsheet.

Introduction to Power Pivot and the Data Model Online - 2-hour Live, Hands-on, Online Workshop

About this course: A concentrated course that unlocks one of the most Powerful add-ins in Excel - Power Pivot. The course covers a hands-on look at how to use Power Pivot to bring data from various datasets together, how to work with relationships, and introduces some of the powerful new features available such as  Calendar tables, distinct count and implicit measures.  

More
Duration: 2 hours

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: Dynamic Tables, Data Relationships, Power Pivot Add-in, Relationship conflicts, Using the Data Model, Named Sets, Tips and Tricks.

Customizable: Partial
Duration: 2 hours
Level: Advanced

Full Course Outline

  • Revisiting a key feature – Dynamic Tables
  • What is Power Pivot and how does it appear in various versions of Excel
  • An Introduction to the Data Model – Power Pivot functionality ( 2013+)
  • Creating Data Relationships from existing datasets
  • Working with the Data Model
  • Creating a Pivot Table from the Data Model
  • New features in Pivot Tables available with Power Pivot and the Data Model

Doing more with Power Pivot - Introduction to Measures, DAX Functions and Time Intelligence Online - 2-hour Live, Hands-on, Online Workshop

About this course: An advanced course that introduces some of Power Pivot's most advanced and powerful features for getting the most out of your data and building powerful cross-referenced reports. Participants will learn how to use DAX functions for creating calculated fields, and work with time intelligence functions.  

More
Duration: 2 hours

Availability: Schedule a publicly available open-group workshop with as few as 5 participants or book an exclusive closed-group workshop. If you have less than 5 participants, check out our calendar of currently scheduled workshops.

Key Topics include: DAX functions, Explicit and Implicit Measures, Time Intelligence functions, Date Tables, Cube Formulas, Tips and Tricks.

Customizable: Partial
Duration: 2 hours
Level: Advanced

Full Course Outline

  • Revising – construction of the Data Model in Power Pivot
  • Understanding Unequal Reporting with Named Sets
  • Understanding how Measures / Calculated Fields work
  • Creating Implicit and Explicit Measures
  • A brief peek into DAX functions for creating measures
  • Exploring Time Intelligence and Date Tables
  • A brief look at Cube Formulas

Excel VBA for the Non-programmer Online - 8-hour, Live, Hands-on, Online Workshop

About this course: The ability to get that extra power out of Excel and simplify everyday tasks or develop spreadsheets with user interfaces, often depends on knowing small, quick macro routines in VBA. This workshop will cover a range of fundamentals and some of the most-used routines and techniques in Excel VBA.    

Availability: This course is only available as a closed-group workshop at a flat-rate fee for a maximum of 20 participants

More

Duration: 4 sessions of 2 hours each

Key Topics include: VBA fundamentals, Basics of Object Oriented Language, Recorded vs Coded macros, User-input, Conditions, Loops and much more with many practical hands-on examples to try out and keep.

Customizable: Partial
Duration: 8 hours
Level: Advanced

Learning topics include:

    • Introduction to VBA – VBA fundamentals
    • Language Basics – Understanding Objects, Collections, Properties, Methods and Events
    • Recording Macros – understanding the difference between recorded code and manual code
    • Manually Adding Functionality by manipulating recorded code
    • Debugging and Fault Finding – common errors and how to identify them
    • Prompt for User Input – understanding variables, creating message and input boxes
    • Initiating Macros – initiating macros through command boxes and events
    • Conditional Statements – using IF statements to execute code
    • Looping Code – introducing the concept of code that runs till a condition is met
    • Taking Macros to the next level – combining various concepts applied to various scenarios
    • Practical Examples – the workshop ends with significant time spent on real-life examples writing from scratch

More specialized titles to choose from

The titles below are specialized topics and cannot be customized but may be combined with other modules mentioned on this page. These 2-hour topics are designed to deliver very specific solutions and are a good choice when you want to augment another course or are facing a problem in a particular area of Microsoft Office. Browse the list below and contact us for more information.

Key reasons to choose Avancer for Online training

9 Years of Online Experience

Finely tuned training thousands of participants from elite Global and Canadian organizations online

Specialized Content

Over 25 specialized courses, hands-on practice enabled with Live Interaction

Flexible Scheduling Policy

Schedule a course with as little as 5 participants or participate in an already scheduled one

Top