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.
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 Full Course OutlineKey Techniques in efficiency – Productivity and quality in focus
Key Techniques in effectiveness – Add strength to your presentation while maintaining professionalism
Productivity module – Tips, Tricks and Techniques to increase your speed while working with slide decks
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.
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 Full Course Outline:
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. 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 Full Course OutlineBuilding good Foundations & Understanding Data
Working with Formulas. Building good formulas and introduction to Functions
Putting it together - tips, tricks, output
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.
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. Full Course Outline:
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.
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 Full Course Outline TOPICS: NOTE: This course is also available as a full day course (8 hours) on request Optional Add-ons for 8-hour Course:
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.
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. Full Course Outline: 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:
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.
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. Full Course Outline
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.
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. Full Course Outline
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.
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. Full Course Outline
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.
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. Full Course Outline
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
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. Learning topics include:
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