Excel 2007 - Advanced

Take Excel to the next level with business intelligence tools such as PivotTables, Goal Seeking, Scenario Manager & more
4.8 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
157 students enrolled
$30
Take This Course
  • Lectures 37
  • Contents Video: 3.5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English

Course 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.

What are the requirements?

  • Basic Microsoft Windows and Intermediate Microsoft Excel 2007 training or equivalent experience

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
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.  

Section 2: Using Advanced Functions
Financial Functions
07:45
Logical Functions
16:04
Text Functions
14:57
Statistical and Math Functions
05:26
Lookup Functions
10:14
Section 3: Formula Auditing
Displaying Formulas
Preview
01:22
Tracing Cell Precedents and Dependents
Preview
01:23
Using the Formula Evaluator
Preview
04:05
Error Checking
Preview
01:31
Section 4: Analyzing Data
Using Subtotals
04:12
Using Goal Seek
03:15
Using the Scenario Manager
08:00
Section 5: Advanced Formatting
Understanding Custom Formats
09:22
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
Section 6: Managing Data
Planning a Database and Understanding Database Terms
10:42
Formatting and Sorting Tables
01:48
Filtering a Table
10:03
Using the Advanced Filter
11:09
Section 7: Working with PivotTables
Creating a Simple PivotTable
01:56
Using the PivotTable Field List Pane
05:31
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
Section 8: Importing and Exporting Data
Importing from Access
07:06
Importing a Text File
07:16
Managing Updates
01:44
Exporting Data
02:59
Section 9: Macros
Recording a Macro
02:43
Running a Macro
01:31
Running a Macro from a Custom Button
02:34
Section 10: Conclusion
Conclusion
01:21

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Ready to start learning?
Take This Course