Excel 2016 Expert Training – Online Course – CPDUK Accredited Course

£19.99

Description

Excel 2016 Expert Training – Online Course – CPDUK Accredited – Microsoft Office Training and Certification.

Welcome to our online Microsoft Office Excel 2016 Expert training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).

Learners will gain an advanced level of understanding of the Microsoft Excel environment, and the ability to guide others to the proper use of the program’s full features – critical skills for those in roles such as accountants, financial analysts, and commercial bankers.

Learners will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Microsoft Office Excel 2016 Expert environments to meet project needs and increase productivity. Microsoft Office Excel 2016 Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Online Microsoft Office Excel 2016 Expert training course

Study method – Online, self-paced

Estimated duration (Indicative CPD hours) – 4 hours

Course format – Online (24/7 access)

Entry requirements – no prerequisites required

Assessment type – Complete end of course assessment (80% needed to pass and gain CPD certificate)

Certification/Qualification – Downloadable CPD certificate

Cost(s) of assessment and certification – Assessment and certification costs included in the course price

Course accreditation – CPD Certification Service (CPDUK)

Course access – Part-time (1-year access)

Course delivery – via desktop PC/MAC, laptops, tablets or smartphones.

Aims and objectives

The online Microsoft Office Excel 2016 Expert training course is designed for both students who are interested in gaining a broad knowledge of the Excel 2016 application and for experienced word users who wish to undertake a refresher course.

This online MS Office Excel 2016 Expert training course follows the Microsoft Office Specialist (MOS) syllabus, and more, and is the ideal study guide for those wishing to gain the industry-recognised MOS certification.

Learning outcomes

On completion of this Microsoft Office Excel 2016 Expert training course, learners will:

  • Gain an advanced level of understanding of the Microsoft Excel environment,
  • Have the ability to guide others to the proper use of the program’s full features – critical skills for those in roles such as accountants, financial analysts, and commercial bankers,
  • Be able to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations,
  • Be able to customize their Microsoft Office Excel 2016 Expert environments to meet project needs and increase productivity.

*Microsoft Office Excel 2016 Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Who is this online MS Office Excel 2016 Expert training course for?

This online Microsoft Office Excel 2016 Expert training course is suitable for anyone who wants to improve their knowledge of Excel 2016. These skills will enhance the learner’s knowledge and employability opportunities.

This online Microsoft Office Excel 2016 Expert training course can be purchased as an individual course or as part of our integrated Microsoft Office training programs and certification.

What is covered in this MS Office Excel 2016 Expert online training course?

This Microsoft Office Excel 2016 Expert training course covers the following modules:

Module One: Manage Workbook Options and Settings

  • Manage Workbooks
    • Save a workbook as a template
    • Copy macros between workbooks
    • Mange Document Versions
    • Reference data in another workbook
    • Reference data by using structured references
    • Enable macros in a workbook
    • Display hidden ribbon tabs
  • Manage Workbook Review
    • Restrict editing
    • Protect a worksheet
    • Configure formula calculation options
    • Protect workbook structure
    • Mange workbook versions
    • Encrypt workbooks with a password

Module Two: Apply Custom Data Formats and Layouts

  • Apply Custom Data Formats and Validation
    • Create custom number formats
    • Populate cells by using advanced Fill Series options
    • Configure data validation
  • Apply Advanced Conditional Formatting and Filtering
    • Create custom conditional formatting rules
    • Create conditional formatting rules that use formulas
    • Manage conditional formatting rules
  • Create and Modify Custom Workbook Elements
    • Create custom color formats
    • Create and modify cell types
    • Create and modify custom themes
    • Create and modify simply macros
    • Insert and configure form controls
  • Prepare a Workbook for Internationalization
    • Display data in multiple international formats
    • Apply international currency formats
    • Manage multiple options for +Body and +Heading fonts

