Welcome to Comnet Group Inc.

Courses

Microsoft Office 365

Course number: CGIMO40

Microsoft Excel

Learn to create, format, enhance and print simple Excel spreadsheets. Students will gain the knowledge the skills and the confidence to create, format, enhance and print simple spreadsheets. The advanced levels will teach you how to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence and keep and maintain workbooks for all manner of purposes. You will also learn how to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions that will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you will be able to focus on getting the answers you need from the vast amounts of data your organization generates.

Microsoft Word

After taking this course, you will be able to create, format and edit basic documents, and perform basic functions such as printing and spell checking. In Advanced Level 2 and 3, Students will learn how to use advanced formatting tools, research tools, use graphics, create tables, charts, headers, and footers, use the research tools, and do a mail merge. Students will also learn how to create interactive forms, webpages, and macros, use reviewing tools, and create document references like Table of Contents, Indices and Footnotes. Students will learn how to create interactive forms, web pages, and macros, use reviewing tools, and create document references like Table of Contents, Indices and Footnotes.

Microsoft PowerPoint

Learn the foundation concepts of Microsoft PowerPoint. This course will teach you how to modify the PowerPoint environment, customize design templates, add SmartArt and math equations to a presentation, work with media and animations, collaborate on a presentation, customize a slide show, and how to secure and distribute a presentation. The advanced levels will also teach you how to modify the PowerPoint environment, customize design templates, add SmartArt and math equations to a presentation, work with media and animations, collaborate on a presentation, customize a slide show, and how to secure and distribute a presentation.

What You Will Learn:

Microsoft Excel:

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks to work with and analyze the data that is critical to the success of your organization.

You will:

Get started with Microsoft Office Excel

  • Perform calculations
  • Modify a worksheet
  • Format a worksheet
  • Print workbooks
  • Manage workbooks

Microsoft Word:

After taking this course, you will be able to create, format and edit basic documents, and do basic functions like printing and spell checking. In Advanced Level 2 and 3, Students will learn how to use advanced formatting tools, research tools, use graphics, create tables, charts, headers, and footers, use the research tools, and do a mail merge. Students will also learn how to create interactive forms, webpages, and macros, use reviewing tools, and create document references like Table of Contents, Indices and Footnotes. Student will learn how to create interactive forms, web pages, and macros, use reviewing tools, and create document references like Table of Contents, Indices and Footnotes.

Upon completion of the course, participants will be able to accomplish the following:

  • Word Basics
  • Explore the User Interface
  • Format Text and Paragraphs
  • Editing
  • Printing and Viewing your Document
  • Customize

Microsoft PowerPoint:

Learn the foundation concepts of Microsoft PowerPoint. This course will teach you how to modify the PowerPoint environment, customize design templates, add SmartArt and math equations to a presentation, work with media and animations, collaborate on a presentation, customize a slide show, and how to secure and distribute a presentation. This course advanced levels will also teach you how to modify the PowerPoint environment, customize design templates, add SmartArt and math equations to a presentation, work with media and animations, collaborate on a presentation, customize a slide show, and how to secure and distribute a presentation.

This section includes:

  • Getting Started with PowerPoint
  • Developing a PowerPoint Presentation
  • Performing Advanced Text Editing Operations
  • Adding Graphical Elements to Your Presentation
  • Modifying Objects in Your Presentation
  • Preparing to Deliver Your Presentation
  • Modify the PowerPoint environment
  • Customize design templates
  • Add SmartArt and math equations to a presentation
  • Work with media and animations
  • Collaborate on a presentation
  • Customize a slide show
  • How to secure and distribute a presentation
Prerequisites
  • A working knowledge of and familiarity with Windows
Target Audience

This course is intended for students who wish to gain a foundational understanding of Microsoft Excel in order to create and work with spreadsheets, and who are interested in learning Microsoft Word and Microsoft PowerPoint.

Course Content
Microsoft Excel Level 1

Create, Open and Save Workbooks

  • What is Excel?
  • Create a New Blank Workbook
  • Create a Workbook from a Template
  • Open Excel Files
  • Get Help
  • Save Workbooks
  • Navigate a Workbook

