Microsoft Excel 2016 - Set of 3 Interactive Courses

METAVERSESKILLS

Certification of Completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Section 1 21:48

  • 1: Microsoft Excel Marketplace 04:08
  • 2: What is Microsoft Excel 04:16
  • 3: Excel Job Types 03:51
  • 4: Who is This Course For 03:30
  • 5: Excel from A-Z Course Intro 03:20
  • 6: Excel Job Opportunities 02:43

• Section 2 21:13

  • 7: Saving an Excel Doc 03:33
  • 8: Customizing the Excel Ribbon 03:03
  • 9: Customizing the Quick Access Toolbar 02:15
  • 10: Excel_s Start Screen 03:15
  • 11: Explaining the Excel Interface 02:43
  • 12: Excel Shortcut Keys 01:43
  • 13: Excel Workbook vs. Excel Worksheet 02:12
  • 14: Excel Interface Cont 01:25
  • 15: Finding and Opening Excel 01:04

• Section 3 29:49

  • 16: Relative vs Absolute Cell References 07:23
  • 17: Order of Operation 06:27
  • 18: Formatting Date Values in Excel 05:19
  • 19: Building Basic Formulas in Excel 04:43
  • 20: Entering Numeric Data in Excel 03:25
  • 21: Creating Excel Labels 02:32

• Section 4 20:45

  • 22: The SUM Function 07:31
  • 23: COUNT Functions 04:57
  • 24: The MIN and MAX Function 03:43
  • 25: Excel Functions Explained 02:34
  • 26: The AVERAGE Function 02:00

• Section 5 35:01

  • 27: Moving and Copying Data 06:45
  • 28: Renaming Moving and Deleting Excel Worksheets 05:27
  • 29: Adjusting the Width and Height of Cells 04:34
  • 30: Insert and Delete Rows and Columns 05:04
  • 31: Adding Protection to Specific Cells 04:23
  • 32: Hiding and Unhiding Excel Rows and Columns 04:28
  • 33: Adding a Workbook Password to Open File 02:09
  • 34: Protecting the Structure of a Workbook 02:11

• Section 6 34:00

  • 35: The Power of Conditional Formatting 06:09
  • 36: Creating Styles for Formatting Efficiency 05:55
  • 37: Formatting Data Appropriately 05:20
  • 38: Formatting Fonts and Cell Background Color 04:54
  • 39: Adding Cell Borders 04:47
  • 40: Merging Cells 03:26
  • 41: The Magic Behind Excel_s Format Painter 03:29

• Section 7 18:55

  • 42: Grab Users Attention using Illustrations 08:38
  • 43: Create Compelling Graphics with SmartArt 05:36
  • 44: Customizing Icons 04:41

• Section 8 22:23

  • 45: Formatting Elements of a Chart 06:23
  • 46: Modifying the Data Type and Location of a Chart 06:06
  • 47: Little Slice of Pie Charts 05:11
  • 48: The Commonly Used Column Chart 02:45
  • 49: Changing the Chart Design 01:58

• Section 9 16:07

  • 50: Excels Page Layout View 06:36
  • 51: Print Preview Options 04:25
  • 52: Printing a Specific Range of Cells 02:38
  • 53: Converting Spreadsheets to PDF Files 02:28

• Section 10 06:44

  • 54: How to Create an Excel Template 05:22
  • 55: Why Create an Excel Template 01:22

• Section 11 35:22

  • 56: Finding and Removing Duplicate Values 07:29
  • 57: How to Prepare Data for Analysis 04:00
  • 58: Converting Datasets into Tables 05:55
  • 59: Creating Subtotals within a Dataset 05:38
  • 60: Applying Filters to Datasets 04:44
  • 61: Multi Level Sorting 02:33
  • 62: Custom Sorting Datasets in Excel 02:26
  • 63: How to Sort Data in Excel 02:37

• Section 12 30:02

  • 64: The SUMIF Function 08:41
  • 65: The DSUM Function 07:47
  • 66: The DSUM Function Cont 07:06
  • 67: The SUBTOTAL Function 06:28

Course 1: Excel Essentials for Beginners

- Duration: 4 weeks (16 lessons)

- Level: Beginner

- Prerequisites: None

Course 2: Intermediate Excel Mastery

- Duration: 6 weeks (24 lessons)

- Level: Intermediate

- Prerequisites: Excel Essentials for Beginners or equivalent knowledge

Course 3: Advanced Excel Techniques and Automation

- Duration: 8 weeks (32 lessons)

- Level: Advanced

- Prerequisites: Intermediate Excel Mastery or equivalent knowledge

Course 1: Excel Essentials for Beginners

Course Outline:

1. Introduction to Microsoft Excel 2016
2. Navigating the Excel Interface
3. Creating and Formatting Worksheets
4. Data Entry and Management
5. Basic Formulas and Functions
6. Cell References and Ranges
7. Formatting and Styling Data
8. Data Validation and Error Checking
9. Sorting and Filtering Data
10. Charts and Graphs
11. Introduction to PivotTables
12. Introduction to Data Analysis Tools
13. Printing and Sharing Worksheets
14. Keyboard Shortcuts for Efficiency
15. Tips for Excel Productivity
16. Course Recap and Assessment

Course 2: Intermediate Excel Mastery

Course Outline:

1. Review of Excel Essentials
2. Advanced Formulas and Functions
3. Conditional Formatting and Data Validation
4. Working with Tables
5. Advanced Charting Techniques
6. Data Analysis with PivotTables
7. Advanced-Data Analysis Tools
8. Importing and Exporting Data
9. Collaboration and Sharing Features
10. Data Protection and Security
11. Macros and Automation Basics
12. Introduction to VBA (Visual Basic for Applications)
13. Customizing Excel with Macros
14. Advanced PivotTable Techniques
15. Advanced Excel Tips and Tricks
16. Course Recap and Assessment

Course 3: Advanced Excel Techniques and Automation

Course Outline:

1. Review of Intermediate Excel Mastery
2. Advanced-Data Modeling with Power Query
3. Power Pivot for Advanced Data Analysis
4. Advanced Charting and Visualization
5. Data Analysis with What-If Analysis Tools
6. Advanced Excel Functions
7. Working with External Data Sources
8. Excel Automation with VBA
9. User Forms and Custom Functions in VBA
10. Error Handling and Debugging in VBA
11. Advanced VBA Techniques
12. Excel Add-Ins and Integration

This Microsoft Excel Advanced course is intended for students who are experienced Excel users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

This Microsoft Excel Advanced course builds on the foundational and intermediate knowledge presented in the Microsoft Excel Introduction and Microsoft Excel Intermediate courses to help you get the most of your Excel experience.

.

Suggested Learning Path:

• Start with Microsoft Excel Introduction to learn the basic Excel functions and interface
• Move onto Microsoft Excel Intermediate once you're comfortable with Excel basic operations, focusing on more advanced Excel formulas and data manipulation
• Progress to Microsoft Excel Advanced if you need to handle large datasets, automation, and complex Excel analysis tasks.

Before taking this Microsoft Excel Advanced course, it is recommended to take the Microsoft Excel Introduction course and Microsoft Excel Intermediate course, or have equivalent knowledge.

1. Being proficient in Microsoft Excel can open the door to many career opportunities such as:

   • Administrative Assistant
   • Data Analyst
   • Accountants
   • Financial Analyst
   • Retail Store Manager
   • Project Manager
   • Business Analyst

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