Outlines

If you don't see what you're looking for, be sure to ask!

Adobe Acrobat

Adobe Acrobat®: Getting Started with Adobe Acrobat Reader DC

Adobe Acrobat®: Getting Started with Adobe Acrobat Pro DC

 

Apple iPad

Apple iPad® - iPad at Work

Bluebeam Revu

Bluebeam Revu Basics

Bluebeam Document Control

Bluebeam Extreme Forms

Bluebeam for Estimators - Measurements and Takeoffs

Bluebeam and Word Editing-Collaboration-Comparison

 

Business and Technical Writing

Business and Technical Writing: Business and Technical Writing Skills

Employment

Employment: Designing an Effective Resume

Employment: Using the Internet in Your Job Search

 

FileMaker

FileMaker Inc. FileMaker®: Getting Started with FileMaker

FileMaker Inc. FileMaker®: Creating Layouts

FileMaker Inc. FileMaker®: Functions, Relationships, Lookups and Portals

 

Microsoft Access

Microsoft Access®: Creating Related and Unrelated Tables, Fields and their Properties

Microsoft Access®: Fundamentals of Querying Databases

Microsoft Access®: Advanced Querying Techniques

Microsoft Access®: Creating Forms and Reports

Microsoft Access®: Advanced Techniques in Form Creation and Report Writing

 

Microsoft Excel

Microsoft Excel®: Getting Started with Excel Formulas & Functions

Microsoft Excel®: Advanced Functions

Microsoft Excel®: Useful Features in Microsoft Excel

Microsoft Excel®: Charting, Linking, Embedding and Working with Multiple Sheets

Microsoft Excel®: Working with Microsoft Excel Databases

Microsoft Excel®: Creating Forms and Recording Macros

Microsoft Excel®: Microsoft Excel Shortcuts

Microsoft Excel®: Introduction to Microsoft Excel

Microsoft Excel®: Intermediate Microsoft Excel

Microsoft Excel®: Advanced Microsoft Excel

Microsoft Excel®: Excel Visual Basic for Applications (VBA)

Microsoft Internet Explorer/Edge

Microsoft Internet Explorer®/Edge: Surfing and Searching the Internet

 

Microsoft OneDrive

Microsoft OneDrive®: Getting Started with OneDrive

 

Microsoft OneNote

Microsoft OneNote®: Getting Started with OneNote

 

Microsoft Outlook

Microsoft Outlook®: Getting Started with Microsoft Outlook

Microsoft Outlook®: Useful Features in Microsoft Outlook

 

 

Microsoft PowerPoint

Microsoft PowerPoint®: Getting Started with Microsoft PowerPoint

Microsoft PowerPoint®: Useful Features in PowerPoint

 

Microsoft Office

Microsoft Office: Tips, Tricks & New Features in Word, Excel, PowerPoint and Outlook

 

Microsoft Project

Microsoft Project®: Getting Started with Microsoft Project

Microsoft Project®: Advanced Features

 

Microsoft SharePoint

Microsoft SharePoint® for the End User: Getting Started with Microsoft SharePoint

Microsoft Skype for Business

Microsoft Skype for Business (AKA Lync)®: Getting Started with Skype for Business

Microsoft Teams

Microsoft Teams®: Getting Started with Microsoft Teams

 

Microsoft Visio

Microsoft Visio®: Getting Started with Microsoft Visio

Microsoft Visio®: Useful Features in Microsoft Visio

 

Microsoft Windows

Microsoft Windows® 10: Getting Started with Windows 10

 

Microsoft Word

Microsoft Word®: Getting Started with Microsoft Word

Microsoft Word®: Tabs, Tables, Graphics & Desktop Publishing

Microsoft Word®: Creating Forms, Mail Merges, Envelopes and Labels

Microsoft Word®: Working with Long Documents

Microsoft Word®: Recording Macros and Using Automation Shortcuts

Microsoft Word®: Useful Features in Microsoft Word

Microsoft Word®: Introduction to Microsoft Word

Microsoft Word®: Intermediate Microsoft Word

Microsoft Word®: Advanced Microsoft Word

 

Novell GroupWise

Novell GroupWise® 8.0

 

Sage Act!

Sage Act!®: Getting Started with Sage Act!

Sage Act!®: Useful Features in Sage Act!

 

Tableau

Tableau®: Getting Started with Tableau Desktop

Top

 
 

Adobe Acrobat®: Getting Started with Adobe Acrobat Reader DC

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • What is Adobe Acrobat DC?

  • Creating PDFs from Office Documents

  • Creating PDFs from Other Programs

  • Converting a PDF Document to Microsoft Word

  • Converting a PDF Document to a Text Document

  • Accessing Help

  • Selecting Preferences

  • Showing and Hiding Toolbars

  • Displaying a Theme

  • Accessing Read Mode and Full Screen Mode

  • Read Out Load

  • Rotating Pages

  • Thumbnails, Bookmarks and Attachments

  • Adobe Acrobat®: Getting Started with Adobe Acrobat Pro DC

  • Saving Files Locally and to the Document Cloud

  • Starring Files

  • Printing Files

  • Sharing Files

  • Finding Text

  • Moving between Pages

  • Panning

  • Zooming

  • Moving between Views

  • Using Sticky Notes

  • Highlighting Text

  • Marking Up a Document

  • Filling Out a Form

  • Signing a Document

Top

Adobe Acrobat®: Getting Started with Adobe Acrobat Pro DC

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • Browsing a PDF document

  • Navigating to specific content within a PDF document

  • Conducting a simple search

  • Extracting content from a PDF document

  • Creating PDF documents

    • Creating a PDF document from a Word document

    • Creating PDF documents using the print command

    • Creating PDF documents from web pages

    • Creating a PDF document using Acrobat

  • Manipulating PDF document pages

    • Editing text in a PDF

    • Adding headers and footers

    • Customizing page numbering

  • Using Bookmarks

    • Navigating using bookmarks

    • Creating bookmarks

    • Modifying bookmarks

    • Rearranging bookmarks

  • Creating and modifying links

  • Formatting a Story as an article

  • Organizing PDFs into a collection

  • Controlling access to multiple PDF documents

  • Searching multiple PDF documents

  • Choosing a collaboration workflow

  • Adding review tools to a PDF document

  • Digitally signing a PDF document

  • Markup a PDF document

  • Compiling and viewing comments from multiple reviewers

 

Top 

Apple iPad® - iPad at Work

3 Hours

Prerequisites: None

 

This course is based on the book of the same name by David Sparks.

 

  • iPad fundamentals

  • Useful utilities

  • Security

  • The internet

  • The cloud

  • Email

  • Contacts

  • Calendars

  • Video conferencing and messaging

  • Remote access

  • Travel

  • The Enterprise

  • Writing

  • PDFs

  • Books

  • Notes and meetings

  • Brainstorming

  • Presentations

  • Task management

  • Calculators and spreadsheets

  • Business graphics

  • Databases

  • Project management

  • Billing and finance

Top

Bluebeam Revu Basics

3 Hours

 

Interface and Navigation

  • Command bar and toolbars

  • Hidden panels and tab Access

  • Navigation and status bar

  • PDF navigation

  • File Access tab

  • Split screen and syncing

 

Profiles and Profile Management

  • Creating profiles

  • Customizing toolbars

 

Markup Tools for Drawings 

  • Overview of markup tools

  • Scaling and rotating markups

  • Customizing the appearance properties of markups

  • Adding subject lines

  • Inserting images using Capture

  • Using the Snapshot tool 

 

Customize Markups

  • Format Painter

  • Adding actions to markup

  • Grouping markups

 

Stamps

  • Creating and applying a stamp

  • Applying a stamp to page(s) from thumbnails

 

The Tool Chest and Sharing Customized Markups 

  • Overview of the Tool Chest

  • Properties Mode vs. Drawing Mode

  • Creating a custom tool set

  • Saving a custom markup to a tool set

  • Sharing a tool set with colleagues

 

The Markups List for Tracking Comments 

  • Overview of Markups List

  • Sorting data in the Markups List

  • Custom columns

  • Importing comments from multiple PDFs onto your file

  • Filtering data

  • Setting statuses

  • Creating custom status fields

  • Replying to comments

  • Exporting all markup data

  • PDF and Excel summaries

 

Document Manipulation 

  • Inserting a blank page, inserting existing page,

  • Deleting and reordering pages

  • Searching text

  • Searching visuals

Top

Bluebeam Revu Document Control

3 hours

 

AutoMark and Page Extraction

  • Running AutoMark to set page labels

  • Setting bookmarks from page labels

  • Extracting all pages to break into individual PDF’s

 

PDF Create and Organization

  • Creating blank PDF and setting options

  • Saving a template

  • Creating a PDF from Outlook and Word

  • Creating a PDF from web

 

PDF Manipulation

  • Editing text

  • Combining PDFs

  • Sending and exporting

  • Splitting PDFs

  • Exporting to another file format

 

Creating a Navigable Drawing Set

  • Linking a drawing set

  • Vector vs. raster drawings

  • Adding hyperlinks via Edit Action

  • Adding links using the Links and Places tabs

 

