Excel 2007 - Advanced
4.7 (29 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
239 students enrolled

Excel 2007 - Advanced

Take Excel to the next level with business intelligence tools such as PivotTables, Goal Seeking, Scenario Manager & more
4.7 (29 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
239 students enrolled
Last updated 3/2020
English
English [Auto]
Current price: $23.99 Original price: $39.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • Basic Microsoft Windows and Intermediate Microsoft Excel 2007 training or equivalent experience
Description

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 info@intellezy.com with proof of completion of the course to obtain your certificate.

Who this course is for:
  • Students who understand the basics of Excel formulas, functions and data collection and are now ready to expand their skills and learn to use tools for gleening information from their data
Course content
Expand all 37 lectures 03:12:42
+ Introduction
1 lecture 01:41

If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.  

Preview 01:41
+ Using Advanced Functions
5 lectures 54:25
Financial Functions
07:44
Logical Functions
16:04
Text Functions
14:57
Statistical and Math Functions
05:26
Lookup Functions
10:14
+ Analyzing Data
3 lectures 15:26
Using Subtotals
04:11
Using Goal Seek
03:15
Using the Scenario Manager
08:00
+ Advanced Formatting
5 lectures 25:53
Understanding Custom Formats
09:21
Applying a Custom Format
03:44
Using Conditional Formatting
02:58
Adding Data Bars, Color Scales, and Icon Sets
04:36
Managing Formatting Rules
05:14
+ Managing Data
4 lectures 30:24
Planning a Database and Understanding Database Terms
10:41
Formatting and Sorting Tables
01:48
Filtering a Table
10:03
Using the Advanced Filter
07:52
+ Working with PivotTables
7 lectures 29:19
Creating a Simple PivotTable
01:56
Using the PivotTable Field List Pane
05:30
Working with PivotTable Options
05:44
Sorting in a PivotTable
06:03
Formatting a PivotTable
02:37
Creating a PivotChart
05:15
Formatting a PivotChart
02:14
+ Importing and Exporting Data
4 lectures 19:05
Importing from Access
07:06
Importing a Text File
07:16
Managing Updates
01:44
Exporting Data
02:59
+ Macros
3 lectures 06:48
Recording a Macro
02:43
Running a Macro
01:31
Running a Macro from a Custom Button
02:34