Hands-On Excel Tutorial 📊 Beginner to Pro Course (2024)

Learn Microsoft Excel and go from Beginner to Pro with this hands-on tutorial. Whether you're just starting out or looking to level up your spreadsheet skills, this full course is designed to be your guide to Microsoft Excel in 2024. We'll kick things off with the basics, ensuring you have a solid foundation in navigating the interface and performing fundamental tasks. As we progress, we'll delve into advanced features, plus tips and tricks that will transform you into an Excel pro!

You will learn about:
Excel basics
Formula usage
Power Query
Excel dashboard design

Download your certificate of completion after you finish this course:
📄https://prag.works/excel-beginner-to-...
Student files
✔️https://prag.works/lwtn-excel-student...

Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan:https://prag.works/lwtn-trial

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:
✔️Twitter:   / pragmaticworks  
✔️Facebook:   / pragmaticworks  
✔️Instagram:   / pragmatic.w.  .
✔️LinkedIn:   / prag.  .

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]

#excel #PragmaticWorks #Allisongonzalez #Training #Microsoft #Tech #FreeConference #learnwiththenerds

**Any sales mentioned in the video may no longer be valid. Offers are subject to change with/without notice and are for a limited time only.

00:00 - Introduction and Agenda
06:15 - Cell Referencing
09:37 - Cell Notation Styles
13:38 - Microsoft Excel Keyboard Shortcuts
15:19 - Formula Editing Tips
27:29 - Math and Statistical Functions (AVERAGE, SUM)
35:19 - XLOOKUP
41:34 - Excel Bootcamp Promo
43:35 - Power Query Basics
1:06:36 - CertXP, a new way to learn with Pragmatic Works
1:09:45 - Microsoft Excel Dashboard Design
1:12:42 - Creating a wireframe as a skeleton for the dashboard design
1:22:22 - Designing the background and layout for the Excel dashboard
1:24:44 - Creating visually appealing cards using cell formatting techniques
1:26:47 - Incorporating live data into the dashboard using pivot table values
1:28:34 - Adding slicers for interactive filtering of data in the dashboard
1:30:20 - Closing and future Learn with the Nerds Promo