Excel 2010 - Part 2

Skills covered:
This course provides material for:
Microsoft Exam code: 77-882
Certificate: Microsoft Office Specialist on Microsoft Office 2010

Overview

This course builds upon the foundational Microsoft® Office Excel® 2010 knowledge and skills you’ve already acquired and sets you on the road to creating advanced workbooks and worksheets that will deepen your firm’s business intelligence.

Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:
  • Customize the Excel environment.
  • Create advanced formulas.
  • Analyze data by using functions and conditional formatting.
  • Organize and analyze datasets and tables.
  • Visualize data by using basic charts.
  • Analyze data by using PivotTables, slicers, and PivotCharts.

Audience

This course is designed for students who already have foundational knowledge and skills in Excel 2010 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Syllabus

Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Online - Instructor Led
Duration: 1 day
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.