Home > Courses > Microsoft > Office Productivity > Excel 2007 - Advanced
   4.7  30 reviews on Udemy

Excel 2007 - Advanced

Take Excel to the next level with business intelligence tools such as PivotTables, Goal Seeking, Scenario Manager & more
Course from Udemy
 244 students enrolled
 en
Use key advanced financial, logical, text, statistical and math, and lookup functions
Audit formulas for errors
Analyze data using subtotals, goal seek and the scenario manager
Use custom and conditional formatting
Manage data with tables, filtering and sorting
Create, use, edit and format PivotTables and PivotCharts
Import and export date to and from a workbook
Create and use macros

This course builds on knowledge gained in the Introduction and   Intermediate courses.  In Advanced Microsoft Office Excel 2007, you   learn how to analyze and manage your data.  You will explore the many   data analysis tools available in Excel, such as formula auditing, goal   seek, Scenario Manager and subtotals. Additionally, during this course   you will use advanced functions, learn how to apply conditional   formatting, filter and manage your data lists, create and manipulate   PivotTables and PivotCharts and record basic macros.



This IAAP-certified counts for 3 recertification points for the CAP certification under the Technology and Information Distribution content area.

Email [email protected] with proof of completion of the course to obtain your certificate.

Excel 2007 - Advanced
$ 39.99
per course
Also check at

FAQs About "Excel 2007 - Advanced"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

CONTACT

[email protected]

SOCIAL NETWORK

Copyright © Elektev
Privacy Policy