Sale!

Certificate In Excel 2013 Advanced

£149.00 £8.99

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

Who is this course for?

This course is perfect for anyone with a basic knowledge of Excel 2013, 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: EC4Y0092 Categories: , Tag:

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

Who is this course for?

This course is perfect for anyone with a basic knowledge of Excel 2013, 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

Inserting SmartArt
Editing the Diagram
Adding Pictures
Adding Textboxes
Drawing Shapes
About the Contextual Tabs

Module Three: Auditing

Tracing Precedent Cells
Tracing the Dependents of a Cell
Displaying Formulas Within the Sheet
Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts

Using Recommended Charts
Inserting a Chart
Overview of the Chart Tools Tabs
Understanding Chart Elements
Resizing and Moving the Chart

Module Five: Working with Charts

Using Chart Elements
Using Chart Styles and Colors
Using Chart Filters
Working with Data Labels

Module Six: Creating Pivot Tables and Pivot Charts

Inserting a PivotTable using Excel Recommendations
Choosing Fields and Grouping Data
Overview of the Pivot Table Tools Tabs
Changing the Data Displayed and Refreshing the PivotTable
Creating a Pivot Chart from a Pivot Table or Data
Some Real-life Examples

Module Seven: Macros

Displaying the Developer Tab
Recording and Running Macros
Changing the Security Level
Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

Using Named Ranges
Understanding Formula Errors
Using Error Checking
Using the Trace Errors Commands
Evaluating Formulas

Module Nine: Using What If Analysis

Using Goal Seek
Using the Scenario Manager
Using a One Input Data Table
Using a Two Input Data Table

Module Ten: Managing Your Data

Transposing Data from Rows to Columns
Using the Text to Columns Feature
Checking for Duplicates
Creating Data Validation Rules
Consolidating Data

Module Eleven: Grouping and Outlining Data

Grouping Data
Adding Subtotals
Outlining Data
Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Words from the Wise

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)