Excel 365 and Excel, Beginner, Advanced and Expert – 7 Course Training Bundle

£349.00

The course bundle will take you through the complete basics of Excel 2010, 2013 and 365, and then guide you through the intermediate and advanced features so you will have a great understanding on how to master Excel.

What is Microsoft Excel?

Microsoft Excel is a computer application from the extremely popular Microsoft Office suite. It allows you to create spreadsheets, calculate data, create graphs and much more..

Only 6 to 8 hours of study is required per course.

The course bundle will take you through the complete basics of Excel 2010, 2013 and 365, and then guide you through the intermediate and advanced features so you will have a great understanding on how to master Excel.

What is Microsoft Excel?

Microsoft Excel is a computer application from the extremely popular Microsoft Office suite. It allows you to create spreadsheets, calculate data, create graphs and much more..

Only 6 to 8 hours of study is required per course.

Courses Included:

Course 1 – Certificate In Excel 365 Essentials

Course 2 – Certificate In Excel 2010 Essentials

Course 3 – Certificate In Excel 2010 Advanced

Course 4 – Certificate In Excel 2010 Expert

Course 5 – Certificate In Excel 2013 Essentials

Course 6 – Certificate In Excel 2013 Advanced

Course 7 – Certificate In Excel 2013 Expert

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

£349.00Add to cart

Modules

Course 1 – Certificate In Excel 365 Essentials

Only 6 to 8 hours of study is required per course.

Module One: Getting Started

By the end of this course, you should be able to:

Open and close spreadsheets
Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
Understand the Excel 365 browser interface
Upload a spreadsheet to the Shared Documents library
Differentiate between worksheets, workbooks, rows, columns, and cells
Download and reload workbooks
Use the Find Command
Save a Copy
Open in Editing View
Open the spreadsheet in the Excel desktop application for more advanced features
Understand saving and collaborating
Create a new file
Enter labels and values
Edit data
Use the Wrap Command
Use cut, copy, and paste
Use Undo and redo
Add rows and columns
Delete cells
Understand shortcuts
Build, copy and edit formulas
Use absolute referencing appropriately
Understand the difference between Formulas and Functions
Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
Understand Autocomplete
Sort and filter data
Collaborate with others on a spreadsheet
Refresh and recalculate data
Format text and numbers
Use alignment options
Apply borders and fill color
Insert and work with Tables
Insert and work with Charts
Insert links

Module Two: Welcome to Office 365 Web Apps

The Home Page
The Team Site
Shared Documents
Uploading a Spreadsheet

Module Three: Worksheets and Workbooks

Opening a Spreadsheet
Overview of the Reading View
Understanding Worksheets vs. Workbooks
Downloading and Reloading
Closing Spreadsheets

Module Four: Working with Excel Files

Using the Find Command
Saving a Copy
Editing in Browser
The Excel Web App Interface
Opening in Excel

Module Five: Editing in the Browser (one)

About Saving and Save As
A New File and AutoSaving
Entering Data
Editing Data
Using the Wrap Command

Module Six: Editing in the Browser (two)

Cut, Copy, and Paste
Using Undo and Redo
Adding Rows and Columns
Deleting Cells
Using Timesaving Shortcuts

Module Seven: Building Formulas

The Math Basics of Excel
Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References

Module Eight: Understanding Functions

Formulas vs. Functions
Using the SUM Function
Using Other Basic Excel Functions
Using AutoComplete

Module Nine: Working with Data

Sorting Data
Filtering Data
About Collaborating
About Refreshing External Data

Module Ten: Formatting Your Data

Changing the Appearance of Text
Changing the Appearance of Numbers
Setting Alignment Options
Adding Borders
Adding Fill Color

Module Eleven: The Insert Tools

Inserting Tables
Inserting Charts
Working with Charts
Inserting Links

Module Twelve: Wrapping Up

Words from the Wise

Course 2 – Certificate In Excel 2010 Essentials

Module One: Getting StartedCourse Objectives

Module Two: Opening and Closing Excel

Opening Excel
Understanding the Interface
Using Backstage View
Understanding Worksheets
Understanding Workbooks

Module Three: Your First Worksheet

Entering Data
Editing Data
Using the Wrap Command
Adding Rows and Columns
Checking Your Spelling

Module Four: Working with Excel Files

Saving Files
Publishing Files to PDF
Sending Files via E-Mail
Closing Files
Opening Files

Module Five: Viewing Excel Data

An Overview of Excel’s Views
Switching Views
Creating Custom Views
Using Zoom
Switching Between Open Files

Module Six: Printing Excel Data

An Overview of the Page Layout Tab
Setting Up Your Page
Using Print Preview
Printing Data

Module Seven: Building Formulas

The Math Basics of Excel
Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References

Module Eight: Using Excel Functions

Formulas vs. Functions
Using the SUM Function
Using Other Basic Excel Functions
Understanding the Formulas Tab
Using the Status Bar to Perform Calculations
Understanding the New Function Names

Module Nine: Using Time Saving Tools

Using AutoFill
Using AutoComplete
Sorting Data
Filtering Data
Adding Sparklines

Module Ten: Formatting Your Data

Changing the Appearance of Text
Changing the Appearance of Numbers
Setting Alignment Options
Using Merge
Removing Formatting

Module Eleven: Advanced Formatting Tools

Adding Borders
Adding Fill Color
Using Cell Styles
Using Conditional Formatting
Changing the Theme

Module Twelve: Wrapping Up

Course 3 – Certificate In Excel 2010 Advanced

Module One: Getting StartedCourse 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

Course 4 – Certificate In Excel 2010 Expert

Module One: Getting StartedCourse 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

Course 5 – Certificate In Excel 2013 Essentials

Module One: Getting StartedCourse Objectives

Module Two: Opening and Closing Excel

Opening Excel
Understanding the Interface
Using Backstage View
Understanding Worksheets
Understanding Workbooks

Module Three: Your First Worksheet

Entering Data
Editing Data
Using the Wrap Command
Adding Rows and Columns
Checking Your Spelling

Module Four: Working with Excel Files

Saving Files
Publishing Files to PDF
Sending Files via E-Mail
Closing Files
Opening Files

Module Five: Viewing Excel Data

An Overview of Excel’s Views
Switching Views
Creating Custom Views
Using Zoom
Switching Between Open Files

Module Six: Printing Excel Data

An Overview of the Page Layout Tab
Setting Up Your Page
Using Print Preview
Printing Data

Module Seven: Building Formulas

The Math Basics of Excel
Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References

Module Eight: Using Excel Functions

Formulas vs. Functions
Using the SUM Function
Using Other Basic Excel Functions
Understanding the Formulas Tab
Using the Status Bar to Perform Calculations
Understanding the New Function Names

Module Nine: Using Time Saving Tools

Using AutoFill
Using AutoComplete
Sorting Data
Filtering Data
Adding Sparklines

Module Ten: Formatting Your Data

Changing the Appearance of Text
Changing the Appearance of Numbers
Setting Alignment Options
Using Merge
Removing Formatting

Module Eleven: Advanced Formatting Tools

Adding Borders
Adding Fill Color
Using Cell Styles
Using Conditional Formatting
Changing the Theme

Module Twelve: Wrapping Up

Course 6 – Certificate In Excel 2013 Advanced

Module One: Getting StartedCourse 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

Course 7 – Certificate In Excel 2013 Expert

Module One: Getting StartedCourse 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)