May
23
Wed
Microsoft Word 2016 – Level 2 @ Capitol Computers Training Center
May 23 @ 9:00 am – 4:00 pm
Microsoft Word 2016 - Level 2 @ Capitol Computers Training Center | Augusta | Maine | United States

Word 2016 Level 2

Days of Training: 1

Word 2016 Level 2 provides the concepts and skills to use some more advanced features of Microsoft Word 2016, including enhanced formatting, character and paragraph styles, references, editing, and sharing, and saving to various formats. Students will benefit most from this course if they want to accomplish advanced workplace tasks in Word 2016, or if they want to have a solid foundation for continuing on to become a Word Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Word, this course provides and important part of their preparation, but they should also complete the other courses in the series to be fully prepared for either exam.

The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows and the basics of Microsoft Word.

Chapter 1: Shapes, WordArt, and SmartArt

  • Module A: Shapes and text
  • Module B: SmartArt

Chapter 2: Managing documents

  • Module A: Custom themes
  • Module B: Building blocks
  • Module C: Section breaks
  • Module D: Page backgrounds

Chapter 3: Styles

  • Module A: Character styles
  • Module B: Paragraph styles

Chapter 4: References and hyperlinks

  • Module A: Reference notes
  • Module B: Table of contents
  • Module C: Hyperlinks

Chapter 5: Navigation and organization

  • Module A: Navigating documents
  • Module B: Master documents

Chapter 6: Saving and sharing documents

  • Module A: Saving and sending
  • Module B: Comments
  • Module C: Protecting documents
May
28
Mon
No Classes Available
May 28 all-day
No Classes Available

No Classes Available

May
30
Wed
Microsoft Word 2016 – Level 3 @ Capitol Computers Training Center
May 30 @ 9:00 am – 4:00 pm
Microsoft Word 2016 - Level 3 @ Capitol Computers Training Center | Augusta | Maine | United States

Word 2016 Level 3

Days of Training: 1

Word 2016 Level 3 covers advanced skills for Microsoft Word 2016 power users: advanced formatting features, document management, references, data fields and sources, macros, and forms. Students will benefit most from this course if they want to build on fundamental Word skills to become a power user, or if they want to have a solid foundation in Word’s advanced features before continuing on to more complex document management or VBA programming topics. If they intend to take a MOS Expert exam for Word, this course will teach them the necessary skills, but they will need to complete the first two courses in this series to successfully complete the Microsoft Office Specialist exam.

This course assumes that students have completed Word 2016 Level 2 or have equivalent knowledge in the core skills of using Microsoft Word 2016.

Chapter 1: Advanced formatting

  • Module A: Tables and charts
  • Module B: Creating building blocks
  • Module C: Linking text

Chapter 2: Advanced document management

  • Module A: Configuring Word options
  • Module B: Working with templates
  • Module C: Tracking and reviewing changes

Chapter 3: Using references

  • Module A: Internal references
  • Module B: Indexing
  • Module C: Citing external sources

Chapter 4: Creating mailings

  • Module A: Recipient lists
  • Module B: Performing mail merges
  • Module C: Envelopes and labels

Chapter 5: Macros and forms

  • Module A: Macros
  • Module B: Forms
Jun
1
Fri
No Classes Available
Jun 1 all-day
No Classes Available

No Classes Available

Jun
4
Mon
Microsoft Outlook 2016 – Level 1 @ Capitol Computers Training Center
Jun 4 @ 9:00 am – 4:00 pm
Microsoft Outlook 2016 - Level 1 @ Capitol Computers Training Center | Augusta | Maine | United States

Outlook 2016 Level 1

Days of Training: 1

Outlook 2016 Level 1 provides the basic concepts and skills to be productive with Microsoft Outlook 2016: how to communicate via email messages, organize your contacts, and arrange your schedule. You will benefit most from this course if you want to accomplish basic workplace tasks in Outlook 2016, or if you want to have a solid foundation for continuing on to become an Outlook expert. If you intend to take a Microsoft Office Specialist exam for Outlook, this course is a good place to start your preparation, but you will need to take both courses in the series to be fully prepared for the exam.