Document Comparison and Overlay Pages

  • Detecting changes with revised sets via Compare Documents

  • Detecting changes using Overlay Pages

  • Overlaying two differently sized sheets using Pick Points

 

Sets

  • Using sets to view separate PDF files as if they are one combined file

  • Setting up a set

  • Viewing revision history in sets

  • Compare documents and overlay pages from sets

 

Using Sets with Bluebeam Studio Projects

  • Overview of Studio Projects

  • Setting up a Studio Project and uploading files

  • Uploading and editing a set within projects

  • Inviting others and setting permissions

  • Read-only mode vs. checking out

  • Working offline

Top

Bluebeam Extreme Forms

2 Hours

Bluebeam Extreme ONLY (other versions do not have this functionality)

Create and Edit PDF Forms

  • Working in Forms Editor

  • Adding form fields

  • Define form field properties

  • Validate form data

  • Use buttons to create actions

  • Collecting data from forms

 

Automatic Forms  (Extreme 2017 Only)

  • Create an Automatic Form

 

OCR+

  • Process text documents to make them readable and searchable

  • Batch OCR+

Top

Bluebeam for Estimators - Measurements and Takeoffs

3 Hours

Loading the Takeoffs Profile

  • Calibration

  • How to calibrate a drawing to correct scale

  • Entering known scale

  • Viewports

 

Measurement Tools

  • Linear Tools: length, area, perimeter, volume

  • Diameter, angle, radius, converting lines to arcs

  • Visual Search + Count

  • Adding depth to get wall area

  • Organizing takeoffs by moving measurement captions

  • Grouping measurements by layers

 

Creating Custom Measurement Tools

  • Customizing the look of your measurement markup

  • Subject line, appearance properties

  • Saving a markup into a custom tool set

  • Creating sequences in the tool set for sequential counting

  • Sketch Tools

  • Dynamic Tool Sets Scaler

 

Basic Estimation in the Markups List and Exporting to Excel

  • Turning on measurement columns

  • Custom columns

  • Creating materials custom column

  • Creating formula columns to calculate costs

  • Managing and importing materials in CSV file format

  • Filtering data in the Markups list

  • Exporting takeoff data to CSV file format

Top

Bluebeam Revu & Microsoft Word - Document Editing, Collaboration & Comparison

3 Hours

 

Bluebeam Revu

Editing a PDF Document

  • Editing text

  • Reviewing text

  • Formatting text

  • Creating hyperlinks

  • Searching and hyperlink

  • Creating bookmarks

  • Headers and footers

  • Inserting comments

 

Manipulate PDF Documents

  • Extracting pages

  • Replacing pages

  • Splitting PDF documents

  • Exporting to another file format

  • Document comparison

  • Comparing documents

Microsoft Word

Reviewing and Collaborating on Documents

  • Tracking changes

  • Viewing markup

  • Accepting and rejecting changes

  • Inserting comments

  • Displaying and editing comments

  • Deleting comments

  • Showing or hiding comments

Document Comparison

  • Comparing documents

  • Combining documents

Creating PDF Documents

  • Creating PDF documents in Word

  • Creating PDF documents in Excel

  • Creating PDF documents from a Web Page

  • Opening a PDF in Word

Top

Business and Technical Writing Skills

6 Hours

Prerequisites: None

  • How do business and technical writing differ?

  • The qualities of good business and technical writing

  • Examples of business and technical documents

  • Important skills for a writer to have

  • Five steps to effective writing

  • Determining the purpose of the document

  • Analyzing the audience

  • Prioritizing information

    • Grouping information into Critical, Essential and Non-essential categories

    • Using a Prioritization Matrix when developing an action plan

  • Creating an outline and developing content

    • Using 5 Ws and an H

    • Using a Fishbone Diagram/Outline

    • Using both left brain and right brain skills

  • Creating headlines

  • Choosing the right words

    • Web and Microsoft Word tools for word choice and grammar

    • Jargon, Acronyms, Idioms, Clichés, Slang, Euphemisms, Colloquialisms

    • The difference between Shall and Should

    • Using grammar properly

    • Avoiding gender bias

    • Using the active and passive voice

    • Using a positive tone

  • Sequencing the document

    • Where to put your bottom line

    • Typical order for sequencing reports

    • Sequencing based on audience

  • Things to avoid

  • Proofreading suggestions

  • Creating a clean visual design

Top

Employment: Designing an Effective Resume

3 Hours

Prerequisites: None

 

  • Using tabs and tables in Microsoft Word

  • Writing effective cover letters

  • Highlighting qualities employers seek

  • Designing resumes

    • The resume heading

    • Job objectives

    • Summary statements

    • Chronological vs. functional formats

    • Using dates

    • Using action words

    • Making your resume achievement oriented

    • Disguising gaps in employment

    • Other possible section headings

    • References

  • Writing thank you letters

 

Top

Employment: Using the Internet in Your Job Search

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

This course introduces applicants to the many resources available online that can help them in the process of finding a job. Topics include general strategies for navigating the web using Internet Explorer and a tour of useful sites that educate the applicant on how to:

 

  • Applying for jobs online

  • Contacting job councilors

  • Contacting employers

  • Establishing an e-mail account where you can be reached

  • Finding a recruiter

  • Finding career fairs, conventions and trade shows

  • Finding job listings at employment sites

  • Finding internships and apprenticeships

  • Hiring someone

  • Honing your interviewing skills

  • Learning how to cope with job loss

  • Becoming skilled at preparing cover letters, resumes and thanks you notes

  • Learning negotiating skills

  • Looking for financial aid

  • Looking up employment and industry trends

  • Networking

  • Obtaining training

  • Obtaining relocation information

  • Posting a resume

  • Reading newspaper job listings

  • Researching companies

  • Researching salary information

  • Researching self employment options

  • Taking self assessment tests

Top

FileMaker Inc. FileMaker®: Getting Started with FileMaker

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • Databases

    • Fields, records, and tables

  • Parts of the screen

    • Title Bar

    • Toolbars

    • Status Area/Book Column

    • Zoom Controls

    • Status Area Control Button

    • Mode Indicator Button

  • Moving within a record

  • Moving between records

  • Modes

    • Browse

    • Find

    • Layout

    • Preview

  • Views

    • View as Form

    • View as List

    • View as Table

  • Creating new records

  • Editing a record

  • Duplicating records

  • Adding information from the index

  • Inserting special info

  • Finding information

    • Performing simple finds

    • Performing complex finds

    • And finds

    • Or finds

    • Omitting records

    • Constraining and extending found sets

    • Performing a quick find

    • Symbols

  • Sorting records 

 

Top

FileMaker Inc. FileMaker®: Creating Layouts

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. It is highly recommended but not required that you take FileMaker Inc. FileMaker: Getting Started with FileMaker first.

 

  • Layout options

  • Displaying rulers

  • Changing tab order

  • Creating buttons

  • Working with layout tools

    • Selection tool

    • Text tool

    • Line tool

    • Rectangle tool

    • Rounded Rectangle tool

    • Oval tool

  • Changing lines and fills

  • Copying the formatting from one object to another

  • Aligning objects

  • Changing the order of objects

  • Sliding objects together

  • Creating tabbed layouts

  • Creating summary reports

    • Summary fields

    • Summary parts

    • Sub-summaries

    • Grand summaries

  • Creating mailing labels

 

Top

FileMaker Inc. FileMaker®: Functions, Relationships, Lookups and Portals

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.  It is highly recommended but not required that you take FileMaker Inc. FileMaker: Getting Started with FileMaker and FileMaker Inc. FileMaker: Creating Layouts first.

 

  • Working with calculated fields

  • Functions

    • The Round function

    • The IF function

    • Logical operations

    • Text operators

    • Nested IF statements

    • Today's Date calculation

    • The PMT function

    • The SUM Function

    • The PROPER Function

    • The Right Function

    • The COUNT function

    • The AVERAGE function

    • The MAX function

    • The MIN function

    • The DAYNAME function

    • The MONTHNAME function

    • The YEAR function

  • Establishing relationships

  • Using repeating fields

  • Creating lookups

  • Creating portals

Top

Microsoft Access®: Creating Related and Unrelated Tables, Fields and their Properties

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • Understanding databases, tables, fields and records

  • Navigating the database window

  • Moving around a table

  • Editing data

  • Adding records

  • Changing column widths

  • Saving design changes

  • Displaying design view and datasheet view

  • Creating field names

  • Setting data types

  • Entering field descriptions

  • Setting field properties

    • Field size

    • Format

    • Input mask

    • Caption

    • Default value

    • Validation rule

    • Validation text

    • Required

    • Allow zero length

    • Indexed

  • Creating relationships between tables

    • Creating Joins

    • Enforcing referential integrity

Top

Microsoft Access®: Fundamentals of Querying Databases

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.  It is highly recommended but not required that you take Microsoft Access: Creating Related and Unrelated Tables, Fields and Their Properties first.

  • Creating queries

    • Working with field lists

    • Placing fields in the grid

    • Removing fields from the grid

    • Sorting in a query

    • Changing display order in a dataset

    • Using the Show row

    • Defining criteria

  • Saving queries

  • Modifying a saved query

  • Creating And queries

  • Creating Or queries

  • Using comparison operators

  • Using keyword operators

  • Using wildcards

  • Showing only top values

  • Using numeric summaries

  • Creating expressions

  • Printing datasets

