Microsoft Office 2013 Excel I
This entry-level Excel training course is designed for students new to working with Microsoft Excel 2010. 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 2013 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 2013 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 2010. 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 2013 Access I
Students will learn the 2010 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 2013 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 2013 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 2013 Basic PowerPoint
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 2013 Advanced PowerPoint
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 2013 Word Intermediate
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 Office 2013 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.
Mcrosoft Office 2013 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.
Microsoft Office 2013 SharePoint I
Learn to work with lists and libraries, how to communicate with team members, work remotely with SharePoint content, customize your SharePoint environment, create a team site, and perform basic site administration. 1 day, 8 hours.
Microsoft Office 2013 SharePoint II
This course provides many other tools for productivity. Learn how to create a site collection. Discover how to manage lists, a discussion board, document libraries, a form library, site access permissions, WSS content, and a workflow. Learn how to work with indexing and searching, manage a SharePoint application using central administration, mange security options in WSS, manage site usage, and perform site maintenance. 1 day, 8 hours.
Microsoft Office 2013 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 Office 2013 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.