Course Description

You will learn how to use the advanced features of Excel 2010. This course is designed to teach you a basic understanding of Excel 2010 in a practical way. This course incorporates a hands-on approach to learning. You will get a chance to practice some of the advanced features right on a computer. 

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!

Learning Outcomes

By the end of this course, you will be able to:
•    Add text to a diagram
•    Reset a diagram
•    Understand the contextual tabs
•    Trace dependents of a cell
•    Display formulas within the sheet
•    Work with comments
•    Insert a chart
•    Resize and move a chart
•    Insert a Pivot Table
•    Use the Pivot Table Tools tab
•    Choose fields and group data in a Pivot Table
•    Change Pivot Table data and refresh the view
•    Create a Pivot Chart from a Pivot Table
•    Understand formula errors
•    Use the Scenario Manager
•    Transposing Data from rows to columns
•    Group Data
•    Add Subtotals

Course Features

Request Course Information

I am interested in Microsoft Excel 2010 Advanced Course


MODULES
Module One: Getting Started
Module Two: SmartArt and Objects
Module Three: Auditing
Module Four: Creating Charts
Module Five: Creating Pivot Tables
Module Six: Working with PivotTables and PivotCharts
Module Seven: Macros
Module Nine: Using What If Analysis
Module Ten: Managing Your Data
Module Eleven: Grouping and Outlining Data
Module Twelve: Wrapping Up

Subscribe to the Free Plan and take this course for Free for 7 days or Subscribe to any of our premium plans and access all courses

Premium One Course

$11.99

  • Unlimited Access to One Course
  • Unlimited Access to All Course Videos
  • Unlimited Access to All Course Case Studies
  • 365 Days Duration of Access
  • Download PDF Certificate
  • Access Assessments
  • Premium email support 24x7
Premium Three Courses

$29.99

  • Unlimited Access to All Three Courses
  • Unlimited Access to All Three Courses Videos
  • Unlimited Access to All Three Courses Case Studies
  • 365 Days Duration of Access
  • Download All Three Courses Certificates
  • Access Assessments
  • Premium email support 24x7
Premium Certificate Program

$49.99

  • Unlimited Access to All Certificate Courses
  • Unlimited Access to All Certificate Videos
  • Unlimited Access to All Courses Case Studies
  • 365 Days Duration of Access
  • Download All Five Courses Certificates + Main Certificate
  • Access Assessments
  • Premium email support 24x7
Premium Mini MBA

$129.99

  • Unlimited Access to All Mini MBA Courses
  • Unlimited Access to All Mini MBA Videos
  • Unlimited Access to All Mini Case Studies
  • Mini-MBA Certificate included
  • 365 Days Duration of Access
  • Download All Thirteen Courses Certificates + Mini MBA Course Certificate
  • Access Assessments
  • Premium email support 24x7

Testimonials

From the Our community