Master Excel || From Dashboards to Formulas --> Excel Business Systems Analyst teaching Excel for students & business professionals with a focus on Pivots, advanced charting, & Dashboard. I have 10 ye

Details

Before we Dive in.....

First, I think it's important to dispel the misconception of the difficulty in understanding Excel. It is a feature rich dynamic app that can overwhelm based on initial glance but, it is also incredibly easy to become comfortable with it when paired with a teacher that understands your habits, preferences, and learning style.

Albeit, instructors, such as myself, have their teaching patterns in order to aid our learners, it behooves us to make our style flexible to best align with learning.

My goal is to guide you on your journey to becoming a master of excel, and, if I do things properly, a teacher yourself someday.

Materials --------------------------------------------------------------

1. Resources:

It is strongly recommended you have access to Microsoft Excel 2021 or greater due to the deprecation of certain functions and integration of new features, which will make your workflow process easier and allow me to instruct you on the most up-to-date features and skills.

If you do NOT have MS Office 365 or Excel 2019 I do provide options for downloading (OS dependent).

Thusly, you will need to have Excel on your local device, have access to Microsoft 365 (online version), or be able to access Excel through an intermediary system such as Mac App Store.

I provide all course material and exercises in a Zipfile that you can download.

If you prefer I can support BYOF (bring your own files), however, this may not produce the best learning experience as materials I provide cover many use cases and scenarios that are helpful for understanding real world application.


2. Pedagogy ----------------------------------------------------------

I adhere to practice-based methodology complemented by interpretation of terms in your own words followed by grouped module exercises.
> Here's a breakdown of what I teach based on skill level:

i) Beginner:
- Shortkeys
- Filtering, Sorting, Grouping, and Formatting
- Flash Fill
- Tables & Ranges
- Basic Charts
- Styles & Designs

ii) Intermediate:
- More Ranges & Pvt Tables
- Created Dynamic Charts and Dashboards
- Excel for Data Analysis and Business Analysis
- Solver & What-IF Analysis
- Logic, Reference and Aggregate FUNCTIONS & FORMULAS (i.e. XLOOKUP, V/HLOOKUP, INDEX, MATCH, FIND etc.)
- Custom LISTs and FORMATTING

iii) Advanced:
- LET, Lambda and Nested IFS
- Add-ins such as FRED, PowerQuery
- Advanced Pvt & PowerPvt, DAX++
- Using ERROR controls
- Data Visualization for Business Case & Presentations