Microsoft Excel

Overview Last time you opened a spreadsheet and are overwhelmed by the Excel Vlookup being used. You don’t know how to make the most out of them, or change them into…

Overview This course teaches you to create well-designed dynamic Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data. By participating in this Microsoft Excel Dashboard…

Overview We will cover the following most common Excel formulas for intermediate users in the Finance world: Vlookup If Statements SumIF AverageIF CountIF TRIM Concatenate  Left, Right, Mid Data Validation…

Overview In this class I discuss the 15 most useful Excel formulas.  Everyone lesson covers a (group of) formula(s). The videos are built up in three ways:1. What does the formula do?2. What…

Overview Are You A Beginner to Intermediate Excel User? Have You Heard Of Pivot Tables But Never Fully Understood How To Create Them? Are You Not Even Sure What You…

Overview In this class, you’ll learn the basic tools and functions that Microsoft Excel offers to do a Data Analysis. While Excel has an endless set of tools and features,…

Overview Basic Excel for Basic Bookkeeping — an introductory Class for those that are new to Excel and new to Bookkeeping or need a refresher class In This Class You Will Learn…

Overview Learn how to plan your project/month/year in this project using Google Sheets and Bullet Journaling. In this class, we will explore how to create a project for your year…

Overview Unlock the power of Excel Tables for your dashboards, models, and reports! Excel Tables is a relatively unknown feature within Excel, but mastering it elevates the quality of dashboards, data…

Overview Welcome to the course on Excel VBA — Learn from very basics of Macros Course! This class is completely targeted towards basics of VBA Programming. I have designed in a way it is…