Microsoft Excel 2023 - From Beginner to Expert in 6 Hours

Focused View

Todd McLeod

5:32:01

82 View

01 - Course information

001 Welcome.mp4

06:22

002 Course files.zip

003 Getting your certificate.mp4

03:33

02 - Quick start with MS Excel

001 Introduction.mp4

04:54

002 Microsoft Excel.mp4

05:07

002 Microsoft-Excel-From-Beginner-to-Expert-in-6-Hours-Course-Outline.pdf

003 07-relative-references-point-and-click.xlsx

003 Relative references.mp4

05:05

004 08-absolute-references.xlsx

004 Absolute references.mp4

07:32

005 09-gradebook.xlsx

005 Calculating a grade.mp4

05:17

006 10-chart-creation.xlsx

006 Creating charts.mp4

07:29

007 11-functions.xlsx

007 Functions.mp4

08:12

008 12-fcdb.xlsx

008 FCDB.mp4

02:22

external-links.txt

03 - Hands-on exercises #1

001 14-hands-on-exercises.xlsx

001 Hands-on exercises.mp4

06:52

04 - MS Excel fundamentals

001 15-16-finding-your-way-around-excel.xlsx

001 Introduction.mp4

02:06

002 15-16-finding-your-way-around-excel.xlsx

002 A tour of Excel.mp4

08:43

003 17-mouse-pointer-awareness.xlsx

003 Mouse pointer awareness.mp4

06:46

004 18-right-click-paste-transpose.xlsx

004 The power of right clicking.mp4

05:28

005 19-books-sheets.xlsx

005 Autosave & autorecover.mp4

04:21

006 MS Excel files.mp4

04:05

05 - Hands-on exercises #2

001 22-hands-on.xlsx

001 Hands-on exercises.mp4

02:18

06 - MS Excel functions

001 23-func-average-max-min.xlsx

001 Max, min, & documentation.mp4

09:26

002 24-func-rand.xlsx

002 Rand & randbetween.mp4

05:47

003 25-func-concat-textjoin.xlsx

003 Concat & textjoin.mp4

07:11

004 26-func-concat-textjoin.xlsx

004 Documentation.mp4

08:43

07 - Hands-on exercises #3

001 28-hands-on-exercises.xlsx

001 Hands-on exercises.mp4

09:00

08 - Popular Excel functions

001 29-introduction.xlsx

001 Introduction.mp4

03:35

002 30-top-10.xlsx

002 Top 10 functions.mp4

03:30

003 31-xlookup.xlsx

003 Xlookup, vlookup, & hlookup.mp4

07:14

004 32-pmt-function.xlsx

004 PMT payment function.mp4

06:41

005 33-pmt-ipmt-functions.xlsx

005 PMT IPMT loan amortization.mp4

06:59

006 34-fv-function.xlsx

006 FV future value function.mp4

04:27

007 35-fv-retirement-amortization.xlsx

007 FV retirement amortization.mp4

02:42

008 36-if-iferror-functions.xlsx

008 IF IFERROR dynamic amortization.mp4

05:42

009 37-conditional-formatting.xlsx

009 Conditional formatting.mp4

03:35

09 - Hands-on exercises #4

001 39-ice-cream-choice.xlsx

001 Hands-on exercises.mp4

03:36

10 - Formatting for impact

001 40-fundamentals-of-formatting.xlsx

001 Fundamentals of formatting.mp4

04:11

002 41-formatting-tables-quickly.xlsx

002 Formatting tables of data quickly.mp4

04:30

003 42-font-is-feeling.xlsx

003 Font is feeling - font formatting.mp4

05:40

004 43-exploring-home-ribbon.xlsx

004 Exploring the home ribbon.mp4

07:12

005 44-zebra-stripe-rows.xlsx

005 Zebra stripe rows.mp4

04:08

11 - Hands-on exercises #5

001 46-hands-on-exercise.xlsx

001 Hands-on exercises.mp4

01:51

12 - Creating charts & graphs

001 47-visually-representing-data.xlsx

001 Content & form.mp4

06:36

002 48-chart-creation-II.xlsx

002 Creating charts.mp4

07:12

003 49-formatting-charts.xlsx

003 Formatting charts.mp4

06:32

004 50-trendlines.xlsx

004 Chart trendlines.mp4

04:40

005 51-combo-chart.xlsx

005 Combo charts.mp4

07:12

006 52-sparklines.xlsx

006 Sparklines.mp4

03:20

external-links.txt

13 - Hands-on exercises #6

001 54-exercises.xlsx

001 Hands-on exercises.mp4

04:17

14 - Working with data

001 55-gapminder-road-data.xlsx

001 Gapminder data.mp4

05:26

002 56-scraping-data.xlsx

002 Scraping web data.mp4

04:39

003 57-outdoor-gear-data.xlsx

003 Outdoor gear coop.mp4

05:06

004 58-name-generator-data.xlsx

004 Name generator.mp4

04:42

external-links.txt

15 - Massaging data

001 59-sorting-data.xlsx

001 Sorting data.mp4

05:06

002 60-freeze-panes.xlsx

002 Freeze panes.mp4

03:26

003 61-remove-duplicates.xlsx

003 Removing duplicates.mp4

01:14

004 62-filter-data.xlsx

004 Filtering data.mp4

03:11

16 - Hands-on exercises #7

001 64-remove-duplicates.xlsx

001 Hands-on exercises.mp4

03:31

17 - Pivot tables in Excel

001 65-pivot-tables.xlsx

001 Introduction.mp4

06:49

002 66-creating-pivot-tables.xlsx

002 Creating pivot tables.mp4

04:43

003 67-pivot-table-slicers.xlsx

