Microsoft Excel Automation
Repetitive tasks in Microsoft Excel may feel tedious and laborious. By automating routine data entry, you can simplify your work and improve your processes.
Sign up for this LIVE, instructor led course and walk through ways to extract, transform and load data automatically with Power Query. You’ll create and record TypeScripts to automate the full range of Excel and Office options. And if you need to integrate more than one application into your automation scheme, you’ll create a custom Excel flow and build processes using Power Automate.
Please note this program is intended for intermediate to advanced users of Microsoft Excel. For the best experience, a subscription to Microsoft 365 is recommended.
Course Outcomes
- Reformat and organize large data sets with Power Query
- Automate regular data merges from external sources
- Record repetitive steps with no-code Office Scripts
- Navigate the Power Automate interface and templates
- Use Power Automate instant flows for repetitive tasks
- Trigger automation using automated, instant or scheduled flows
Course Agenda
Request group training
Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.
More Courses in