Course details

Microsoft® Office Excel 2007 teaches the new information worker how to work with worksheets and workbooks to analyze data using a variety of features to create, modify and format common business reports such as budgets, inventory reports, invoices, and charts. This course is designed for those people who require the skills necessary to use a spreadsheet program on a daily basis to manage and audit numerical reports.Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for a Microsoft Office Specialist Exam #77-602.

Course Prerequisites

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.The course assumes that students have completed the Microsoft Windows Level 1 course or have equivalent Microsoft Windows knowledge and experience. Students who wish to become proficient using the features of Microsoft Office Excel 2007 will benefit from taking this course.

Course Outline

About This Courseware

  • Lesson 1: Introducing Excel
  • Lesson 2: Manipulating Items
  • Lesson 3: Using Formulas
  • Lesson 4: Formatting the Worksheet
  • Lesson 5: Preparing to Print
  • Lesson 6: Working with Charts
  • Lesson 7: Using Functions
  • Lesson 8: Working with Illustrations
  • Lesson 9: Customized Charts
  • Lesson 10: Customized Formatting
  • Lesson 11: Working with Tables
  • Lesson 12: Working with Databases
  • Lesson 13: Using Data Tools
  • Lesson 14: Preparing Online
  • Lesson 15: Collaborating with Others
  • Lesson 16: Using Analysis Tools

Appendices

  • Appendix A: A Quick Review of the Basics
  • Appendix B: Apply Your Skills Exercises
  • Appendix C: Answers to Review Questions
  • Appendix D: Microsoft Office Excel 2007 Exam Objectives
  • Appendix E: Glossary of Terms
  • Appendix F: Index
Updated on 08 March, 2016

About G TEC Computer Education

we_they provides quality education in Information Technology. We focus on Programming Courses, Animation and Web Design Courses. We also provide Diploma and Post Graduate Diploma Courses.
we_they is division of Glosoft Technologies (P) Ltd, India. Glosoft is an Information Technology company in the field of Software Training, Technology resource and Knowledge Consulting. It provides solutions through application of proven platforms and adaptation of emerging technologies. Core to its offering is a solution through well documented software engineering practices, project management mile stones and quality assurance parameters for each stage of software training and development lifecycles.
See all G TEC Computer Education courses
Are you from G TEC Computer Education ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or