Search results will show here

Connecting residents of the RMWB with events and activities in our communities.

en English
ar Arabiczh-CN Chinese (Simplified)nl Dutchen Englishfr Frenchde Germanit Italianpt Portugueseru Russianes Spanish

Contact us

Microsoft Excel Power Workshop

Cost: $50

View all events

Date

Feb 23 2021 - Feb 24 2021

Time

9:00 am - 12:00 pm

Location

Virtually-Zoom link will be emailed

Organizer

Sherry MacEachern
Phone
780-791-9333
Email
sherry.maceachern@fusesocial.ca
Website
http://www.fusesocial.ca
  • + Add to Google Calendar
  • + iCal export

Harness the Power of Excel!

 

Join Barrie Morse, a Microsoft Certified Master trainer, of Dragon Corporate Training for this workshop.

 

For the more comprehensive user, Excel offers a whole raft of tools and functionality to help you.
From advanced calculations, to data modelling tools and automation.

 

In this 2 day workshop we will cover how to develop advanced and nested functions, build powerful PivotTables and PivotCharts, use the What-If group of tools and explore Dynamic Tables.

 

Time is also built into the sessions to allow for specific questions and for customization specific to individual users.

 

Topics will include:

• Use absolute and mixed references in a formula
• Using Named Ranges
• Nested and logical Functions
• Using Lookup Functions
• Use the Goal Seek feature
• Create and manage scenarios, as well as create scenario reports
• Use Data Validation
• Linking Spreadsheets
• Create, modify, and work with PivotTables, PivotCharts, and Slicers
• Creating PivotTable Calculations
• Custom Grouping and Reporting in PivotTables
• Dynamic Tables
• DAX Functions

 

This workshop session will be instructor-led, hands-on and specifically designed for maximum retention and understanding.

 

This is an online training session and registrants will be emailed login details in advance of the session.

 

If cost is a barrier to attending this session, please reach out to sherry.maceachern@fusesocial.ca to work out an alternate arrangement to registration.

Visit website

Share this event

Initiated and sponsored by:

Events/Activities posted must meet
St. Aidan’s House Society Guidelines.

All individuals and organizations using this free service must read and adhere to these Calendar Posting Guidelines.

Contact Us

Privacy Policy Terms & Conditions

© 2021

Crafted by Trait Marketing

Sell your event tickets online Submit an Event Join our newsletter