The course assumes you know how to use a computer and that you’re familiar with Microsoft Windows. It does not assume that you’ve used a different version of Outlook or a similar desktop application before.

Chapter 1: Fundamentals

  • Module A: Getting around
  • Module B: Viewing Outlook items

Chapter 2: Email basics

  • Module A: Creating messages
  • Module B: Acting on messages
  • Module C: Adding content
  • Module D: Signatures

Chapter 3: Contacts

  • Module A: Managing contacts
  • Module B: Using contact groups
  • Module C: Using the People pane

Chapter 4: Tasks

  • Module A: Creating tasks
  • Module B: Managing tasks
  • Module C: Assigning tasks

Chapter 5: Scheduling

  • Module A: Appointments
  • Module B: Meetings
  • Module C: Using the calendar

Chapter 6: Customization

  • Module A: Customizing the ribbon
  • Module B: Customizing Outlook
Jun
5
Tue
Microsoft Excel 2016 – Level 1 @ Capitol Computers Training Center
Jun 5 @ 9:00 am – 4:00 pm
Microsoft Excel 2016 - Level 1 @ Capitol Computers Training Center | Augusta | Maine | United States

Excel 2016 Level 1
Days of Training: 1

Excel 2016 Level 1 provides the basic concepts and skills to start being productive with Microsoft Excel 2010: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel 2016, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course is a good place to start their preparation, but they will need to continue on to other courses in the series to be fully prepared for either exam.

The course assumes students know how to use a computer, and that they’re familiar with Microsoft Windows. It does not assume that they’ve used a different version of Excel or another spreadsheet program before.

Chapter 1: Fundamentals

  • Module A: Getting around
  • Module B: Workbook basics

Chapter 2: Creating worksheets

  • Module A: Entering data
  • Module B: Formulas
  • Module C: Functions
  • Module D: Moving and copying data
  • Module E: Reference types

Chapter 3: Formatting

  • Module A: Text formatting
  • Module B: Number formatting
  • Module C: Alignment
  • Module D: Borders and highlighting
  • Module E: Styles and themes

Chapter 4: Manipulating data

  • Module A: Data entry shortcuts
  • Module B: Paste options
  • Module C: Inserting, deleting, and hiding

Chapter 5: Charts

  • Module A: Creating charts
  • Module B: Chart types and elements

Chapter 6: Output

  • Module A: Managing worksheet windows
  • Module B: Printing worksheets
  • Module C: Sharing workbooks

Chapter 7: Settings and templates

  • Module A: Workbook options and properties
  • Module B: Templates
Jun
7
Thu
Microsoft PowerPoint 2016 – Level 1 @ Capitol Computers Training Center
Jun 7 @ 9:00 am – 4:00 pm
Microsoft PowerPoint 2016 - Level 1 @ Capitol Computers Training Center | Augusta | Maine | United States

PowerPoint 2016 Level 1

Days of Training: 1

PowerPoint 2016 Level 1 provides the basic concepts and skills that you need to start being productive with Microsoft PowerPoint 2016: How to create, navigate, format, and customize PowerPoint presentations. You will benefit most from this course if you want to accomplish basic workplace tasks in PowerPoint 2016, or if you want to have a solid foundation for continuing on to master PowerPoint. If you intend to take a Microsoft Office exam for PowerPoint, this course is a good place to start your preparation, but you will also need to complete the Level 2 course to be fully prepared for either exam.

The course assumes you know how to use a computer, and that you’re familiar with Microsoft Windows. It does not assume that you’ve used a different version of PowerPoint or any other presentation program before.

Chapter 1: Fundamentals

  • Module A: Exploring the PowerPoint environment

Chapter 2: Creating a presentation

  • Module A: Creating a presentation
  • Module B: Creating and modifying slide content

