Learn how to quickly format, view, and organize your Microsoft Excel data using easy formulas and built-in tools.
Microsoft Excel is one of the most widely used tools for managing and analyzing data—and once you know a few key functions, you’ll be amazed at how much faster and smarter you can work. This beginner-friendly course shows you the most important formulas and built-in tools that anyone using Excel should know. In less than an hour, you'll be able to clean up data, find information fast, and even build charts that bring your numbers to life.
You'll learn essential formulas like VLOOKUP, IF, and CONCATENATE, as well as tools like PivotTables, Conditional Formatting, and Text to Columns. We’ll also walk through how to create basic and dual-axis charts for effective data storytelling. If you're looking to gain a solid Excel foundation quickly and confidently, this course is for you.
Digital Media Professional
I'm an award winning digital media professional with over a decade and a half of experience working in the digital space. In that career I've negotiated countless contracts as both a buyer and seller. I’ve even negotiated multi-million dollar contracts with Fortune 500 brands, some of which took over a year to finalize. Since 2015 my online courses have been taken by over 60,000 students around the world, with thousands of five-star reviews. When I'm not teaching, I work full time in the advertising space, speak at conferences, or I'm at home in NYC watching the Buffalo Bills! I can't wait to see you in class!
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.
