reed.co.uk Courses

Header

Microsoft Excel

Accredited Microsoft Excel Complete Training (Beginner, Intermediate, Advanced) | FREE PDF Certificate | Lifetime Access


Course Cloud

Summary

Price
Save 98%
£10 inc VAT (was £999)
Offer ends 01 March 2021
Study method
Online, self-paced
Duration
10 hours
Access to content
Lifetime access
Qualification
No formal qualification
CPD
10 CPD hours / points
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students
  • Certificate of completion available and is included in the price

383 students purchased this course

Add to basket or enquire

Overview

What Will I Learn?

This Microsoft Excel bundle course you will be able to teach yourself excel from beginner level functions right to the complex formula programming related tasks by excel..

From the Microsoft Excel 2016 Introduction Course you will learn:

  • To create simple worksheets
  • Understand calculation hierarchy and the Order of Operations
  • Format and align worksheet data
  • Proof and print a workbook
  • Use Functions in formulas
  • Add columns and rows
  • Use cell styles and themes
  • Manage Worksheets

From the Microsoft Excel 2016 Intermediate course you will learn:

  • Custom Excel
  • Work with Range Names
  • Analyze Data with Common Lookup Functions
  • Analyze and Organize with Tables
  • Outline with Subtotals and Grouping
  • Work with Date and Time Functions
  • Link Workbooks and Worksheets
  • Analyze Data with Common Logical Functions
  • Sort and Filter Range Data
  • Use Conditional Formatting
  • Display Data Graphically
  • Work with Flash Fill
  • Work with Common Text Functions

From the Microsoft Excel 2016 Advanced course you will learn:

  • Use Advanced IF Statements
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Working with What-If Analysis Tools
  • Protecting Worksheet and Workbook
  • Use Advanced PivotTables and PowerPivot Tools
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Import and Export Data to a Text File

Microsoft Excel Complete Training (Beginner, Intermediate, Advanced) Bundle is a best-selling course bundle developed by industry experts and it has already helped tons of students like you. It is suitable for anyone who wants to improve or gain fantastic skills in Microsoft Excel.

Microsoft Excel is the world’s most popular spreadsheet and data visualisation tool. Almost every company uses it on a day to day basis, so learning how to use it and being an expert in it will significantly improve your employability and it has become a must-have skill nowadays.

Enrol now in this all in one bundle and start mastering Microsoft Excel today.

The courses in this bundle are accredited by CPD, so you will get a career boost upon completing this course. Our Microsoft Excel Complete Training (Beginner, Intermediate, Advanced) Bundle is packed with several information-rich modules that break down each topic for easy understanding.

After completing the course you will be awarded a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.

We know that you are busy and your time is very important, so to make our learners feel at ease we have designed this course for any type of student and you can complete it at your own pace. The course materials are accessible from anyplace, from any device and at any time.

And lastly, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

CPD

10 CPD hours / points
Accredited by CPD Accreditation Group

Course media

Description

Course Curriculum

Microsoft Excel 2016 Introduction

Introduction

  • Introduction

Getting Started with Excel

  • What is Excel
  • Opening Excel

Creating Workbooks and Using Templates

  • Creating a New Workbook
  • Creating Workbooks Using Templates

Entering Data

  • Navigating a Worksheet by Mouse or Keyboard
  • Excel Data Types

Excel Formula Basics Data

  • What are Formulas and Functions
  • Using the Quick Analysis Tool

Adjusting a Worksheet

  • Modifying Columns and Rows
  • Hiding and Unhiding Columns and Rows

Formatting and Aligning Worksheet Data

  • Formatting and Aligning Data
  • Removing Formatting Quickly

Using Cell Styles and Themes

  • Understanding Cell Styles
  • Applying Cell Styles

Inserting Objects and Graphics

  • Inserting and Formatting Images
  • Inserting and Formatting Shapes

Proofing a Workbook

  • Using Find and Replace
  • Finding and Replacing Formatting

Printing an Excel File

  • Printing and Previewing Excel Files
  • Creating Custom Margins and Scaling

Managing Worksheets

  • Renaming and Coloring Worksheet Tabs
  • Adding, Deleting, and Navigating Worksheets

Navigating and Viewing Excel Files

  • Viewing Workbooks
  • Using Zoom Tools

Conclusion

  • Course Recap