Chapter 3: Formatting

  • Module A: Working with slide masters and layouts
  • Module B: Formatting slides and text

Chapter 4: Working with shapes and images

  • Module A: Creating and formatting shapes
  • Module B: Working with images

Chapter 5: Working with charts and tables

  • Module A: Working with charts
  • Module B: Working with tables

Chapter 6: Customization

  • Module A: Slide transitions
  • Module B: Additional text options
  • Module C: Printing
Jun
8
Fri
Microsoft Word 2016 – Level 1 @ Capitol Computers Training Center
Jun 8 @ 9:00 am – 4:00 pm
Microsoft Word 2016 - Level 1 @ Capitol Computers Training Center | Augusta | Maine | United States

Word 2016 Level 1

Days of Training: 1

Word 2016 Level 1 Provides the basic concepts and skills to start being productive with Microsoft Word 2016: how to create, format, and set up a document, and how to add graphics and tables. Students will benefit most from this course if they want to accomplish basic workplace tasks in Word 2016, or if they want to have a solid foundation for continuing on to become Word Expert. If students intend to take a Microsoft Office Specialist or Expert exam for Word, this course is a good place to start preparation, but they will need to complete the other courses in the series to be fully prepared for either exam.

The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows. It does not assume that they’ve used a different version of Word or another word processing program.

Chapter 1: Fundamentals

  • Module A: Getting around
  • Module B: Creating documents
  • Module C: Document views

Chapter 2: Formatting

  • Module A: Formatting characters
  • Module B: Formatting paragraphs
  • Module C: Quick Styles
  • Module D: Making lists

Chapter 3: Document setup

  • Module A: Page layout
  • Module B: Proofing documents
  • Module C: Printing, headers, and footers
  • Module D: Templates

Chapter 4: Graphics

  • Module A: Inserting pictures
  • Module B: Formatting pictures
  • Module C: Picture layout

Chapter 5: Tables

  • Module A: Creating tables
  • Module B: Formatting tables
Jun
11
Mon
Microsoft Outlook 2016 – Level 2 @ Capitol Computers Training Center
Jun 11 @ 9:00 am – 4:00 pm
Microsoft Outlook 2016 - Level 2 @ Capitol Computers Training Center | Augusta | Maine | United States

Outlook 2016 Level 2

Days of Training: 1

Outlook 2016 Level 2 provides more advanced concepts and skills for Microsoft Outlook 2016 productivity: how to organize Outlook items, use advanced message properties, and collaborate with others. You will benefit most from this course if you have a basic knowledge of Outlook 2016 and plan to continue on to become an Outlook expert. If you intend to take a Microsoft Office Specialist exam for Outlook, this course is a good place to complete your preparation, but you will need to complete both courses in the series to be fully prepared for the exam.

The course assumes you know how to use a computer and that you’re familiar with Microsoft Windows. It also assumes that you have completed the preceding Outlook 2016 Level 1 course, or have equivalent knowledge.

Chapter 1: Organizing Outlook

  • Module A: Account management
  • Module B: Using folders
  • Module C: Categorizing items
  • Module D: Searching and filtering
  • Module E: Quick steps

Chapter 2: Managing your mail

  • Module A: Managing junk mail
  • Module B: Using rules
  • Module C: Cleaning up your mailbox

Chapter 3: Advanced email settings

  • Module A: Message options
  • Module B: Customizing message appearance

Chapter 4: Notes and Journal entries

  • Module A: Notes
  • Module B: Using the Journal

Chapter 5: Collaboration

  • Module A: Performing mail merges
  • Module B: Sharing items
  • Module C: Outlook integration
Jun
12
Tue
Microsoft Excel 2016 – Level 2 @ Capitol Computers Training Center
Jun 12 @ 9:00 am – 4:00 pm
Microsoft Excel 2016 - Level 2 @ Capitol Computers Training Center | Augusta | Maine | United States

Excel 2016 Level 2

Days of Training: 1

