Skip to content

Microsoft Excel 2016 - Set of 3 Interactive Courses

Interactive Video Lessons | Free E-Certificate | Tutor Support

METAVERSESKILLS

Summary

Price
£12 inc VAT
Study method
Online, On Demand What's this?
Duration
4.9 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Certification of Completion - Free
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students

Add to basket or enquire

Overview

Unlock the full potential of Microsoft Excel 2016 with our comprehensive three-course series designed to take you from beginner to advanced Excel user. Whether you're a student, professional, or simply looking to enhance your spreadsheet skills, this set of interactive courses will equip you with the knowledge and techniques needed to excel in Excel.

Certificates

Certification of Completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Curriculum

12
sections
67
lectures
4h 53m
total

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

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

    • 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

    • 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

    • 54: How to Create an Excel Template 05:22
    • 55: Why Create an Excel Template 01: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

    • 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 media

Description

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

Who is this course for?

- Interactive video lessons with real-world examples.

- Hands-on exercises and practice files for each lesson.

- Quizzes and assessments to gauge your progress.

- Access to a community forum for peer support and discussion.

- Personalized feedback from experienced Excel instructors.

- Completion certificates for each course and a final certificate for the full set.

Requirements

No prior knowledge or experience required

Career path

  1. Collaborative Workflows with SharePoint and OneDrive
  2. Excel Dashboards and Reporting
  3. Final Project: Building an Automated Excel Solution
  4. Course Recap and Final Assessment

Questions and answers

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

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Business administration courses, Microsoft courses, Online courses