Top

Microsoft Access®: Advanced Querying Techniques

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, take Microsoft Access: Fundamentals of Querying Databases.

 

  • Creating parameter queries

  • Finding duplicate records

  • Finding unmatched records

  • Creating crosstab queries

  • Using a form to provide criteria for a query

  • Using Action queries

    • Creating make table queries

    • Creating delete queries

    • Creating append queries

    • Creating update queries

  • Creating union queries

Top

Microsoft Access®: Creating Forms and Reports

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.  It is recommended but not required that you take Microsoft Access: Creating Related and Unrelated Tables, Fields and their Properties and Microsoft Access: Fundamentals of Querying Databases first.

 

  • Creating AutoForms

  • Creating Autoreports

  • Using report sections

  • Adding fields and controls to reports and forms

  • Aligning fields and objects

  • Resizing fields and objects

  • Manipulating controls on a report or form

  • Concatenating fields and text

  • Using wizards to create reports and forms

  • Creating blank reports

  • Printing a report definition

  • Sorting and grouping on a report

  • Changing the order of objects

  • Changing an object’s properties

  • Changing tab order

Top

Microsoft Access®: Advanced Techniques in Form Creation and Report Writing

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is HIGHLY recommended that you first take Microsoft Access: Creating Forms and Reports.

 

  • Creating subforms to display information from related tables

  • Creating expressions in subforms

  • Creating a relationship between tables

  • Methods for creating forms

  • Displaying expressions from subforms on main forms

  • Adding check boxes, toggle buttons and option buttons

  • Creating combo boxes

  • Creating list boxes

  • Creating option groups

  • Working with tab controls

  • Creating switchboards

  • Creating macros

Top

Microsoft Excel®: Getting Started with Excel Formulas & Functions

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • Understanding the user interface

  • Customizing the user interface

  • Navigating a spreadsheet quickly

  • Entering and editing text

  • Using Backspace vs. Delete while editing

  • Deleting data

  • Modifying cell alignment

  • Moving and copying data

  • Using Undo and Redo

  • Using the Autofill handle to copy or extend a series

  • Separating and formatting text with FlashFill

  • Creating formulas

    • Adding, subtracting, multiplying and dividing

    • Using cell references and range references

  • Creating Basic Functions

    • SUM

    • MAX

    • MIN

    • AVERAGE

    • COUNT

    • COUNTA

  • Using AutoFill to copy formulas

  • Understanding the Order of Operations

  • Finding and replacing information on a spreadsheet

  • Understanding relative and absolute references

  • Displaying formulas on a spreadsheet

  • Formatting a spreadsheet

    • Changing fonts

    • Formatting numbers as currency

    • Centering text across columns

    • Adding headers and footers

    • Changing the orientation of the page

    • Applying borders

    • Scaling a spreadsheet to fit on a page

    • Centering a spreadsheet on a page

  • Printing a spreadsheet

Top

Microsoft Excel®: Advanced Functions

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, take Microsoft Excel: Basic Formulas & Functions or have equivalent training or experience with Microsoft Excel.

  • Lean to use the following functions:

    • IF - Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.

    • HLOOKUP - Looks for a value in the top row of a table and then returns a value in the same column from a row you specify.

    • VLOOKUP - Looks for a value in the left row of a table and then returns a value in the same row from a column you specify.

    • SUMIF - You use the SUMIF function to sum the values in a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) that meet criteria that you specify.

    • COUNTIF - The COUNTIF function counts the number of cells within a range that meet a single criterion that you specify.

    • INDEX - Returns a value or reference of a cell at the intersection of a particular row and column, in a given range.

    • MATCH - The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.

    • SUMPRODUCT - Multiplies corresponding components in the given arrays, and returns the sum of those products.

    • PMT - Calculates the payment for a loan based on constant payments and a constant interest rate.

    • OFFSET - Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.

    • UPPER - Converts text to uppercase.

    • LOWER - Converts all uppercase letters in a text string to lowercase.

    • PROPER - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

    • ISERROR - Returns TRUE or FALSE depending on whether the tested scenario leads to an error except N/A..

    • ISTEXT - Returns TRUE or FALSE depending on whether the tested scenario returns text.

    • ISNUMBER - Returns TRUE or FALSE depending on whether the tested scenario returns a number.

    • STDEV - Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

    • TRIM - Removes all spaces from text except for single spaces between words.

    • AVERAGE - Returns the average (arithmetic mean) of the arguments.

    • MEDIAN - Returns the median of the given numbers. The median is the number in the middle of a set of numbers.

    • MODE.MULT - Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. This will return more than one result if there are multiple modes.

    • MODE.SNGL - Returns the most frequently occurring, or repetitive, value in an array or range of data.

    • RANK.AVG - Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned.

    • RANK.EQ - Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned.

    • LARGE - Returns the k-th largest value in a data set.

    • SMALL - Returns the k-th smallest value in a data set.

  • Separating text into multiple columns

 

Top

Microsoft Excel®: Useful Features in Microsoft Excel

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, take Microsoft Excel: Basic Formulas & Functions or have equivalent training or experience with Microsoft Excel.

 

  • Applying a password to open or modify a spreadsheet

  • Allowing users to edit ranges with passwords

  • Using named ranges for navigation purposes and creating formulas

  • Creating custom lists

  • Creating custom views

  • Creating scenarios

  • Using the Format Painter

  • Applying conditional formatting to one or more cells

  • Creating and using styles

  • Using Paste Special

  • Printing titles

  • Validating data with data validation

  • Using Goal Seek

  • Using Solver to optimize a result

  • Creating one and two way Data Tables

Top

Microsoft Excel®: Charting, Linking, Embedding and Working with Multiple Sheets

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is helpful to have taken Microsoft Excel: Basic Formulas & Functions or have a basic familiarity with Excel.

  • Creating Charts

    • Selecting the data to include in a chart

    • Creating a chart with a single keystroke

    • Moving a chart

    • Resizing a chart

    • Modifying characteristics of a chart

      • Changing bar colors

      • Changing the color of the background

      • Deleting gridlines

      • Formatting gridlines

      • Formatting text

      • Formatting values

      • Adding text to a chart

    • Creating a chart template​

    • Using new chart types - Treemap, Sunburst, Histogram, Box and Whisker, Waterfall, Funnel, People Graph

  • Linking

    • Creating a link using an equation

    • Creating a link using Paste Special

    • Linking from Microsoft Excel to Microsoft Word

  • Embedding

    • Embedding an Excel spreadsheet inside a Word document

  • Working with Multiple Sheets

    • Renaming sheets

    • Changing the color of tabs

    • Adding new sheets

    • Deleting sheets

    • Setting the default number of sheets in a new workbook

    • Changing the order of sheets

    • Using Group Mode to modify several sheets at the same time

    • Creating equations using data from different sheets

  • Creating and using hyperlinks

 

Top

Microsoft Excel®: Working with Microsoft Excel Databases

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is helpful to have taken Microsoft Excel: Basic Formulas & Functions or have a basic familiarity with Excel.

 

  • Splitting windows

  • Freezing panes

  • Navigation techniques

  • Sorting a database

  • AutoFiltering a database

  • Working with tables

    • Creating tables

    • Formatting tables

    • Creating total rows

    • Adding calculated columns

    • Using Slicers

    • Adding new fields

  • Using advanced filters

  • Subtotaling a list

  • Creating database functions - DSUM, DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DGET

  • Creating PivotTables and PivotCharts

    • Rules for setting up a database

    • Modifying the format of Calculated Fields

    • Creating Calculated Items

    • Creating user-defined Calculated Fields

    • Using Slicers and Timelines

    • Creating Dashboards

    • Connecting Slicers to multiple PivotTables

    • Creating PivotCharts

    • Automatically adding new records to the source of data for the PivotTable

    • Refreshing PivotTables manually, upon file open and upon activating a sheet

 

Top

Microsoft Excel®: Recording Macros and Creating Forms

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is helpful to have taken Microsoft Excel: Basic Formulas & Functions or have a basic familiarity with Excel.

 

  • Creating Macros

    • Recording a macro

    • Using absolute and relative references when recording a macro

    • Running macros from the macro dialog box

    • Running macros using a button created by the user

    • Running macros using shortcut keys

    • Creating a macro button on the Quick Access Toolbar

    • Creating a custom menu item on the toolbar

    • Viewing the VBA code

    • Making minor modifications to the VBA code

    • Assigning shortcut keys to existing macros

  • Creating Forms

    • Adding labels

    • Adding group boxes

    • Adding buttons

    • Adding check boxes

    • Adding option buttons

    • Adding list boxes

    • Adding combo boxes

    • Adding scroll bars

    • Adding spinners

    • Toggling the grid

Top

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Microsoft Excel®: Microsoft Excel Shortcuts

3 Hours

