HOME
 

Microsoft Excel Bundle - Accredited by CPD

Study365
Course summary
18 hours
79 GBP
English
Distance
Next available date: This course is available to purchase anytime of the year. - Distance
Last application: This course is available to register anytime of the year.
e-learning / Online / Distance

Course description

Overview

This excellent bundle has been created so you can become an expert user of Excel, which is used in most workplaces, and is extremely useful. With instruction from some very experienced teachers, you’ll be learning from the best, and will be taken through the process with support from a tutor. This bundle consists of the following courses: Excel 2016 – PC, Excel 2016 Bootcamp, Excel 2016 for PC – Charting, Excel 2016 for PC – Evaluating Data, Excel 2016 for PC – Frequently Used Formulas & Functions, Excel 2016 for PC – Pivot Tables, Excel 2016 for PC – Protecting Your Spreadsheets and Excel 2016 for PC – Statistical Analysis.

By the time you’re finished with this course bundle, you’ll have a deep understanding of working with your data – from sharing and securing, to importing and exporting. Now is your time to go from Excel Zero, to Excel Hero, and for you to become the Microsoft Excel professional in your office.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

Suitability - Who should attend?

Entry Requirement:

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Outcome / Qualification etc.

Successful candidates will be awarded certificates for Excel 2016 – PC, Excel 2016 Bootcamp, Excel 2016 for PC – Charting, Excel 2016 for PC – Evaluating Data, Excel 2016 for PC – Frequently Used Formulas & Functions, Excel 2016 for PC – Pivot Tables, Excel 2016 for PC – Protecting Your Spreadsheets, and Excel 2016 for PC – Statistical Analysis.

Training Course Content

Course Curriculum

1: GETTING STARTED
2: WORK WITH DATA AND DATASETS
3: CREATE FORMULAS
4: MANAGE DATA AND DATASETS
5: FORMAT YOUR TABLE
6: WORK WITH SHEETS
7: WORK WITH CHARTS
8: SHARE AND SECURE DATA
9: IMPORT AND EXPORT DATA
1: OVERVIEW
2: HOW TO MAKE A QUOTE & INVOICING FORM
3: USING TEMPLATES
4: CLEANING UP MESSY DATA
5: GRAPHS IN EXCEL
6: PIVOT TABLES
7: HOW TO MAKE A PROFIT & LOSS SHEET
8: CHEAT SHEET & SHORTCUTS
1: GETTING STARTED
2: CHART TABS AND RIDDONS
3: FORMAT YOUR CHART
4: PRESENT YOUR CHART
5: Work with Sparklines
6: New Chart Types
1: Getting Started
2: Data Validation
3: Conditional Formatting
1: Getting Started & What’s New
2: Formulas
3: Linking and Consolidating Worksheets
4: Auditing & Error Checking
1: Getting Started
2: Creating & Deleting
3: Custom Appearance & Layout
4: Printing Options & Copying a Pivot Table
5: Summarizing with Totals & Formulas
6: Refreshing Data
7: Pivot Charts
8: Sparklines & Slicers
1: Protecting Your Spreadsheet
1: Describing Data
2: Comparing Variables
3: Tests of Significance
4: Printing Options & Copying a Pivot Table
5: Data Analysis ToolPak

Course Duration:

From the day you purchase the course, you will have 12 months access to the online study platform. As the course is self-paced you can decide how fast or slow the training goes, and are able to complete the course in stages, revisiting the training at any time.

Method of Assessment:

At the end of each module, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.

Included courses:

  • Excel 2016 – PC
  • Excel 2016 Bootcamp
  • Excel 2016 for PC – Charting
  • Excel 2016 for PC – Evaluating Data
  • Excel 2016 for PC – Frequently Used Formulas & Functions
  • Excel 2016 for PC – Pivot Tables
  • Excel 2016 for PC – Protecting Your Spreadsheets
  • Excel 2016 for PC – Statistical Analysis

Expenses

Now £79.00

Was £249.00

Continuing Studies

Career Path:

Upon successfully completing the Microsoft Excel Bundle, you will gain recognised certifications that will prove your expertise in Excel concepts, formulas and functions. You can use the certifications to make a strong impression on potential employers and gain the desired job role across multiple industries. You will also be eligible for incentives put forth by the organisation or a pay raise.

This course could help you pursue a career in any of the following job roles:

  • Office Administrator - £18,172 per annum
  • Accountant - £28,875 per annum
  • Bookkeeper - £10.89 per annum

About provider

Study365

Study 365

Study 365 is a leading vocational and professional accredited course provider, offering over 1000 courses to students worldwide over 7+ years. We have a solid reputation which has helped us become a highly trusted and reliable course provider learning marketplace....


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel Bundle - Accredited by CPD.

  Contact the provider

  Get more information

  Register your interest

Request information

Find out more about this Microsoft Excel Bundle - Accredited by CPD course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here