Live workshopMicrosoft Office training for teams
Microsoft Excel Intermediate (Level 2)
- Built around your actual work
- Live online, or on-site by request
- Training careers nationwide since 2006
Workshop brief
Microsoft Excel Intermediate (Level 2)
- Duration
- 7 hrs (2 sessions)
- Tuition
- $359.00per participant; team and private pricing by quote
- Delivery
- Live onlineOn-site, in person, by request
- Included
- Certificate of completionFor every participant
You know the formulas. The data still takes all afternoon.
The Level 1 gap closes fast. The Level 2 gap is where the hours are. It is the person who exports two reports and matches them by eye, who retypes data because the format is wrong, who builds the same summary by hand every month.
None of that is a knowledge problem exactly. They have heard of lookups. They have not been shown the pattern that turns a two hour reconciliation into a formula. This workshop is that gap, taught on the work they are actually doing.
Operations and finance leaders use this where reporting takes days it should not. HR and learning and development leaders use it for staff whose Excel plateaued years ago. Participants bring their own real files, and most leave having automated something they had accepted as unavoidable.
Content, datasets, and examples are built around your actual work before delivery. Most groups train live online, and on-site in-person delivery is available by request. This workshop is available by request only, with a three participant minimum, and sits alongside our other data analytics and data literacy workshops.
Why teams book DWC
- Content, datasets, and examples built around your work before delivery
- Live online with a real instructor, or on-site at your location
- Invoicing and purchase order documentation for your organization
What your team gets
This course includes
- Live, instructor led workshop delivered in two sessions
- Hands on work with your own real files and messy data
- The lookup family taught properly, including the modern approach
- Conditional logic and data cleaning techniques
- Digital learning materials and take home reference guides
- Certificate of completion for every participant
Course outline
How the workshop runs
Every session is live with a real instructor, and the exercises are built around your team's work.
The first session is getting data from where it is to where you need it. Participants learn the lookup family properly, including why the classic approach breaks and what to use instead, and practice matching two datasets that do not quite agree. This is usually where the biggest single time saving in the workshop lands.
The second session is logic and cleaning. Participants build conditional formulas that handle real exceptions rather than the tidy case, and learn to split, combine, and standardize messy imported data without retyping any of it. They work on their own bad data, which is more instructive than clean examples.
The workshop closes on summarizing. Participants learn to turn a large table into an answer a manager can read, using functions that aggregate conditionally, and build a report that updates rather than one they rebuild.
Outcomes
What You'll Learn at a Glance
- Pull data across sheets and files with lookups that do not break
- Match two datasets that do not quite agree
- Build conditional logic that handles the exceptions, not just the tidy case
- Clean, split, and standardize imported data without retyping it
- Summarize large tables with conditional aggregation
- Build a report that updates instead of one you rebuild
- Identify the manual work in your week that a formula should be doing
Duration
Prerequisites
Participants should be comfortable entering data, writing basic formulas, and understanding cell references. Those without that foundation should start with Microsoft Excel Beginners (Level 1).
Format
Online for most groups; on-site delivery by request.
Dates and options
Join a public session or book your teamBook this workshop for your team
Public sessions
Train your team privately
Schedule this workshop for your team, live online or on-site, with content built around your work. Tell us your group size, goals, and target dates.
How team training works
From first call to trained team
- 20,000+Participants trained
- 90%Completion rate
- 1,500+Organizations served
Scope it
A short call about your team, your tools, and what needs to change after the session.
Customize it
Your instructor builds examples, exercises, and datasets around your actual work before delivery.
Deliver it live
Live online for most groups, or on-site at your location, scheduled around your team.
Make it stick
Every participant leaves with reference materials and a certificate of completion.
Pricing
Tuition and ways to buy
$359.00 per participant
Microsoft Excel Intermediate (Level 2) is available by request only, scheduled around your team.
- $359 per participant, with a three participant minimum
- Private training: request a custom quote. One on one sessions and teams below the three participant minimum are priced case by case
- Larger groups: request a custom quote. We price larger cohorts case by case based on group size, schedule, and delivery format
Request a quote and we will build pricing around your team.
- Per participant
Enroll a few employees at the per-participant rate.
- Private team session
Your group only, built around your data, tools, and schedule.
- Invoice your organization
DWC invoices your company directly and provides purchase order documentation.
- Multi-workshop programs
Combine workshops into a series for a department or a cohort of new managers.
Microsoft Office training
Microsoft Office training for employees
Excel is the tool most teams use every day and the one fewest people were ever taught. DWC builds Microsoft Office training for employees in levels, from beginner foundations through advanced Excel, Word, Outlook, PowerPoint, SharePoint, and Power BI, so each person starts where they are and every session uses your own files.
Combine workshops into a Microsoft Office skills program for new hires, a single department, or a whole team moving work into Microsoft 365.
Can you customize this workshop for our team?
Yes. Content, datasets, and examples are built around your actual work before delivery, so participants practice on the files, tools, and situations they deal with every day.
Is the training online or on-site?
Most groups train live online with a real instructor. On-site, in-person delivery is available by request.
Is there a minimum group size?
Most workshops booked for a team have a three participant minimum, and the Tuition section on each workshop page lists its exact terms. One-on-one sessions and smaller groups are priced case by case, and larger groups are quoted based on group size, schedule, and delivery format.
Can employees at different skill levels attend?
Most Microsoft Office workshops come in levels, from beginner through advanced, so you can place each employee in the right session. We can help you sort your team by level before you book.
Can you train our team on Excel, Word, and Outlook together?
Yes. Workshops can be combined into a multi-workshop program for a department or a new hire group, scheduled around your team and built around the files you use.
Do participants receive a certificate?
Yes. Every participant receives a certificate of completion, along with digital learning materials and take-home reference guides.
Can we pay by invoice or purchase order?
Yes. DWC invoices your organization directly and provides purchase order documentation.
Can individual employees join a public session?
When a workshop has public dates, they appear in the Dates section of this page with a registration button. If none are listed, request a quote and we will share your options.
Bring this workshop to your team
Tell us about your group and your goals. A training advisor follows up within one business day with options and pricing.