# Excel Learning Path **URL:** \ **Category:** Learning Paths\ **Tags:** excel\ **Created:** [February 29, 2024, 3:00pm UTC](https://www.techhub.training/t/excel-learning-path/2225 "2024-02-29T15:00:33Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Benjamin\_Lau](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/benjamin_lau/32/379_2.png) [@Benjamin\_Lau](https://www.techhub.training/u/Benjamin_Lau)\ **Post date:** [February 29, 2024, 3:00pm UTC](https://www.techhub.training/t/excel-learning-path/2225/1 "2024-02-29T15:00:33Z")
**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. **How This Page Works** The purpose of this Learning Path is to train you to a level sufficient to begin solving the beginner-level challenges on TechHub. - First, follow the instructions under Technology Access to download Excel. - 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** Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138) if you need help downloading Excel. If you have never used Excel before, we recommend watching an [intro video](https://www.youtube.com/watch?v=kSQmPK-tWnw&list=PLmkaw6oRnRv8B9JFK7z9cq2x_pJV3KdfC&index=1) before starting the challenges to familiarize yourself with the layout. Additionally, [here](https://www.youtube.com/playlist?list=PLmkaw6oRnRv8B9JFK7z9cq2x_pJV3KdfC) is a link to a youtube playlist on Excel Basics. **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](https://byu.box.com/shared/static/uhhae1pov0k86beg3r9y1zuem68d1pip) 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 > - Video: Click [here](https://www.youtube.com/watch?v=PbWRI7ANjsE) > - Left, Mid, Right: Click [here](https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-left-mid-right) > > - CONCAT > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=McHIeXY5UyI) > > - VLOOKUP, XLOOKUP > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=3MdPSHkyfdI) > > - TechHub.training challenge for this topic: [158|EXCEL – Text Manipulation](https://www.techhub.training/t/158-excel-text-manipulation/2252) > **Statistics functions** > > - IF, AND, OR > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=KkTaQ5OjAGc&ab_channel=LeilaGharani) > - If, And, Or: Click [here](https://support.microsoft.com/en-us/office/using-if-with-and-or-and-not-functions-d895f58c-b36c-419e-b1f2-5c193a236d97) > > - AVERAGE, SUM, STDDEV, VARIANCE > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=H9t4u34znEU&ab_channel=CodyBaldwin) > - Aggregate functions: Click [here](https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-aggregates) > > - SLOPE, INTERCEPT, RSQ > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=KwQsV77bYDY&ab_channel=TheOrganicChemistryTutor) > - Slope: Click [here](https://support.microsoft.com/en-gb/office/slope-function-11fb8f97-3117-4813-98aa-61d7e01276b9) > - Intercept: Click [here](https://support.microsoft.com/en-gb/office/intercept-function-2a9b74e2-9d47-4772-b663-3bca70bf63ef) > - RSQ: Click [here](https://learn.microsoft.com/en-us/office/troubleshoot/excel/statistical-functions-rsq) > > - SUMIFs, AVERAGEIFs > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=AZuBNWMh7VM&ab_channel=LeilaGharani) > - Sumifs: Click [here](https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b) > - Averageifs: Click [here](https://support.microsoft.com/en-us/office/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690) > > - Graphing > - Resouces external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=MfEAEmdFOBo) > - Graphing: Click [here](https://support.microsoft.com/en-us/topic/present-your-data-in-a-scatter-chart-or-a-line-chart-4570a80f-599a-4d6b-a155-104a9018b86e) > > - Analysis Toolpak > - Resouces external to TechHub.training > - How to load the Analysis Toolpak: Click [here](https://support.microsoft.com/en-us/office/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4) > - Regression Video: Click [here](https://www.youtube.com/watch?v=0lpfmFnlDHI) > - How to use the Analysis Toolpak: Click [here](https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6) > > - TechHub.training challenge for this topic: [148|EXCEL – Statistics](https://www.techhub.training/t/148-excel-statistics/2237) > **Solver: Optimization** > > - Basic elements (Constraints, decision variables, etc.) > - Resources to external Techub.training > - Video: Click [here](https://www.youtube.com/watch?v=MU5r2ceGbxg&t=819s) > - First 13 Minutes for introduction to skills > > - Trouble Shooting > - Resources to external Techub.training > - Video: Click [here](https://www.youtube.com/watch?v=MU5r2ceGbxg&t=819s) > - Minute 30 to the end > > - TechHub.training challenge for this topic: [144|EXCEL – Solver](https://www.techhub.training/t/144-excel-solver/2232) > **Finance functions** > > - NPV, IRR > - Resources for external TechHub.training > - Microsoft training: Click [here](https://support.microsoft.com/en-us/office/go-with-the-cash-flow-calculate-npv-and-irr-in-excel-9e3d78bb-f1de-4f8e-a20e-b8955851690c) > > - PV, FV, PMT, RATE > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=AfWRp1mExQw&ab_channel=SteveCrute) > - PV Function: Click [here](https://support.microsoft.com/en-us/office/pv-function-23879d31-0e02-4321-be01-da16e8168cbd) > - FV function: Click [here](https://support.microsoft.com/en-us/office/fv-function-2eef9f44-a084-4c61-bdd8-4fe4bb1b71b3) > - PMT function: Click [here](https://support.microsoft.com/en-us/office/pmt-function-0214da64-9a63-4996-bc20-214433fa6441) > - RATE function: Click [here](https://support.microsoft.com/en-gb/office/rate-function-9f665657-4a7e-4bb7-a030-83fc59e748ce) > > - YIELD > - Resources external to TechHub.training > - Video: Click [here](https://www.youtube.com/watch?v=rvqCLHrGB7A&ab_channel=How-ToGuide) > - YIELD Function: Click [here](https://support.microsoft.com/en-us/office/yield-function-f5f5ca43-c4bd-434f-8bd2-ed3c9727a4fe) > > - Intro Challenge to be added soon! > **Pivot Tables** > > - Pivot Tables Basic > - Resources external to TechHub.training > - Pivot Tables: Click [here](https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576) > - Sum, Average, Count: Click [here](https://www.youtube.com/watch?v=IKPjXtsKp9Q) > > - TechHub.training challenge for this topic: [146|EXCEL – Pivot Tables](https://www.techhub.training/t/146-excel-pivot-tables/2235) > **Keyboard Shortcuts** > > - Resources external to TechHub.training > - Keyboard Shortcut List: Click [here](https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f) > > - TechHub.training challenge for this topic: [164|EXCEL – Keyboard Shortcuts](https://www.techhub.training/t/164-excel-keyboard-shortcuts/2261) **TechHub Challenges** > **Beginner Challenges** > > [2|EXCEL – Little Chicken](https://www.techhub.training/t/2-excel-little-chicken/572) > [13|EXCEL – Transform Your Data!](https://www.techhub.training/t/13-excel-transform-your-data/163) > [75|EXCEL – Audit Schedule Solver](https://www.techhub.training/t/75-excel-audit-schedule-solver/641) > [125|EXCEL – Debugging Escape Room](https://www.techhub.training/t/125-excel-debugging-escape-room/756) > [129|EXCEL – Passion for Payables](https://www.techhub.training/t/129-excel-passion-for-payables/754) > **Intermediate Challenges** > > [3|EXCEL – Advisory Revenue Pivot Tables](https://www.techhub.training/t/3-excel-advisory-revenue-pivot-tables/153) > [10|EXCEL – Budget Blitz](https://www.techhub.training/t/10-excel-budget-blitz/160) > [25|EXCEL – Tax Prep Startup](https://www.techhub.training/t/25-excel-tax-prep-startup/179) > [89|EXCEL – Charting Challenge](https://www.techhub.training/t/89-excel-charting-challenge/709) > [138|EXCEL – Chettinad Chaats and Curries](https://www.techhub.training/t/138-excel-chettinad-chaats-and-curries/673) **Additional Learning** > **Certifications** > > Microsoft provides a certificate for those who pass the exam for Excel. This can provide credible evidence that you are a Excel specialist. > > - [Microsoft Office Specialist: Excel Associate](https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-2019/)