iLearn

Advanced Microsoft® Excel® 2007, Part I: Analyzing Data

Advanced Microsoft® Excel® 2007, Part I: Analyzing Data

In this Microsoft Excel tutorial for intermediate-level users, explore some of the most powerful features in Microsoft Excel for calculating and analyzing data. Learn how to write complex formulas using IF statements, work with PivotTables and add-ins, use database features such as forms and data validation, and create your own Microsoft Excel macro commands and functions with VBA.

114 Ratings

There are currently no sessions for this course.

Notify me when a new session opens.

iLearn

iLearn courses are free, practical, led by expert instructors, and available around the clock to work with your schedule.

Take A Tour

Lessons

Lesson 1: Microsoft Excel Tutorial: Advanced Excel Formulas and Functions

Don't let complex Excel functions intimidate you! In this lesson, you'll learn how to create powerful Excel formulas and functions that include logical conditions and other advanced attributes.

Lesson 2: Microsoft Excel Tutorial: Working with Data Analysis Tools

Excel provides many tools for helping you analyze numeric information. In this lesson, you'll learn about some of these tools, including Excel financial functions, goal seeking, and working with PivotTables.

Lesson 3: Microsoft Excel Tutorial: Using Excel Database Tools

Besides serving as an excellent spreadsheet tool, Excel also functions as a flat-file database program. In this lesson, you'll learn how to modify and manage database data in a worksheet and how to integrate Excel-stored data into Microsoft Access.

Lesson 4: Microsoft Excel Macro Commands and the VB Editor

Did you ever wish that Microsoft® Excel® could do something it can't or that you could accomplish certain tasks more easily? With Microsoft Excel macro commands and VBA scripts, you can extend Excel's capabilities. This lesson shows you how.

What You'll Learn

  • Write logical functions with IF statements
  • Set up conditional formatting
  • Use Boolean operators and concatenation
  • Analyze data with PivotTables
  • Install and use add-ins
  • Work with database functions, forms, and validation
  • Record and save macros

Other Courses

  • None

Take A Tour!

Learn how courses work in five quick and easy steps!

Give Us Feedback

Tell us what you think about iLearn courses.

Tell a Friend

Tell your friends about iLearn courses.

Find an Answer

Got a question about the site? Find out here.