Excel 2016 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel 2016: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users. Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks such as rearranging and presenting complex data. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course will continue their preparation, but they will need to continue on to the Level 3 course, particularly to prepare for the Expert exam.

The course assumes students know how to use a computer, that they’re familiar with Microsoft Windows, and that they’ve taken the Level 1 course or have equivalent introductory experience with Excel.

Chapter 1: Managing workbooks

  • Module A: Managing worksheets
  • Module B: Customizing Excel

Chapter 2: Named ranges

  • Module A: Using names in formulas

Chapter 3: Tables

  • Module A: Sorting
  • Module B: Filtering tables
  • Module C: Structured references
  • Module D: Validation
  • Module E: Transposing data

Chapter 4: Summarizing data

  • Module A: Consolidation
  • Module B: Subtotals

Chapter 5: PivotTables

  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: PivotCharts

Chapter 6: Presentation features

  • Module A: Conditional formats
  • Module B: Custom Formats
  • Module C: Graphics

Chapter 7: Advanced charts

  • Module A: Special chart types
  • Module B: Sparklines
  • Module C: Quick Analysis

Chapter 8: Collaboration

  • Module A: Permissions
  • Module B: Shared workbooks
Jun
13
Wed
Private Training
Jun 13 all-day

Registration for this training is closed to the public.

Jun
14
Thu
Microsoft PowerPoint 2016 – Level 2 @ Capitol Computers Training Center
Jun 14 @ 9:00 am – 4:00 pm
Microsoft PowerPoint 2016 - Level 2 @ Capitol Computers Training Center | Augusta | Maine | United States

PowerPoint 2016 Level 2

Days of Training: 1

PowerPoint 2016 Level 2 provides advanced concepts and skills for PowerPoint 2016 power users: how to use advanced formatting features, and animation and transition techniques, add and format media, track corrections and work with multiple presentations, create custom slide shows, and work with security and sharing options. You will benefit most from this course if you want to build on fundamental PowerPoint skills to become a power user, or if you want to have a solid foundation in PowerPoint’s advanced features.

This course assumes that you have completed PowerPoint 2016 Level 1 or have equivalent knowledge in the core skills of using Microsoft PowerPoint 2016.

Chapter 1: Advanced formatting

  • Module A: Inserting and formatting SmartArt
  • Module B: Additional formatting options

Chapter 2: Animation, time effects, and media

  • Module A: Animating slide content
  • Module B: Inserting and formatting media

Chapter 3: Reviewing content, tracking changes, and saving in other formats

  • Module A: Reviewing content and tracking changes
  • Module B: Saving a presentation in other formats

Chapter 4: Custom slide shows

  • Module A: Working with notes pages
  • Module B: Configuring, rehearsing, and presenting slide shows

Chapter 5: Sharing, collaborating, and security

  • Module A: Protecting your presentations
  • Module B: Sharing your presentations
Jun
15
Fri
Microsoft Word 2016 – Level 2 @ Capitol Computers Training Center
Jun 15 @ 9:00 am – 4:00 pm
Microsoft Word 2016 - Level 2 @ Capitol Computers Training Center | Augusta | Maine | United States

Word 2016 Level 2

Days of Training: 1

Word 2016 Level 2 provides the concepts and skills to use some more advanced features of Microsoft Word 2016, including enhanced formatting, character and paragraph styles, references, editing, and sharing, and saving to various formats. Students will benefit most from this course if they want to accomplish advanced workplace tasks in Word 2016, or if they want to have a solid foundation for continuing on to become a Word Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Word, this course provides and important part of their preparation, but they should also complete the other courses in the series to be fully prepared for either exam.

The course assumes that students know how to use a computer, and that they are familiar with Microsoft Windows and the basics of Microsoft Word.

Chapter 1: Shapes, WordArt, and SmartArt

  • Module A: Shapes and text
  • Module B: SmartArt

Chapter 2: Managing documents

  • Module A: Custom themes
  • Module B: Building blocks
  • Module C: Section breaks
  • Module D: Page backgrounds

