Microsoft Excel Beginners (Level 1)
Microsoft Excel Beginners builds the foundation almost nobody was given. Across two sessions, participants learn to structure a spreadsheet so it can grow, write formulas that do not break when a row moves, format so a reader can follow it, and stop doing by hand what Excel will do for them. The payoff is staff who produce reliable work instead of fragile ones. Available by request only, with a three participant minimum.
Description
The first session is structure. Participants learn to lay out data so it can be sorted, filtered, and summarized later, which is the decision that determines whether a spreadsheet is useful in six months. They work on entering data cleanly, using tables rather than loose ranges, and formatting for a reader rather than for themselves.
The second session is formulas. Participants build up from arithmetic to the functions that carry most workplace analysis, and learn what relative and absolute references actually do, which is the single most common source of errors they will produce. They practice fixing broken formulas rather than only writing new ones.
The workshop closes on the work Excel should be doing for them: sorting, filtering, conditional formatting, and basic charts. Participants leave having rebuilt something they actually use, and knowing why the new version will not break.
Prerequisites
There are no prerequisites for this workshop. It assumes no Excel experience. Participants who are already comfortable with formulas should start with Microsoft Excel Intermediate (Level 2).
Includes
This course includes
- Live, instructor led workshop delivered in two sessions
- Hands on work using your own data and reporting formats
- Foundations in structure, formulas, references, and formatting
- Practice fixing broken spreadsheets, not just building new ones
- Digital learning materials and take home reference guides
- Certificate of completion for every participant
Objectives
What You'll Learn at a Glance
- Structure a spreadsheet so it can be sorted, filtered, and summarized later
- Understand what relative and absolute references actually do
- Write formulas that do not break when rows or columns move
- Use the core functions that cover most workplace analysis
- Diagnose and fix a broken formula
- Sort, filter, and conditionally format to find what matters
- Build a basic chart that communicates rather than decorates
Overview
Most people learned Excel by watching someone else do it wrong.
Almost nobody was taught Excel. They watched a colleague, copied a file that already existed, and built from there. It works until the file gets big or the person who built it leaves, and then nobody can safely change anything.
This workshop replaces improvisation with foundation. Participants learn why a spreadsheet built one way survives and another falls over, what a cell reference actually does, and the handful of functions that cover most real work. Most discover they have been doing something manually for years that takes one formula.
HR and learning and development leaders use this for new hires and for staff who list Excel on a resume and use ten percent of it. Operations managers use it where reporting errors are traced back to a spreadsheet nobody understands. Exercises use your data and your reporting formats.
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.
Tuition
Microsoft Excel Beginners (Level 1) 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.