003 Slicers - filtering pivot tables.mp4

02:26

004 68-pivot-charts.xlsx

004 Pivot charts.mp4

03:11

18 - Hands-on exercises #8

001 70-pivot-exercises.xlsx

001 Hands-on exercises.mp4

01:16

19 - Odds & ends

001 71-printing-worksheets.xlsx

001 Printing your worksheet.mp4

05:40

002 72-protect.xlsx

002 Protecting (locking) workbooks, sheets, and cells.mp4

05:34

003 73-ole.docx

003 73-ole.xlsx

003 Object linking & embedding (OLE).mp4

01:34

20 - Creating macros

001 74-macros.xlsx

001 74-macros.zip

001 Introduction to macros.mp4

04:53

21 - Hands-on exercises #9

001 76-macros.xlsx

001 76-macros.zip

001 Hands-on exercises.mp4

03:30

22 - Congratulations

001 Great work!.mp4

01:48

002 Bonus lecture.mp4

02:15

Description

Excel Made Easy - From Beginner to Expert - Microsoft Certified Master Instructor - MOS Expert - Master Microsoft Excel

What You'll Learn?

Learn Microsoft Excel Fast: Excel formulas and functions, Excel shortcuts and tips, Excel charts and graphs, Excel for beginners & intermediate users
Taught by a best-selling Udemy author, Microsoft Certified Educator, Microsoft Office Specialist Expert, & Tenured College Professor
Conditional formatting in Excel, Excel date functions and formatting, Excel templates, Excel for Data Management
Data analysis in Excel, Pivot tables in Excel, Excel for data visualization, Excel data validation, Excel macros
Excel for business analysis, Excel for finance and accounting, Excel for sales and marketing
Excel for budgeting and forecasting, Excel for project management, Excel for inventory management
Excel functions: sum, vlookup, xlookup, if, count, average, concatenate, max, min, round, and more
Excel documentation: learn how to read Excel's documentation so that you are empowered to find answers
Hands-on exercises with solutions, Over 400,000 students taught, Lifetime course access
100% satisfaction guaranteed, Learn at your own pace, This course is tested and proven

Who is this for?

This course is perfect for beginners to Microsoft Excel & for people with some experience with Excel

Lifetime access to this Excel training allows you to come back to review material or learn more about MS Excel

What You Need to Know?

In order to participate in the hands-on portions of this course, you will need to have Microsoft Excel.

More details

Description
This training provides you everything you need to know about Microsoft Excel.
From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.
You can learn Microsoft Excel easily and quickly if it is taught correctly.Â Developed by a Microsoft Certified Master Instructor, this course provides comprehensiveÂ coverage onÂ Microsoft Excel. A university professor withÂ over twentyÂ years of experience teaching individuals of all ability levels "how to use" Microsoft Excel,Â Todd McLeod has designed, refined, and perfected thisÂ course to make it easy for you to masterÂ Microsoft Excel.
In only five hours of videos, provided to you in 80 separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:
Learn how to navigate around Excel
Learn how to enter and edit data in Excel
Learn how to adjust the way data and information are displayed in Excel
Learn how to write formulas quickly and easily with the point-and-click method
Learn how to use relative, absolute, and mixed references in Excel
Learn how to create powerful calculations with Excel functions
Learn how to visually represent your data with charts and graphs in Excel
Learn how to use Excel data tools like sorting, subtotaling, and filtering
Learn how to "freeze columns and rows" with freeze panes in Excel
Learn how to remove duplicates from data in Excel
Learn how to "transpose data" - switching the columns and rows in Excel
Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
Learn how to format worksheets in Excel for impact and appeal
Learn how to automate Excel tasks with time-saving macros
Learn how to integrate Microsoft Excel with Microsoft Word
Learn how to use passwords in Excel to protect your work in multiple scenarios
Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
Learn how to use printing and sharing in Excel
how to harvest data from the web
how to create online forms which allow you to gather data from individuals
Download all of the Excel project files that are used in the videos
This class is guaranteed to teach you Microsoft Excel.
Described as â€œfunâ€ and â€œamazingâ€ and â€œlife changing,â€ Todd McLeodâ€™s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.Â
Who this course is for:
This course is perfect for beginners to Microsoft Excel & for people with some experience with Excel
Lifetime access to this Excel training allows you to come back to review material or learn more about MS Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Fun, Quick, & EasyLearning can be fun, quick, and easy if you have the right teacher. I come from a family of teachers, I've taught at the college and university level for over 20 years, and I have been recognized as one of the top teachers in the California college system. I became a teacher because I love sharing knowledge and seeing how it transforms people's lives. Learning is the noblest of all endeavors. The more you learn, the more you improve your life.Learn Quickly & Effectively All of my courses include step-by-step tutorials and hands-on exercises. The tutorials show you what to do. The hands-on exercises allow you to practice what you have just seen. These hands-on exercises also come with all of the files you need and video solutions so that you can learn more quickly and effectively.Great Courses for BeginnersI work with beginners all of the time. I understand how to take topics and make them easy to understand.The Human ElementStudents do better in classes where they enjoy the teacher. I am a bit goofy at times but this keeps my courses fun, interesting, and engaging. When you are learning with me, you are guaranteed to have a few laughs.Traditional Credentials I am a tenured professor in California, an autodidact, and multidisciplinarian. I have taught at the graduate and undergraduate levels in business, information system, and computer science. I also have a lot of knowledge about mindfulness, meditation, psychology, and personal growth. I was born into a culture of mindfulness and meditation, and have been involved with mindfulness and meditation all of my life. I have authored 48 books and have experience with the publishing industry, literature, and film. As I said, I love learning and love sharing knowledge with others.I look forward to seeing you in class!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.