Module Three: Create Advanced Formulas

  • Apply Functions in Formulas
    • Perform logical operations by using AND, OR, and NOT functions
    • Perform logical operations by using nested functions
    • Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions
  • Look up data using Functions
    • Look up data by using the VLOOKUP
    • Look up data by using the HLOOKUP function
    • Look up data by using the MATCH function
    • Look up data by using the INDEX function
  • Apply Advanced Date and Time Functions
    • Reference the date and time by using the NOW and TODAY functions
    • Serialize numbers by using date and time functions
  • Perform Data Analysis and Business Intelligence
    • Import, transform, combine, display, and connect to data
    • Consolidate data
    • Perform what-if analysis buy suing Goal Seek and Scenario Manager
    • Use cube functions to get data out of the Excel data model
    • Calculate data by using financial functions
  • Troubleshoot Formulas
    • Trace precedence and dependance
    • Monitor cells and formulas by using the Watch Window
    • Validate formulas by using error checking values
    • Evaluate formulas
    • Calculate data by using financial functions
  • Define Named Ranges and Objects
    • Name cells
    • Name data ranges
    • Name tables
    • Mange named ranges and objects

Module Four: Create Advanced Charts and Tables

  • Create Advanced Charts
    • Add trendlines to charts
    • Create dual axis charts
    • Save a chart as a template
  • Create and Manage Pivot Tables
    • Create PivotTables
    • Modify field selections and options
    • Create slicers
    • Group PivotTable data
    • Reference data in a PivotTable by suing the GETPRIVOTDATA function
    • Add calculated fields
    • Format data
  • Create and Manage PivotCharts
    • Create PivotCharts
    • Manipulate options in existing PivotCharts
    • Apply styles to PivotCharts
    • Apply Styles to PivotCharts
    • Manipulate options in existing PivotCharts
    • Apply styles to PivotCharts
    • Drill down into PivotChart details.

How do I book for the online MS Office Excel 2016 Expert training course?

You can book for the MS Office Excel 2016 Expert training course online. Just click ‘Buy Now’ in the top right-hand corner of this page to order your MS Office Excel 2016 Expert training course online. Follow the instructions to complete the order.

Once you complete your Excel 2016 Expert online order, you will receive a confirmation email within a few minutes. You will also receive a separate email providing you with the link to your MS Office Excel 2016 Expert training course online and login details. You should then be able to access your online MS Office Excel 2016 Expert training course portal immediately and complete your online training modules.

Certification and Accreditation

On successful completion of the online MS Office Excel 2016 Expert training course, you will be able to download, save and/or print a quality assured CPD certificate. Our CPD certificate can be used to provide evidence for compliance and audit (recognised internationally).

LearnPac Systems and The Mandatory Training Group have worked with a range of subject matter experts to develop high-quality online training courses and programmes. The CPD Certification Service (CPDUK) has peer-reviewed independently and accredited our online MS Office Excel 2016 Expert as conforming to universally accepted Continuous Professional Development (CPD) guidelines.

Click here to see our CPDUK corporate continuing professional development accreditation.

Online assessment

On completion of the online  MS Office Excel 2016 Expert training course, you will be required to complete an online assessment (pass mark of 80%).

If you don’t pass the first, don’t worry! You can take the online test as many times as you need with no extra charge.

Click Here for Online Training Courses, Programmes and Qualifications.

Why is this MS Office Excel 2016 Expert training course relevant?

Proficiency in Microsoft Office products is increasingly important in today’s competitive business environment and, whether you are currently employed or a job seeker, Microsoft Office Specialist certification proves to employers and prospective employers that you have the necessary skills to become an essential member of their team.

Start mastering Excel, the world’s most popular and influential spreadsheet program with our Excel 2016 Expert training course. Learn how to enter best and organise data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables.

You will also learn how to utilise the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

Microsoft Office – online training courses and certification

LearnPac Systems provides a wide range of online Microsoft Office e-learning courses. Click on the links below to purchase these MS Office courses:

Why choose LearnPac Systems’ E-Learning courses?

LearnPac Systems is a leading UK provider of accredited online training courses, programmes and qualifications including the following categories:

LearnPac Systems is a leading UK provider of accredited online training courses, programmes and qualifications. Contact our Support Team on 024 7610 0090 or via Email to discuss your online training requirements.

Excel 2016 Expert Training – Online Course – CPDUK Accredited – Microsoft Office Training and Certification.

Please follow and like us:
EMAIL
Facebook
Facebook
TWITTER
Visit Us
LinkedIn