To Join The Live Class: Please Click On The Join Live Class via Zoom Button
Microsoft Excel
Intermediate & Advanced
March 25 - April 24, 2025 every Tuesday & Thursday from 4:00pm EST - 5:00pm EST
Click on the button below to join the live class at the scheduled time
Getting Started
Class Expectations
Watch this video to learn more about what we expect from our students during our online classes and what you can expect from your online learning experience and from your instructor.
Online Class Tips
A quick guide on how to access our live classes, when and how to access the class recordings, where to download the files (i.e. spreadsheets) for the class and more.
Solutions to Practice Exercises
Stuck while completing one of our practice exercises? Do you want to check your work to see if you completed the Practice Exercises correctly. Click on the button to view tutorials and the files with the solutions to all practice exercises.
Meet your Instructor
My Microsoft Office journey began 10 years ago in college during my first semester of business school. I have been hooked on Microsoft Office programs, such as Excel, PowerPoint, Word, Outlook and others ever since. My interests and passions include minimalism, startups, investing and yoga/meditation. In my free time I enjoy scenic long drives, spending time in nature and gaining wisdom from thought leaders via books and podcasts. My favorite book is Meditations by Marcus Aurelius.
Adi Ruparel
adiruparel@leadershipbuild.com
Class Recordings & Files
Lesson 1: A Refresher on Basic Excel Formulas
During the first day of class, we will do more of a "refresher" and cover how to use basic Excel formula, learn the structure, provide a few tips when working with formulas and give you time to apply what you have learned.
Lesson 2: Working with Dates
In this lesson, we'll focus on how we can use formulas with dates in our tables. We'll learn a few ways to calculate years and how to use certain formulas to calculate days.
Lesson 3: Conditional Formatting & Data Validation
We'll take a brain-break from Excel formulas and learn how to use Conditional Formatting and how to control data entry errors with Data Validation.
Lesson 4: Text to Columns, Text Formulas & Special Values
We're going to expand on our skills on Lesson 4 and learn more about Text functions in Excel: text formulas, text to columns and how to remove formulas from cells.
Lesson 5: Shortcuts to Use with Tables
Lesson 5 will be a "catch up" day where you'll learn some table shortcuts and get a chance to apply what you have learned so far in the class.
Lesson 6: Intro to Logical Formulas
During this session, you'll be introduced to variations of the IF formula and learn (and create) logical formulas to place rules on your calculations.
Lesson 7: Advanced Logical Formulas
This session is a continuation from the previous session. In this session you will learn how to use more automated rules using IF, AND and OR formulas.
Lesson 8: Lookup Formulas
During this session, you'll learn how to use the VLOOKUP formula and other LOOKUP formulas.
Lesson 9: Pivot Tables
During this session, you'll learn the easy way to create pivot tables, best practices for using them and how to make them presentable
Lesson 10: Pivot Charts
Learn how to create charts and graphs with Pivot Charts on the final day of class.
Leave A Comment or Question
Copyright © Leadership Build 2021. All Rights Reserved.