Certificate in Excel 2013 Expert Online Course

Learn How To Excel in Excel

Certificate in Excel 2013 Expert Online Course

NOW ONLY

€149

Save €120 (45%)
OFF RRP €269
Get Info Pack

Learn How To Excel in Excel

Using Conditional Formatting
This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.

Working with Slicers
Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this course students are shown how to insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer.

Using Power View, Part One
Power View has many applications for upper-level users of Excel 2013. Students will learn in this course how to enable Power View, create a Power View, add and remove fields, arrange fields, and filter and sort data.

Using Power View, Part Two
Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This course looks at how to: refresh data, choose a visualization, change tile display, and set display options.

Using the Inquire Add-In
The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This course shows students how to install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks.

Working with Tables
Tables are efficient for dealing with ranges of data. Students will get the most from the course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style.

Working with Records and Fields
Records and fields are the building blocks of data. Covered in this course is what they actually are and how to add fields by inserting columns, add records by inserting rows, and delete records or fields.

Using Excel as a Database
Databases are an assemblage of data which can be manipulated in many ways. This course takes a look at how to filter data with wildcard characters, validate data with lists or formulas, and how to use database functions.

Using Custom AutoFill Lists
An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This course will show users how to create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list.

Using Comments
Comments allow users to engage with the material and each other through making messages added to Excel files. This course gives students the knowledge how to insert, edit, navigate, and delete comments.

Tracking Changes
When changes are made to a file it’s very handy to know what has been changed and when and by who. This course touches upon how to track and review changes, set options for tracking changes, and stop tracking changes.

Linking, Consolidating, and Combining Data
When working with multiple files with interrelated data it’s handy to make the most of linking. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Using Conditional Formatting

  • Applying Conditional Formatting
  • Applying Multiple Rule Sets
  • Creating Custom Rule Sets
  • Viewing and Managing Rules
  • Clearing Custom Rules

Working with Slicers

  • Inserting and Using a Slicer
  • Renaming the Slicer
  • Changing Slicer Settings
  • Formatting a Slicer
  • Clearing the Slicer

Using Power View, Part One

  • Enabling Power View
  • Creating a Power View
  • Adding and Removing Fields
  • Arranging Fields
  • Filtering Data
  • Sorting Data

Using Power View, Part Two

  • Refreshing Data
  • Choosing a Visualization
  • Changing Tile Display
  • Setting Display Options

Using the Inquire Add-In

  • Installing Inquire
  • Generating a Workbook Analysis Report
  • Viewing Workbook and Worksheet Relationships
  • Viewing Cell Relationships
  • Comparing Two Workbooks

Working with Tables

  • What is a Table?
  • Creating Tables
  • Resizing the Table
  • Choosing a Table Style
  • Clearing the Table

Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records or Fields

Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions

Using Custom AutoFill Lists

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List

Using Comments

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments

Tracking Changes

  • Tracking Changes
  • Reviewing Changes
  • Setting Options for Tracking Changes
  • Stopping Tracking Changes

Linking, Consolidating, and Combining Data

  • Linking Workbooks
  • Consolidating Workbooks
  • Consolidating Worksheets
  • Pivoting Consolidated Data 

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

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(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

About this Course

Learn How To Excel in Excel

Using Conditional Formatting
This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.

Working with Slicers
Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this course students are shown how to insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer.

Using Power View, Part One
Power View has many applications for upper-level users of Excel 2013. Students will learn in this course how to enable Power View, create a Power View, add and remove fields, arrange fields, and filter and sort data.

Using Power View, Part Two
Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This course looks at how to: refresh data, choose a visualization, change tile display, and set display options.

Using the Inquire Add-In
The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This course shows students how to install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks.

Working with Tables
Tables are efficient for dealing with ranges of data. Students will get the most from the course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style.

Working with Records and Fields
Records and fields are the building blocks of data. Covered in this course is what they actually are and how to add fields by inserting columns, add records by inserting rows, and delete records or fields.

Using Excel as a Database
Databases are an assemblage of data which can be manipulated in many ways. This course takes a look at how to filter data with wildcard characters, validate data with lists or formulas, and how to use database functions.

Using Custom AutoFill Lists
An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This course will show users how to create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list.

Using Comments
Comments allow users to engage with the material and each other through making messages added to Excel files. This course gives students the knowledge how to insert, edit, navigate, and delete comments.

Tracking Changes
When changes are made to a file it’s very handy to know what has been changed and when and by who. This course touches upon how to track and review changes, set options for tracking changes, and stop tracking changes.

Linking, Consolidating, and Combining Data
When working with multiple files with interrelated data it’s handy to make the most of linking. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Using Conditional Formatting

  • Applying Conditional Formatting
  • Applying Multiple Rule Sets
  • Creating Custom Rule Sets
  • Viewing and Managing Rules
  • Clearing Custom Rules

Working with Slicers

  • Inserting and Using a Slicer
  • Renaming the Slicer
  • Changing Slicer Settings
  • Formatting a Slicer
  • Clearing the Slicer

Using Power View, Part One

  • Enabling Power View
  • Creating a Power View
  • Adding and Removing Fields
  • Arranging Fields
  • Filtering Data
  • Sorting Data

Using Power View, Part Two

  • Refreshing Data
  • Choosing a Visualization
  • Changing Tile Display
  • Setting Display Options

Using the Inquire Add-In

  • Installing Inquire
  • Generating a Workbook Analysis Report
  • Viewing Workbook and Worksheet Relationships
  • Viewing Cell Relationships
  • Comparing Two Workbooks

Working with Tables

  • What is a Table?
  • Creating Tables
  • Resizing the Table
  • Choosing a Table Style
  • Clearing the Table

Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records or Fields

Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions

Using Custom AutoFill Lists

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List

Using Comments

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments

Tracking Changes

  • Tracking Changes
  • Reviewing Changes
  • Setting Options for Tracking Changes
  • Stopping Tracking Changes

Linking, Consolidating, and Combining Data

  • Linking Workbooks
  • Consolidating Workbooks
  • Consolidating Worksheets
  • Pivoting Consolidated Data 

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

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(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

We provide a 7 Day Money Back Refund on all Courses

Now Only €149 Save €120 (45%)
OFF RRP €269
Delivery Method

Online - Certificate

Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value €300)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 002EX13EXOC
Delivery Mode: Online
Course Access: Lifetime Course Access
Time required: Study at your own pace
Course Duration: 6 - 8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner