Photoshop Tutorial Course (Photoshop CS4)
Microsoft Word Course (2007- Introduction)
Microsoft Excel Course (2003 Introductory)
Microsoft Access Course (2007)
Microsoft Word Course (2003- Introduction)
More...



The ExpertRating Online Excel Course (MS Excel 2007-Intermediate)
(leading to ExpertRating Excel Certification-2007-Intermediate).

Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. Learn how to create
informative and eye-catching charts, as well as how to harness the power of Excel 2007's filtering techniques.

Become adept at using Excel 2007 to gain further insight into your valuable data. Find out how to create macros that eliminate repetitive tasks,
and set yourself apart from the casual Excel user by understanding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions. These practical, hands-on lessons are
guaranteed to take your Excel skills to the next level!

Buy the ExpertRating Online Excel Course (MS Excel 2007-Intermediate)- $129.99

Part I of this course is also available. Any of these courses can be bought collectively or individually for $129.99 each.

Buy Part-I of the Course

This course includes a knowledgeable and caring instructor who will guide you through your lessons, facilitate discussions, and answer your questions. The instructor for this course will be Chad Wambolt.

 

Chad Wambolt

About the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) instructor: 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.

 Online Excel Course requirements: For taking this instructor led ExpertRating Online Excel Course (MS Excel 2007-Intermediate) you need Microsoft Windows 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; Internet access, e-mail, and the Microsoft Internet Explorer or Mozilla Firefox Web browser. This course is not suitable for Macintosh users, nor for users of older versions of Microsoft Excel.

 Testimonials: The ExpertRating Online Excel Course (MS Excel 2007-Intermediate) has received overwhelming positive feedback and reviews from students around the world. Here are a few:

" Wow! I learned so much in this class. It was informative and fun at the same time. I feel confident enough now to say that I know Excel."
"This class was so much easier to comprehend than any text on the market"
"I think this is the best course I have ever taken."
"Well Done! Thorough and easy to understand."
"The explanation of the assignments were straight forward to me I think this is the best course I have ever taken."

Buy the ExpertRating Online Excel Course (MS Excel 2007-Intermediate)- $129.99

ExpertRating Online Excel Course (MS Excel 2007-Intermediate)

(leading to ExpertRating Excel Certification-2007- Intermediate)

 ExpertRating is one of the world's only ISO 9001:2008 Certified companies (from TUV America) offering an Online Excel (MS Excel 2007-Intermediate) Course (leading to ExpertRating Excel (MS Excel 2007-Intermediate) Skills Certification).

     

ExpertRating is a trusted name in online testing and certification with over 200,000 certified professionals in over 60 countries in more than 200 skill areas. ExpertRating offers its testing services to the world's best companies such as Convergys Corp, UPS, GAP, Sony, Coke, Citrix, Deltek Corp, IKEA Systems and Ericsson to name a few. See where ExpertRating Certified Professionals are working.


 It is very safe to buy from ExpertRating. Apart from being an ISO 9001:2008 certified company, it is a member of the TRUSTe and HackerSafe approved.

TRUSTe online privacy certification

ExpertRating Solutions has been reviewed by TRUSTe for compliance of their strict program requirements ensuring that your information is always safe. ExpertRating has certified Several thousand individuals who are working with leading companies across the US and other countries. View list.

When you choose the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) you can be sure that you are buying a premium International certification that is recognized by hundreds of employers and Government bodies in the US and other countries.

 

 With ExpertRating you get certified quickly online and you are equipped with a store house of information through the in-depth ExpertRating Online Excel Course (MS Excel 2007-Intermediate) Courseware which has been developed by experienced Computer Applications Experts.

 The ExpertRating Excel Certification is by far the best value for money instructor led Excel Program at $129.99.

    

*Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation.

Some Popular questions and answers about this ExpertRating Online Excel Course (MS Excel 2007-Intermediate) and certification:

 How much does the Excel Certification cost and what does it include?

You can buy this ExpertRating Online Excel Course (MS Excel 2007-Intermediate) leading to Excel certification at a special offer price of only $129.99 which includes the in-depth ExpertRating Online Excel Course (MS Excel 2007-Intermediate) Courseware and exam fee. This is the best value for money Excel Program available till date. You get the following services within the USD $129.99 fee.

 In-depth ExpertRating Online Excel Course (MS Excel 2007-Intermediate) Courseware including scenarios and case studies.

 An instructor to guide you through the course and to whom you can direct your questions.

 World wide airmail delivery of the hard copy Excel Certificate. The Excel Certificate can be used to prove your certified status and does not mention the words "online".

 An online transcript that can be used to prove your certified credentials on the internet at any time.

How do I get certified?

