Complete Excel Course - Beginner to Expert

Focused View

Jarrod Hill

20:19:22

58 View

1. Introduction

1. Introduction.mp4

00:45

1. Introduction.zip

2. Fundmentals

1. Excel for Complete Beginners.mp4

08:52

2. Basic Math.mp4

09:29

3. Referencing Cells.mp4

13:45

4. Fixed & Relative Cell References.mp4

20:17

5. Fundamentals Quiz.html

6. Fundamentals Assignment.html

3. Formatting

1. Formatting Basics.mp4

21:44

2. Number Formatting.mp4

14:46

3. Custom Formatting Part 1.mp4

33:43

4. Custom Formatting Part 2.mp4

05:06

5. Formatting a Balance Sheet.mp4

09:15

6. Cell Styles.mp4

05:26

7. Conditional Formatting Part 1.mp4

39:55

8. Conditional Formatting Part 2.mp4

15:37

9. Formatting Quiz.html

10. Formatting Assignment.html

4. Working With Data

1. Sorting.mp4

08:59

2. Filtering.mp4

09:49

3. Advanced Filter.mp4

10:47

4. Hiding, Grouping & Subtotals.mp4

14:19

5. Text to Columns.mp4

05:33

6. Flash Fill.mp4

04:11

7. Data Validation.mp4

18:10

8. Connecting to an External Workbook.mp4

04:01

9.1 UFC Fights.txt

9. Connecting to a Text File.mp4

02:57

10. Connecting to a Website.mp4

04:58

11. Stocks & Geography.mp4

02:25

12. Consolidate Data.mp4

04:40

13. Scenario Manager.mp4

08:41

14. Data Tables.mp4

08:03

15. Goal Seek.mp4

08:01

16. Solver.mp4

07:44

17. Forecasting.mp4

03:23

18. Named Ranges.mp4

22:12

19. Booleans.mp4

07:18

20. Tables.mp4

12:21

21. Working With Data Quiz.html

22. Working With Data Assignment.html

5. Formulas & Functions

1. Intro to Functions.mp4

08:19

2. Logial Functions.mp4

23:14

3. Errors.mp4

06:14

4. INDIRECT.mp4

15:12

5. Basic Functions on Ranges.mp4

05:29

6. OFFSET.mp4

17:22

7. SUMCOUNTAVERAGE IF(S).mp4

10:26

8. SUMPRODUCT.mp4

12:52

9. More Math Functions.mp4

12:18

10. More Text Functions.mp4

26:00

11. Lookup Functions-VLOOKUP, HLOOKUP & LOOKUP.mp4

38:02

12. INDEX & MATCH.mp4

17:10

13. INDEX Part 2.mp4

16:21

14. Formula Auditing & Formula Ribbon Tab.mp4

07:32

15. Date & Time Functions.mp4

18:50

16. SUBTOTAL & AGGREGATE.mp4

05:47

17. CHOOSE.mp4

10:00

18. FREQUENCY.mp4

02:44

19. Financial Functions.mp4

18:26

20. Other Functions.mp4

09:40

21. Formulas & Functions Quiz.html

22. Formulas & Functions Assignment.html

6. Arrays

1. Note On Videos In This Section.html

2. Old Array Formulas (Pre-2018).mp4

17:25

3. FILTER.mp4

13:09

4. SORT & SORTBY.mp4

09:09

5. RANDARRAY & SEQUENCE.mp4

06:19

6. UNIQUE.mp4

01:29

7. SINGLE.mp4

02:57

8. XLOOKUP.mp4

24:29

9. XMATCH.mp4

07:58

10. Applying Arrays to Standard Functions.mp4

04:06

11. Using Arrays To Create A Searchable Dropdown List.mp4

10:54

12. Arrays Quiz.html

13. Arrays Assignment.html

7. Pivottables

1. Pivottable Introduction.html

2. Pivottable Examples 1.mp4

22:03

3. Pivottable Examples 2.mp4

10:39

4. Manual Sort, Multiple Filter & Pivottable Options.mp4

04:26

5. Drill Down.mp4

01:35

6. Conditional Formatting in Pivottables.mp4

01:16

7. Grouping Dates.mp4

03:17

8. Slicers.mp4

10:30

9. Timelines.mp4

06:43

10. Analyse & Design.mp4

12:17

11. Calculated Fields.mp4

06:31

12. GETPIVOTDATA Formula.mp4

06:20

13. Pivotcharts.mp4

04:44

14. Pivottables Summary.mp4

09:48

15. Introduction to Powerpivot.mp4

03:59

16. Pivottables Quiz.html

17. Pivottables Assignment.html

8. Charts

1. Chart Foundations.mp4

10:44

2. Dynamic Chart Ranges.mp4

10:29

3. Chart Design.mp4

06:25

4. Chart Formatting Part 1.mp4

22:00

5. Chart Formatting Part 2.mp4

05:25

6. Column vs Bar Charts.mp4

04:59

7. Line Charts.mp4

08:09

8. Pie Charts.mp4

04:34

9. Scatter & Bubble Charts.mp4

05:13

10. Histogram.mp4

02:27

11. Other Charts-Box & Whisker, Sunburst, Treemap, Funnel, Surface, Radar.mp4

09:45

12. Maps.mp4

02:23

13. Project Timeline.mp4

05:52

14. Combo Charts.mp4

08:47

15. Sparklines.mp4

04:22

16. Selecting Flags Using a Dropdown.mp4

