Learn Microsoft Excel from basic to advanced

In this online course, you will learn Microsoft Excel from the beginner level all the way to the expert level. This course was originally 2 separate courses, but then combined into one. In the first course, you will learn Excel from the very basics until you can master all aspects of the software. And in the second course, you will go deeper into formula and functions in Excel.

Reed Courses Certificate of Completion

Digital certificate - Included

• Introduction 20:55

  • 1: Introduction 05:03
  • 2: Exercise files and other information 05:32
  • 3: Microsoft Office, Office 365 and Microsoft 365 05:01
  • 4: About Microsoft 365 05:19

• The basics of Excel 50:56

  • 5: Working with Excel files 05:58
  • 6: Excel UI basics 08:52
  • 7: Excel UI advanced 07:51
  • 8: The basics of inputting data 05:17
  • 9: Data types in Excel 08:52
  • 10: Data structure 05:39
  • 11: Navigation 08:27

• Working with data 51:42

  • 12: Editing data and AutoFill 07:13
  • 13: Creating custom AutoFill 05:39
  • 14: Undo Redo Save and Save-as 07:34
  • 15: The basics of Formula 07:26
  • 16: Introduction to Function SUM and AVERAGE 10:31
  • 17: XLOOKUP function 05:20
  • 18: Cut, Copy, and Paste 07:59

• Cell references 44:54

  • 19: Cell reference range 06:49
  • 20: Relative vs Absolute cell references 07:41
  • 21: Mixed reference and the ROUND function 07:09
  • 22: External Worksheet reference 05:11
  • 23: External Workbook Reference 08:41
  • 24: Named reference 09:23

• Data presentation 1:33:32

  • 25: Formatting basics in Excel 06:18
  • 26: Number formatting and Format Painter 08:47
  • 27: Custom formatting 09:54
  • 28: Basic date formatting 05:58
  • 29: Advanced date formatting 07:55
  • 30: Text formatting 06:09
  • 31: Text color 07:34
  • 32: Fill color 07:58
  • 33: Border line settings 08:57
  • 34: Border styles and colors 04:34
  • 35: Column and row sizes 07:15
  • 36: Text position and orientation 03:11
  • 37: Cell Styles 09:02

• Managing table structure 20:22

  • 38: Organizing table structure 07:11
  • 39: Hiding columns and rows 05:44
  • 40: Merging and splitting cells 07:27

• Graphics and Charts 2:00:01

  • 41: Inserting images 06:36
  • 42: Insert versus Link 04:17
  • 43: Transformation and snapping 04:45
  • 44: Managing visual objects 08:00
  • 45: Transparency and Cropping 08:30
  • 46: Shape objects basics 07:19
  • 47: Lock Drawing Modifiers and Alignment 08:55
  • 48: Editing Shapes 08:35
  • 49: Text box 10:22
  • 50: Effects and Styles 06:27
  • 51: Grouping 03:53
  • 52: SmartArt in Excel 09:31
  • 53: Creating Charts in Excel 07:39
  • 54: Managing charts objects and data 08:59
  • 55: Chart design customization 08:12
  • 56: Sparkline 08:01

• Advanced data processing 54:24

  • 57: Paste types 10:21
  • 58: Notes and Comments 10:43
  • 59: Find 08:04
  • 60: Replace 06:38
  • 61: Sorting data 07:30
  • 62: Filters 07:54
  • 63: Freeze panes 03:14

• Table and PivotTable 47:05

  • 64: Excel table basics 08:05
  • 65: Advanced Excel Table 09:01
  • 66: PivotTable basics 09:14
  • 67: PivotTable Field, Filter, and Slicer 07:14
  • 68: PivotTable Design 06:53
  • 69: Connecting Excel table to PivotTable 06:38

• Conditional formatting 51:32

  • 70: Conditional formatting basics 09:23
  • 71: Conditional custom formatting 05:17
  • 72: Advanced conditional rules 08:52
  • 73: Rule stacking 04:51
  • 74: Conditional formatting with graphics 09:58
  • 75: Active cell in Excel 03:44
  • 76: Conditional formatting with formulas 09:27

• Printing and exporting 1:36:34

  • 77: Basic printing techniques 10:26
  • 78: Selective printing 09:51
  • 79: Adding a Header or Footer 09:03
  • 80: Header or Footer content and size 10:11
  • 81: Managing Headers and Footers 03:15
  • 82: Scale to fit 05:25
  • 83: Sheet options 09:07
  • 84: Locking data in Excel 07:51
  • 85: Protecting Excel files 06:38
  • 86: Print to PDF and XPS 09:56
  • 87: Exporting with Insert Object 06:54
  • 88: Exporting with Copy and Paste 07:57

• First exam 17:00

  • 89: First Exam 17:00

• Tips for working with formulas 1:26:21

  • 90: Online references 05:35
  • 91: Understanding the syntax 07:26
  • 92: Tips on navigation and selection 07:17
  • 93: Flash Fill 08:17
  • 94: Extend Format and Formula 05:34
  • 95: Adding symbols using special fonts 10:50
  • 96: Emoji and symbol shortcut 06:06
  • 97: UNICHAR function 09:05
  • 98: Splitting formula into multiple lines 07:10
  • 99: Using helper columns or cells 10:52
  • 100: Avoiding volatile functions 08:09

• Table and Dynamic Array 48:41

  • 101: Working with Tables 07:56
  • 102: Table cell reference 06:36
  • 103: Adding data and AutoFill 08:33
  • 104: Total reference and conversion to Range 06:40
  • 105: Resize Table and Slicer 07:58
  • 106: Introduction to Dynamic Array 05:47
  • 107: Table and Dynamic Array 05:11

