Excel: Foundational

Gain the skills you need to start using Microsoft Excel like a pro and save with this discount bundle of two 4-hour live-online workshops.

In Excel Level 1: Fundamentals, you'll learn how to navigate, manage, create formulas and use basic functions in worksheets. Then in Excel Level 2: Working with Data, you'll learn how to understand, filter and sort different types of data, work with advanced formulas, and utilize the Data Model with pivot tables. After the full day of Microsoft Excel training, you’ll be able to organize and analyze data more efficiently and effectively to make informed business decisions.

Follow along with the instructor as you practice various tools and functions using the downloadable exercise files provided. You'll also receive a comprehensive guide with step-by-step instructions, shortcuts, and tips for everything you learn in this class.

Upon completion, students will be awarded two digital credentials - Excel Level One: Fundamentals, and Excel Level Two: Working with Data - issued by St. Cloud State University on behalf of the Minnesota State Live Online collaboration. Certificates of Completion will be available to download/print along with the digital credentials.

For human resource professionals, each 4-hour course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.

What You'll Learn in Excel Level 1:

  • Getting Started: Exploring the Microsoft Excel Environment
  • Navigating and Managing Worksheets
  • Entering and Modifying Data
  • Creating Formulas & Using Basic Functions
  • Formatting Cells
  • Full Understanding of Number Formats
  • Printing Worksheets
What You'll Learn in Excel Level 2:
  • Filtering and Sorting Review
  • Excel Tables
  • Nesting Functions
  • Advanced Formulas: Logic and Summarizing Functions (COUNTIF, SUMIF, AVERAGEIF)
  • vLookup & xLookup Functions and Applications
  • Pivot Tables & Pivot Charts

What You'll Earn:
Students who complete these trainings will earn two industry-specific digital credentials tied to in-demand skills, using the Credly platform, an industry leader in digital credentials. Digital credentials, or badges, give learners a more concrete and portable way to highlight just how aligned their academic knowledge is with today’s labor market. These credentials will be valuable additions to your professional portfolios, allowing you to communicate the skills you have acquired through aligned professional offerings, using language that employers understand.

Digital credentials are easily shared via LinkedIn, Twitter, Facebook, digital resumes, and even as part of an email signature. Watch the short video linked here to see your digital credential in action! Within one week of course completion, you will receive an email from St. Cloud State University (via Credly) informing you that you have a new digital credential to accept. There is no fee for this service and acceptance is totally up to you.

Important Note: Certificates of Completion will be available to download/print from the Credly platform. You will need to follow the instructions emailed to you 1 week after course completion to accept the digital credentials in order to download and print your Certificate of Completion for each class.

About The Instructor:
Bob Bruce is a Twin Cities-based Information Architect who has expert level skills in the Microsoft Office suite of products. He’s an Excel 2013 Microsoft Certified Expert. Bob has logged thousands of hours as a software trainer, and is energized by the prospect of improving student skills and knowledge.

This live online training course is offered by a collaboration of Minnesota State colleges and universities.

Feedback from attendees

  • Bob was a great trainer with a wealth of knowledge.  His experience and ability to relate the topics to real life was great.  He kept our audience's attention in what could have been a fairly flat topic.
  • It was helpful to learn how unintimidating Excel can be.
  • Great investment of time and money.  Nice job!
  • I loved the multiple shortcuts used to save time
  • The workbook will help cement all we have learned.
  • The class was excellent!
  • The pivot tables portion was all new to me and will benefit my day to day Excel use.
  • Vlookup and pivot tables were very helpful
  • The class was very helpful and exactly what I expected.  Thank you!
  • The examples were great.  I really enjoyed the entire presentation.
  • Loved the shortcuts and new features!
Register Online with a Credit Card Sign up for our mailing list

Level 1 and Level 2 

We require that participants utilize the video feature during the training session so the instructor can monitor your experience. To further enhance your experience, we suggest you have two monitors but it is not required.

Dates: Virtual

  • July 24
  • Aug. 28
  • Sept. 24
  • Oct. 30
  • Nov 20
  • Dec. 18

Times:

  • Excel 1: 8 a.m.-12 p.m. 
  • Excel 2: 1-5 p.m.
  • Excel 1 and 2: 8 a.m.- 5 p.m. (break 12-1 p.m.)
Cost: Early-bird registration fee applies 2 weeks prior. Registration closes 1 week prior
  • $130 early bird; $150 regular cost for one session
  • $105 St. Cloud State students for one session
  • $210 for both sessions

Alternate registration

Cancellation Policy:  

  • A full refund minus a $25 processing fee will be issued if request is made one week prior to the class.
  • No refunds will be provided if request to cancel is after one week prior to the class.

Questions:  Kassidi Andres, 320-308-5759

We customize

We can tailor courses to meet the needs of your business or group and offer them at Professional and Continuing Education's classrooms and meeting spaces or a location of your choice.

Contact: pace@stcloudstate.edu; 320-308-4252.