Learn to apply the important concepts and techniques of data analysis using Excel.

This course, "Data Analysis Essentials Using Excel", is meticulously designed to transform you into an Excel wizard, capable of extracting profound insights from complex datasets. In today's data-driven world, the ability to analyze information and make informed decisions is paramount, and Excel remains an indispensable, accessible tool for anyone looking to bridge the gap between raw data and actionable business intelligence. You will gain hands-on expertise through practical, real-world scenarios, learning to manipulate, analyze, and visualize data effectively.
Upon completion, you will be proficient in:
This course provides the essential skills to confidently turn data into powerful narratives, empowering you to drive smarter decisions.

Stanford MBA, Real Estate Expert, Financial Modeling Ninja
Hey, thank you for considering taking one of my courses. I am a real estate and business consultant based out of Los Angeles CA. I am the co-author of "Airbnb for Dummies", to be released May 2020. I currently help private real estate investors with their acquisitions and deal structuring and advise startup entrepreneurs on their business models and financial forecasts. Previously, I was head of marketing analytics at the Panda Restaurant Group after serving as a senior financial analyst supporting new store underwriting efforts. Before that, I was a global M&A manager for Ingram Micro, a Fortune 80 company. Prior to that, I worked on commercial real estate acquisitions at a private equity real estate fund, covering a wide range of asset classes across the western USA. I am also a cofounder of LearnBNB, a boutique consultancy and education blog specializing in the home-sharing economy. I received dual degrees in Computer Engineering (Magna Cum Laude) and Economics (Summa Cum Laude) from UC Irvine and an MBA from Stanford University.

Tech Veteran | University of Chicago MBA My first job at age 21 was building and designing Microsoft Excel formulas and VBA at Microsoft Corporation. I am a seasoned tech veteran from Silicon Valley. I co-founded my first company at age 22 in the Bay Area and have since participated in six successful exits as tech entrepreneur, investor and management. The previous company I sold was for data analytics. Currently, I advise and teach people how to scale businesses digitally and expand into international markets. I hold degrees in Computer Science and studied Financial Mathematics and MBA at the University of Chicago.
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.