Prerequisites: This course is most useful for people who already use Excel but feel that there must be a faster way to get things done.

  • Using AutoFill to extend a series

  • Using Flash Fill to separate, join or format text and numbers

  • Entering the current date and time with the keyboard

  • Entering information into several cells at the same time

  • Selecting an entire column

  • Selecting an entire row

  • Selecting the entire sheet

  • Selecting a block of information

  • AutoFit a column

  • AutoFitting an entire spreadsheet

  • The Mini Toolbar

  • Entering formulas into multiple cells at the same time

  • Finding formulas and finding constants

  • Displaying all the formulas in a spreadsheet at the same time

  • Quickly navigate to different sheets

  • Quickly navigate to a specific sheet

  • Comparing values in a row or column to the first value in the row or column

  • Transposing data

  • Erasing cell contents with the mouse

  • Changing cell orientation

  • ®, ™ and © symbols

  • Putting frames on pictures

  • Copying equations down as far as there is data in the column next to it

  • Copying down and copying right

  • Moving down one screen or one screen to the right

  • Creating a new worksheet

  • Scrolling quickly

  • Navigating to a specific cell quickly

  • Changing the default number of worksheets in a new file

  • Copying formatting from one location to one or more locations

  • Entering fractions

  • Adding and removing borders with the keyboard

  • Drawing perfect objects

  • Navigating and selecting a block of data

  • Freezing the first row or column of a list

Top

 

Microsoft Excel®: Introduction to Microsoft Excel

6 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • Understanding the user interface

  • Customizing the user interface

  • Navigating a spreadsheet quickly

  • Entering and editing text

  • Backspace vs. delete

  • Deleting data

  • Modifying alignment

  • Moving and copying data

  • Undo and Redo

  • Using the Autofill handle

  • Creating formulas

    • Adding, subtracting, multiplying and dividing

    • Using cell references and range references

  • Creating Basic Functions

    • SUM

    • MAX

    • MIN

    • AVERAGE

    • COUNT

    • COUNTA

  • Using AutoFill to copy formulas or extend a series

  • The Order of Operations

  • Finding and replacing information on the spreadsheet

  • Understanding relative and absolute references

  • Displaying formulas on a worksheet

  • Formatting a spreadsheet

    • Changing fonts

    • Formatting numbers as currency

    • Centering text across columns

    • Adding headers and footers

    • Changing the orientation of the page

    • Applying borders

  • Printing a spreadsheet

 

Top

Microsoft Excel®: Intermediate Microsoft Excel

6 Hours

 

  • Working with named ranges

  • Inserting and formatting graphics

  • Creating charts

    • Modifying charts

    • Formatting charts

    • Changing chart types

  • Creating calculations across sheets

  • Using more advanced functions

  • Splitting windows

  • Freezing panes

  • Working with tables

    • Creating tables

    • Formatting tables

    • Creating total rows

    • Adding calculated columns

    • Using Slicers

    • Adding new fields

  • Creating PivotTables and PivotCharts

    • Rules for setting up a database

    • Modifying the format of Calculated Fields

    • Creating Calculated Items

    • Creating user-defined Calculated Fields

    • Using Slicers

    • Creating Dashboards

    • Connecting Slicers to multiple PivotTables

    • Creating PivotCharts

    • Automatically adding new records to the source of data for the PivotTable

    • Refreshing PivotTables

  • Working with Themes

    • Applying Themes

    • Creating your own Theme

  • Working with Templates

  • Understanding Excel options

 

Top

 

Microsoft Excel®: Advanced Microsoft Excel

6 Hours

 

  • Applying a password to open or modify a spreadsheet

  • Allowing users to edit ranges with passwords

  • Applying conditional formatting

  • Using data validation to restrict data entry

  • Creating drop-down lists

  • Auditing a spreadsheet

    • Displaying formulas

    • Tracing precedents and dependents

    • Creating a Watch Window

    • Evaluating formulas

    • Using automatic and manual calculation options

  • Creating sparklines

  • Using the Scenario Manager

  • Using Goal Seek

  • Creating custom lists

  • Creating custom views

  • Creating one way and two way Data Tables

  • Removing duplicates

  • Using the Analysis ToolPak

  • Linking cells (DDE)

    • Creating a link using an equation

    • Creating a link using paste special

    • Linking from Microsoft Excel to Microsoft Word

  • Embedding programs (OLE)

    • Embedding an Excel spreadsheet inside a Word document

 

Top

Microsoft Excel®: Excel Visual Basic for Applications (VBA)

12 Hours over 2 Days

This class is a programming class. Students should be proficient in using Microsoft Excel before taking this class.

 

  • Chapter 1 - Getting started

    • Introducing Excel VBA

    • Macros

    • The Developer Ribbon

    • Recording a macro using Absolute and Relative references

    • Recording an Absolute Macro

    • Running a macro using the ribbon

    • Running a macro using a shortcut key

    • Creating an icon on the Quick Access Toolbar to run a macro

    • Adding a command button to run a macro

    • Recording a Relative Macro

    • Viewing the Visual Basic for Applications (VBA) code

    • Editing a macro in the VBA Editor     

    • Understanding the development environment

    • The Object Browser   

    • Using Visual Basic Help

    • Closing the Visual Basic Editor

  • Chapter 2 - Working with procedures and functions

    • Understanding modules

    • Creating a Standard Module

    • Understanding procedures    

    • Creating a Sub Procedure

    • Calling Procedures from inside other procedures

    • Using the Immediate Window

    • Creating a Function Procedure

    • Naming procedures   

    • Working with the Code Editor

    • Colors used in coding

    • Using capitalization while coding     

    • Setting Code Editor Options

    • Code settings

    • Window settings

    • Guidelines for editing code

    • Commenting code

    • Finding code 

    • Complete Word feature

Chapter 3 - Understanding objects

  • Understanding objects
    • Navigating the Excel Object Hierarchy

    • Understanding collections

    • Using the Object Browser

    • Working with properties

    • Using the With Statement

    • Working with methods

    • Creating an Event Procedure

  • Chapter 4 - Using expressions, variables, and intrinsic functions

    • Understanding expressions and statements

    • Declaring variables

    • Explicit vs. implicit variable declaration

    • Working with Declaration Statements

    • Working with variable scope

    • Naming variables

    • Understanding Data Types    

    • Creating an Assignment Statement

    • Using intrinsic functions

    • Understanding constants

    • Using intrinsic constants

    • Using Message Boxes

    • Using Input Boxes

    • Declaring and using Object Variables

  • Chapter 5 – Controlling program execution

    • Understanding control-of-flow structures

    • Working with Boolean expressions

    • Comparison Operators and Logical Operators (Keyword Operators)           

    • Using the If…End If decision structures

    • If…Then Statements

    • If…Then…Else Statements

    • Using the Select Case…End Select structure

    • Using the Do…Loop structure

    • Using the For…To…Next structure

    • For…Next Statements

    • Using the For Each…Next structure

    • Guidelines for use of control-of-flow structures

  • Chapter 6 - Working with forms and controls

    • Understanding UserForms

    • Using the Toolbox

    • Working with UserForm properties, events and methods

    • Understanding controls

    • Setting control properties in the Properties Window

    • Working with the Label Control

    • Working with the Text Box Control

    • Working with the Command Button Control

    • Working with the Combo Box Control

    • Populating a control

    • Working with the Frame Control

    • Working with Option Button Controls

    • Working with control appearance

    • Setting the tab order

    • Adding code to controls

    • Launching a form in code

  • Chapter 7 - Working with the PivotTable object

    • Understanding PivotTables

    • Creating a PivotTable

    • Working with the PivotTable Wizard method

    • Working with PivotFields

    • Assigning a procedure to a custom toolbar

  • Chapter 8 - Debugging Code

    • Understanding errors

    • Using debugging tools

    • Setting Breakpoints

    • Stepping through code

    • Using Break Mode during Run Mode

    • Determining the value of expressions

  • Chapter 9 - Handling errors

    • Understanding error handling

    • Understanding VBA’s error trapping options

    • Trapping errors with the On Error statement

    • Understanding the Err object

    • Writing an error-handling routine

    • Working with inline error handling

 

Top

Microsoft Internet Explorer®/Edge: Surfing and Searching the Internet

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

 

  • History of the internet

  • Accessing sites using the Run command

  • The combo Address/Search bar

  • Icons in the address bar

  • Selecting a new default search provider

  • Adding search providers and picking them on the fly

  • Home, Favorites and Tools icons

  • Favorites

    • Adding favorites to favorites list and favorites bar

    • Organizing favorites

    • Sorting favorites

  • Zooming (including zooming shortcut keys)

  • Displaying Menu Bar (permanently and temporarily), Favorites Bar, Command Bar

  • Internet Options

    • Setting one or more Home pages

    • History settings

    • AutoComplete settings

  • Tabs

    • Shortcuts to move between tabs, select a tab by number, close a tab, create a tab

    • Reordering tabs

    • Duplicating tabs

    • Putting tabs in their own windows and using aero snap to tile them

    • Enabling Quick Tabs

    • Putting a shortcut to a page on the taskbar

    • Pinning sites to the IE taskbar icon

  • Security

    • Using InPrivate browsing

    • Deleting browsing history

    • Identifying whether a site is encrypted

    • Identifying the actual address of a site to make sure it’s not a masked phishing site

  • Newsgroup Netiquette

  • Searching

    • Effective search techniques

    • Advanced searches

    • Google search operators (+ - ~ …)

    • Accessing Google Search Help

    • Image searches

  • Search Exercise

  • Keyboard shortcuts

