Online Seminar

Accelerated Intermediate Excel

Sep 22, 2022

Online

DATE

SEP 22

2022

TIME

8:30 AM - 12:30 PM

WHO CAN ATTEND

All

PD HOURS

3.75 Hours

ETHICS HOURS

0 Hours

STATUS

Registration open until

Sep 19, 2022

EVENT DESCRIPTION

When learning on-the-job, Excel users understandably develop familiarity with those features that impact their output and jobs. This condensed High-intensity workshop is designed to give such users a good grounding in a broad range of features and techniques that includes productivity techniques in data management, getting familiar with the various aspects of data analysis and formula building, troubleshooting data errors, conditionality and lookups, tapping into the power tools like Pivot Tables and other productivity tools. Participants will work hands-on along with the facilitator on a practice data-file with supplied examples.

KEY TAKEAWAYS:

Managing and effectively dealing with Data

  • Understand data types, and the options for handling dates, time, and other kinds of data, and how to use them in formulas
  • Learn techniques for managing data inconsistency, and functions to clean up data
  • Explore the concepts of dynamic data for manually entered as well as queried data
  • Analysis with functions and formulas
  • Introducing important Functions for conditional calculations in data analysis and reports
  • Understand the Lookups using VLOOKUP for extracting information and merging tables
  • Explore tips and tricks to enhance your lookup formulas

  • Spreadsheet Tools for effective work

    • Working with PIVOT TABLES
      • Maintaining Data discipline
      • Creating Pivot Tables
      • Manipulating Pivot Table Fields
      • 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)

    WHO WILL BENEFIT

    Those who work with some spreadsheet tools and want to ensure they understand a broad range of tools available for undertaking more complex activities with a heightened output.

    PRICING

    $163.00 Personal Passport

    $190.00 Organization Passport

    $261.00 Member

    $261.00 Student

    $317.00 Public

    Status: Registration open until Sep 19, 2022

    LOCATION

    Online

    SPEAKER(S) BIO

    Paul Mascarenhas, BSc. MBA., President of Avancer Learning Inc., is a specialist in Strategic Analysis, and Communications. Paul has conducted his much sought after brand of hands-on IT Skills workshops, to globally renowned names as the Canadian Forces, Canadian Tire, Carlson Wagonlit, SKF Bearings (I) Ltd, CGI Inc, Colgate Palmolive GSSO, Tetra Pak (I), ICICI Prudential, to name a few.

    SPECIAL INSTRUCTIONS

    • This is a hands-on workshop and to be able to follow along, participants will need to bring their laptop computers with a working copy of Microsoft Excel. Microsoft Excel for PC, Version 2013 or Version 2016/Office 365 will be used in the demonstration of techniques of this workshop. Participants may use version 2010 as well with minor loss of functionality or older versions with some loss of functionality. Starter Edition will NOT be adequate for this workshop.

    This course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.

    Electronic material can be accessed one week prior to the course at https://pdlms.cpaontario.ca/ and should be downloaded in advance.

    Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.