Microsoft Excel Beginner to Pro Tutorial 📊 2024 Edition [Full Course] ⚡

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:
📄prag.works/excel-beginner-to-...
Student files
✔️prag.works/lwtn-excel-student...
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan:prag.works/lwtn-trial
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: 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: [phone]
Email: [e-mail]
#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

[@ShihChiWang]

Thanks for always providing valuable courses.

[@chuckchukwuma7085]

The Best Excel Professor That I Have Ever Seen. Very straightforward teaching with so much finesse. Good job Allison! Thank you.

[@TheMusicalEmpress]

I have searched for lots of courses. Some teachers speak to quickly and are not as thorough. Thank you for this excellent course, WITH TIME STAMPS 🥰😃as I definitely need a refresher. :)🥰 Your explanations are fully broken down. New Subscriber with notifications on! Thank You!

[@user-od4fz5ls3d]

Nero!! Thanks for all what you did and u r non-selfish

[@shahzadiqbal6739]

Thanks for the Info

[@AliensMatrix]

Thanks for your teaching! It would be great if you chose a bigger mouse pointer to locate the area on the screen you are talking about.

[@mohamedsalah656]

Thank You Good work

[@SamiullahEhsan997]

Well taught.

[@chidozienwokoji4923]

Thank your very much for the video. I'm watching from Nigeria. Please in your subsequent videos, try and be zooming in so we can see what you are doing clearer . I was really finding it difficult jotting downs most of the formular

[@surenderpalsingh6508]

Thanks alottt mam❤

[@Gary-ts6dh]

1:02:00 - I would have expected Power Query to fill the column only down to the last row of data here. It looks like it filled to the end of the Year column. Is there a way to get it to stop at the end of the data? or at least, enter nothing in the rows where there is no date in the Date column?

[@TaesGamingYt]

Can we add this as a skill on our resumes?

[@KT97379]

Is it possible to earn good side income if one has a good command over excel in 2024 (keeping in mind the influence of AI). Thanks !

[@tajnazeer9209]

Hi Allison I am searching remote Excel job where to search.? Advice please

[@jignasajoshi27]

Everything good before pivot table. In Candle Table sheet we have Date field wiht numbers not date so could you please replace data file with date? so we would practice properly. Thanks a lot.

[@PragmaticWorks]

Thanks for letting us know! The link has been updated.

[@jignasajoshi27]

Thanks a lot..... appriciate for very quick response@@PragmaticWorks

[@user-iy5ek8qp9h]

I'm a beginner, with zero excel knowledge. Would this suffice?

[@johndonnelly6899]

Had a Pivot Table out of nowhere and didn't explain Dashboard, prior excellent, Thanks.

[@PragmaticWorks]

Glad it helped! Here's a link if you want to learn more about Pivot Tables: kzbin.info/www/bejne/gIfJYn-kZaqhnNE We also have an Advanced Pivot Table and Full Dashboard video coming out soon!

[@chidozienwokoji4923]

Hi, I'm watching from Nigeria. Is there any certificate issued upon completion of this course ?

[@austinlibal]

There’s a certificate in the video description.

[@user-vx2xe6qg1l]

How do I print out the short cuts sheets?

[@PragmaticWorks]

The PDF is included in the student files here: pragmaticworks.com/lwtn-excel-beginner-to-pro-student-files

[@emiliaogonowska2792]

Is it possible to download the data file for the tutorial?

[@PragmaticWorks]

You can find this in the description of the video.

[@lefty21laura]

This is not for beginners I am lost already. I need to know about entering data and creating files. Do you have a video for beginners, I have only heard about excel very limited.

[@theplumgaming2039]

Don’t see the class sheets

[@PragmaticWorks]

Student files are in the description. Here you go! pragmaticworks.com/lwtn-excel-beginner-to-pro-student-files

[@allstarsacademydaycare5405]

Hi, thank you the video. Can you create an Excel calculator for me, please? It's at Icm911 yh for now.

[@LuisPerez-bu2uc]

Sorry to long of a opening. That's why my 4 th grade teacher told me Get to the point. Sorry to long opening

[@rhettpeter83]

lol just fast forward

[@jenna80532]

Just watched 30 seconds and already don’t understand what she’s talking about.