Complete Excel Course – Beginner to Expert

سرفصل های دوره

Become an Excel expert in just 20 hours and 130 videos

1. Introduction

1. Introduction

1. Introduction.zip

2. Fundmentals

1. Excel for Complete Beginners

2. Basic Math

3. Referencing Cells

4. Fixed & Relative Cell References

5. Fundamentals Quiz.html

6. Fundamentals Assignment.html

3. Formatting

1. Formatting Basics

2. Number Formatting

3. Custom Formatting Part 1

4. Custom Formatting Part 2

5. Formatting a Balance Sheet

6. Cell Styles

7. Conditional Formatting Part 1

8. Conditional Formatting Part 2

9. Formatting Quiz.html

10. Formatting Assignment.html

4. Working With Data

1. Sorting

2. Filtering

3. Advanced Filter

4. Hiding, Grouping & Subtotals

5. Text to Columns

6. Flash Fill

7. Data Validation

8. Connecting to an External Workbook

9.1 UFC Fights.txt

9. Connecting to a Text File

10. Connecting to a Website

11. Stocks & Geography

12. Consolidate Data

13. Scenario Manager

14. Data Tables

15. Goal Seek

16. Solver

17. Forecasting

18. Named Ranges

19. Booleans

20. Tables

21. Working With Data Quiz.html

22. Working With Data Assignment.html

5. Formulas & Functions

1. Intro to Functions

2. Logial Functions

3. Errors

4. INDIRECT

5. Basic Functions on Ranges

6. OFFSET

7. SUMCOUNTAVERAGE IF(S)

8. SUMPRODUCT

9. More Math Functions

10. More Text Functions

11. Lookup Functions-VLOOKUP, HLOOKUP & LOOKUP

12. INDEX & MATCH

13. INDEX Part 2

14. Formula Auditing & Formula Ribbon Tab

15. Date & Time Functions

16. SUBTOTAL & AGGREGATE

17. CHOOSE

18. FREQUENCY

19. Financial Functions

20. Other Functions

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)

3. FILTER

4. SORT & SORTBY

5. RANDARRAY & SEQUENCE

6. UNIQUE

7. SINGLE

8. XLOOKUP

9. XMATCH

10. Applying Arrays to Standard Functions

11. Using Arrays To Create A Searchable Dropdown List

12. Arrays Quiz.html

13. Arrays Assignment.html

7. Pivottables

1. Pivottable Introduction.html

2. Pivottable Examples 1

3. Pivottable Examples 2

4. Manual Sort, Multiple Filter & Pivottable Options

5. Drill Down

6. Conditional Formatting in Pivottables

7. Grouping Dates

8. Slicers

9. Timelines

10. Analyse & Design

11. Calculated Fields

12. GETPIVOTDATA Formula

13. Pivotcharts

14. Pivottables Summary

15. Introduction to Powerpivot

16. Pivottables Quiz.html

17. Pivottables Assignment.html

8. Charts

1. Chart Foundations

2. Dynamic Chart Ranges

3. Chart Design

4. Chart Formatting Part 1

5. Chart Formatting Part 2

6. Column vs Bar Charts

7. Line Charts

8. Pie Charts

9. Scatter & Bubble Charts

10. Histogram

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

12. Maps

13. Project Timeline

14. Combo Charts

15. Sparklines

16. Selecting Flags Using a Dropdown

17. Camera

18. Infographics & Battery Chart

19. Speedometer

20. Introduction to Dashboards

21. Charts Quiz.html

22. Charts Assignment.html

9. Print, Page Setup & View

1. Themes

2. Page Setup

3. Headers & Footers

4. Printing

5. Spreadsheet Views

6. Arranging Windows

7. Page Layout & View Summary

8. Print, Page Setup & View Quiz.html

9. Print, Page Setup & View Assignment.html

10. Proofing, Sharing & Protection

1. Proofing

2. Comments & Notes

3. Sharing & Protection

4. Proofing, Sharing & Protection Quiz.html

5. Proofing, Sharing & Protection Assignment.html

11. Shortcuts

1. Other Shortuts

2. Keyboard Shortcuts

3. Shortcuts Quiz.html

4. Shortcuts Assignment.html

12. Other Useful Tips

1. Series & Justify

2. Go To

3. Find & Replace

4. Paste Special

5. Hyperlinks

6. Ideas

7. Clipboard

8. Illustrations, Text & Symbols

9. Templates

10. Add-Ins

11. Crashing & Recovery

12. Other Useful Tips Quiz.html

13. Other Useful Tips Assignment.html

13. File, Ribbon, QAT & Summary

1. Ribbon Summary

2. Customising the Ribbon

3. Quick Access Toolbar

4. File

5. R1C1 Style Referencing

6. Help & Search

7. Top 10 Quick Hacks

8. Ribbon & Quick Access Toolbar Assignment.html

14. Conclusion

1. Conclusion

2. Final Message & Further Resources.html

3. BONUS LECTURE Discount to my Other Course.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy