# Excel Learning Path

Excel Learning Path

Authors: @Benjamin_Lau, @Carter_Lee, @Dallin_Gardner

Introduction
This Excel learning path aims to provide practices and challenges for those who are still learning how to use Excel. Hopefully, it helps you learn and develop. It does not aim to provide teaching and tutorials for each function. We direct the learning of some specifics to existing materials, for example, YouTube videos and Microsoft webpages.

The purpose of this Learning Path is to train you to a level sufficient to begin solving the beginner-level challenges on TechHub.

• Then, take some time to look through the resources provided under Background Learning. These modules will teach you the basic skills you’ll need to use Excel.
• Next, work through the Intro Challenges section.

After completing these steps, you’ll be ready to tackle the Additional Challenges found on the TechHub website! We’ve listed them under Continue the Learning Journey in difficulty order to help you develop your skills. If you need help along the way, refer to the Background Learning links or the Additional Resources links for some direction. Good luck!

Background Learning

Dataset
We will use the same dataset of SmartHome Co. to walk through each topic of basic functions in Excel. SmartHome Co. sells smart home systems of three levels (Base, Plus, and Full). SmartHome has an international salesforce and generates millions of sales each year. This dataset of SmartHome employees includes their information, performance, and satisfaction scores in the sheet “Employee Data”. SmartHome Co.’s Japanese branch’s sales mix analysis is included in the sheet “Sales Mix Analysis”.

Text Manipulation and Lookups
• RIGHT, LEFT, MID
• Resources external to TechHub.training
• CONCAT
• Resources external to TechHub.training
• VLOOKUP, XLOOKUP
• Resources external to TechHub.training
• TechHub.training challenge for this topic: 158|EXCEL – Text Manipulation
Statistics functions
• IF, AND, OR
• Resources external to TechHub.training
• AVERAGE, SUM, STDDEV, VARIANCE
• Resources external to TechHub.training
• SLOPE, INTERCEPT, RSQ
• Resources external to TechHub.training
• SUMIFs, AVERAGEIFs
• Resources external to TechHub.training
• Graphing
• Resouces external to TechHub.training
• Analysis Toolpak
• Resouces external to TechHub.training
• TechHub.training challenge for this topic: 148|EXCEL – Statistics
Solver: Optimization
• Basic elements (Constraints, decision variables, etc.)
• Resources to external Techub.training
• First 13 Minutes for introduction to skills
• Trouble Shooting
• Resources to external Techub.training
• Minute 30 to the end
• TechHub.training challenge for this topic: 144|EXCEL – Solver
Finance functions
• NPV, IRR
• Resources for external TechHub.training
• PV, FV, PMT, RATE
• Resources external to TechHub.training
• YIELD
• Resources external to TechHub.training
• Intro Challenge to be added soon!
Pivot Tables
• Pivot Tables Basic
• Resources external to TechHub.training