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-pro-certificate Student files ✔️https://prag.works/lwtn-excel-student-files 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: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.w... ✔️LinkedIn: https://www.linkedin.com/company/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