Explore the User Interface

  • Backstage View
  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Work with Data

  • Enter, Edit and Delete Data
  • Data Selection Methods
  • Use Autofill and Autocomplete
  • Cut, Copy, Paste and Paste Special
  • Resize Columns and Rows
  • Insert and Delete Columns, Rows, Cells
  • Use Undo, Redo and Repeat
  • Spellcheck and AutoCorrect
  • Use Find, Replace and Go To
  • Use Basic Functions
  • Use SmartTags and Options Buttons
  • Add, Edit, and Remove Comments

Format A Workbook

  • Format Using the Home Ribbon
  • Format Using the Mini-Toolbar
  • Format Using Dialog Boxes
  • Use and Modify Conditional Formatting
  • Use the Format Painter
  • Create and Modify Styles
  • Add, Name, Move, Delete and Color Sheets Charts
  • Create and Format a Chart
  • Modify Chart Layout and Structure
  • Change Chart Types, Options, Location and
  • Data Source
  • Save a Chart as a Template

Printing and Viewing A Workbook

  • Use the View Ribbon
  • Split and Freeze
  • Manage Multiple Windows
  • Use Page Layout, Print Preview and Basic
  • Print Options
  • Add Headers and Footers

Customize

  • Customize the Quick Access Toolbar
  • Show/Hide the Ribbon
Microsoft Excel Level 2

Use Tables

  • Create a Table from Data
  • Modify Table Format and Structure
  • Use Structured References in a Table

Formulas and Functions

  • Understand Mathematical Operators
  • Use Auto Functions
  • Use Relative and Absolute References
  • Explore the Function Ribbon and Overview of Categories
  • Use the Insert Function Wizard and Dialog Box
  • Use Basic Text, Financial, Date, and Logical Functions
  • Name and Use Ranges of Cells in Formulas
  • Use Array Formulas
  • Audit Formulas
  • Trace and Remove Trace Arrows
  • Use a Watch Window

Sort and Filter

  • Use Basic Sort Options
  • Advanced Sort Options

Use Auto Filters

  • Create Custom Auto filters
  • Use Advanced Filters
  • Use Data Validation
  • Use Database Functions

Enhance A Workbook

  • Insert Symbols and Characters
  • Add and Format Shapes
  • Manipulate Shapes
  • Use and Modify SmartArt
  • Add a Signature Line
  • Add and Format Text Boxes and WordArt
  • Use Screenshot
  • Link and Embed Objects

Protect and Finalize

  • Add Protection
  • Allow Edit Options within Protection
  • Info Panel Options*
  • Share Panel Options*
  • Use the Document Inspector
  • Check Compatibility and Mark as Final
  • Customize Excel Options

Views

  • Create Custom Views
  • Hide Workbooks, Sheets and Cells
  • Set File Properties
Microsoft Excel Level 3

Enhancing Workbooks

Customize Workbooks

  • Comments
  • Hyperlinks
  • Watermarks
  • Background Pictures

Manage Themes

  • About Themes
  • Customizing Themes

Create and Use Templates

  • Templates
  • Template Types
  • Creating a Template
  • Modifying a Template

Protect Files

  • Recovering Lost Data
  • The Changes Group
  • Worksheet and Workbook Protection
  • The Protect Worksheet Option
  • The Protect Workbook Option

Preparing a Workbook for Multiple Audiences

  • Displaying Data in Multiple International Formats
  • Utilize International Symbols
  • Modifying Worksheets Using the Accessibility Checker
  • Managing Fonts

Auditing Worksheets

Trace Cells

  • The Trace Cells Feature
  • Tracer Arrows
  • Troubleshoot Invalid Data and Formula Errors
  • Invalid Data
  • The Error Checking Command
  • Error Types

Watch and Evaluate Formulas

  • The Watch Window
  • Formula Evaluation

Create a Data List Outline

  • Outlines
  • The Outline Group

VLOOKUP Review

Working with Multiple Worksheets and Workbooks

Consolidate Data

  • Data Consolidation
  • The Consolidate Dialog Box
  • Consolidation Functions

Link Cells in Different Workbooks

  • External References

Merge Workbooks

  • The Compare and Merge Workbooks Feature

Exporting Excel Data

