Learn advanced Excel techniques to automate workflows, enhance security, and create dynamic dashboards with tools like INDEX, XLOOKUP, and PivotBy.
Master advanced Excel techniques with this comprehensive course.Learn to filter and search data dynamically, create automated workflows with macros, and build visually engaging dashboards.
Discover lookup methods, including INDEX, MATCH, and XLOOKUP, for efficient data retrieval, and explore advanced charting and tracking techniques. Develop practical tools like habit trackers, expiry alerts, and project scheduling systems using functions like NETWORKDAYS and STOCK HISTORY.
Enhance security with cell protection strategies, streamline large spreadsheet printing, and automate titles for a dynamic workflow. Dive into innovative features like Copilot and PivotBy, and even create barcodes and hyperlinks to elevate your productivity.
In this program, it includes the following assets:
Assemble You teaches the Power Skills you need to build the best you. Skills unique to humans. Leadership, Productivity, Wellbeing, Project Management, Communication, Intrapreneurship, Strategy, Systems, Ethics, and so much more. Each Assemble You course includes impactful video lessons, downloadable key-point infographics and ends with a short test. Become the best you with Assemble You.
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.
