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.
* Unit 1: Organizing and Analyzing Data
* Unit 2: Formatting Data and Content
* Unit 3: Collaborating
* Unit 4: Managing Data and Workbooks
* Unit 5: Customizing Excel
The Kilroy's College Microsoft Office Specialist (MOS) course is ideal for people wanting to develop the basic desktop skills they've learnt from day to day work.
The course is aimed at people looking to improve these vital skills as a general introduction to the world of IT, or for people who have specific computer requirements and want to use them more effectively as part of their current job. 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.