Denver Excel Training Classes & Workshops – Virtual or On-Site

As a Microsoft Certified Trainer (MCT) and Certified Excel Expert based in the Denver area, I welcome the chance to be your partner for Excel training in Denver, in-person or hybrid. Or, for more flexibility, let’s talk about creating a valuable virtual Excel training class. To build your Microsoft Excel skills, choose from these popular Excel training sessions (virtual or in-person) or create a custom workshop:

“You are such an entertaining and dynamic speaker. The software tips you provided opened a new door to productivity.”

Conference Attendee

“It’s rare to attend a presentation in which the takeaways will literally save me hundreds of hours in improved productivity well into the future.
The tips you shared are sure to do this for me and many others
”

Steve Krueger, CPPO, CPPB

“Your virtual training gave me the intuitiveness and confidence
to think outside the box and apply something new, and it worked!”

Heather J. Mowry, MPA, State of Oregon

Dawn brought a high level of professionalism when working with my team.
Beyond her impeccable knowledge of the content, she displayed a True Spirit to Serve. This is a rare combination.”

Jeff Cole, Hospitality Vice President

“The Outlook tips you shared were incredible!
 Just your tip on automating email responses was worth the entire conference! Brilliant!”

Senior Meeting Planner, Charles Schwab

“Thank you for your virtual classes! I always thought I knew enough about Word and Excel, but you proved me wrong in a good way!”

Linda Morse, Purchasing & Contracts Manager

“I’m saving at least 2 days of work every month
by applying the new Excel skills and processes I’ve learned from Dawn. She is a lifesaver!”

Financial Analyst

“Dawn’s session on Microsoft Copilot tips and tricks was AMAZING and will likely save me hours each week.”

Executive Assistant, Conference Participant

“Dawn was professional, consistent, and a joy to work with! She is at the top of her game and she is an excellent presenter. Conference attendees loved her, and she knows her subjects.”

Erik Ruthruff, Microsoft Office Solutions Conference

“Dawn consistently ranked among the top presenters at NIGP (The Institute for Public Procurement) events, quickly becoming a trusted and sought-after expert for our members. When we launched our online Learning Lab series, her engaging, practical, and supportive teaching style elevated the entire program. Partnering with Dawn was a decision that truly strengthened our organizational success.”

Bradley Davis, Strategic Business Development Manager, IACET


“Dawn’s presentation was upbeat, funny, and very informative. Most important, I am still hearing from our members who are using the great ideas from the session. It takes a lot to ‘Wow!’ some meeting planners, but Dawn succeeded!”

Chapter President, Society of Government Meeting Professionals

“Thank you, Dawn. We received tremendous feedback that your presentation on Microsoft Office was dynamic, interesting, and very informative. The strong points of your presentation were how you interacted with the audience, and your expertise and enthusiasm on the subject.”

London Matusiak, Marketing Manager, Vitech Systems Group

“Dawn’s presentation style is fun, interactive, and incorporates a variety of creative training techniques. I highly recommend Dawn not only as an excellent presenter but as a Microsoft expert!”

Don Marquez, Denver Water, Director of Training & Development (Retired)

“Dawn is an exceptionally professional and knowledgeable speaker who brings the same passion and engagement to virtual sessions as she does in person. She creates a personal, connected experience for every participant while staying on track and delivering real value. Dawn consistently goes above and beyond to support learners, making her one of my top training recommendations.”

Terry Gonzales, Training Officer, Federal Transit Administration

“Dawn blew me away when it came to showing us how to navigate through Microsoft Outlook. We learned to organize and prioritize email messages, navigate through our inbox messages, create tasks and appointments, and all in record time. This has greatly enhanced my productivity. It’s refreshing to learn from someone that’s as engaging and exuberant as Dawn.”

Gary Barkman, CPPB, Procurement Specialist Supervisor, Mesa Public Schools

“Wow! Your program on Microsoft Office was the best training session I have ever attended!”

Carol Selke, Business Support Coordinator, IT, COPIC Insurance

Are You Ready to Be More Productive with Microsoft Excel?

Let’s connect to talk about creating your custom Microsoft Excel training programs or conference sessions for skill levels ranging from foundation (beginning) to advanced as well as targeted, project-specific education.

These Denver Excel training and speaking topics may be combined to create customized education solutions ranging from 45-minute presentations, hands-on online Learning Labs, one to two-hour virtual training classes, Lunch & Learn sessions or half-day to full-day workshops:

Stop Wasting Time in Excel! Tips & Shortcuts to Be More Efficient

Microsoft Excel is packed full of features designed to help you create, edit, and format a wide range of worksheet projects. With all its power, many Excel shortcuts, tips, and techniques are not obvious or intuitive. Join this session to learn how to simplify actions in Excel, customize your workspace, and discover the steps and shortcuts to quickly and easily get your work done.

  • Building Excel skills with data entry tips and easy formatting
  • Navigating shortcuts
  • Managing workbooks
  • Exploring tips and shortcuts for automating your work in Excel
  • Managing data with tables
  • Customizing your Excel environment