Top

 
 

Microsoft OneDrive®: Getting Started with OneDrive

90 Minutes

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • What is Microsoft OneDrive?

  • Benefits of Microsoft OneDrive

  • Accessing OneDrive

    • Accessing OneDrive from File Explorer

    • Accessing OneDrive from Microsoft Office Programs

    • Accessing OneDrive from Microsoft Office 365

  • Getting OneDrive on Your Devices

  • Uploading Files to OneDrive from Microsoft Office 365           

  • Uploading Folders from Microsoft Office 365

  • Opening Files from within Office 365

  • Renaming Files from within Office 365   

  • Copying Files from within Office 365       

  • Downloading Files from within Office 365

  • Deleting Files from within Office 365

  • Displaying Version History and Working with Versions

  • Sorting Files in Office 365

  • Viewing Files with Tile Previews

  • Displaying Recent File Activity

  • Searching for Files

  • Filtering Search Results

  • Clearing Search Filters

  • Sharing Documents from Within Office 365

  • Microsoft OneDrive Shortcut Keys

Top

Microsoft OneNote®: Getting Started with OneNote

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • What is OneNote?

  • Ways people use OneNote

  • The OneNote hierarchy

  • Creating a new notebook

  • The Notebook Properties dialog box

  • Creating a section Group

  • Creating a new section

  • Renaming a section

  • Moving a section into a section Group

  • Changing the color of a section

  • Moving a section

  • Deleting a section

  • Adding text to a page

  • Creating a bulleted or numbered list

  • Changing Text Attributes

  • Applying a style to text

  • Highlighting text

  • Aligning text

  • Handwriting

  • Customizing a pen type

  • Converting handwriting to text

  • Working with note containers

  • Spelling

  • Inserting a table

  • Inserting and removing rows and columns from a table

  • Inserting a graphic

  • Inserting a screen capture

  • Inserting web content

  • Inserting mathematical functions

  • Inserting a line or shape

  • Modifying a line or shape

  • Inserting a link

  • Attaching a file

  • Inserting the date and time

  • Inserting an equation

  • Inserting a symbol

  • Recording an audio clip

  • Previewing and printing a note page

  • Searching

  • Working with Outlook

  • Emailing a Page

  • Assigning a task in Outlook

  • Inserting meeting details into OneNote

  • Sending an email to OneNote

  • Inserting a new Page

  • Page Templates

  • Working with subpages

  • Adding or removing space from a page

  • Password protecting a section

Top

Microsoft Outlook®: Getting Started with Microsoft Outlook

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • What is Outlook?

  • Parts of the screen

    • The Navigation Pane

    • The Message List

      • Compact View vs. Single View

      • Message Preview

    • The Reading Pane

      • Reading pane options

    • The Calendar and Task Panes

  • Marking messages as read or unread

  • Filtering for unread messages

  • Searching mail

  • Sorting messages

  • Working with folders

    • Creating folders

    • Rearranging and sorting folders

    • Adding and removing folders from Favorites

  • Searching for files, appointments, meetings, notes, contacts and tasks

  • Creating a message

    • Addressing a message

    • CC, BCC

    • Checking spelling

    • Message Options

    • Read and delivery receipts

    • Importance

    • Sensitivity

    • Delay delivery

    • Direct replies to someone else

    • Voting buttons

    • Saving sent items in a particular folder

  • Working with attachments

    • Creating attachments

    • Previewing attachments

    • Saving attachments

  • Working with categories

    • Creating categories

    • Sorting by category

    • Filtering by category

  • Working with the calendar

    • Working with calendar views

    • Navigating within a calendar

    • Setting calendar options

    • Creating appointments

    • Deleting appointments

    • Entering recurring appointments

    • Creating and sending a meeting request

    • Checking to see an invitee's availability

    • Printing a calendar

  • Creating a contact card

  • Creating tasks

    • Creating and sending a task request

  • Creating notes

  • Using and modifying Outlook Today

 

Top

Microsoft Outlook®: Useful Features in Microsoft Outlook

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, take Microsoft Outlook: Getting Started with Microsoft Outlook or have equivalent training or experience with Microsoft Outlook.

 

  • Creating items based on other items

  • Creating search folders and other advanced search techniques

  • Filtering options

  • Forwarding emails as attachments

  • Working with conversations

  • Setting out of office messages

  • Recalling a message

  • Creating hyperlinks

  • Creating an AutoSignature

  • Flagging messages for follow-up

  • Creating contact groups

  • Forwarding and sharing contacts

  • Working with other people's calendars

  • Overlaying calendars

  • Setting up delegate access

  • Working with other Microsoft Office applications

  • Working with Permissions

  • Understanding options

  • Creating your own views

  • Sending vCards

  • Working with Quick Steps

  • Setting up Rules

  • Archiving

 

Top

Microsoft PowerPoint®: Getting Started with Microsoft PowerPoint

3 Hours

6 Hour Format Titled Introduction to PowerPoint

 

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • Starting PowerPoint

  • Adding a title and subtitle

  • Editing and formatting text

  • Resizing text placeholders

  • Saving a presentation

  • Opening and closing a presentation

  • Shortcuts for creating a new presentation and new slides

  • Creating bulleted and numbered lists

  • Changing bulleted symbols

  • Creating tables

  • Creating charts

  • Creating SmartArt Graphics

  • Inserting and modifying video files and online videos

  • Moving from slide to slide

  • Working with views

  • Using drawing tools

  • Drawing “Perfect” objects

  • Resizing an object around a point

  • Grouping objects

  • Rotating objects

  • Stacking objects with Bring Forward/Send to Back

  • Spell checking

  • Printing

  • Inserting pictures

  • Presentation guidelines

  • Running a slide show

 

Top

Microsoft PowerPoint®: Useful Features in PowerPoint

3 Hours

6 Hour Format Titled Advanced PowerPoint

 

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment and Microsoft PowerPoint: Creating Effective Presentations or equivalent training or experience working with Microsoft PowerPoint.

 

  • Using guidelines

  • Creating bulleted and numbered lists

  • Using transitions

  • Applying a theme

  • Creating a template

  • Using slide masters to change a number of slides at the same time

    • Modifying the slide master

    • Creating your own layouts

    • Canceling the slide master for one page

  • Adding page numbers

  • Changing the color scheme of one slide

  • Inserting an outline from Microsoft Word

  • Replacing fonts throughout a presentation

  • Creating tables

  • Enhanced drawing

  • Duplicating objects

  • Rotating and flipping objects

  • Aligning objects

  • Changing AutoShapes

  • Grouping and ungrouping objects

  • Using the Format Painter

  • Creating and editing graphs

  • Changing layouts

  • Importing a Microsoft Excel spreadsheet

  • Importing a chart

  • Linking a spreadsheet

  • Working with graphics

    • Recoloring and cropping graphics

  • Creating Speaker Notes

  • Working with the Handout Master

  • Applying slide transitions

  • Tricks while running a slide show

    • Hiding slides

    • Using a pen to annotate a presentation

    • Using a laser pointer

    • Pausing during a slide show

    • Blacking out or whiting out the presentation

    • Stopping and starting an automatic show

  • Branching to other presentations

  • Customizing the ribbon

  • Understanding PowerPoint Options

  • Changing the default presentation

  • Animating slides

  • Creating custom layouts

 

Top

Microsoft Office: Tips, Tricks & New Features in Word, Excel, PowerPoint and Outlook

3 Hours

This class is designed for people who regularly work in an older version of these products but would like to learn the new features of the version they currently use.

 

The topic list for this class is dependent on which version the student has moved from and which version they are moving to.

 

Top

Microsoft Project®: Getting Started with Microsoft Project

6 Hour and 12 Hour Formats Available

 

Note: The 12 hour format is very popular because it includes a thorough review of topics covered on the first day and includes a module where students build their own practice projects from scratch!

 

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • The history of modern project management

  • Benefits and limitations of using project management software

  • Steps to building a project

  • Getting help

  • Sizing columns

  • Displaying the task form

  • Toggling between active/Inactive panes

  • Entering tasks

  • Entering durations

  • Saving

  • Creating milestones

  • Creating summary tasks

  • Outlining

  • Obtaining project status

  • Linking

  • Setting up relationships

  • Slack, lag and lead

  • Formatting text

  • Displaying the critical path in the Gantt chart

  • Task information

  • Working with the Network Diagram

  • Using the mouse in the Gantt chart

  • Creating a resource pool

  • Sorting a list

  • Modifying the task entry form to include initials

  • Assigning resources

  • Understanding the Standard calendar

  • Creating a base calendar

  • Altering resource calendars

  • Identifying overallocations

  • Remedying overallocations

  • Setting the baseline

  • Entering actual dates

  • Displaying the Tracking Gantt view

  • Printing

  • Reports

 

