Choose Excel training from Penticton
Penticton learners can select a current live online Excel course using the published learning ladder. Ask Power Concepts to confirm any requested local or workplace session, including the date, venue and delivery cost.
A fictional seasonal business tracks bookings, capacity and cancellations. Its exercise compares the same reporting period across two seasons without confusing booking dates with service dates.
A useful report defines the date being analysed and distinguishes confirmed bookings from enquiries. Choose the course level from your current table, formula and summary skills. For a team workshop, send an anonymised sample and explain the decision the finished report should support.
Related options: Excel Courses in Canada: Live Online Training; Excel Training for Teams and Businesses; Excel skills assessment.
Compare the published course pathways
These public outlines are starting points for the skills discussed above. A role-specific example or requested workshop topic is not automatically included in every public session. Check the outline and confirm any must-have requirement before booking.
Excel Intermediate 1
Build a budget while improving the way you use Excel tables, references and formatting. The published course uses construction examples to practise a workflow that also applies to everyday spreadsheet work.
Listed duration: 4 hours
- Build and format a budget worksheet
- Excel tables, sorting and filtering
- Absolute and relative references
Excel Advanced Data Management
Prepare reliable Excel data and summarise it with PivotTables and PivotCharts. This course covers data validation, duplicates, advanced filters and slicers; the separate Expert Data Management course covers Power Query and Power Pivot.
Listed duration: 4 hours
- Collect data with validation and pick lists
- Remove duplicates and highlight invalid data
- Advanced filters
Excel Expert Data Management
Learn Power Query and Power Pivot in Excel to import, clean and connect data for repeatable reporting. Build data models, manage relationships, create measures and define KPIs after establishing a solid PivotTable foundation.
Listed duration: 4 hours
- Import data with Power Query
- Clean irregularly formatted data
- Connect to data sources
Discuss your training needs
Send the work task, learner count and software version. Power Concepts can confirm whether a public course or a scoped workshop is suitable, along with availability and a written quote.
Prepare an email enquiryCall 1-877-954-8433
Your email app opens with a draft for you to edit and send. No information is submitted by this page. You can also email info@powerconcepts.ca directly.
Sources and booking details
- Excel Intermediate 1 — published course outline
- Excel Advanced Data Management — published course outline
- Excel Expert Data Management — published course outline
- Microsoft Excel help and learning
Practice scenarios on this page are illustrative. Fees, dates, delivery arrangements, feature availability and custom scope must be confirmed for your booking.
