Microsoft Excel Automation and Power Queries

Learn techniques to improve efficiencies and automate tedious tasks

Continuing Education Credits: CEU: 0.3 

Download Brochure

Half-Day Seminar


$189 for groups of 5 or more

Choose an Event

Jul (8)
Aug (8)


Bring this topic or 200+ other training opportunities to your location in-person or online.

Request Onsite Training

Already attended this seminar?

Rate and Get Certificates

View additional Computer Software training

"I have been a member of Fred Pryor for almost three years now and I have yet to attend a class that didn't have valuable information that would benefit my company and/or our employees."

— Teri M.

"Excellent!! As always, Fred Pryor's courses are easy to follow, very informative and presented in a format that keeps your attention!!"

— Cynthia S.

"I enjoy all of the seminars that I attend through the Fred Pryor Training Rewards program. They are very informative and the instructors are very knowledgeable and helpful."

— Tasha M.

"Excellent info for all levels of users. There are always things to add to your "bag of tricks"."

— Wendy S.

"Wow! I have taken many wonderful courses through Fred Pryor; this one takes the cake!!"

— Dana N.

"Top notch! Thank you Fred Pryor, this is the best investment my boss could have made."

— Lewis C.

"I received a lot of great information in this training. Several co-workers went with me which was a great help for me to start implementing some of the changes we need to do at the office. It was very eye opening for them to realize the things that we need to do at the office. It was very eye opening for them to realize the things that need to get to me. It was like Fred Pryor and the trainer had my back!"

— Tasha C.


This course provides solutions using Microsoft 365 Business Standard, Microsoft 365 Premium or Microsoft 365 Education online and desktop. Microsoft 365 Basic does not have all of the applications needed to perform some of the functions.

According to Business Money, automation of business processes can save your organization money, increase productivity and efficiency of employees and improve overall job satisfaction. Prevent your schedule from filling up with repetitive deadlines and menial tasks. Microsoft Excel’s automation solutions can improve your efficiency, allowing you to focus on more important responsibilities.

Working with Microsoft Excel can become redundant. How many times do you have tasks that require the same steps to be repeated over and over again? Not only is this boring and time-consuming, but it’s also error prone. Humans aren’t perfect, so when a process is manual the chances of mistakes increase. Decrease this likelihood by taking advantage of Microsoft’s many automation solutions and focus your organization’s manpower on improving other areas of business. Microsoft 365 has automation solutions to address these issues using Power Automate, Office Scripts and Power Query.

With the increase of hybrid workspaces, automation of tasks is more important than ever. Get the most out of your employees by utilizing Microsoft Excel’s automation tools to complete tedious, monotonous tasks and focus their brainpower on innovation and improvement of other business areas. Save time and money, as well as offer the tools for your business to leap ahead of your competitors.

What You Will Learn

  • Automate repetitive steps without coding.
  • Improve reliability of data.
  • Reduce time and effort required for repetitive steps.
  • Focus on the data and not the data cleanup.
  • Allow less experienced team members to complete complex functions.
  • Trigger activities automatically.
  • Create complex functions without coding.

Who Will Benefit

Intermediate to Advanced Excel Users; recommend experience working in Microsoft 365, any businessperson working with data to achieve a goal.