Export Excel Data

  • The Export Process

Import a Delimited Text File

  • The Import Process
  • The Get External Data Group
  • Delimited Text Files
  • Methods of Importing Text Files

Integrate Excel Data with the Web

  • The File Publishing Process
  • Publish as Web Page Dialog Box

Create a Web Query

  • Web Queries
  • The New Web Query Dialog Box

Analyzing Data with PivotTables, Slicers, and Pivot Charts

  • Create a PivotTable
  • PivotTables
  • Start with Questions, End with Structure
  • The Create PivotTable Dialog Box
  • The PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • The “Show Values As” Functionality of a PivotTable
  • External Data
  • PowerPivot
  • PowerPivot Functions

Filter Data by Using Slicers

  • Slicers
  • The Insert Slicers Dialog Box

Analyze Data with Pivot Charts

  • Pivot Charts
  • Creating Pivot Charts
  • Applying a Style to a PivotChart

Automating Worksheet Functionality

Update Workbook Properties

  • Workbook Properties

Create and Edit a Macro

  • Macros
  • The Record Macro Dialog Box
  • Naming Macros
  • Visual Basic for Applications
  • Copying Macros Between Workbooks
  • Macro Security Settings

Apply Conditional Formatting

  • Conditional Formatting
  • Conditional Formats
  • The Conditional Formatting Rules Manager Dialog Box
  • The New Formatting Rule Dialog Box
  • Clear Rules

Add Data Validation Criteria

  • Data Validation
  • The Data Validation Dialog Box
Microsoft Word Level 1

Basics

  • Create, Open and Save Documents
  • What is Word?
  • Create a New Blank Document
  • Create a Document from a Template
  • Open Word Files
  • Get Help
  • Save Documents
  • Navigate a Word Document
  • Add, Select and Delete Text

Explore the User Interface

  • Office Button
  • Backstage View
  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Format Text and Paragraphs

  • Use the Home Ribbon to Format Font and Paragraphs
  • Format with the Mini-Toolbar
  • Font and Paragraph dialog boxes
  • Use the Quick Style Gallery
  • Use Basic Bullets and Numbering
  • Add Borders and Shading
  • Set Tabs and Use the Ruler

Editing

  • Using Cut, Copy, Paste
  • Use the Office Clipboard
  • Undo/Redo
  • Find, Replace and Go To
  • Use the Format Painter
  • Check Spelling and Grammar

Printing and Viewing Your Document

  • Use the View Ribbon Commands
  • Show/Hide Markings
  • Use the Page Set-Up Group and Dialog Box
  • Print Preview and Print Options
  • Print Panel

Customize

  • Customize the Quick Access Toolbar
  • Show/Hide the Ribbon
Microsoft Word Level 2

Explore the User Interface

  • Office Button
  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Work with Templates

  • Create a Template
  • Modify a Template
  • Attach a Template to a Document

Working with Styles

  • Create a Style from Text
  • Use the Styles Pane
  • Modify and Delete Styles
  • Use the Style Inspector
  • Use Reveal Formatting
  • Manage Styles

Bullets and Numbering

  • Custom Bullets and Numbering
  • Create a Multi-Level List
  • Restart or Continue Numbering

Advanced Page Formatting

  • Use Columns
  • Insert Page Breaks, Column Breaks, Section Breaks and Line Breaks
  • Set Break Options
  • Create a Blank Page and a Cover Page
  • Add Page Colors, Watermarks, Borders, and Horizontal Lines
  • Add Headers and Footers
  • Use Header and Footer Galleries
  • Add a Header or Footer to the Gallery
  • Link and Unlink Headers and Footers
  • Use and Modify Themes

Hyperlinks

  • Add Hyperlinks
  • Edit Hyperlinks
  • Remove Hyperlinks

Use Time Saving Tools

  • Use Hyphenation and Word Count
  • Use Research, Language and Translation Tools
  • Use and Customize Autocorrect
  • Insert the Date and Time
  • Insert Symbols and Special Characters
  • Work with Smart Tags

Mail Merge

  • Use the Mail Merge Wizard
  • Use the Mailings Ribbon
  • Create Envelopes and Labels

Use Send Options

  • Fax a Document
  • Email a Document
  • Use Email Features

