Sale!

Certificate In Excel 2013 Expert

£149.00 £8.99

The course will take you through the complete expert features of Excel 2013.

Who is this course for?

This course is perfect for anyone with an advanced knowledge of Excel 2013, and want to extend their learning to the expert features of the popular program.

Only 6 to 8 hours of study is required.

SKU: EC4Y0093 Categories: , Tag:

The course will take you through the complete expert features of Excel 2013.

Who is this course for?

This course is perfect for anyone with an advanced knowledge of Excel 2013, and want to extend their learning to the expert features of the popular program.

Only 6 to 8 hours of study is required.

What’s Included?

Wiki_tick  Unlimited  lifetime access
Wiki_tick  Access anywhere, any time
Wiki_tick  Fast effective training, written and designed by industry experts
Wiki_tick  Track your progress with our Learning Management System
Wiki_tick  Unlimited support
Wiki_tick  Save money, time and travel costs
Wiki_tick  Learn at your own pace and leisure
Wiki_tick  Easier to retain knowledge and revise topics than traditional methods
Wiki_tick  Exam preparation quizzes, tests and mock exams to ensure that you are 100% ready

£149.00 £8.99Add to cart

Modules

Only 6 to 8 hours of study is required.

Module One: Getting Started

Course Objectives

Module Two: Working with Permissions and Options

Marking a Workbook as Final
Encrypting with a Password
Protecting the Current Sheet or the Workbook Structure
Adding a Digital Signature
Setting Excel Options
Managing Versions
Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

Inspecting a Document
Sharing a Workbook
Editing a Shared Workbook
Tracking Changes
Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

Using the Watch Window
About the Excel Calculation Process
Setting Calculation Options
Enabling or Disabling Automatic Workbook Calculations
Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

About Array Formulas
Creating One-Dimensional and Two-Dimensional Constants
Creating a Simple Array
Creating an Advanced Array

Module Six: Working With Macros

Assigning a Macro to a Command Button
Running a Macro by Clicking an Area of a Graphic Object
Configuring a Macro to Run Automatically Upon Opening the Workbook

Module Seven: Working With Forms

About Excel Forms, Form Controls, and Active X Controls
Using a Data Form
Using a List Box Control
Using a Combo Box Control
Using a Spin Button Control
Using a Scroll Bar Control

Module Eight: Applying Advanced Chart Features

About Trend Lines
Add a Trend Line
Using Secondary Axes
Using Chart Templates

Module Nine: Working With Slicers and Timelines

About Slicers and Timelines
Creating a Slicer in an Existing Table
Formatting a Slicer
Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

Connecting to a New External Data Source
Creating a PivotTable Using an External Data Connection
Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

About Power View
Creating a Power View Sheet
Add a Table to the Data Model
Adding a Map to a Power View Report

Module Twelve: Wrapping Up

System Requirements

Minimum specifications for the computer are:

Windows:

Microsoft Windows XP, or later
Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS:

OSX/iOS 6 or later
Modern and up to date Browser (Firefox, Chrome, Safari)

All systems:

Internet bandwidth of 1Mb or faster
Flash player or a browser with HTML5 video capabilities (We recommend Google Chrome)