Recommended Session Length: 45 to 120 minutes (customized to audiences and organizations). Longer, hands-on training sessions are also available on key topics in Microsoft Excel.

Mastering Microsoft 365 Copilot in Excel: Work Smarter with AI

Ever wished Excel could do the heavy lifting for you? With Microsoft 365 Copilot, it can! This hands-on training will show you how to analyze data, uncover trends, and automate tasks with AI, all while saving you time and effort. Whether you’re cleaning up messy spreadsheets, building reports, or making forecasts, Copilot helps you work smarter, not harder.

What you’ll learn:

  • Ask Copilot to analyze and summarize data—no formulas required!
  • Get instant insights with AI-powered trend detection
  • Automate data clean-up, formatting, and calculations in a snap
  • Create PivotTables and charts just by describing what you need
  • Enhance forecasting and spot trends with AI-driven suggestions
  • Boost productivity with smart automation in Excel

Who Should Attend? If you use Excel and want to work faster and more efficiently, this session is for you! Perfect for business professionals, analysts, administrative staff, and anyone curious about AI-powered Excel magic. Plus, no advanced Excel skills needed!

Microsoft Excel: Top Editing & Formula Skills

The key to using Microsoft Excel effectively is to build a strong foundation of important editing, formatting, and formula skills. In this training course, find out how to easily create, edit, and format data and build Excel formulas.

  • Editing and formatting data
  • Leveraging automatic features: AutoFill, AutoSum, AutoComplete, AutoCorrect
  • Using Find and Replace
  • Creating basic formulas
  • Working with Excel functions
  • Understanding the 3 Types of Cell References in Excel

Recommended Session Length: 45 to 120 minutes (customized to audiences and organizations). Longer, hands-on training sessions are also available on key topics in Microsoft Excel.

Microsoft Excel: Top Essential Functions

With almost 500 functions built into Microsoft Excel, which of these functions are likely to be most valuable to you to build formulas, analyze data, extract essential information, and use your Excel worksheets more effectively? This workshop focuses on many of the frequently used and essential functions in Microsoft Excel.

  • Understanding absolute and relative references
  • Creating named ranges
  • Improving data analysis with logical functions including IF, SUMIF, AVERAGEIF
  • Looking up values with VLOOKUP & XLOOKUP
  • Working with date values
  • Leveraging functions for combining and extracting text

Recommended Session Length: 45 to 120 minutes (customized to audiences and organizations). Longer, hands-on training sessions are also available on key topics in Microsoft Excel.

Microsoft Excel: Linking & Sharing Data

Some of the most valuable and time-saving features in Excel are the choices to link and share worksheet data. Find out how to easily reference and summarize data from other worksheets, learn how to use Excel data in other programs, and look at options to protect data.

  • Linking within a workbook
  • Linking and updating across workbooks
  • Sharing Excel data with other programs (Word, PowerPoint)
  • Applying protection
  • Handling comments
  • Creating hyperlinks to other files and resources

Recommended Session Length: 45 to 120 minutes (customized to audiences and organizations). Longer, hands-on training sessions are also available on key topics in Microsoft Excel.

Microsoft Excel: How to Visually Communicate Data with Charts & Graphics

Not all of Excel is about crunching numbers. Excel is also an easy yet powerful program for creating charts and graphics. With this training, you’ll discover how to use Excel’s graphics capabilities to quickly communicate complex data in a chart and learn how to use Excel’s other graphics and diagram tools to enhance your worksheets.

  • Creating, updating, and customizing a chart
  • Modifying chart formats and options
  • Building combination charts to display diverse data
  • Adding mini charts with Sparklines
  • Creating professional graphics and diagrams with SmartArt

Recommended Session Length: 45 to 120 minutes (customized to audiences and organizations). Longer, hands-on training sessions are also available on key topics in Microsoft Excel.

Microsoft Excel: How to Save Countless Hours with Excel PivotTables

How can you answer data-related questions quickly, easily, and applicably? When your projects require synthesizing large amounts of data, Excel PivotTables are often a great solution to save hours, or even days, when you need to summarize and evaluate your key data. In this session, explore the steps to efficiently work with PivotTables to manage and analyze complex Excel worksheets.

  • Creating, formatting, and modifying a PivotTable
  • Sorting and filtering in a PivotTable
  • Adding a Slicer or Timeline to filter data
  • Summarizing, calculating, and customizing data
  • Creating a PivotChart

Microsoft Excel: Custom

Build your own customized conference session or training course (on-site or virtual) to focus on the Microsoft Excel skills that are essential to help your team and organization get the results they need.

Bring an Excel Expert to Your Office or Next Meeting

Quickly build Microsoft Excel expertise within your office, department, or work team by bringing Dawn to your next meeting for virtual or in-person computer training and seminars. Add valuable educational sessions by adding a Microsoft certified expert, Certified Speaking Professional, Certified Virtual Presenter (CVP), and software conference speaker to your organization or association meetings and conferences. Or create customized virtual training for expert training without travel.

Contact The Software Pro® for your tailor-made training program.

Dawn Bjork, MCT, MOSE, CSP®, CVP, The Software Pro®
(303) 699-6868

[email protected]