04:21

17. Camera.mp4

03:41

18. Infographics & Battery Chart.mp4

16:15

19. Speedometer.mp4

06:03

20. Introduction to Dashboards.mp4

12:53

21. Charts Quiz.html

22. Charts Assignment.html

9. Print, Page Setup & View

1. Themes.mp4

01:43

2. Page Setup.mp4

16:12

3. Headers & Footers.mp4

08:53

4. Printing.mp4

02:58

5. Spreadsheet Views.mp4

04:36

6. Arranging Windows.mp4

04:50

7. Page Layout & View Summary.mp4

05:11

8. Print, Page Setup & View Quiz.html

9. Print, Page Setup & View Assignment.html

10. Proofing, Sharing & Protection

1. Proofing.mp4

05:59

2. Comments & Notes.mp4

03:26

3. Sharing & Protection.mp4

13:22

4. Proofing, Sharing & Protection Quiz.html

5. Proofing, Sharing & Protection Assignment.html

11. Shortcuts

1. Other Shortuts.mp4

02:37

2. Keyboard Shortcuts.mp4

17:55

3. Shortcuts Quiz.html

4. Shortcuts Assignment.html

12. Other Useful Tips

1. Series & Justify.mp4

07:56

2. Go To.mp4

06:10

3. Find & Replace.mp4

04:08

4. Paste Special.mp4

05:34

5. Hyperlinks.mp4

04:59

6. Ideas.mp4

02:36

7. Clipboard.mp4

03:41

8. Illustrations, Text & Symbols.mp4

10:36

9. Templates.mp4

08:07

10. Add-Ins.mp4

05:32

11. Crashing & Recovery.mp4

07:06

12. Other Useful Tips Quiz.html

13. Other Useful Tips Assignment.html

13. File, Ribbon, QAT & Summary

1. Ribbon Summary.mp4

21:41

2. Customising the Ribbon.mp4

06:09

3. Quick Access Toolbar.mp4

01:58

4. File.mp4

07:56

5. R1C1 Style Referencing.mp4

02:17

6. Help & Search.mp4

01:42

7. Top 10 Quick Hacks.mp4

17:10

8. Ribbon & Quick Access Toolbar Assignment.html

14. Conclusion

1. Conclusion.mp4

00:22

2. Final Message & Further Resources.html

3. BONUS LECTURE Discount to my Other Course.html

Description

Become an Excel expert in just 20 hours and 130 videos

What You'll Learn?

Analyse large data sets in a few clicks using Pivot Tables & Pivot Charts
Visualise data using Graphs & Dashboards
Create dynamic Graphs which automatically capture new data
Format data to highlight key points
Solve problems using Formulas and Functions
Monitor unkwown factors using 'What If Analysis'
Sort, Filter, manipulate & summarise data to draw quick conclusions
Increase productivity using Array Formulas
Customise reports in a professional and presentable way
Add security & protection to improve data integrity
Learn tips and tricks in the case of system crashes
Save time with keyboard shortcuts
Apply built-in templates and add-ins for thousands of applications
Master basics of Excel spreadsheets-navigating, saving, printing, math
Connect to data from external sources including text, websites, databases, stocks and geographical sources

Who is this for?

Excel users of all levels

What You Need to Know?

Require a computer with excel installed (2013 version or later reccomended)

More details

Description
I have learned Excel from many different sources including books, websites, Youtube, online courses & analyst employment. My goal was to create a course that has everything in 1 place so that you don't have to go searching everywhere like I did. It took me a long time to master Excel and now IÂ want the course that I wish I had when I started learning so that you can learn in a 20 hour course what takes most people 5-20 years to learn. That is my goal with this course.
As far as the content goes, I cover everything except for VBA/Macros because that really needs a whole course of it's own. But everything else in Excel I cover and that's why the course is so long. But it's not really not that long if you think about the benefits, including the time it will save you when you become an excel expert and also the career opportunities. You could be less than a week away from becoming an Excel expert! Or you can do the course slowly over years, it's completely up to you. The course can be done at your own pace and in any order. I have arranged it logically into what I think is the best way to learn but you can do the videos in any order. If one video requires having seen another as a prerequisite then I mention that in the video so you can go back and watch that if you need to. The main thing is that you find the course valuable and learn a lot.
The course is suitable for complete beginners and I have a video at the start teaching excel for people who have never used it before. But that's not to say it won't be useful for advanced users. As you can see from the content we cover everything, including the most advanced formulas and features. I try to do this with a lot of examples and explain as clearly as possible so that you understand why we do certain things not just how to do it. In only 20 hours and 130 videos, I guarantee you will the Excel guru among your friends &Â co-workers.

Contents
Fundamentals
Formatting
Working With Data
Formulas & Functions
Arrays
Pivottables
Charts
Print, Page Set & View
Proofing, Sharing & Protection
Shortcuts
Other Useful Tips
File, Ribbon & Quick Access Toolbar
The course is 130 videos, 20 hours long and all course materials are available to download
Who this course is for:
Excel users of all levels

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Jarrod Hill

Instructor's Courses

I have learned Excel from many different sources including books, websites, Youtube, online courses & analyst employment. My goal is to create a course that has everything in 1 place so that you don't have to go searching everywhere like I did. It took me a long time to master Excel and now I want to create the course that I wish I had when I started learning so that you can learn in a short course what takes most people 5-20 years to learn. That is my goal here on Udemy

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.