Top

Microsoft Project®: Advanced Features

6 Hours

 

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is highly recommended that you take Microsoft Project: Creating a Project.

 

  • Review of building a project

  • Entering actual dates

  • Rescheduling part of a project

  • Using the Tracking Gantt view

  • Updating the entire project

  • Changing the current date and displaying it on the Gantt chart

  • Updating tasks

  • Using additional baseline plans

  • Displaying multiple baselines in one view

  • Viewing progress in the Network Diagram

  • PERT analysis

  • Creating custom views

  • Creating custom reports

  • Creating custom filters

  • Adding customized items to the global template

  • Creating master projects consisting of sub projects

  • Understanding how adding or changing resources affects durations, work and units

  • Understanding options

  • Work contours

  • Creating links between projects

  • WBS

  • Formatting the Timescale

Top

Microsoft SharePoint® for End Users: Getting Started with Microsoft SharePoint

  • What is SharePoint and how is it used?

  • Accessing SharePoint Online

  • Sites

    • Accessing SharePoint sites

    • Navigating SharePoint sites

    • Creating a subsite

    • Following a site

    • Using Alerts to notify changes were made

    • Sharing a site

  • Libraries and Documents

    • Creating a library

    • Uploading a document to a library

    • Retrieving a document from a library

    • Sharing a document in a library

    • Creating a document in a library

    • Using breadcrumb navigation

    • Checking a document in and out of a library

    • Moving and copying documents

    • Deleting a document from a library

    • Using Versioning

    • Following a document

    • Sharing a document

    • Sharing a folder

  • Searching

    • Searching for a document

    • Searching for content

    • Searching for people

    • Updating your profile

    • Using smart filters to find files or list items

  • Pages

    • Creating Wiki pages

    • Working with Web Part pages

  • Custom Lists

    • Creating a list

    • Adding items to a list

    • Deleting items from a list

    • Modifying items in a list one at a time

    • Using Quick Edit to modify items in a list

    • Creating a new column for a list

    • Creating a calculated field

    • Validating info added to a list

    • Creating a Lookup field

    • Sorting a list

    • Filtering a list

    • Grouping items in a list and expanding and collapsing the groupings

    • Exporting a list to Excel

    • Importing an Excel spreadsheet range as a list

    • Sharing a list

  • List and Library Views

    • Creating a view

    • Make a view the default public view

    • Adding an existing column to a view of the list

    • Creating a public view

  • Tasks

    • Adding a task app

    • Adding a task

    • Modifying a task

    • Viewing a task list

    • Marking task completion

    • Deleting a task

  • Blogs

    • Creating and managing a blog

    • Creating a post

    • Adding categories

    • Breaking inheritance from the parent site for a blog

    • Creating unique permissions for lists and libraries in a blog

    • Changing a blog post layout

  • Calendars

    • Creating a calendar

    • Adding events to the calendar

    • Deleting events

    • Attaching files to events

    • Day, Week and Month views

    • Moving events with drag and drop

  • Apps

    • Adding an app to a site

    • Adding an app part to a page

  • Permissions

    • Editing and managing permissions for a list or library

Top

Microsoft Skype for Business®: Getting Started with Skype for Business

90 Minutes

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • The Skype Window

  • Signing in

  • Setting your presence status

  • Adding a personal note

  • Setting your location

  • Navigating in Skype

  • Adding a contact from your organization

  • Adding a contact from outside your organization

  • Deleting a contact

  • Using contact groups

    • Creating a new group

    • Adding contacts to groups

    • Deleting a contact group

  • Contact views

  • Changing the privacy relationship

  • Using the Quick Launch Bar

  • Sending an Instant Message

  • Using tabbed conversations

  • Using Persistent Chat

    • Chat room privacy settings

    • Following a chat room

    • Managing a chat room

    • Topic feeds

    • Disabling a chat room

  • Skype Meetings

    • Scheduling a meeting in Skype

    • Scheduling a meeting in Skype with your Outlook calendar

    • Joining a scheduled meeting

    • Participating in a meeting

    • Adding Users to a meeting    

    • Presenting content in meetings

    • Sharing an attachment

    • Downloading meeting content

  • Sharing a PowerPoint presentation and annotating the presentation

    • Select who can view your presentation privately

  • Using the whiteboard

  • Creating polls

  • Using Q&A

  • Using private and shared meeting notes (OneNote Notes)

  • Setting presenter meeting options

  • Skype phone calls

    • Placing a call

    • Muting a call  

    • Putting a call on hold

    • Transferring a call

    • Answering an incoming call

    • Starting a conference call    

    • Adding a phone

    • Adjusting audio and visual settings

  • Using video calling   

  • Tagging for status change alert

 

Top

Microsoft Teams®: Getting Started with Microsoft Teams

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • What is Microsoft Teams?

  • How is Microsoft Teams Useful?

  • Online, Desktop and Mobile Versions

  • The Interface

  • Availability

    • Changing Your Availability

    • Changing Your Profile Picture

  • Teams

    • Creating Your First Team

    • Creating Additional Teams

    • Renaming a Team

    • Adding Members to Existing Teams

    • Alerting Members that You Have Created a Team

    • Reordering Teams in the Team List

    • Making Someone a Team Owner

    • Removing Members from a Team

    • Locating and Joining a Team

    • Joining a Suggested Team

    • Listing Team Members

    • Changing a Team from Public to Private or Vice Versa

    • Adding Guests to a Team

    • Setting Member and Guest Permissions

    • Determining If Your Team Has Guests

    • Showing and Hiding a Team

    • Activity Notifications

    • Learning More about a Team Member

    • Determine Which Teams You are a Member Of

    • Changing the Picture for a Team

    • Leaving a Team

    • Deleting a Team

    • Restoring a Deleted Team

  • Channels

    • Creating a New Channel

    • Renaming a Channel

    • Adding Members to a Channel

    • Alerting Members that You Have Created a Channel

    • Expanding the Compose Box

    • Changing Font Size

    • Formatting Options

    • Adding Pictures or Other Files to a Channel

    • Adding an Emoji to a Channel

    • Adding a GIF to a Channel

    • Adding a Sticker or Meme to a Channel

    • Adding a Caption to a Sticker or Meme

    • Editing a Message

    • Deleting a Message

    • Forwarding Email to a Channel

    • Setting Up a Meeting from Within a Channel

    • Deleting a Channel

    • Restoring a Deleted Channel

    • Bots

    • Apps

    • Connectors

    • Saving Messages In a Channel (Formerly Known As Bookmarks)

  • Marking Messages as Read/Unread

  • @Mentions

  • Chats

    • Creating a New One-On-One Chat

    • Creating a New Group Chat

    • Adding Someone to a Chat

    • Adding a Chat to Favorites

    • Removing a Chat from Favorites

    • Determining Who Is In a Group Chat

    • Leaving a Group Chat

    • Renaming a Chat

    • Chat History

    • Liking a Chat

  • Meetings

  • Working with Files

    • Creating a New File from Within Teams

    • Uploading Files to Teams

    • Uploading Files Using Drag and Drop

    • Deleting Files from Teams

  • Wikis

    • Creating a Wiki

    • Creating a New Wiki Section

    • Reordering Sections

    • Deleting a Section

    • Searching Within a Wiki

  • Adding Tabs

  • Adding A Word Document to a Tab

  • Adding A Website to a Tab

  • Adding OneNote to a Tab

  • Staying Up to Date with Your Team

  • The Activity Tab

    • Activity Feed Symbols

    • The Activity Feed Filter

  • Managing a Team

  • Frequently Asked Questions (FAQs)

    • Why Can’t I Change Team Settings?

    • Why Can’t I Create a Team?

    • Who Can See What I Post in a Channel

    • If I Add Someone to a Chat, Will They See What Was Previously Typed?

    • Can I Remove Someone from a Group Chat?

    • Can I Delete a Conversation?

    • Can I Turn Off Chat History

    • Can Private and Group Chats have subject lines?

  • The Command Box

  • Accessing Teams on Other Devices

  • Security on Teams

  • Accessing Help

  • Microsoft Teams Shortcut Keys

Top

