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:
Student files

Next step on your journey:


Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

#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.

[chuckchukwuma]

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!

[odfzlsd]

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

[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.

[Gary-tsdh]

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?

[chidozienwokoji]

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

[tajnazeer]

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

[KT]

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 !

[jignasajoshi]

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.

[TaesGamingYt]

Can we add this as a skill on our resumes?

[iyekqph]

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

[chidozienwokoji]

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

[johndonnelly]

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

[vxxeqgl]

How do I print out the short cuts sheets?

[emiliaogonowska]

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

[leftylaura]

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.

[allstarsacademydaycare]

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

[LuisPerez-buuc]

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

[jenna]

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