Sale!

Certificate In Excel 2010 Advanced

£149.00 £8.99

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

Who is this course for?

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

Only 6 to 8 hours of study is required.

SKU: EC4Y0090 Categories: , Tag:

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

Who is this course for?

This course is perfect for anyone with a basic knowledge of Excel 2010, and want to extend their learning to the more advanced 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: SmartArt and Objects

Lesson One: Inserting SmartArt
Lesson Two: Adding Text to the Diagram
Lesson Three: Resizing and Moving the Diagram
Lesson Four: Resetting the Diagram
Lesson Five: Adding Pictures from Your Computer
Lesson Six: Adding Clip Art
Lesson Seven: Adding Text Boxes
Lesson Eight: Drawing Shapes
Lesson Nine: About the Contextual Tabs

Module Three: Auditing

Lesson One: Tracing Recedent Cells
Lesson Two: Tracing the Dependents of a Cell
Lesson Three: Displaying Formulas Within the Sheet
Lesson Four: Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts

Lesson One: Inserting a Chart
Lesson Two: Overview of the Chart Tools Tab
Lesson Three: Understanding the Parts of a Chart
Lesson Four: Changing the Chart Style
Lesson Five: Resizing and Moving the Chart

Module Five: Creating Pivot Tables

Lesson One: Inserting a Pivot Table
Lesson Two: Choosing Fields and Grouping Data
Lesson Three: Overview of the Pivot Tools Tabs

Module Six: Working with PivotTables and PivotCharts

Lesson One: Changing the Data Displayed and Refreshing the PivotTable
Lesson Two: Applying a Style to Your Pivot Table
Lesson Three: Creating a Pivot Chart from a Pivot Table
Lesson Four: Creating a Pivot Chart from Data
Lesson Five: Some Real-life Examples

Module Seven: Macros

Lesson One: Displaying the Developer Tab
Lesson Two: Recording and Running Macros
Lesson Three: Changing the Security Level
Lesson Four: Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

Lesson One: Using Named Ranges
Lesson Two: Understanding Formula Errors
Lesson Three: Using the Trace Errors Commands
Lesson Four: Using Error Checking

Module Nine: Using What If Analysis

Lesson One: Using Goal Seek
Lesson Two: Using the Scenario Manager
Lesson Three: Using a One Input Data Table
Lesson Four: Using a Two Input Data Table

Module Ten: Managing Your Data

Lesson One: Transposing Data from Rows to Columns
Lesson Two: Using the Text to Columns Feature
Lesson Three: Checking for Duplicates
Lesson Four: Creating Data Validation Rules
Lesson Five: Consolidating Data

Module Eleven: Grouping and Outlining Data

Lesson One: Grouping Data
Lesson Two: Adding Subtotals
Lesson Three: Outlining Data
Lesson Four: Viewing Grouped and Outlined Data

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)