• Conditional functions 50:09

  • 108: Nested IF versus IFS 10:04
  • 109: Comparison operators 05:57
  • 110: AND, OR, and NOT 08:25
  • 111: AND and OR logic in Criteria 08:23
  • 112: SUMIF, AVERAGEIF, and COUNTIF 05:51
  • 113: SUMIFS, AVERAGEIFS, and COUNTIFS 07:13
  • 114: MAXIFS and MINIFS 04:16

• Lookup functions 53:56

  • 115: VLOOKUP 07:42
  • 116: XLOOKUP 06:15
  • 117: Match Mode 07:04
  • 118: Search Mode 06:33
  • 119: 2-way lookup 08:27
  • 120: INDEX, MATCH, and XMATCH 08:40
  • 121: Wildcards 09:15

• Rounding and division functions 22:24

  • 122: Rounding functions 07:03
  • 123: Rounding to specific multiples 06:25
  • 124: Using QUOTIENT and MOD 08:56

• Date and Time functions 38:04

  • 125: The true value of date and time 09:09
  • 126: Date and time extraction 08:05
  • 127: Time conversion and rounding 08:51
  • 128: Calculating elapsed days and years 07:55
  • 129: Calculating deadlines 04:04

• Text processing functions 33:17

  • 130: Input numbers as text 05:50
  • 131: Basic text extraction 04:53
  • 132: Text extraction with delimiter 06:26
  • 133: UPPER, LOWER, and PROPER 01:34
  • 134: Combining text 07:08
  • 135: Splitting text 07:26

• Statistical functions 22:03

  • 136: Searching for values based on rank 04:46
  • 137: Finding the middle and frequent values 05:10
  • 138: Calculating variations and combinations 05:52
  • 139: Forecasting value based on trend 06:15

• Second exam 07:00

  • 140: Second exam 07:00

In this online course, you will learn Microsoft Excel from the beginner level all the way to the expert level. This course was originally 2 separate courses, but then combined into one. In the first course, you will learn Excel from the very basics until you can master all aspects of the software. And in the second course, you will go deeper into formula and functions in Excel.

The curriculum is carefully crafted so you can learn Excel in the shortest time possible but still through a learning process that feels easy. After this course, in sha Allah, you will have real and applicable competencies in Excel that can help your business or your career.

In addition to providing complete lessons from start to finish, this course also provides 2 levels of exams to reinforce and guarantee that you have mastered all the skills. Upon completion, we will reward your success with a valid Reed certificate that can help boost your professional resume.

About the author

I am an entrepreneur, who is also an academic lecturer in information systems and computer graphics. I have a bachelor's degree in software development and a master’s degree in information systems and business management. For more than 20 years, I have been using Microsoft Excel for a variety of needs, be it for business or academic purposes. I use Excel for bookkeeping or finance, student data management, academic research, project management, data analysis, and so on. By the time I published this course, I had more than a total of 100,000 students worldwide.

What you will learn

There are so many things that you will learn in this online course. It would take too long to explain all of them in this description. To see the details, you can check the curriculum section. As a macro-overview, there are a total of 18 chapters, excluding the introduction chapter. 10 of which are from the basic-level course. And 8 of which are from the advanced formula and functions course. In total, there are more than 135 lessons, and more than 16.5 hours of video content.

In the first course, after the introduction chapter, you will learn the basics of Microsoft Excel such as the UI and navigation techniques, etc. Learn about data types and techniques for working with data. Then you will learn how to use various types of cell references, from the simplest to the most complex ones. Next, you will learn the ins and outs of data presentation in Excel. Then learn various techniques for structuring the table. In the next section, you will learn about various things related to graphics. Such as creating SmartArt, Charts, and Sparklines. In the next chapter, we will discuss advanced data processing techniques. We will discuss things like find and replace techniques, data sorting, filters, and so on. Then after that, we will discuss in detail everything related to tables, pivot tables, and how to combine the two features. We'll also cover a variety of conditional formatting features from the basic examples to more complex ones. And in the final chapter, we will cover different techniques related to printing and exporting, such as defining print areas, exporting to PDF, and so on.

In the second course, first, you will learn important tips related to working with formulas in Excel. Then you will learn advanced techniques related to tables and dynamic arrays. In the next chapter, you will learn various conditional functions. Such as IFS, SUMIFS, AVERAGEIFS, etc. You will also learn logical functions such as AND, OR, and NOT. Next, you will learn various lookup functions, such as VLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH, etc. You will learn in detail the “Match Mode” and “Search Mode” arguments, complete with various use cases. We will discuss rounding and division techniques, such as ROUNDOWN, ROUNDUP, and so on. In the next chapter, you will learn various techniques related to date and time. Such as extracting time data, converting time to different formats, and so on. Next, you will learn in-depth various techniques for working with text data. In the final chapter, you will learn various functions related to statistics, such as how to forecast future conditions based on trends or past data.

So don't wait any longer. Join this course now! And maximize your Excel skills to their fullest potential.

• Beginners who want to learn Microsoft Excel from scratch
• Employees who want to improve their career by leveraging Excel
• Students and academics who need an effective tool to perform research
• Managers or CEOs who need large data analysis and present them effectively

• Operating a computer in general
• Already have Microsoft Excel 365 or Office 2019 or higher installed

• Financial Analyst - $60,000 to $100,000 / year
• Data Analyst - $55,000 to $90,000 / year
• Accountant - $50,000 to $80,000 / year
• Business Intelligence Analyst - $65,000 to $100,000 / year
• Statistician - $65,000 to $105,000 / year
• Financial Planner - $60,000 to $100,000 / year

Currently there are no Q&As for this course. Be the first to ask a question.