Microsoft Excel Beginner to Pro Tutorial 📊 2024 Edition [Full Course] ⚡
Vložit
- čas přidán 30. 06. 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:
📄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: (904) 638-5743
Email: training@pragmaticworks.com
#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 - Zábava
Thanks for always providing valuable courses.
The Best Excel Professor That I Have Ever Seen. Very straightforward teaching with so much finesse. Good job Allison! Thank you.
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!
Nero!! Thanks for all what you did and u r non-selfish
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.
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
Thanks for the Info
Thank You Good work
Well taught.
Thanks alottt mam❤
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?
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 !
Can we add this as a skill on our resumes?
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.
Thanks for letting us know! The link has been updated.
Thanks a lot..... appriciate for very quick response@@PragmaticWorks
Had a Pivot Table out of nowhere and didn't explain Dashboard, prior excellent, Thanks.
Glad it helped! Here's a link if you want to learn more about Pivot Tables: czcams.com/video/JVf1Ln0Enfo/video.html
We also have an Advanced Pivot Table and Full Dashboard video coming out soon!
Hi
Allison I am searching remote Excel job where to search.?
Advice please
I'm a beginner, with zero excel knowledge. Would this suffice?
Hi, I'm watching from Nigeria. Is there any certificate issued upon completion of this course ?
There’s a certificate in the video description.
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.
Is it possible to download the data file for the tutorial?
You can find this in the description of the video.
How do I print out the short cuts sheets?
The PDF is included in the student files here: pragmaticworks.com/lwtn-excel-beginner-to-pro-student-files
Sorry to long of a opening. That's why my 4 th grade teacher told me Get to the point.
Sorry to long opening
lol just fast forward
Don’t see the class sheets
Student files are in the description. Here you go! pragmaticworks.com/lwtn-excel-beginner-to-pro-student-files
Hi, thank you the video. Can you create an Excel calculator for me, please? It's at Icm911 yh for now.
Just watched 30 seconds and already don’t understand what she’s talking about.