***Microsoft Excel 2016 Intermediate***

Introduction

  • Introduction

Customizing Excel

  • Customizing the Ribbon
  • Customizing the Quick Access ToolBar

Linking Workbooks and Worksheets

  • Linking Workbooks and Worksheets
  • Linking Worksheets with 3D References

Working with Range Names and Advanced Formulas

  • What are Range Names
  • Creating Range Names Using Create from Selection

Analyzing Data with Common Logical Functions

  • Working with the Most Common Logical Functions
  • Evaluate Data with the AND Function

Analyzing Data with Common Lookup Functions

  • What are Lookup Functions
  • Using VLookup

Sorting and Filtering Range Data

  • Differences Between Sorting & Filtering
  • Sorting Lists

Analyzing and Organizing with Tables

  • Creation and Benefits of a Table
  • Elements of a Table

Using Conditional Formatting

  • What is Conditional Formatting
  • Conditional Formatting and Highlight Cells and Top Bottom Rules

Outlining with Subtotals and Grouping

  • What are Subtotals and Grouping
  • Creating Subtotals

Displaying Data Graphically

  • What are Charts
  • Creating Charts

Understanding PivotTables and PivotCharts and Filtering with Slicers

  • What is a Pivot Table
  • Creating a Pivot Table

Working with Flash Fill

  • What is Flash Fill
  • Using Flash Fill and Autofill

Working with Date and Time Functions

  • What are Date and Time Functions-
  • Using TODAY, NOW, and DAY Functions

Working with Common Text Functions

  • What are Text Functions
  • Using UPPER, LOWER, & PROPER Functions

Conclusion

  • Course Recap

***Microsoft Excel 2016 Advanced***

Introduction

  • Introduction

Using Advanced IF Statements

  • Summarize Data with SUMIF
  • Summarize Data with AVERAGIF

Using Advanced Lookup Functions

  • Using VLOOKUP with TRUE to find an Approximate Match
  • Using HLOOKUP TRUE to find an Approximate Match

Using Complex Logical and Text Functions

  • Creating a Nested IF Function
  • Using the IFERROR Function

Formula Auditing

  • Showing Formulas
  • Tracing Cell Precedents and Dependents

What-If Analysis Tools

  • Using the Scenario Manager
  • Using Goal Seek

Worksheet and Workbook Protection

  • Protection Overview
  • Excel File Password Encryption

Advanced Use of PivotTables and PowerPivot

  • Using the Pivot Tables Charts Wizard

Automating with Macros

  • What are Macros

Working with Form Controls

  • What are Form Controls

Ensuring Data Integrity

  • What is Data Validation

Collaborating in Excel

  • Working with Comments

Importing and Exporting Data to a Text File

  • Importing a Text File

Conclusion

  • Course Recap

Certification

Complete your course by sitting for an MCQ assessment. To pass the test, you need to achieve 60% or higher in the final assessment. After passing, you will be able to get the UK and internationally recognised certificate to share your achievement with potential employers or to include it in your CV. The PDF certificate is totally free, or you can get a a physical version of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Who is this course for?

This course bundle is great for:

  • Students
  • Recent graduates
  • Job seekers
  • Those looking to learn an in-demand skill and improve their earning potential

Requirements

  • Basic knowledge of operating a computer
  • Microsoft Excel software

Questions and answers


No questions or answers found containing ''.


Ceri asked:

Hi, Can I do this course on a MacBook

Answer:

Good day. Yes, a MacBook is compatible to do the course. Thanks

This was helpful. Thank you for your feedback.

Reviews

4.9
Course rating
97%
Service
100%
Content
100%
Value
Leave a review

{{ getTruncatedSinglePointScore(item.OverallCourseRating) }} Star Review by {{ item.ReviewerName }} for {{ item.Title }}


{{ getLongDate(item.CreatedOn) }}
{{ item.Title }}
Reviewed by {{ item.ReviewerName }}
|Purchased {{ getHumanisedPassageOftime(item.PurchasedOn) }}
{{ item.ProviderName }} responded to this review
{{ getLongDate(item.ProviderResponseDate) }}
{{ results.length }} out of {{ totalResultsCount }} reviews

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk 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.

What are CPD hours/points?

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.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

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.

What is an ‘endorsed’ course?

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.

Modals

Mobile Navigation