Course Description

Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as holding place for report data. You may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers. 



This course will teach you the most common advanced features of Microsoft Excel 2007. The goal of this course is to get you familiar with these functions in a safe learning environment. Once it is completed, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or at home. 

Learning Outcomes

By the end of this course, you will be able to:
•    Open and close Excel
•    Differentiate between worksheets, workbooks, rows, columns, and cells
•    Enter labels and values
•    Set up your page
•    Copy formulas
•    Use absolute referencing appropriately
•    Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
•    Use Selection Statistics
•    Format text and numbers
•    Change the workbook theme



Course Features

Request Course Information

I am interested in Microsoft Excel 2007 Advanced Course


MODULES
Module One: Getting Started
Module Two: SmartArt
Module Three: Inserting Objects
Module Four: Creating Charts
Module Five: Creating Pivot Tables
Module Six: Working with Pivot Tables
Module Seven: Creating Pivot Charts
Module Eight: Solving Formula Errors
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