After completion of the Business Applications or Microsoft Office program, Advanced Office is for those who want to take their skills to a higher level. The objective is to give students skills that would fit a fast paced office environment where knowing Word and Excel at a higher level would offer a more competitive edge over their colleagues and/or job search competition. This program is also for those who already have an intermediate level of knowledge with Word and Excel. Also, the important component to a business environment is proficiency in many of the applications used in businesses today. Extensive knowledge in Microsoft Word compliment any resumé. This program is designed to promote job placement and can also be for entry level to higher level jobs. An evaluation of your current skills would be necessary to determine if you are ready for the Advanced course. It may be recommended to take the Microsoft Office or Business Applications course first so you will be well prepared for the Advanced course.
Course Length: 24 hrs (approx. 2 weeks) – All classes are 4 hours with a 15 minute break.
Advanced Word 1
In this segment, the student will learn to use the highlighter tool, track changes review changes from others, send emails directly from Word, review changes and compare documents. Students will use file compatibility features, check documents with the document inspector, restrict formatting and editing as well as secure documents with or without passwords and mark as final
Advanced Word 2
Students will learn to customize Word to work the way we do. In the Word Options menu, we will learn to navigate, create and customize shortcuts and properties as well as create and run macros.
Advanced Excel 1
Students will learn to manage data using a table, create custom filters in the table, rename a table and use structured references in a formula. Students will also create financial functions such as NPER and PMT and create one & two variable data tables. Students will also use What-if analysis tools to create scenarios and adjust input values using goal seek.
Advanced Excel 2
We will show students how to create Pivot Tables and Pivot Charts, modify and format them as well as insert a slicer to filter a Pivot Table. Students will also learn to create a calculated field.
Advanced Excel 3
Students will learn to easily and quickly navigate lengthy spreadsheets by using the Find & Go To features, hyperlinks and insert comments as well as add alt text to objects. Students will also learn about inspecting documents, protect workbook and encrypt with a password and how to inspect your workbooks for accessibility and compatibility.
Integrating Microsoft Office Applications
Each product in the Microsoft Office Suite is designed to work in sync with each other. In this class, students will get a better understanding of how to do this to enhance productivity and make multitasking easy using examples such as creating a table in Word and import it into Excel or create a chart in Excel and display it in Word or PowerPoint.