(888) 804-1132

Microsoft Excel

Master the Art of Data Handling with Microsoft Excel 2021/365

Business women working on a spreadsheet.Unleash the true power of data with Microsoft Excel 2021/365 – the pulsating heart of modern data management! Excel, Microsoft’s masterpiece of spreadsheet software, isn’t just a tool but an essential language of the digital workplace. Can you speak it fluently?

From cracking the basics to conquering the advanced, our immersive Microsoft Excel 2021/365 training is designed to infuse you with lightning-fast navigation tricks and superior spreadsheet skills. It’s not just a course, it’s a game-changer!

Whether you’re a lone wolf seeking to upskill, or a team ready to elevate its data wizardry, we’ve got you covered. All our courses are crafted under the watchful eyes of seasoned Microsoft Excel instructors, who bring a wealth of real-world experience to the table.

Embrace the future of learning with options to suit your style. Dive into our virtual classes from anywhere in the world, all with a live instructor. With tailored learning experiences and tiered courses, you choose your pace, and we guide your journey. Let’s excel together!

$150 – $550 / Person / Session
*based on number of people

Beginner to Advanced
*all courses can be customized

For Groups Up to 15
*larger groups accommodated with multiple sessions

Virtual or In-person at Client Site
*no public classes

These are the main topics covered in each level of our Excel public courses.  Private courses can be customized to focus on the skillsets your team requires.

Excel Essentials

  • Launching Excel and familiarizing with basic features
  • Workbook manipulation: opening, navigating, saving, closing
  • Toolbar and Ribbon customization

Creating Worksheets

  • Understanding Excel data types and worksheet design
  • Data entry: text, numbers, simple data
  • Formulas: basic calculations, special functions, arguments, Autofill
  • Data movement: cut, copy, paste, drag and drop, understanding reference limitations

Formatting a Worksheet

  • Selecting multiple ranges, formatting text, numbers, dates, currency, decimal control
  • Cell alignment, text wrapping, merging cells
  • Border, fill color, cell style application
  • Format clearing, theme usage and customization

Manipulating Data

  • Finding and replacing data, using Format Painter
  • Diverse paste options, pasting links
  • Row, column, range: insertion, deletion, hiding, and unhiding

Printing a Worksheet/Workbook

  • Print preview and printing with current settings
  • Printing entire workbook, selected worksheets, controlling print setup options
  • Managing print area, print titles, headers and footers
  • Saving workbooks in different formats

Using Multiple Worksheets and Workbooks

  • Inserting/deleting worksheets
  • Rearranging & renaming worksheets
  • Referencing cells/ranges in other workbooks

Named Ranges

  • Assigning names to ranges
  • Using names in formulas and values

Charting

  • Creating basic charts (line, pie, column)
  • Managing chart styles, layout, and elements
  • Applying trendlines and combining data sets in charts

Lists and Tables

  • Sorting and filtering data
  • Creating and formatting Excel tables
  • Removing duplicate values and setting up data validation rules

Summarizing Data

  • Consolidating data from various ranges
  • Inserting subtotals and managing subtotal data

Pivot Tables and Charts

  • Creating and filtering pivot tables
  • Grouping data and manipulating field settings
  • Creating and analyzing data with pivot charts

Presentation Features

  • Conditional and custom formatting
  • Inserting graphics

Logical and Reference Functions

  • Use of IF, AND, OR, NOT, LET for conditional value return
  • Utilizing SUMIF and SUMIFS for conditional calculations
  • Applying Lookup, INDEX, MATCH, XMATCH for value retrievals

Auditing Formulas and Error-trapping

  • Tracing and rectifying errors in formula
  • Using IFERROR for handling formula errors
  • Understanding and displaying formulas

Calculation and Iteration

  • Controlling calculation and iteration

Date, Time and Text Functions

  • Manipulating dates and calculating duration
  • Working with text values

External Data and Protecting Data

  • Importing and exporting files
  • Password protection for workbooks
  • Locking and protecting cells and workbook structure

