Microsoft Office and Basic End User Training

ACTT Hawaii is one of the leading training companies in Honolulu Hawaii for Microsoft Office Application Training. Providing focused, hands on practice using Excel, Word, PowerPoint, Access, Outlook and Project applications in a instructor-led classroom setting.

Word

Link to recorded videos here -

Microsoft Office Word Basic
Microsoft Office Word Intermediate

Basic
In Microsoft Word 2010 or 2013 Basic, students will cover the basic functions and features of Word 2010 or 2013, this includes learning how to enter and edit text, and save and browse documents. Students will learn how to enhance the appearance of a document by using various formatting options and will be able to create tables, insert headers and footers, proof and print documents, and insert graphics.

Click for Course Outline

Intermediate
Building on concepts from Microsoft Word 2010 or 2013 basic, Microsoft Word 2010 or 2013 Intermediate teaches students to work with styles, sections, and columns. Students will learn to format tables, print labels and envelopes, and work with graphics. They will also use document templates, manage document revisions, and work with Web features.

Click for Course Outline

Advanced
In the advanced course for Microsoft Word 2010 or 2013, students will learn to perform mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. They will also create macros, customize the Quick Access toolbar and keyboard shortcuts, and work with XML documents.

Click for Course Outline


Excel

Link to recorded videos here -

Microsoft Office Excel Basic
Microsoft Office Excel Intermediate

Basic
The basic course covers an introduction to spreadsheet terminology and Excel?s window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.

Click for Course Outline

Intermediate
The intermediate course will cover topics such as using multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. The student will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Students will save workbooks as Web pages, and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates.

Click for Course Outline

Advanced
In the advanced course students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.

Click for Course Outline


Powerpoint

Link to recorded videos here - Microsoft Office PowerPoint Basic

Basic
The basic course teaches each student to create new presentations that include text, graphics, WordArt, tables, charts, and diagrams. They will also edit and format slide content, and apply transition effects.

Click for Course Outline

Advanced
The advanced Students will customize PowerPoint by modifying the Quick Access Toolbar and creating macros. They will also apply themes and templates, and they will work with SmartArt graphics and tables. Students will add multimedia content and interactive elements to slides, and they will learn about presentation distribution options including PDF and HTML. Finally, students will integrate PowerPoint with Word and Excel.

Click for Course Outline


Outlook

Basic
Students enrolling in these courses will learn creating and revising business documents using Outlook. It is also intended for persons desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Outlook.

Students will be able to change formatting, add attachments, check spelling and grammar, and add voting buttons to messages. Send a message to single and multiple users, open and save message attachments, print, forward, reply to, mark as unread, and delete messages. Schedule, edit, delete, and restore individual and recurring appointments and events. Also print preview the calendar, schedule and reserve meeting resources, reply to, update, and propose new meeting times, track responses and attendee status, and cancel a meeting. Add, edit, sort and find contacts. Create, edit, delete, and mark tasks as complete and display a task list. Create and rearrange personal folders and subfolders, sort and move messages between folders, and search for messages. Create, display, resize assigned contacts and categories to notes.

Click for Course Outline

Intermediate
Students enrolling in these courses will learn creating and revising business documents using Outlook. It is also intended for persons desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Outlook.

Students will be able to work with Contact data to import information, to perform a mail merge, and to map an address, use MSN Messenger to send and respond to an instant message, as well as access a newsgroup to view messages, use Outlook's Journal tool to record, create, and open journal entries, configure a dialup connection, add an account, and set global security options, interact with the Internet to share free/busy calendar information, schedule an online meeting, add a Web page shortcut, create a folder home page, and insert a hyperlink in an email message, learn the necessary steps involved to work either offline or remotely, including creating an offline folder, synchronizing offline folders, configuring startup options, and downloading messages, create, save, and test a custom form.

Click for Course Outline

Advanced
Students enrolling in these courses will learn creating and revising business documents using Outlook. It is also intended for persons desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Outlook.

Students will be able to work with Contact data to import information, to perform a mail merge, and to map an address, use MSN Messenger to send and respond to an instant message, as well as access a newsgroup to view messages, use Outlook's Journal tool to record, create, and open journal entries, configure a dialup connection, add an account, and set global security options, interact with the Internet to share free/busy calendar information, schedule an online meeting, add a Web page shortcut, create a folder home page, and insert a hyperlink in an email message, learn the necessary steps involved to work either offline or remotely, including creating an offline folder, synchronizing offline folders, configuring startup options, and downloading messages, create, save, and test a custom form.

Click for Course Outline


Access

Basic
Students enrolling in these courses will learn creating and revising business documents using Access. It is also intended for persons desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Access.

This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills needed to get started creating databases in Access and working with the data by using tables, queries, forms, and reports. Almost all users of Access need to create queries, forms, or reports, and this course will get you started.

Click for Course Outline

Intermediate
Students enrolling in these courses will learn creating and revising business documents using Access. It is also intended for persons desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Access.

This course builds on the skills and concepts taught in Access 2010 or 2013: Basic. Students will learn how to normalize data work with Lookup fields and subdatasheets create join queries add objects to forms, print reports and labels create charts and use PivotTables and PivotCharts.

Click for Course Outline

Advanced
Students enrolling in these courses will learn creating and revising business documents using Access. It is also intended for persons desiring to prepare to be a certified Microsoft Office Specialist (MOS) in Access.

Students will be able to put existing data into correctly designed tables and compact the database, use a variety of techniques to summarize data, create and revise basic Access macros, create macros that require data entry in certain fields and automate data entry in others, use advanced features to enhance forms, reports and distribute a report to non-Access users, use Office Links to use Access data in other Office programs.

Click for Course Outline


Introduction to Computers

Link to recorded videos here - Introduction to Computers

The Introduction to Computers course is designed to take an individual with little to no computer experience and give them the confidence to set up, navigate, and do other useful day-to-day activities on their personal computer.

Exercises include learning how to properly set up a computer, the parts of the computers and their functions, and how to operate a mouse.

Students will study the basics of the Windows operating system and the basics of internet use.


Introduction to Windows

Link to recorded videos here - Introduction to Windows 7

Introduction to Windows offers an overview of one of the most popular operating systems.

Students will learn to identify and open objects on the desktop, utilize the Help and Support Center, navigate and manage folders using My Computer and Window Explorer.

Other exercises include managing the Recycle Bin, creating simple word processing documents and drawings using the Control Panel, browsing the Internet, using Internet Explorer, and proper power down.


Keyboarding

Typing/Week 1 - Home Keys
In Section A, students will learn the basic computer keyboard layout, practice use of the home keys, and perform exercises and drills designed to increase keyboarding skills. Students will be monitored and tested on the use of proper techniques and knowledge of the keyboard.

Typing/Week 2 - Accuracy and Speed
In Section B, students will participate in speed and accuracy drills as well as timed typing. Students will also explore business and personal letter styles, form letters and basic formatting techniques.