Working with Graphics

  • Add Pictures and Clipart
  • Format and Modify Images
  • Add Captions
  • Add and Format WordArt
  • Add and Format AutoShapes
  • Add and Format Text Boxes
  • Align, Distribute, Group and Order Graphics
  • Add Quick Parts and Use Building Blocks
  • Add and Format SmartArt

Working with Tables

  • Insert a Table
  • Table Selection Options
  • Format a Table
  • Modify Table Structure
  • Draw a Table
  • Use Table Options Dialog Boxes
  • Convert Text to Table
  • Sort a Table

Working with Data and Charts

  • Use and Insert Equations
  • Insert a Chart
  • Format a Chart
  • Modify Chart Options
  • Embed and Link Excel Tables and Charts
Microsoft Word Level 3

Explore the User Interface (If Required for Upgrade Students)

  • Office Button
  • Backstage View
  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Work with Forms

  • Use the Developer Tab
  • Create Forms
  • Add and Format Form Controls
  • Group Controls
  • Test, Protect and Distribute Forms
  • Assign Help to a Form Field
  • Use Legacy Controls

Work with Webpages

  • Create Webpages
  • Use Legacy and ActiveX Controls on Webpages
  • Save as Webpage Options

Macros

  • Set Macro Security
  • Record a Macro
  • Assign a Macro to a Keystroke or Quick Access Toolbar
  • Copy a Macro from a Template

Reviewing Documents

  • Add, Edit, Navigate and Delete Comments
  • Use the Review Pane
  • Track and Review Changes
  • Track Changes Options
  • Inspect the Document
  • Prepare for Sharing
  • Compare and Combine Documents
  • Protect Documents
  • Create and Modify Outlines

Use Reference Tools

  • Create a Table of Contents from Heading Styles
  • Create a Table of Contents from an Outline
  • Format, Modify and Update a TOC
  • Add Footnotes and Endnotes
  • Navigate and Edit Footnotes and Endnotes
  • Use Bookmarks
  • Use Cross References
  • Create a Bibliography
  • Manage Bibliography Sources and Choose Styles
  • Add Captions and Create a Table of Figures
  • Mark Entries and Create an Index
  • Update and Modify an Index
  • Create and Update a Table of Authorities
  • Create and Use Outlines
  • Drag and Drop Headings
  • Create a Master Document
  • Create and Work with Sub Documents

Customizing

  • Customize Word Options
  • Use the Info Pane
  • Use the Share Pane
Microsoft PowerPoint Level 1

Getting Started with PowerPoint

  • Navigate the PowerPoint Environment
  • View and Navigate a Presentation
  • Create and Save a PowerPoint Presentation
  • Use PowerPoint Help

Developing a PowerPoint Presentation

  • Select a Presentation Type
  • Edit Text
  • Build a Presentation

Performing Advanced Text Editing Operations

  • Format Characters
  • Format Paragraphs
  • Format Text Boxes

Adding Graphical Elements to Your Presentation

  • Insert Images
  • Insert Shapes

Modifying Objects in Your Presentation

  • Edit Objects
  • Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects

Preparing to Deliver Your Presentation

  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation
  • Deliver Your Presentation
Microsoft PowerPoint Level 2 and 3

Modifying the PowerPoint Environment

  • Customize the User Interface

Customizing Design Templates

  • Modify Slide Masters and Slide Layouts
  • Add Headers and Footers
  • Modify the Notes Master and the Handout Master

Adding SmartArt and Math Equations to a Presentation

  • Create SmartArt
  • Modify SmartArt
  • Write Math Equations

Working with Media and Animations

  • Add Audio to a Presentation
  • Add Video to a Presentation
  • Customize Animations and Transitions

Collaborating on a Presentation

  • Review a Presentation
  • Store and Share Presentations on the Web

Customizing a Slide Show

  • Annotate a Presentation
  • Set Up a Slide Show
  • Create a Custom Slide Show
  • Add Hyperlinks and Action Buttons
  • Record a Presentation

Securing and Distributing a Presentation

  • Secure a Presentation
  • Broadcast a Slide Show
  • Create a Video or a CD

Available Formats

Live Online
Register