What is Office 365 for Business? What can it do for your organization and what are the limitations? Find out in this overview of the resources and tools in the cloud that have been designed to help organizations achieve a high level of communication, team collaboration, sharing and overall management efficiency. Topics will include Mail, SharePoint, OneDrive and Customization. This introductory overview will prepare you for the next step in the training process, regardless as to whether you are an end user, administrator, manager or developer. Discover an educational pathway that will lead you with the best solutions. Three hours.
Learn to create, edit, and print a document. Become familiar with basic Microsoft Word features. Prerequisite: Microsoft Windows. 1.2 CEUs.
Learn to create, edit, and modify spreadsheets. Basic formulas and functions will be introduced. This class moves at a quicker pace than our regular two-day classes. Prerequisite: Microsoft Windows. .6 CEUs.
Learn to create, modify, print, and format worksheets; create basic formulas and functions; create charts; and incorporate graphics in worksheets. Prerequisite: Working with Windows or equivalent. 1.2 CEUs.
Learn how to create three-dimensional formulas, display multiple workbooks, sort and filter lists using autofilter and outline data. You will also learn to create templates and how to set file protection. Prerequisite: Microsoft Excel Level 1 or equivalent. 12 hrs. 1.2 CEUs.
Learn how to use advanced features of Excel including creating tables and charts, sorting and filtering advanced formulas; analysis tools including pivot tables. This class moves at a quicker pace than our regular two-day classes. Prerequisite: Microsoft Excel Level 1 in a Day. .6 CEUs.
Learn how to import and export data. Work with advanced formulas as well as lookup functions such as VLOOKUP. Find out about data validation and database functions such as DSUM. Also, explore the analytical features of Excel such as goal seek and solver, smartart graphics, and conditional
formatting with graphics. Prerequisite: Microsoft Excel Level 2. 1.2 CEUs.
This course is intended for advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). Prerequisite: Excel Level 3. .6 CEUs.
Learn to create, edit, modify, and format documents; create tables and lists; and incorporate graphics. Prerequisite: Microsoft Windows. .6 CEUs.
Learn to add graphics and manipulate text, fonts, and styles to enhance the design layout of any project. Templates, mail merge, and macros are also covered in this course. Prerequisite: Microsoft Word Level 1. 1.2 CEUs.
In just a day, work with advanced tables, add graphics, and manipulate text and styles to enhance the design and layout of any project. Mail merge is not covered in this class. Prerequisite: Microsoft Word in a Day. .6 CEUs.
Learn advanced techniques for working with Word such as mail merge, creating forms, and writing simple macros. Use features associated with long documents such as table of contents, index, captions, table of figures, and cross references. Prerequisite: Microsoft Word Level 2. 6 hours .6 CEUs.
Create and modify presentation slides that combine text, clip art drawings, tables, charts, and graphs. Learn to run a basic PowerPoint presentation. Prerequisites: Microsoft Windows experience and basic knowledge of Microsoft Word. .6 CEUs.
Learn to build your own design template, create slides with special effects, apply audio and video files, and include hyperlinks on slides. Prerequisite: Introduction to PowerPoint or equivalent. .6 CEUs.