Microsoft Excel

Overview

This course covers the Excel interface and navigation, how to create and format worksheets. Topics such as creating formulas, copying, inserting and deleting a range of cells are covered in the course. Students learn how to work with worksheets in Excel, and how to manage display properties, advanced calculation techniques and worksheet data manipulation. The Outline and Web Integration section covers outlining worksheets and publishing a workbook as a Web page. The Charts and Drawing Objects section teaches creating and modifying a chart and drawing objects. The course teaches template and database integration, shared workbooks, consolidating data across workbooks, Data Analysis and Automation, data importing and querying, pivot tables, macros, and data analysis tools.

Course Contents

Remember, You can complete this Microsoft Excel course within 6 to 9 months of enrolling. So take your first step by contacting us today !

Detailed Content

Unit 1: Organizing and Analyzing Data

• Use subtotals
• Define and apply advanced filters
• Group and outline data
• Use data validation
• Create and modify list ranges
• Add, show, close, edit, merge, and summarize scenarios
• Perform data analysis using automated tools
• Create PivotTable and PivotChart reports
• Use Lookup and Reference functions
• Use Database functions
• Trace formula precedents, dependents, and errors
• Locate invalid data and formulas
• Watch and evaluate formulas
• Define, modify, and use named ranges
• Structure workbooks using XML

Unit 2: Formatting Data and Content

• Create and modify custom data formats
• Use conditional formatting
• Format and resize graphics
• Format charts and diagrams

Unit 3: Collaborating

• Protect cells, worksheets, and workbooks
• Apply workbook security settings
• Share workbooks
• Merge workbooks
• Track, accept, and reject changes to workbooks

Unit 4: Managing Data and Workbooks

• Import data to Excel
• Export data from Excel
• Publish and edit Web worksheets and workbooks
• Create and edit templates
• Consolidate data
• Define and modify workbook properties

Unit 5: Customizing Excel

• Customize toolbars and menus
• Create, edit, and run macros
• Modify Excel default settings

Frequently asked questions

Right away if you wish! This is the great advantage of home study.

The minimum system spec required to run any of our CD-ROMs is: A PC with Microsoft Windows 98 or later. For audio, a sound card with speakers or headphones.

Earning Microsoft Office Specialist(MOS) certification acknowledges that you have the expertise to work with Microsoft Office programs. Office Specialist certification sets you apart in today's competitive job market, bringing employment opportunities, greater earning potential and career advancement, in addition to increased job satisfaction.

Our course involves 15 to 20 hours learning time, depending on previous knowledge, and is designed to equip you with the right skills to perform real work. This preparation course is provided on our unique Skill Builder software which tailors each course to your individual needs. On all our NETg SkillBuilder courses, you can begin by doing a short skills assessment (called a Pre-assessment) which will give you a clearer idea of what you already know. The courseware will then create a learning path tailored to your own needs so you can spend time only on those areas that you have not yet mastered.

Office Specialist exams are administered at authorised testing centres.

Delivery Method:
1. CBT

Duration: 6 to 9 months