The process of getting yourself certified is very simple. All you have to do is buy the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) for $129.99. Log in to the instructor led course using your password. Go through the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) Courseware (which would take you 6 weeks) and complete the final Excel Certification exam at your convenience. You can complete the exam within 2 months of buying the Excel Certification. The result of the exam appears as soon as it is completed, and your Excel Certificate is mailed immediately.

What learning aids will I get?

The ExpertRating Online Excel Course (MS Excel 2007-Intermediate) includes the following learning aids:

24 x 7 hour access to the courseware. A printer friendly version of the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) is also provided

A friendly instructor to answer your questions online

A discussion area to have your questions answered

Chapter end quizzes to ensure that you are learning important aspects of every chapter

Chapter assignments to help you practically use the Excel that you will learn during the Excel Course.

What is the final exam like?

The final exam is fully based upon the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) Courseware that is provided along with the Excel Certification. If you have gone through the courseware properly you should not have a problem clearing the exam. The exam consists of multiple choice questions from all chapters of the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) Courseware.

What are the course start dates?

ExpertRating instructor led courses commence every month, you can always choose a suitable date for your course commencement in any month. To see available course start dates, please click on the "Enroll now" button. All courses run for six weeks, with a two-week grace period at the end. Two lessons are released each week for the six-week duration of the course. You do not have to be present when the lesson is released, but you must complete each lesson within two weeks of its release.

A new section of each course starts on the second or third Wednesday of each month. If enrolling in a series of two or more courses please be sure to space the start date for each course at least two months apart.

TRUSTe online privacy certification

Buy the ExpertRating Online Excel Course (MS Excel 2007-Intermediate)- $129.99

   

Microsoft Excel Course takes you a step further from the basic course and helps to trace formula precedents, dependents and errors and teaches you VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions.

Microsoft Excel is an electronic spreadsheet which can be used to arrange data in rows and columns. Microsoft Excel includes features to use advanced filters, data validation and security features such as protection, digital signatures and passwords. This application helps to speed up the process of analysis of data using single or multiple variations or conditions.

 


 

Anyone who can use formulas and charts with ease will be comfortable with Microsoft Excel as well. This application is popular with accountants as it helps them to report, sort and summarize data independent of the original data layout. The ExpertRating Excel Certification will make you adept with this application by making you understand its nuances and making you confident to use this tool.

ExpertRating Online Excel Course (MS Excel 2007-Intermediate) Coverage (6 weeks program)  

Week One

Wednesday - Lesson 01

In the first lesson, you'll discover why Excel 2007 is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So, you'll find out how to choose the right chart for telling your story, and then how to create, format, and edit your chart to help others clearly visualize that story. 
 

Friday - Lesson 02

There are so many great charting features and enhancements in Excel 2007, there's no way we could cover all of them in a single lesson. So we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well known, these options can add tremendous value to your worksheets in the right situations. Walk through a few of them step-by-step so you'll see the value for yourself.
 

Week Two

Wednesday - Lesson 03

Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In this lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

Friday - Lesson 04

Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.

Week Three

Wednesday - Lesson 05-

In this lesson, learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

Friday - Lesson 06

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart.

Week Four

Wednesday - Lesson 07

Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

Friday - Lesson 08

Back by popular demand, it's Solver! This lesson continues with our topic from the prior lesson, but this time, we'll throw in a little bit of a wrinkle. Instead of me guiding you step-by-step through a practical, hands-on experience with the Solver, I'm only going to guide you to a point because I want to help you master a tool that's as complex as it is powerful. By the end of this lesson, and mostly on your own, you'll have successfully mastered using Solver!

Week Five

Wednesday - Lesson 09

In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

Friday - Lesson 10

If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.

Week Six

Wednesday - Lesson 11

Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In This lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of Excel 2007's new functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

Friday - Lesson 12

Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. You will learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!

Buy the ExpertRating Online Excel Course (MS Excel 2007-Intermediate) - $129.99

Part I of this course is also available. Any of these courses can be bought collectively or individually for $129.99 each.

Buy Part-I of the Course

Accounting
Art, History, Psychology, & Literature
Basic Computer Literacy
Business Administration
Career Certificate Programs
Certification Prep
Child Care & Parenting
Computer Applications
Continuing Education CE Credits Courses
Courses for Teaching Professionals
Database Management & Programming
Digital Photography & Digital Video
Entertainment Industry
Grant Writing & Nonprofit Management
Graphic Design
Health Care Continuing Education
More...


HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Home  |  About Us  |  Privacy Policy  |  Site Map  |  FAQs  |  Contact Us
This site is US friendly - Hosted in the US - Payments in US Dollars - Payments received in the US through a US based payment processor.