Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Courses Computer Applications Microsoft Intermediate Microsoft Excel 2007
Return to Microsoft
intermediate-excel-courses-2007

Intermediate Microsoft Excel 2007

Take your Excel skills to the next level! Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. In this practical, hands-on course, you'll learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007's filtering techniques. 

In these hands-on lessons, you'll see how Excel 2007 can give you further insight into your valuable data. And by learning how to create macros that eliminate repetitive tasks, you'll earn your coworkers admiration and gratitude. With your macro knowledge, you'll be able to manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by learning how to use Excel's time-saving functions. So get ready for six weeks that will make you an Excel expert!

6 Weeks / 24 Course Hrs
Starting October 18, 2017

Offered in Partnership with your Preferred School

Los Angeles Valley College Why this school? It's been chosen based on your location or if you've visited this school's website.

Change School

Learning Method

Instructor-led Confirm your Start Date in Cart

Intermediate Microsoft Excel 2007

Learning Method

Instructor-led Confirm your Start Date in Cart

Intermediate Microsoft Excel 2007 Reviews

Intermediate Microsoft Excel 2007 Details + Objective

Course Code: nx7

You Will Learn
  • Master charting and PivotTables, and other advance features of Microsoft Excel 2007
  • Learn to create useful and eye-catching charts
  • Discover how to manipulate data with the push of a button
  • Add the time-saving functions of advanced Excel users to your repertoire
How the course is taught
  • Instructor-led course
  • 6 weeks in duration
  • Courses begin each mont
  • 2 lessons released each week
  • 24 course hours
How you will benefit
  • Take your Excel 2007 skills to an expert level and become a more productive member of your organization
  • Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
  • Learn to fully harness the power of Microsoft Excel 2007 and use all of its capabilities to save time and money
Intermediate Microsoft Excel 2007 Outline
Expand All
Week 1

Find out how to choose the right chart for telling your story with numbers, and then how to create, format, and edit your chart to help others clearly visualize that story. Then, explore some of Excel’s lesser known charting options and how they can add tremendous value to your worksheets in the right situations.

Week 2

Learn how to use Auto Filter to limit your table information to just the records you want. Then, you’ll learn how to use Goal Seek to display the information you need when your formula isn’t returning the answers you want.

Week 3

Practice creating a PivotTable and discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. Then, you’ll move on to more advanced Pivot Table features including how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart.

Week 4

Learn how to use and master Solver to solve a complex problem based on the criteria and constraints we provide it in hands-on exercises.

Week 5

Find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them.

Week 6

Dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category, specifically the SUMIF and COUNTIF functions. Finally, learn how to use the extremely popular VLOOKUP function as well as INDEX and MATCH functions.

View All Sections
Intermediate Microsoft Excel 2007 Instructors
Chad Wambolt

Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales ranging from $500 million to $3 billion. Through the course of his career, Chad has become an expert user of Microsoft Excel. His knowledge of Excel's capabilities has helped organizations streamline processes and save countless hours of labor. Chad has taught Excel to students of varying skill levels since 1997.

Intermediate Microsoft Excel 2007 Requirements / Prerequisites

There are no prerequisites for this course.

Microsoft Windows 8, Microsoft Windows 7, Vista, or XP, Microsoft Excel 2007 or Microsoft Excel Home and Student 2007 or Microsoft Office 2007 (the Home and Student Edition or Standard Edition of Microsoft Office 2007 are all acceptable). Please be sure to install the software on your computer before the course begins.

This course is not suitable for Macintosh users, nor for users of older versions of Microsoft Excel.

Note: "Starter Version" and "Web App" versions of Microsoft Excel 2010 will not work with the full version of Excel taught in this course.

Intermediate Microsoft Excel 2007 Frequently Asked Questions
Expand All
When can I get started?

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work?

Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

How long do I have to complete each lesson?

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

What if I need an extension?

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Browse All