Microsoft Visio®: Getting Started with Microsoft Visio

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • What is Visio?

  • Important terminology

    • Diagrams

    • Shapes

    • Masters (AKA Stencil Masters)

    • Stencils

    • Templates

  • Modifying the workspace

    • Shape views

    • Floating and docking stencil windows

    • The Favorites Stencil

      •  Displaying the Favorites stencil

      • Adding a stencil master to favorites

      • Removing a stencil master from favorites

  • Drawing tools

    • Rectangle tool

    • Ellipse tool

    • Line tool

    • Arc tool

    • Freeform tool

    • Pencil tool

  • Working with the zoom level

    • Changing the zoom percentage

    • Magnification tricks

  • Working with shapes

    • Basic Shapes stencil

    • Selecting shapes

    • Resizing a shape

    • Modifying a shape

    • Selecting multiple shapes at one time

    • Selecting shapes partially within the selection area

    • Selecting overlapping shapes

    • Selecting objects by type

    • Adding text to a shape

    • Rotating a shape

    • Rotating a shape that contains text

    • Adding ScreenTips to shapes

    • Formatting text

    • Moving shapes

    • Copying shapes

    • Aligning shapes

    • Manually aligning shapes

    • Using Dynamic Grid

    • Distributing shapes

    • Grouping and ungrouping shapes

    • Changing the order of shapes

  •  Connecting shapes

    • Creating Point to Point connections

    • Creating Shape to Shape connections

    • Creating a Shape to Point or Point to Shape connection

    • Ungluing a connector from a shape

    • Switching from any tool back to the Pointer tool

    • AutoConnect

    • Changing the shape of connectors

    • Resetting a connector

    • Adding arrows and other shapes to the end of connectors

    • Changing the thickness, color, type and curvature of a connector

    • Creating and using custom connectors

  • Printing a drawing

  • Working with pages

    • Creating additional pages

    • Deleting pages

    • Renaming pages

    • Reordering pages

    • Moving between pages

  • Creating a Decision Branch Flowchart

  • Creating an Organizational Chart

 

Top

Microsoft Visio®: Useful Features in Microsoft Visio

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. It is
also highly recommended that you take Microsoft Visio: Getting Started with Microsoft Visio or have equivalent training or experience working with Visio.

 

  • Callouts

    • Associating a callout with a shape

    • Changing the callout style

    • Moving a callout

    • Unassociated callouts

    • Callouts from previous versions of Visio

  • Line jumps

  • Themes

  • Containers

    • Creating an empty container

    • Adding a shape to a container.

    • Putting a container around existing shapes

    • Formatting a container

  • Using a shape to access another page

  • Accessing a page with an off-page reference

  • Accessing a page with a hyperlink

  • Shape behaviors and abilities

  • Using headers and footers

  • Saving a drawing as a web page

  • Saving a drawing as a graphic file

  • Changing the drawing scale

  • Determining width, height or angle of an object

  • Displaying height, width or angle with a geometry field

  • Displaying height or width with a dimensioning Tool

  • Slide snippets

  • Using the Pencil tool to create your own shapes from existing shapes

  • ShapeSheets

    • Displaying the ShapeSheet

    • Changing the values in a ShapeSheet

    • Using formulas in ShapeSheets

  • Creating and using custom templates

  • Creating a Brainstorming Diagram

  • Creating a Cross Functional Flowchart

 

Top

Microsoft Windows 10®: Getting Started with Windows 10

3 Hours

Prerequisites: There are no prerequisites for this class.

 

  • Getting Help

  • Personalizing the Desktop

  • Working with the Start Menu

    • Pinning apps to the Start Menu

    • Pinning apps to the Taskbar

    • Jump lists

    • Working with tiles

    • Group and title tiles

    • Resize the tile area

    • Make the Start Menu full screen

  • Creating shortcuts on the Desktop

  • Moving and resizing windows

  • Displaying multiple windows at the same time

  • Switching between windows

  • Using a mouse

  • Arranging icons

  • Using Auto Arrange

  • Minimizing, maximizing and restoring windows

  • Closing windows

  • Cascading and tiling windows

  • Task View (Multi-App View)

  • File Explorer
  • The Action Center
    • Airplane mode

    • Brightness

    • Focus Assist

    • Project

    • Screen Snip

    • Tablet mode

  • Setting screen resolution

  • Organize email accounts in one place

  • Cortana

  • Windows Store

  • Photos App

  • Windows Media Player

  • Deleting files/emptying the Recycle Bin

  • Using Aero features

    • Aero Peek

    • Aero Shake

    • Aero Snap

  • Using the Run Command

  • Using the Clock

  • Using the Calculator

  • Using WordPad

  • Using Paint

  • Changing views

  • Finding files

  • Setting default printers

  • Changing Mouse Properties

  • Shutting down

  • Working with the Task Bar

  • Windows shortcut keys

Top

Microsoft Word®: Getting Started with Microsoft Word

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • Becoming familiar with the environment

  • Using Backspace and Delete

  • Using Insert and Overtype modes

  • Inserting hard and soft returns

  • Viewing formatting symbols

  • Saving files

  • Previewing a document

  • Editing in Print Preview

  • Printing

  • Working with views

  • Formatting

    • Formatting characters

    • Formatting paragraphs

    • Formatting documents

  • Indenting paragraphs

  • Using Undo and Redo

  • Using the Spell Checker

  • Using the Thesaurus

  • Using the Research Task Pane

  • Finding text

  • Replacing text

  • Moving and copying text

  • Adding headers and footers

  • Inserting bullets and numbering

Top

Microsoft Word®: Tabs, Tables, Graphics & Desktop Publishing

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is recommended that you take Microsoft Word: Getting Started with Microsoft Word or have equivalent training or experience with Microsoft Word.

 

  • Tabs

    • Setting tabs

    • Moving tabs

    • Removing tabs

    • Setting tab leaders

  • Tables

    • Creating tables

    • Formatting tables

    • Adding and deleting rows and columns

    • Inserting formulas in tables

    • Merging cells

    • Drawing unconventional tables

  • Inserting blank Excel spreadsheets

  • Creating newspaper columns

  • Inserting and deleting page breaks and column breaks

  • Working with graphics

    • Inserting graphics

    • Resizing a graphic

    • Wrapping text around graphics

    • Adding and editing WordArt

    • Inserting SmartArt graphics

  • Creating and applying styles

  • Inserting hyperlinks

 

Top

Microsoft Word®: Creating Forms, Mail Merges, Envelopes and Labels

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is recommended that you take Microsoft Word: Getting Started with Microsoft Word or have equivalent training or experience with Microsoft Word.

 

  • Inserting tables

  • Building forms

    • Adding a rich text content control

    • Adding a plain text content control

    • Adding a picture content control

    • Adding a combo box content control

    • Adding a drop down list content control

    • Adding a building block gallery control

    • Working with Legacy tools

    • Adding instructional text to the form

    • Protecting parts of a form

    • Preparing a form to be filled out

  • Setting up mail merges

    • Displaying the mail merge toolbar

    • Creating a new data source

    • Selecting an existing data source

    • Creating a mail merge letter

    • Creating a single label

    • Creating many labels at the same time

    • Creating a single envelope

    • Creating many envelopes at the same time

    • Creating a directory

 

Top

Microsoft Word®: Working with Long Documents

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is recommended that you take Microsoft Word: Getting Started with Microsoft Word or have equivalent training or experience with Microsoft Word.

 

  • Cursor movement

  • Highlighting text

  • Splitting windows

  • Working with page breaks and section breaks

  • Using bookmarks

    • Creating bookmarks

    • Locating a bookmark

  • Browsing by object

  • Using built-in styles

  • Using find and replace with styles

  • Adding borders to a paragraph

  • Working with multiple documents

  • Copying text between documents

  • Scroll bar screen tips

  • Working with Outline View

  • Reducing the size of graphic content

  • Creating a Table of Contents

  • Creating an Index

  • Creating hyperlinks within a document

 

Top

Microsoft Word®: Recording Macros and Using Automation Shortcuts

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is recommended that you take Microsoft Word: Getting Started with Microsoft Word or have equivalent training or experience with Microsoft Word.

 

  • Modifying the Quick Access Toolbar

  • Using AutoCorrect and AutoFormat

    • Examples of AutoCorrect

    • Disabling AutoCorrect/AutoFormat options and adding entries

  • Pagination options

    • Other break options

  • Headers and footers

  • Inserting symbols and equations       

  • Inserting hyperlinks    

  • Fast formatting

    • The Format Painter

    • Styles

    • Using built-in styles    

    • Creating your own styles

    • Themes

    • Replacing formatting using find and replace

  • Automatically adding elements to a document

    • Inserting cover pages

    • Working with Quick Parts

  • Creating templates

  • Working with macros

    • Recording a macro

    • Running a macro

    • Add a macro icon to the Quick Access Toolbar

    • Viewing the Visual Basic for Applications code

 

Top

Microsoft Word®: Useful Features in Microsoft Word

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is
highly recommended that you take Microsoft Word: Getting Started with Microsoft Word or have equivalent training or experience with Microsoft Word.

 

  • Creating bookmarks

  • Creating hyperlinks

  • Inserting drop caps

  • Working with the research task pane

  • Looking up words

  • Counting words in a document

  • Changing the case of words

  • Working with Full Screen view

  • Viewing thumbnails

  • Adding footnotes and endnotes

  • Working with floating menus

  • Revealing formatting

  • Copying paragraph marks

  • Adding borders to a paragraph

  • Inserting symbols

  • Searching for a file with basic file search

  • Editing and viewing summary info

  • Protect a document with a password

  • Customizing the Quick Access Toolbar and ribbons

  • Creating a table of contents

  • Creating an index

  • Creating diagrams

  • Using comments

  • Tracking Changes

 

Top

Microsoft Word®: Introduction to Microsoft Word

