Complete Excel Megacourse: Beginner to Expert

Focused View

Creativity Unleashed

23:18:42

113 View

1. Introduction

1. What is Microsoft Excel.mp4

02:29

2. How do I get Microsoft Excel.mp4

03:58

3. How do I open Microsoft Excel.mp4

02:13

2. Getting to know the Interface

1. Cell, Worksheets and Workbooks.mp4

09:05

2. The Ribbon Toolbar.mp4

09:30

3. Selecting Cells and The Name Box.mp4

11:03

4. Altering Rows and Columns.mp4

10:20

5. Borders.mp4

09:06

6. Revision Times Table Square.mp4

08:07

3. Using Formulae in Excel

1. Exploring Data Types.mp4

11:47

2. Formatting Data.mp4

14:49

3. Creating a Series.mp4

07:52

4. Creating Formulae.mp4

11:22

5. Formulae and Autofill (Relative Addressing).mp4

12:27

6. Resolving Relative Addressing Issues (Absolute Addressing).mp4

13:27

7. Formatting Cells.mp4

09:55

8. Revision Times Table Square.mp4

07:49

4. Protecting Cells and Worksheets

1. Protecting Worksheets.mp4

10:22

2. Restricting Data in Cells.mp4

05:16

5. Data, Formatting and the First Function

1. Creating Lists.mp4

04:07

2. Adding and Deleting Rows and Columns.mp4

05:21

3. Conditional Formatting.mp4

10:05

4. Introducing Functions - MOD.mp4

12:41

5. Revision Times Table Square.mp4

20:59

6. Basic Functions in Excel

1. Introducing Battleships.mp4

13:13

2. The IF Function.mp4

10:00

3. The COUNTIF Function.mp4

02:09

4. The COUNTA Function.mp4

02:34

5. Nested IFs.mp4

08:02

6. The SUM Function.mp4

05:51

7. Named Ranges.mp4

06:09

8. Revision Battleships.mp4

18:44

7. Shapes and Images

1. 3D Formulae.mp4

02:36

2. Shapes.mp4

03:36

3. Images.mp4

09:52

4. Revision Battleships.mp4

13:48

5. Revision Battleships.mp4

17:54

8. Importing Data into Excel

1.1 Excel Megacourse_Lesson 38 - convertcsv.zip

1. Using CSV files.mp4

15:47

2. Exporting Data into a CSV file.mp4

08:04

3. Issues with CSV files.mp4

08:35

4. Importing CSV files Using the Legacy Wizard.mp4

08:38

9. Averages in Excel

1.1 Excel Megacourse_Lesson 42 - one million numbers.zip

1. The AVERAGE Function.mp4

14:42

2. The MEDIAN Function.mp4

10:07

3. The MODE Function.mp4

05:58

4. The MODE.SNGL Function.mp4

03:01

5. The MODE.MULT function.mp4

04:37

6.1 Excel Megacourse_Lesson 47 - gradelist.zip

6. Revision Gradebook.mp4

14:29

10. Using Lookups in Excel

1.1 Excel Megacourse_Lesson 48 - lookup data.zip

1. The VLOOKUP Function.mp4

11:32

2.1 Excel Megacourse_Lesson 49 - subject data.zip

2. The HLOOKUP Function.mp4

04:49

11. More Functions in Excel

1. The MAX and MIN Functions.mp4

02:09

2. The RAND and RANDBETWEEN Functions.mp4

07:26

3. The INDEX Function.mp4

01:58

4. The MATCH Function.mp4

05:00

5. Filters.mp4

05:07

6. Revision Gradebook.mp4

11:51

12. Functions and Conditions

1. The SUMIF Function.mp4

03:15

2. The SUMIFS Function.mp4

05:16

13. Working with Dates and Text

1. Working with Dates.mp4

05:26

2. Working with Text.mp4

03:45

14. Simple Graphs and Charts

1. Simple Bar Graphs.mp4

06:14

2. Pie Charts.mp4

03:50

3. Scattergraphs.mp4

18:00

4. Scattergraphs 2.mp4

13:12

15. Handling Text and Importing WWW Data

1. Manipulating Text.mp4

12:23

2. More Manipulating Text.mp4

17:00

3. Importing Data from the Web.mp4

07:53

16. Generating Test Data

1. Creating Test Data Pt. 1.mp4

22:17

2. Creating Test Data Pt. 2.mp4

19:05

17. Creating a Budgetary System

1. Developing a Budget Spreadsheet.mp4

28:49

2. Continuing the Budget Spreadsheet.mp4

21:56

18. Revision Exercise Astronomical Modelling

1. Revision Astronomical Modeling Pt. 1.mp4

21:24

2. Revision Astronomical Modeling Pt. 2.mp4

23:39

3. Revision Astronomical Modeling Pt. 3.mp4

27:56

4. Revision Astronomical Modeling Pt. 4.mp4

05:32

19. New Functions in Excel 365

1. UNIQUE and Spills.mp4

09:07

2. The IFS Function.mp4

08:58

3. The MAXIFS Function.mp4

02:21

4. The MINIFS Function.mp4

01:09

5. The SWITCH Function.mp4

02:33

6. The SORT Function.mp4

02:55

7. The XMATCH Function.mp4

08:22

8. The LET Function.mp4

03:30

9. The XLOOKUP Function.mp4

04:20

10. The FILTER Function.mp4

