Certificate In Excel 2013 Advanced Online Course

Courses For Success

Preço a consultar

Informação importante

  • Curso
  • Online
  • Quando:
    à escolha

Get Ahead with Advanced Skills 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! Learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013. At the end of this Certificate In Excel 2013 Advanced Online Course, you will be able to: Use SmartArt and other objects in worksheets Trace precedent cells and dependent cells, as well as use other auditing tools Create and work with charts Create Pivot Tables and Pivot Charts Record and run macros Solve formula errors Use What If Analysis tools Use tools to manage rows, columns, duplicates, and validation Group and outline data 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 are taught in a step by step process...

Informação importante

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


Instalações e datas

Início Localização
à escolha

O que se aprende nesse curso?

IT Auditing
MS Excel


  • 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