Certificate In Excel 2013 Expert Online Course

Courses For Success

Preis auf Anfrage

Wichtige informationen

  • Kurs
  • Online
  • Wann:
    Freie Auswahl

Acquire Expert Skills in Excel 2013 You will learn how to use the advanced features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013. Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making! At the end of this Certificate In Excel 2013 Expert Online Course, you will be able to: Understand permissions, versions, and Excel Options Track changes and share workbooks Perform advanced formula auditing and calculation Create arrays Create additional ways to run a macro Create a form using a variety of controls Use trend lines, secondary axes and chart templates Work with slicers in PivotTables Create and manipulate a PowerView sheet Analyze data using multiple tables 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 own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) 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...

Wichtige informationen

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


Wo und wann

Beginn Lage
Freie Auswahl

Was lernen Sie in diesem Kurs?

MS Excel


Module One: Getting Started

  • Course 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