Leaders in Online Testing & Certification

About ExpertRating

ExpertRating ExpertRating is an ISO 9001-2008 certified company offering online certification and training services to individuals and companies in over 160 countries. Over 2,700,000 people in 160 countries have benefited from ExpertRating Online Certifications.

See where ExpertRating Certified Professionals are working .

ExpertRating ranks within the top 0.01% of the websites in the world in terms of traffic and popularity according to the Alexa Rankings. ExpertRating is one of the world's only ISO 9001:2008 Certified companies (from TUV America) offering an Microsoft Excel Course (2007 - Advanced) (leading to ExpertRating Microsoft Excel 2007 Skills Certification (Advanced)).

Microsoft Excel Course (2007 - Advanced)

Any proficient Microsoft Excel user will agree that MS Excel is a very powerful analytical tool. In this practical and information-packed course, you'll see how to maximize Excel's functions and capabilities.

Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. Your company is probably no exception. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead you and others to better decision-making. Over the next six weeks, you'll see how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. You'll impress your coworkers by learning how to add functional and eye-catching controls to any worksheet and how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Learn how Excel 2007 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!


Microsoft Excel Course (2007 - Advanced) Requirements:


Microsoft Office Excel 2007 (B000HCVR1M), Microsoft Office Excel Home and Student 2007(B000HCVR26), Microsoft Office Home and Student 2007 (B000HCZ8EO), Microsoft Office Standard 2007 (B000HCVR3A), Microsoft Office Professional 2007 (B000HCVR30), Microsoft Office Ultimate 2007 (B000HCTY26) are all acceptable (software must be installed and fully operational before the course begins); Microsoft Windows XP or Windows Vista; Internet access, e-mail, the Microsoft Internet Explorer or Mozilla Firefox Web browser, and the Adobe Flash and PDF plug-ins (two free and simple downloads you obtain at http://www.adobe.com/downloads by clicking Get Adobe Flash Player and Get Adobe Reader). Note: This course is not suitable for Macintosh users. Completion of the online Intermediate Microsoft Excel 2007 course or a similar course is recommended.

Microsoft Excel Course (2007 - Advanced)

  • By learning these advanced Excel techniques, you can become more valuable to your organization and excel in your career.

  • As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!


Microsoft Excel 2007 Skills Certification (Advanced)

Microsoft Excel Course (2007 - Advanced) Coverage:

 
 
     
More Online Certifications
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...