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.
5 activities • 15 videos • duration: 46m
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!
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
fun, easy to understand
good overview of excel basics
Thank you this course was really helpful :)
Good tips, need to spend some time now reviewing with my own data
