Microsoft Excel I
This entry-level Excel training course is designed for students new to working with Microsoft Excel 2007. Students will learn to use Excel to create, modify and format worksheets, perform calculations, and print and Excel workbooks. By the end of this course students will know the Microsoft Office Excel environment, and be able to create a basic worksheet; perform calculations; modify a worksheet; format a worksheet; print workbook contents; and manage large workbooks. 1 day, 8 hours.
Microsoft Office Excel II
In this intermediate-level Excel training, will discuss and apply visual elements and advanced formulas to a worksheet to display data in various formats. Excel II covers intermediate Microsoft Excel skills. The class assumes the student has taken the Excel I class or has a comparable knowledge base of Excel. Basics will not be covered. Excel II covers the construction and processing of formulas and then moves into more complex areas. At the conclusion of the course, the student should more fully understand how to handle larger volumes of data through various Excel capabilities as well as linking workbooks and sheets together and creating charts. By the end of this course students will be able to calculate with advanced formulas; organize worksheet and table data; create and modify charts; analyze data using PivotTables and PivotCharts; insert graphic objects; and customize and enhance workbooks and the Microsoft Office Excel environment. 1 day, 8 hours.
Microsoft Office Excel III
In this advanced-level Excel training students will learn to automate common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. By the end of this course students will be able to collaborate with others using workbooks; audit worksheets; analyze data; work with multiple. There are nearly 400 functions included with Excel 2007. This course reviews a sampling of functions from most of the function categories. First, the function wizard is reviewed along with its strengths and weaknesses. Then the various functions are employed. The student works along with the instructor to learn each function. The function categories reviewed are Logical, Mathematical, Text, Date/Time, Financial, Statistical, Lookup/Reference and Information. Several exercises are employed to ensure the student understands the various functions studied. 1 day, 8 hours.
Microsoft Office Access I
Students will learn the 2007 Access interface, including the Ribbon and the Quick Access toolbar. Upon completion students will be able to design and build a simple database; work with data in tables; and create basic queries, forms and reports. 1 day, 8 hours.
Microsoft Office Access II
This intermediate Access course will cover topics such as controlling data entry, joining tables, creating action and parameter queries, improving forms, customizing reports, and sharing data with other applications such as Excel and Word. 1 day, 8 hours.
Microsoft Office Access III
Students will learn data importing, linking, and exporting features of Microsoft Access. By the end of this course students will be able to transfer data to and get data from external data sources such as other Access databases, Excel spreadsheets, flat text files, Outlook and the Web. Students will also learn advanced concepts in integrating Microsoft SQL databases in Access Projects. 1 day, 8 hours.
Microsoft Office Outlook
This course provides students with the skills needed to effectively use the integrated features of the Microsoft Office Outlook communications management application. Students will learn to compose and send email, schedule appointments and meetings, manage contact information and tasks, use notes, customize the Outlook environment, Calendar, mail, and folders. By the end of this course students will be able to personalize email, organize Outlook items, manage Outlook data files, share and link contacts, save and archive email, create forms, and work offline and remotely. 1 day, 8 hours.
Microsoft Office PowerPoint I
This overview class on Microsoft’s presentation application will introduce the PowerPoint interface, including Menus, Toolbars, Rulers and Views. Students will learn how to create new presentations, work with Outlines, Rearrange and delete slides, use slides from other presentations, and format slides and text. 1 day, 8 hours.
Microsoft Office PowerPoint I
This advanced level course will discuss PowerPoint’s drawing tools; Drawing objects; AutoShapes, Working with text in objects. Students will also learn techniques in using tables and charts; Working with tables, Creating and modifying charts, Creating organization charts. By the end of the course, students will be able to insert and embed objects; work with WordArt, add clip art, embed graphics and pictures; modify presentations using templates, work with the slide master; create transitions and timings, add speaker notes and footers, and set up and execute slide shows. 1 day 8 hours.
Microsoft Office Word I
This entry-level course on Microsoft’s ubiquitous word processing application will discuss how to create real-world documents including letters, memos, faxes, basic flyers, and basic newsletters. Upon successful completion of this course, participants will be able to: navigate the Microsoft Word interface; Open, save and close documents; Create a new document; Select and work with text in a document; Format text in a document; Create and use tabs, stops and leaders; Create tables of figures and text, and use the help system. 1 day, 8 hours.
Microsoft Office Word II
This course extends the learner’s basic skills and knowledge of Microsoft Word and helps them create more intricate and varied documents. Students will gain in-depth knowledge on key topics such as formatting, tables, and lists, and new features such as merging, envelopes, sections, clip art and graphics are introduced. Upon successful completion of this course, participants will be able to: Set Word options; Work with multiple, concurrent documents; use advanced formatting features; Use tabs, and work with bulleted and numbered lists; Create enhanced tables; Use timesaving features such as Building Blocks, styles and templates; create section and page breaks; Create headers and footers; Create letters, envelopes and labels; Perform mail merges; and Incorporate pictures, drawings and WordArt into documents. 1 day, 8 hours.
Microsoft Project - Advanced Topics
This course will discuss advanced topics in Microsoft Project including: entering task progress information; rescheduling a task; filtering tasks in a project plan; creating custom tables; hyper-linking tasks to external documents; creating custom reports; creating a project plan template to use in other projects; sharing resources between projects; and creating a master project plan to consolidate multiple projects. 1 day, 8 hours.
Microsoft Project I
This introduces Microsoft Project for managing projects. Students will learn aspects of dealing with tasks and resources. Upon successful completion of this course, participants will be able to: navigate Microsoft Project’s user interface and work with key features; create a new project file; enter and work with tasks, task duration, and task relationships; create and work with resource pools; understand resource assignment concepts; assign resources to tasks; level resources; enter costs into a project; set constraints and deadlines; monitor and track process and print summary information. 1 day, 8 hours.
Microsoft Project II
This course builds on skills learned in Microsoft Project I. Upon completion of this course students will be able to: create a complete project plan, and enter actual progress information; exchange project plan information with other applications; import a task list from an Excel file into a project plan; export project plan cost data into Excel, and save project plan information as a Web page. 1 day, 8 hours.
Microsoft Visio I
Diagrams and charts play a pivotal role in knowledge dissemination, making complex data easy to creating pictorial representations of information. In this course, you will learn the essentials of Visio. Course Objective: You will design and manage basic diagrams, workflows, and flowcharts. Target Student: This course is designed for persons who have an understanding of basic workflows and the concept of end-to-end flowcharting. 1 day, 8 hours.
Microsoft Visio II
Students will learn advanced Visio diagramming techniques including: custom shapes and stencils; advanced custom properties; drawings and data, creating custom reports, linking to data sources, layers and layering; assigning shapes to layers and creating new layers; creating multipage diagrams; and adding Visio diagrams to slideshows and other documents. 1 day, 8 hours.