Streamline your operations by mastering data automation and analysis tools to transform complex tasks into efficient workflows for smarter decision-making.
Unlock the full potential of your spreadsheets and stop letting the software push you around with the course Operations Management Techniques in Excel. Led by expert David Ringstrom, CPA, this course is designed to transition users from brute-force manual data entry to efficient, automated operations management. Whether you are an accountant or a business professional in any field, you will learn how to overcome common obstacles in Excel and establish workflows that save time and reduce errors.
This comprehensive training moves beyond basic spreadsheet usage, focusing on the specific tools and techniques required to manage operations effectively. You will discover how to streamline data extraction, automate repetitive cleaning tasks, and utilize advanced analysis features to make data-driven decisions. By mastering these techniques, you ensure that you are controlling Excel, rather than letting it control you.
Key topics covered in this course include:
By the end of this course, you will possess a robust toolkit for handling complex data operations, allowing you to summarize, visualize, and forecast with confidence.
CPA, Author, Professional Excel Spreadsheet Trainer and Consultant
David H. Ringstrom, CPA, is the author of Microsoft 365 Excel for Dummies, and a nationally recognized instructor who has taught over 2,500 live webinars. His Excel courses are based on over 30 years of consulting and teaching experience. David’s catchphrase is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should know about Microsoft Excel. His goal is to empower you to use Excel more effectively. David has authored or co-authored 10 books, including Exploring Microsoft Excel's Hidden Treasures, QuickBooks Online for Dummies, and Idiot's Guide to Introductory Accounting.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
