Complete Excel Megacourse: Beginner to Expert

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

Learn how to use Microsoft Excel like a pro with this step-by-step course!

1. Introduction

1. What is Microsoft Excel

2. How do I get Microsoft Excel

3. How do I open Microsoft Excel

2. Getting to know the Interface

1. Cell, Worksheets and Workbooks

2. The Ribbon Toolbar

3. Selecting Cells and The Name Box

4. Altering Rows and Columns

5. Borders

6. Revision Times Table Square

3. Using Formulae in Excel

1. Exploring Data Types

2. Formatting Data

3. Creating a Series

4. Creating Formulae

5. Formulae and Autofill (Relative Addressing)

6. Resolving Relative Addressing Issues (Absolute Addressing)

7. Formatting Cells

8. Revision Times Table Square

4. Protecting Cells and Worksheets

1. Protecting Worksheets

2. Restricting Data in Cells

5. Data, Formatting and the First Function

1. Creating Lists

2. Adding and Deleting Rows and Columns

3. Conditional Formatting

4. Introducing Functions - MOD

5. Revision Times Table Square

6. Basic Functions in Excel

1. Introducing Battleships

2. The IF Function

3. The COUNTIF Function

4. The COUNTA Function

5. Nested IFs

6. The SUM Function

7. Named Ranges

8. Revision Battleships

7. Shapes and Images

1. 3D Formulae

2. Shapes

3. Images

4. Revision Battleships

5. Revision Battleships

8. Importing Data into Excel

1.1 Excel Megacourse_Lesson 38 - convertcsv.zip

1. Using CSV files

2. Exporting Data into a CSV file

3. Issues with CSV files

4. Importing CSV files Using the Legacy Wizard

9. Averages in Excel

1.1 Excel Megacourse_Lesson 42 - one million numbers.zip

1. The AVERAGE Function

2. The MEDIAN Function

3. The MODE Function

4. The MODE.SNGL Function

5. The MODE.MULT function

6.1 Excel Megacourse_Lesson 47 - gradelist.zip

6. Revision Gradebook

10. Using Lookups in Excel

1.1 Excel Megacourse_Lesson 48 - lookup data.zip

1. The VLOOKUP Function

2.1 Excel Megacourse_Lesson 49 - subject data.zip

2. The HLOOKUP Function

11. More Functions in Excel

1. The MAX and MIN Functions

2. The RAND and RANDBETWEEN Functions

3. The INDEX Function

4. The MATCH Function

5. Filters

6. Revision Gradebook

12. Functions and Conditions

1. The SUMIF Function

2. The SUMIFS Function

13. Working with Dates and Text

1. Working with Dates

2. Working with Text

14. Simple Graphs and Charts

1. Simple Bar Graphs

2. Pie Charts

3. Scattergraphs

4. Scattergraphs 2

15. Handling Text and Importing WWW Data

1. Manipulating Text

2. More Manipulating Text

3. Importing Data from the Web

16. Generating Test Data

1. Creating Test Data Pt. 1

2. Creating Test Data Pt. 2

17. Creating a Budgetary System

1. Developing a Budget Spreadsheet

2. Continuing the Budget Spreadsheet

18. Revision Exercise Astronomical Modelling

1. Revision Astronomical Modeling Pt. 1

2. Revision Astronomical Modeling Pt. 2

3. Revision Astronomical Modeling Pt. 3

4. Revision Astronomical Modeling Pt. 4

19. New Functions in Excel 365

1. UNIQUE and Spills

2. The IFS Function

3. The MAXIFS Function

4. The MINIFS Function

5. The SWITCH Function

6. The SORT Function

7. The XMATCH Function

8. The LET Function

9. The XLOOKUP Function

10. The FILTER Function

11. The SORTBY Function

12. The SEQUENCE Function

13. Revision Combining Functions

20. More Basic Features of Excel

1. The RANDARRAY Function

2. Text to Columns

3. Zooms and Sheet Selections

4. Logical Functions

5. ODDs and EVENs

6. Trigonometry

7. Ceilings and Floors

8. Reviewing all our Learning

9. Last Words

21. Data Visualization through Tables

1. Introducing Conditional Formatting

2. Highlight Cell Rules

3. TopBottom Rules

4. Data Bars

5. Colors Scales

6. Icon Sets

7. Create, Clear or Manage Rules

8. Revision

9. Practice Project A Academic Report

22. From Tabular to Graphical Representation

1. Introducing Charts & Graphs

2. Tables vs Charts & Graphs

3. Sparklines

4. Mini Charts

5. Revision

6. Practice Project B Gantt Chart

23. From Tabular to Graphical Representation

1. Understanding the Need

2. Chart Area

3. Plot Area

4. Axes

5. Axes Titles

6. Chart Title

7. Data Labels

8. Data Table

9. Error Bars

10. Gridlines

11. Legend

12. Trendlines

13. Altering Styles

14. Altering Colors

15. Data Sources

16. Data Series

17. Quick Quiz A 10 MCQs

24. Must-Know Charts & Graphs

1. Column or Bar Charts (Comparisons)

2. Line or Area Charts (Trends)

3. Pie or Doughnut Charts (Proportions)

4. Scatter or Bubble Chart (Relationships)

5. Histograms or Box & Whisker (Statistical Analysis)

6. Treemap or Sunburst (Hierarchies)

7. Revision

8. Practice Project C Daily Activity Tracker

139,000 تومان

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

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

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

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