Microsoft Excel Advance (contd.)

03 Sep Microsoft Excel Advance (contd.)

Posted at 13:44h in Course, Event Calendar by
0 Likes

BSIA of BC · Microsoft Excel Workshop · Virtual

Excel for Business
Advanced — Pivot Tables, Automation & Dashboards

Take your Excel skills further — advanced formulas, PivotTables, Power Query, and macros that turn raw data into decisions. Two live, instructor-led virtual sessions built for people who already know the basics and want to work faster.

📅 October 27 & 28, 2026 · 10:00 AM – 1:30 PM PT
💻 Virtual — Live Online
Member: $299 | Non-Member: $499

BSIA Excel for Business Advanced Workshop - Virtual - October 27 and 28, 2026

Workshop Begins In

00
Days
00
Hours
00
Minutes
00
Seconds

Workshop Highlights

Work Faster, Analyze Deeper

Built for people who already know the basics and want to move beyond them.

01
PivotTables & PivotCharts
Summarize and visualize large datasets in minutes, not hours.
02
Advanced Formulas
VLOOKUP, INDEX/MATCH, nested IF, and other formulas analysts rely on daily.
03
Automate with Macros
Record and run macros to eliminate repetitive manual work.
04
Power Query Basics
Clean and combine data from multiple sources with a repeatable process.
05
Build Dashboards
Turn raw data into executive-ready reports and dashboards.

Curriculum

What You’ll Cover Across Two Days

Draft agenda — subject to instructor refinement before the workshop.

Day 1 — Advanced Formulas & Analysis
PivotTables & PivotCharts · VLOOKUP, INDEX/MATCH & nested IF · data validation · What-If analysis with Goal Seek & Data Tables.
Day 2 — Automation & Dashboards
Recording & running macros · intro to Power Query · advanced charting techniques · building simple dashboards & sharing best practices.

Who It’s For

Built for Experienced Excel Users

Comfortable with core Excel skills (formulas, formatting, basic charts)? Completion of Excel for Business — Beginner, or equivalent experience, is recommended.

Experienced Excel Users
Analysts & Finance Staff
Managers & Supervisors
BSIA Member Companies

Your Instructor

Meet Your Instructor

LR

Luis Ribeiro

President, Crystal Clear Computer Training

Luis brings hands-on, practical computer training to organizations across BC, with a focus on building real, usable skills — not just theory.

See instructor testimonials →

Schedule

The Workshop at a Glance

Two live virtual sessions, one week apart.

Day 1 — Tuesday, October 27, 2026 · 10:00 AM – 1:30 PM PT
Advanced Formulas & Analysis
  • PivotTables & PivotCharts
  • VLOOKUP, INDEX/MATCH & nested IF
  • Data validation
  • What-If analysis: Goal Seek & Data Tables
Day 2 — Wednesday, October 28, 2026 · 10:00 AM – 1:30 PM PT
Automation & Dashboards
  • Recording & running macros
  • Intro to Power Query
  • Advanced charting techniques
  • Building simple dashboards & sharing best practices
Before You Join

Laptop with Microsoft Excel required. Completion of Excel for Business — Beginner, or equivalent experience, is recommended. A Zoom link will be emailed to registrants ahead of Day 1.

Registration Open Now

Reserve Your Spot

Join us live online October 27 & 28, 2026. Complete the form below to register — a confirmation and Zoom link will follow by email.

Questions? Contact the BSIA at 604-513-2205 or info@bsiabc.ca.

Tags:
No Comments

Sorry, the comment form is closed at this time.