6 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • Becoming familiar with the interface

  • Using Backspace and Delete

  • Using Insert and Overtype Modes

  • Inserting hard and soft returns

  • Viewing formatting symbols

  • Saving files

  • Previewing a document

  • Printing

  • Working with views

  • Cursor movement

  • Highlighting text

  • Formatting

    • Formatting characters

    • Formatting paragraphs

    • Formatting documents

  • Using Undo and Redo

  • Reverting character and paragraph formatting to defaults

  • Using the Spell Checker

  • Working with the Smart Lookup

  • Finding synonyms

  • Finding and replacing text

  • Working with graphics

  • Moving and copying text

  • Working with multiple documents

  • Moving and copying text between documents

  • Adding Headers and Footers

  • Inserting bullets and numbering

  • Splitting windows

  • Using bookmarks

    • Creating bookmarks

    • Locating a bookmark

    • Creating links to bookmarks

  • Browsing by object

  • Using built-in styles

  • Using find and replace with styles

  • Adding borders to a paragraph

  • Reducing the size of graphic content

  • Inserting drop caps

  • Creating hyperlinks within a document

 

Top

Microsoft Word®: Intermediate Microsoft Word

6 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is recommended that you take Microsoft Word: Introduction to Microsoft Word or have equivalent training or experience with Microsoft Word.

  • Tabs

    • Setting tabs

    • Moving tabs

    • Removing tabs

    • Setting tab leaders

  • Tables

    • Creating tables

    • Formatting tables

    • Adding and deleting rows and columns

    • Inserting formulas in tables

    • Merging cells

    • Drawing unconventional tables

  • Inserting blank Excel spreadsheets

  • Creating newspaper columns

  • Wrapping text around graphics

  • Inserting and deleting page breaks and column breaks

  • Working with graphics

    • Inserting graphics

    • Resizing a graphic

    • Wrapping text around graphics

    • Adding and editing WordArt

    • Inserting SmartArt graphics

  • Creating and applying styles

  • Setting up mail merges

    • Displaying the mail merge toolbar

    • Creating a new data source

    • Selecting an existing data source

    • Creating a mail merge letter

    • Creating a single label

    • Creating many labels at the same time

    • Creating a single envelope

    • Creating many envelopes at the same time

    • Creating a directory

Top

Microsoft Word®: Advanced Microsoft Word

6 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it is recommended that you take Microsoft Word: Intermediate Microsoft Word or have equivalent training or experience with Microsoft Word.

  • Modifying the Quick Access Toolbar

  • Using AutoCorrect and AutoFormat

    • Examples of AutoCorrect

    • Disabling AutoCorrect/AutoFormat options and adding entries

  • Pagination options

    • Other break options

  • Headers and footers

  • Inserting symbols and equations        

  • Fast formatting

    • The Format Painter

    • Styles

    • Using built-in styles    

    • Creating your own styles

    • Themes

    • Replacing formatting using find and replace

  • Automatically adding elements to a document

    • Inserting cover pages

    • Working with Quick Parts

  • Creating templates

  • Working with macros

    • Recording a macro

    • Running a macro

    • Add a macro icon to the Quick Access Toolbar

    • Viewing the Visual Basic for Applications code

  • Counting words in a document

  • Changing the case of words

  • Working with Full Screen view

  • Viewing thumbnails

  • Revealing formatting

  • Copying paragraph marks

  • Inserting symbols

  • Searching for a file with basic file search

  • Editing and viewing summary info

  • Protect a document with a password

  • Customizing the ribbons

  • Creating diagrams

  • Using comments

  • Tracking Changes

  • Adding footnotes and endnotes

  • Creating a Table of Contents

  • Creating an Index

  • Building forms

    • Adding a rich text content control

    • Adding a plain text content control

    • Adding a picture content control

    • Adding a combo box content control

    • Adding a drop down list content control

    • Adding a building block gallery control

    • Working with Legacy tools

    • Adding instructional text to the form

    • Protecting parts of a form

    • Preparing a form to be filled out

 

Top

 

Novell GroupWise® 8.0

3 Hours

Prerequisites:  Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • Getting started with GroupWise

    • Working with the GroupWise interface

    • Exploring the GroupWise Help system

  • Working with messages

    • Reading email messages

    • Creating and sending messages

    • Routing slips

    • Working with the Advanced Message Options

    • Setting email properties

    • Working with attachments

    • Working with Sent Items

    • Retracting and resending

    • Reply to and forward a message

    • Creating and using signatures

  • Managing messages

    • Creating a Tasklist

    • Filtering items

    • Creating color-coded categories

    • Deleting items

    • Working with folders

    • Configuring Junk Mail Handling

    • Archiving messages

  • Working with address books

    • Sending messages using the Address Book

    • Creating a Mail Group

    • Working with contacts

  • Using the calendar

    • Working with the calendar

    • Scheduling posted appointments

    • Customizing the calendar

    • Creating and managing tasks

    • Working with reminder notes

    • Sharing calendars

    • Using Multi-User View

  • Using resources and Multi-User Views

    • Working with rules

 

Top

Sage Act!®: Getting Started with Sage Act!

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

 

  • What is Act!?

  • What can you do with Act!?

  • Getting help

  • Starting Act!

  • Understanding contact screens

  • Moving around the database

  • Working with toolbars

  • Adding a contact

  • Deleting a contact

  • Adding a contact with the same address

  • Entering information

  • Sorting contacts

  • Inserting notes

  • Deleting notes

  • Attaching files to a contact record

  • Printing address books for your contacts

  • Scheduling a call

  • Scheduling a meeting

  • Scheduling a to-do

  • Clearing activities

  • Writing a letter to the current contact

  • Calling the contact using the Auto Dialer

  • Viewing the contact list

  • Performing lookups

  • Grouping contacts

  • Viewing all or come activities with the task list

  • Defining user fields

  • Adding history

  • Using the Timer

  • Viewing and using calendars

  • Writing memos, fax cover pages, etc.

  • Creating reports

  • Modifying reports

  • Creating a new database

 

Top

Sage Act!®: Useful Features in Sage Act!

3 Hours

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment. Also, it
is highly recommended that you take Sage Act!: Getting Started with Sage Act! or have equivalent training or experience with Sage Act!.

 

  • Creating and using queries

  • Creating macros

  • Adding a macro to the toolbar

  • Importing and exporting data

  • Setting startup settings

  • Creating and modifying templates and mail merges

  • Customizing report templates

  • Performing system maintenance

  • Using internet links

 

Top

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Tableau: Getting Started with Tableau Desktop

12 Hours over 2 Days

Prerequisites: Microsoft Windows: Getting Started with Windows or equivalent training or experience working in the Windows environment.

  • Introduction

    • What is Tableau Desktop?

    • The types of visualizations you can create

    • The Tableau interface

    • The Data Window/Sidebar

    • Data Roles – Discrete versus Continuous

    • Understanding field colors and symbols

    • Understanding field icons

  • Working with imported data

    • Accessing your data from the program

    • Modifying imported data

    • Changing a measure to dimension or vice versa

    • Setting the default properties for a dimension

    • Setting the default properties for a measure

  • Creating Visualizations

    • Creating bar charts

    • Creating heat maps

    • Creating crosstabs

    • Adding row or column totals to crosstabs

    • Creating highlight tables

    • Creating pie charts

    • Creating tree maps

    • Creating histograms and bins

    • Creating combination charts        

    • Creating scatter plots

    • Creating motion charts

  • Modifying Visualizations

    • Replacing fields in a view        

    • Replacing an axis in a view with a different measure        

    • Swapping fields

    • Displaying titles,  captions and summaries

    • Displaying trend lines

    • Highlighting data with reference lines

    • Highlighting data with reference bands

    • Using the new Analytics Pane        

  • Sorting data

    • Applying computed sorts

    • Applying manual sorts        

    • Applying nested sorts

  • Filtering data

    • Displaying quick filters

    • Applying date filters

    • Applying relative date filters

    • Working with dates

    • Range of dates filter

    • Creating a starting or ending date filter

  • Hierarchies

    • Creating hierarchies

  • Groups

    • Creating regular groups

    • Creating visual groups

  • Sets

    • Creating sets

  • Working with Multiple Measures

    • Creating individual axes

    • Creating blended axes

    • Creating and color coding dual axes​​

  • Mapping

    • Creating a Map

    • Displaying map layers

    • Displaying data layers

    • Mapping Tips!

    • Removing a map background from a filled map

  • Calculated Fields

    • Creating a calculation

    • Important things to know about calculations

    • Editing a calculation

    • Concatenating text with a calculation

    • Converting data types with a calculation

    • Modifying dates with a calculation

    • Using logical functions in a calculation

    • Applying Quick Table calculations

  • Parameters

    • Creating and using parameters

  • Formatting Your View

    • Using the Marks card to apply formatting

    • Applying contextual formatting

  • Dashboards

    • Creating a Dashboard

    • Displaying a Title on a Dashboard

    • Renaming a Dashboard

    • Tiled or Floating Objects

    • Hiding a Worksheet

    • Adding an Image to a Dashboard

    • Using a Worksheet in the Dashboard as a filter (AKA Filter Actions)

Top

Cancellation policy: We must charge 100% for rescheduling or canceling within 5 business days.

    2020 Launch®. All rights reserved.