Course Description

Microsoft Excel Bundle

Study 365



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 walked 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.

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

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.

Course Curriculum

——– Excel 2016 – pc ——–

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

——– excel 2016 bootcamp ——–

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

——– excel 2016 for pc – charting ——–

1: getting started

2: chart tabs and riddons

3: format your chart

4: present your chart

5: work with sparklines

6: new chart types

——– excel 2016 for pc – evaluating data ——–

1: getting started

2: data validation

3: conditional formatting

——– excel 2016 for pc – frequently used formulas & functions ——–

1: getting started & what’s new

2: formulas

3: linking and consolidating worksheets

4: auditing & error checking

——– excel 2016 for pc – pivot tables ——–

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

——– excel 2016 for pc – protecting your spreadsheets ——–

1: protecting your spreadsheet

——– excel 2016 for pc – statistical analysis ——–

1: describing data

2: comparing variables

3: tests of significance

4: printing options & copying a pivot table

5: data analysis toolpak

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.

Certification:

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.

Why Choose Us?

  • Our courses represent outstanding value for money
  • High quality e-learning study materials and mock exams.
  • Each course is designed by industry experts, using an innovative interactive learning approach.
  • Includes step-by-step guided videos tutorials.
  • 24/7 Access to the Online Learning Portal.
  • Anytime & Anywhere Learning.
  • Recognised Accredited Qualification.
  • Access Course Content on Mobile, Tablet or Desktop.
  • Study in a user friendly, advanced online learning platform.
  • Excellent customer service and administrative support.

Course Code S 0397
College Name Study 365
Course Category Computers & IT (Information Technology)
Course Type Online Learning
Course Location Athlone, Westmeath, Dublin, Ireland
Course Fee 92
Course Duration 365 days
Entry Requirements Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.
Career Path Administrator Office manager Business executive Accountant Bookkeeper
For information about Study 365, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

Study 365



406 White Horse Lane London E1 3FY., Dublin, United Kingdom

Make Enquiry


Please insert your contact details and any additional information you require and we will forward your request to the organisation in question.

Captcha code        I confirm I have read the Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

Reviews

Submit a Review for
Microsoft Excel Bundle
Study 365

Your email address will not be published. Required fields are marked *

Click to Rate

We'd love to send you the latest news and articles about evening classes, further learning and adult education by email. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

Comments and Reviews Policy