Certificate In Excel 2010 Expert Online Course

Courses For Success
Online

Price on request

Important information

  • Course
  • Online
  • When:
    Flexible
Description

Gain Skills to Become an Expert with Excel 2010 You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users of Excel 2010. Excel is the world's premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information, and better information leads to better decision making! By the end of this Certificate In Excel 2010 Expert Online Course, you will be able to: Mark Workbook as Final Encrypt with a Password and Restrict Permissions Protect the Current Sheet or the Workbook Structure Add a Digital Signature Set Excel Options Manage Versions Save a Workbook as an Excel Template Inspect Documents Share Workbooks Edit a Shared Workbook Track Changes Merge Copies of a Shared Workbook Use the Watch Window Set Calculation Options Enable or Disable Automatic Workbook Calculations Use the IFERROR Function to Evaluate Formulas Use Array Formulas Understand a Variety of different Functions Assign Macros to a Command Button on the Ribbon Run a Macro by Clicking an Area of a Graphic Object Configure a Macro to Run Automatically Upon Opening the Workbook Change a Macro Insert Form Controls Use a data form Use Trend Lines Add a Secondary Axis Use Chart Templates Work with PivotTable Tools Work with PivotChart Tools Use the Slicer Choose External Data Sets with the Slicer Understand the Analysis ToolPak Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your...

Important information

Requirements: 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:...

Venues

Where and when

Starts Location
Flexible
Online

What you'll learn on the course

Excel
Options
Secondary
MS Excel

Course programme

 

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