02:11

11. The SORTBY Function.mp4

02:12

12. The SEQUENCE Function.mp4

05:53

13. Revision Combining Functions.mp4

11:27

20. More Basic Features of Excel

1. The RANDARRAY Function.mp4

07:48

2. Text to Columns.mp4

01:27

3. Zooms and Sheet Selections.mp4

02:21

4. Logical Functions.mp4

10:09

5. ODDs and EVENs.mp4

06:47

6. Trigonometry.mp4

10:06

7. Ceilings and Floors.mp4

06:07

8. Reviewing all our Learning.mp4

06:24

9. Last Words.mp4

00:31

21. Data Visualization through Tables

1. Introducing Conditional Formatting.mp4

07:52

2. Highlight Cell Rules.mp4

19:08

3. TopBottom Rules.mp4

09:52

4. Data Bars.mp4

04:57

5. Colors Scales.mp4

03:42

6. Icon Sets.mp4

04:22

7. Create, Clear or Manage Rules.mp4

08:44

8. Revision.mp4

07:19

9. Practice Project A Academic Report.mp4

26:19

22. From Tabular to Graphical Representation

1. Introducing Charts & Graphs.mp4

07:39

2. Tables vs Charts & Graphs.mp4

16:32

3. Sparklines.mp4

21:37

4. Mini Charts.mp4

11:44

5. Revision.mp4

05:42

6. Practice Project B Gantt Chart.mp4

26:13

23. From Tabular to Graphical Representation

1. Understanding the Need.mp4

09:06

2. Chart Area.mp4

07:10

3. Plot Area.mp4

04:38

4. Axes.mp4

13:14

5. Axes Titles.mp4

06:37

6. Chart Title.mp4

04:01

7. Data Labels.mp4

08:01

8. Data Table.mp4

06:31

9. Error Bars.mp4

13:11

10. Gridlines.mp4

05:38

11. Legend.mp4

08:32

12. Trendlines.mp4

09:24

13. Altering Styles.mp4

04:18

14. Altering Colors.mp4

02:56

15. Data Sources.mp4

08:18

16. Data Series.mp4

10:18

17. Quick Quiz A 10 MCQs.mp4

09:58

24. Must-Know Charts & Graphs

1. Column or Bar Charts (Comparisons).mp4

30:57

2. Line or Area Charts (Trends).mp4

24:12

3. Pie or Doughnut Charts (Proportions).mp4

22:04

4. Scatter or Bubble Chart (Relationships).mp4

29:29

5. Histograms or Box & Whisker (Statistical Analysis).mp4

30:33

6. Treemap or Sunburst (Hierarchies).mp4

29:11

7. Revision.mp4

15:53

8. Practice Project C Daily Activity Tracker.mp4

36:52

Description

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

What You'll Learn?

How to use Microsoft Excel and its basic functions
How to create worksheets
Everything about using and formatting cells
How to use autofill
The principles and use of formulas
How to manipulate data through different functions
How to use and master Excel’s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF
Simple graphs and charts
How to create a budgetary system
All the new functions in Excel 365
How to customize your charts
How to use dashboards
How to create 2D or 3D maps

Who is this for?

Anyone who wants to learn to use Microsoft Excel - no experience needed!

Professionals who want to learn new tools of Excel

Anyone who wants take their Excel skills from beginner to advanced

Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.)

More details

Description
Learn Microsoft Excel!
Have you ever wanted to be able to use Microsoft Excel - the largest spreadsheets program, like a pro? From managing your accounts to running your businessâ€™ finances, modelling chaos to simulating airports, recording your progress to planning your time; spreadsheets are an invaluable tool to learn and understand. Whether youâ€™re looking to record your home incomings and outgoings, or want to explore Excel for its mathematical opportunities, investigate the statistical tools, and its data analysis wizards, this course is for you.
In this course, youâ€™re going to learn everything you need to know to get started with Excel. You will explore what cells and worksheets are, how to enter formulae, manipulate data through functions and present the data in an effective fashion. Youâ€™ll even learn how to use Excel to develop diverse and interesting solutions to problems, as well as learn the individual techniques and how to apply them to a solution.
Our instructor has many years of experience teaching Excel to a wide range of audiences - from very young children through to professionals, and the expertly-crafted syllabus is designed to be easy to follow and thorough. Weâ€™ve also included plenty of practical examples explained and done on-screen for you to study. Thatâ€™s why this is the only Microsoft Excel course youâ€™ll ever need to master this software!
Start using Excel today!

After taking this course youâ€™ll be able to:

Work professionally with Microsoft Excel and its advanced features
Solve real work problem with the help of Excel
Use the elements and theories in Excel to make your work processes better
Create your own KPI or Investment Dashboard
Create a Web Analytics Report
Make a Daily Activity Tracker
Who this course is for:
Anyone who wants to learn to use Microsoft Excel - no experience needed!
Professionals who want to learn new tools of Excel
Anyone who wants take their Excel skills from beginner to advanced
Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.)

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Creativity Unleashed

Instructor's Courses

We are Creativity Unleashed, a group of professional creators dedicated to helping you unleash your creativity with our online courses.We have dozens of years of experience in design, illustration, filmmaking, video editing and other areas of creative work. We believe that education needs to be fun and engaging and that's exactly the kind of courses we're creating.We're excited to have you here with us and we can't wait to help you unleash your creativity. Let's do this!

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.