Contact Us  
  Site Map  
  Corporate Solutions  
  Blog  
  Home  
CommLab University CommLab University
MS-Excel 2007 McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Click to View Demo
Share

The Excel application is used extensively in different work places including businesses, educational institutions, etc. to maintain and systematize data. Some uses for Excel include organizing phone numbers, tracking financial projections, creating invoice templates, tracking inventory control and so on.

This course is designed help you understand its new feature, "Ribbon", and explain its various options. It also elaborates the features in Office Button and demonstrates the method of working with different features like Excel formulae, Charts, Printing and Conditional Formatting. It also focuses on important topics such as Data Validation, Goal Seek and Scenario Manager.

Course Duration: : Approximately 120 minutes.

Learning Outcomes:

On completion of this course, the learner will be able to:

  • Understand the various features of Office Button
  • Navigate the features in "Ribbon"
  • Manipulate the Quick Access Toolbar
  • Format a worksheet
  • Create and modify charts in worksheets
  • Design the layout of Pivot Chart tables
  • Set Data Validation rules
  • Create a scenario

Pre-requisites:

  • You don't need to have any prior knowledge of MS Excel 2007. A basic working knowledge of computers should suffice.

Methodology:

These exercises are designed to impart relevant skills and knowledge by simulating the actual software environment.

  1. First show the operations.
  2. Invite the learner to try to perform the required operations with some guidance.
  3. Finally, allow him/her to try the operations all by himself/herself.

This provides a smooth transition in learning-from watching, then trying and finally, doing.

Price: USD 25.00  |  
Share
Free Courses Free Courses
Webinars and freebees Webinars and
freebees
Career Enhancement Tools Career Enhancement
Tools
Management
Sales & Marketing
Learn More
Lean Manufacturing
Learn More
Compliance
Learn More
Investment
Learn More
Information Techonology
Mastering Authoring Tools
Learn More
MS-Office Tutorials
Learn More
Personal Development
Business Writing
Learn More
Commlab University  |  MS-Office Tutorials  |  MS Excel 2007
Solution Graphics
  McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
 About Us Privacy Policy Blog Contact Us Site Map