Analysis

  • Using Watch Window for formula value tracking
  • Applying Scenarios and Goal Seek for outcome analysis

Automate Tasks with Macros

  • Recording and running macros
  • Introduction to macro editing

Download Our Brochures for a More Detailed Course Description

Carol has always had a passion for helping others in their journey for personal growth. She is a corporate Teacher, Trainer, eLearning Instructor and Program developer with 28 years of experience providing outstanding training for thousands of managers, employees and individuals. Carol is known for her dynamic, motivating and engaging instructional approach.
Chris is our most senior MS Office trainer. He brings 30+ years of experience designing, developing, and delivering effective learning solutions to Tech Touch. With his amazing sense of humor, Chris is a very well-liked and a respected trainer. His classes are lively and never dull. Our clients always ask for him to return!
Michel is an experienced corporate trainer with 20 years of experience and a bachelor’s degree in Business Management. He takes pride in having a unique training style, focusing as much on the ‘What’ and ‘Why’ as it is on the ‘How to’ factor. Michel’s classes showcase real life examples, comparisons, and analogies that all audiences can relate to and benefit from the simplicity of the presented material.
What if I have learners that have different skills sets, some beginners and some more advanced?

Your training specialist will assist you with developing a curriculum that will ensure that no one is left behind. Depending on group size, your consultant may suggest delivering multi sessions so that beginning students don’t feel pressured and more advanced learners don’t feel like the pace is too slow.

Because every situation is different, it is best to discuss this with your Tech Touch Training Specialist, who will help you to come up with a plan that is both economical and efficient.

Where does the training take place?

Public courses are delivered online via Zoom with a live instructor.

Private courses can be delivered either online via Zoom or Webex, or we can bring the training to your location.

Talk to your Tech Touch Training Specialist about your options, and we will find a suitable option that best fits your needs and that of your team.

What version do you teach?

Public sessions are taught on the latest version of Excel, 2021/365.

For private training, our team of expert instructors can deliver training in any version, so you will be able to learn on the exact version you are using for your projects.

Most individuals and businesses have access to the Microsoft 365 plans, which allows you to download the latest version. The most recent version is what we recommend, as you will have the latest features and capabilities.

Tech Touch instructors keep up-to-date on the latest tools for each program in the Microsoft suite. Because our instructors are Microsoft Certified, they often get access to the latest version of these programs in advance of them being made available to the public, so they have familiarized themselves with the latest tools before you have access to them. Therefore, we are able to deliver your best training experience when you are.

Is the training with a live instructor?

Absolutely! Whether you attend the training online or at your location, there is a live instructor delivering your class. No video recordings here.

Having a live instructor available so your team can ask questions and get real-time assistance, is the best training model for learning programs in the Microsoft Office Suite. At Tech Touch, we want you to have the best learning experience possible, so live instruction is a must.

What are the training times?

Public class times are 8am – 3:30pm Pacific / 10am – 5:30pm Central.

For private courses you can choose any 7.5 hour time slot. Most of our clients prefer to have class times starting at 9 am and ending at 4 pm.

This is something your Training Specialist will discuss with you based on your needs and availability.

All sessions include a 1-hour lunch, and two 15-minute breaks.

Do we have to attend an all-day session, or can they be broken up into smaller sessions?

For public classes, yes.

For private training, this is one of the biggest reasons Tech Touch offers customized training solutions. Your time is valuable and your team may not be available to leave their work for an entire day. We can offer half-day options and/or break your training sessions up over multiple consecutive or non-consecutive days.

Be sure to discuss your options with your Training Specialist.

Testimonials

Ready to Learn More?

Reach out below to get started on your customized Microsoft Excel training course.

The
Tech Touch
Difference

With decades of experience in corporate training, we’re proven time and again that customized training programs are far more effective than cookie-cutter classes.

We put in the work beforehand to ensure that our programs meet your individual needs and goals with a laser-focus on exactly what you need to get YOUR job done.

At Tech Touch, we operate with integrity and passion. As such, we want to be your trusted training partner, not just a training company delivering a service.

Request a Quote

Fields marked with an * are required