Chapter 3: Styles

  • Module A: Character styles
  • Module B: Paragraph styles

Chapter 4: References and hyperlinks

  • Module A: Reference notes
  • Module B: Table of contents
  • Module C: Hyperlinks

Chapter 5: Navigation and organization

  • Module A: Navigating documents
  • Module B: Master documents

Chapter 6: Saving and sharing documents

  • Module A: Saving and sending
  • Module B: Comments
  • Module C: Protecting documents
Jun
18
Mon
No Classes Available
Jun 18 all-day
No Classes Available

No Classes Available

Jun
19
Tue
Microsoft Excel 2016 – Level 3 @ Capitol Computers Training Center
Jun 19 @ 9:00 am – 4:00 pm
Microsoft Excel 2016 - Level 3 @ Capitol Computers Training Center | Augusta | Maine | United States

Excel 2016 Level 3

Days of Training: 1

Excel 2016 Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel 2016: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, using Power Pivot and the Power Pivot Data Model, what-if-analysis, and macros. Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks such as handling and getting information from large amounts of data from sources inside out and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course will complete their coverage of all the objectives for both exams.

The course assumes students know how to use a computer, that they’re familiar with Microsoft Windows, and that they’ve taken the Level 1 and Level 2 courses or have equivalent introductory experience with Excel. The exercises are more detailed and complex than those in the previous levels

Chapter 1: Logical and Lookup Functions

  • Module A: Decision-making functions
  • Module B: Lookup and reference functions

Chapter 2: Advanced Formulas

  • Module A: Auditing and error-trapping
  • Module B: Formula options
  • Module C: Arrays

Chapter 3: Special functions

  • Module A: Date and time functions
  • Module B: Text functions
  • Module C: Other functions

Chapter 4: Importing and Exporting

  • Module A: The Power Pivot Data Model
  • Module B: Exporting data

Chapter 5: Analysis

  • Module A: What-if analysis
  • Module B: The Analysis Toolpak

Chapter 6: Macros and Forms

  • Module A: Recording macros
  • Module B: Running macros
  • Module C: Forms
Jun
21
Thu
No Classes Available
Jun 21 – Jun 22 all-day
No Classes Available

No Classes Available

Jun
29
Fri
Microsoft Word 2016 – Level 3 @ Capitol Computers Training Center
Jun 29 @ 9:00 am – 4:00 pm
Microsoft Word 2016 - Level 3 @ Capitol Computers Training Center | Augusta | Maine | United States

Word 2016 Level 3

Days of Training: 1

Word 2016 Level 3 covers advanced skills for Microsoft Word 2016 power users: advanced formatting features, document management, references, data fields and sources, macros, and forms. Students will benefit most from this course if they want to build on fundamental Word skills to become a power user, or if they want to have a solid foundation in Word’s advanced features before continuing on to more complex document management or VBA programming topics. If they intend to take a MOS Expert exam for Word, this course will teach them the necessary skills, but they will need to complete the first two courses in this series to successfully complete the Microsoft Office Specialist exam.

This course assumes that students have completed Word 2016 Level 2 or have equivalent knowledge in the core skills of using Microsoft Word 2016.

Chapter 1: Advanced formatting

  • Module A: Tables and charts
  • Module B: Creating building blocks
  • Module C: Linking text

Chapter 2: Advanced document management

  • Module A: Configuring Word options
  • Module B: Working with templates
  • Module C: Tracking and reviewing changes

Chapter 3: Using references

  • Module A: Internal references
  • Module B: Indexing
  • Module C: Citing external sources

Chapter 4: Creating mailings

  • Module A: Recipient lists
  • Module B: Performing mail merges
  • Module C: Envelopes and labels

Chapter 5: Macros and forms

  • Module A: Macros
  • Module B: Forms
Jul
4
Wed
No Classes Available
Jul 4 all-day
No Classes Available

No Classes Available

Jul
11
Wed
Private Training
Jul 11 all-day

Registration for this training is closed to the public.