Sale!

Certificate In Excel 2010 Expert

£179.00 £10.95

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

Who is this course for?

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

Only 6 to 8 hours of study is required.

SKU: EC4Y0091 Categories: , Tag:

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

Who is this course for?

This course is perfect for anyone with an advanced knowledge of Excel 2010, 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

Modules

Only 6 to 8 hours of study is required.

Module One: Getting Started

Course Objectives

Module Two: Working with Permissions and Options

Marking Workbook as Final
Encrypting with a Password and Restricting Permissions
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 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 Functions

Working with Math and Trigonometry Functions
Using a SUMIF Function
Working with Date and Time Functions
Working with Financial Functions
Working with Text Functions
Working with Cube Functions
Working with Statistical Functions

Module Seven: 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
Changing a Macro

Module Eight: 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 Nine: Applying Advanced Chart Features

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

Module Ten: Working with PivotTables and PivotCharts

Working with PivotTable Tools
Working with PivotChart Tools
About Slicers
Creating a Slicer in an Existing PivotTable
Creating a Standalone Slicer
Formatting a Slicer
Sharing Slicers with Another PivotTable
Disconnect or Delete a Slicer

Module Eleven: Using the Automated Analysis Tools Add-In

Loading the Analysis ToolPak
About the Analysis ToolPak Options (I)
About the Analysis ToolPak Options (II)
About the Analysis ToolPak Options (II)

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)