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
Bluebeam Revu
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
Google Chrome
Google Chrome: Surfing and Searching the Internet
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 Edge
Microsoft Edge: Surfing and Searching the Internet
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: Recording Macros and Creating Forms
Microsoft Excel: Microsoft Excel Shortcuts, Tips, and Tricks
Microsoft Excel: Introduction to Microsoft Excel
Microsoft Excel: Intermediate Microsoft Excel
Microsoft Excel: Advanced Microsoft Excel
Microsoft Excel: Excel Visual Basic for Applications (VBA)
File Explorer
Microsoft File Explorer: Getting Started with Microsoft File Explorer
Microsoft Forms
Microsoft Forms: Getting Started with Microsoft Forms
Microsoft OneDrive
Microsoft OneDrive: Getting Started with Microsoft OneDrive
Microsoft OneNote
Microsoft OneNote: Getting Started with Microsoft 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 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 Whiteboard
Microsoft Whiteboard: Getting Started with Microsoft Whiteboard
Microsoft Windows
Microsoft Windows 10/11: Getting Started with Microsoft Windows 10/11
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
Sage Act!
Sage Act!: Getting Started with Sage Act!
Sage Act!: Useful Features in Sage Act!
Tableau
Tableau: Getting Started with Tableau Desktop
Adobe Acrobat: Getting Started with Adobe Acrobat Reader DC
3 Hours
-
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 Loud
-
Rotating pages
-
Thumbnails, Bookmarks and Attachments
-
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
Adobe Acrobat: Getting Started with Adobe Acrobat Pro DC
3 Hours
-
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
Apple iPad - iPad at Work
3 Hours
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
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
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
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+
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
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
Business and Technical Writing Skills
6 Hours
-
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
Employment: Designing an Effective Resume
3 Hours
-
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
Employment: Using the Internet in Your Job Search
3 Hours
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
FileMaker Inc. FileMaker: Getting Started with FileMaker
3 Hours
-
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
FileMaker Inc. FileMaker: Creating Layouts
3 Hours
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
FileMaker Inc. FileMaker: Functions, Relationships, Lookups and Portals
3 Hours
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
Google Chrome: Surfing and Searching the Internet
3 Hours
-
How Does the Internet Work?
-
Important Dates in the History of the Internet
-
Fun Facts
-
Understanding Email Addresses
-
Understanding URLs
-
Full Screen Mode
-
Getting Help
-
Navigating to Websites
-
Going Back or Forward a Page
-
Refreshing a Page or Website
-
Stopping a Page from Loading
-
Finding Content on the Page
-
Changing the Default Search Provider
-
Home Pages
-
Displaying the Home Icon and Setting the Home Page
-
Moving from the Current Page to Your Home Page
-
-
Zooming In and Out of Webpages
-
Setting Default Zoom Percentage
-
Working with Tabs
-
Opening Webpages in Separate Tabs
-
Navigating between Tabs
-
Moving Tabs into Their Own Windows and Docking and Tiling Them
-
Creating New Tabs
-
Closing Tabs
-
Duplicating Tabs
-
Reopening Closed Tabs
-
Pinning Tabs
-
Muting Sites - make sure that the site never plays sound
-
-
Reopening the Last Browsing Session
-
Bookmarks
-
Show Bookmarks Bar
-
Adding Pages to Your List of Bookmarks
-
Adding Current Open Tabs to Bookmarks
-
Displaying Your Bookmarks
-
Managing Bookmarks
-
Adding a Website to Your Taskbar
-
-
RSS Feeds
-
History - View sites from the last 90 days
-
Viewing History
-
Deleting Browsing History
-
-
Security
-
Identifying Whether a Site is Encrypted
-
Viewing Which Site a Link Will Bring You To
-
Incognito Mode Browsing
-
-
My Favorite Shortcuts
-
Google Searches
-
Effective search techniques
-
Google search operators
-
Advanced searches
-
Accessing Google Search Help
-
Image searches
-
-
Cool Websites
Microsoft Access: Creating Related and Unrelated Tables, Fields and their Properties
3 Hours
-
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
-
Microsoft Access: Fundamentals of Querying Databases
3 Hours
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
Microsoft Access: Advanced Querying Techniques
3 Hours
It is highly recommended you first 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
Microsoft Access: Creating Forms and Reports
3 Hours
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
Microsoft Access: Advanced Techniques in Form Creation and Report Writing
3 Hours
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
Microsoft Edge: Surfing and Searching the Internet
3 Hours
-
How Does the Internet Work?
-
Important Dates in the History of the Internet
-
Fun Facts
-
Understanding Email Addresses
-
Understanding URLs
-
Changing the Appearance of the Interface
-
Viewing Full Screen
-
Getting Help
-
Navigating to Websites
-
Going Back or Forward a Page
-
Refreshing a Page or Website
-
Stopping a Page from Loading
-
Finding Content on the Page
-
Changing the Default Search Provider
-
Home Pages
-
Setting a Home Page
-
Moving from the Current Page to Your Home Page
-
Page or Pages to Open to On Startup
-
-
Zooming In and Out of Webpages
-
Working with Tabs
-
Opening Webpages in Separate Tabs
-
Navigating between Tabs
-
Moving Tabs into Their Own Windows and Docking and Tiling Them
-
Creating New Tabs
-
Closing Tabs
-
Duplicating Tabs
-
Reopening Closed Tabs
-
Muting a Tab
-
Tab Groups
-
-
Reopening the Last Browsing Session
-
Favorites
-
Show or Hide the Favorites Bar
-
Managing Favorites
-
Adding Pages to Your List of Favorites
-
Adding Current Open Tabs to Favorites
-
Displaying Your Favorites List
-
Displaying the Favorites Bar
-
Sorting Favorites
-
Adding a Website to Your Taskbar
-
-
Collections
-
RSS Feeds
-
History
-
Viewing History
-
Managing History
-
Clearing Browsing History
-
-
Read Aloud
-
Security
-
Identifying Whether a Site is Encrypted
-
Viewing Which Site a Link Will Bring You To
-
InPrivate Browsing
-
-
My Favorite Shortcuts
-
Google Searches
-
Effective search techniques
-
Google search operators (+ - ~ …)
-
Advanced searches
-
Accessing Google Search Help
-
Image searches
-
-
Cool Websites
Microsoft Excel: Getting Started with Microsoft Excel Formulas & Functions
3 Hours
-
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
Microsoft Excel: Advanced Functions
3 Hours
It is highly recommended you take Microsoft Excel: Basic Formulas & Functions or have equivalent training or experience with Microsoft Excel.
-
Learn to use the following functions:
-
IF
-
HLOOKUP, VLOOKUP, XLOOKUP
-
SUMIF
-
COUNTIF
-
INDEX
-
MATCH
-
SUMPRODUCT
-
PMT
-
OFFSET
-
ROUND
-
UPPER, LOWER, PROPER
-
ISERROR
-
ISTEXT
-
ISNUMBER
-
STDEV
-
TRIM
-
AVERAGE, MEDIAN, MODE.MULT, MODE.SNGL
-
RANK.AVG, RANK.EQ
-
LARGE, SMALL
-
-
Separating text into multiple columns
Microsoft Excel: Useful Features in Microsoft Excel
3 Hours
It is highly recommended you 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
Microsoft Excel: Charting, Linking, Embedding and Working with Multiple Sheets
3 Hours
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
Microsoft Excel: Working with Microsoft Excel Databases
3 Hours
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
-
Microsoft Excel: Recording Macros and Creating Forms
3 Hours
It is helpful to have taken Microsoft Excel: Basic Formulas & Functions or have a basic familiarity with Excel.
-
Recording 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 and moving labels
-
Turning off gridlines
-
Adding combo boxes
-
Adding option buttons
-
Adding check boxes
-
Adding list boxes
-
Adding scroll bars
-
Adding spinners
-
Creating a report with the results
-
Top
Microsoft Excel: Microsoft Excel Shortcuts, Tips, and Tricks
3 Hours
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
Microsoft Excel: Introduction to Microsoft Excel
6 Hours
-
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
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
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
-
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
-
Microsoft File Explorer: Getting Started with File Explorer
90 Minutes
-
Accessing File Explorer
-
Parts of the screen
-
Drive properties
-
Address bar
-
The Search Box
-
The View ribbon
-
The Home ribbon
-
The Share ribbon
-
Sharing to OneNote, Mail, WebEx
-
Windows 10 shortcut keys
Microsoft Forms: Getting Started with Microsoft Forms
3 Hours
-
What is Microsoft Forms?
-
Popular uses of Microsoft Forms
-
How to access Microsoft Forms
-
Accessing Microsoft Forms in Teams
-
The Forms interface
-
Creating a new form
-
Titling a form and adding a description
-
Adding new questions to a form
-
Previewing a form as it appears on a computer or mobile device
-
Question Suggestions
-
Creating sections
-
Branching
-
Adding a theme
-
Collecting responses
-
Viewing responses to surveys or quizzes
-
Opening responses in Excel
-
Printing a summary of responses
-
Sharing a Summary Link
-
Inviting others to add and edit questions, view responses and share with others
-
Allow others to use this as a template and make it their own
-
Accessing Settings
-
Creating surveys in foreign languages
-
Printing forms
-
Creating a new quiz
-
Immersive Reader
Microsoft OneDrive: Getting Started with Microsoft OneDrive
90 Minutes
-
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
Microsoft OneNote: Getting Started with Microsoft OneNote
3 Hours
-
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
Microsoft Outlook: Getting Started with Microsoft Outlook
3 Hours
-
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
Microsoft Outlook: Useful Features in Microsoft Outlook
3 Hours
It is recommended you 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
Microsoft PowerPoint: Getting Started with Microsoft PowerPoint
3 Hours
6 Hour Format Titled Introduction to PowerPoint
-
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
Microsoft PowerPoint: Useful Features in Microsoft PowerPoint
3 Hours
6 Hour Format Titled Advanced PowerPoint
It is highly recommended you take Microsoft PowerPoint: Creating Effective Presentations or have 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
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.
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!
-
The history of modern project management
-
Benefits and limitations of using project management software
-
Steps to building a project
-
Getting help
-
Sizing columns
-
Creating a base calendar
-
Assigning a base calendar to be the project calendar
-
Entering tasks
-
Entering durations
-
Saving
-
Creating milestones
-
Creating summary tasks
-
Outlining
-
Linking
-
Modifying relationship types
-
Displaying the task form
-
Toggling between active/Inactive panes
-
Slack, lag and lead
-
Formatting text
-
Displaying the critical path in the Gantt chart
-
Working with Task Information options
-
Creating a resource pool
-
Sorting a list
-
Modifying the task entry form to include initials
-
Assigning resources
-
Altering resource calendars
-
Obtaining project status
-
Working with the Network Diagram
-
Identifying overallocations
-
Remedying overallocations
-
Setting the baseline
-
Entering actual dates
-
Displaying the Tracking Gantt view
-
Using the mouse in the Gantt chart
-
Printing
-
Reports
Microsoft Project: Advanced Features
6 Hours
It is highly recommended that you take Microsoft Project: Getting Started with Microsoft Project first.
-
Using PERT to calculate durations
-
Using Task Paths
-
Splitting tasks
-
Creating recurring tasks
-
Activating and inactivating tasks
-
Using the mouse in the Gantt Chart and Calendar
-
Review of building a project
-
Creating and linking an external resource pool
-
The Resource Information dialog box
-
Modifying resource assignments
-
Assigning resources, effort driven scheduling and task types
-
Setting a baseline
-
Entering actuals
-
Updating a project as complete through a date
-
Rescheduling uncompleted work
-
Setting and displaying multiple baselines
-
Displaying a project summary task
-
Accessing built-in views and creating custom views
-
Formatting tasks on the Gantt char
-
Displaying the current date and the status date in the Gantt chart
-
Customizing the timescale portion of the Gantt chart view
-
Formatting task bars based on task type
-
Customizing the timescale
-
Accessing built-in tables and creating custom tables
-
Formatting text in the Entry table based on task type
-
Creating custom fields
-
Adding a lookup field to a custom field
-
Adding a calculation to a custom field
-
Adding graphical indicators to a custom field
-
Adding an outline code to a custom field
-
-
Using standard and highlight filters
-
Creating custom filters
-
Sorting project information
-
Using and customizing groups
-
Creating custom reports
-
Using the Organizer to manage custom objects
-
Customizing WBS codes
-
Creating master projects with subprojects
-
Using cross project linking
-
Creating overhead tasks
-
Creating a look ahead
-
Setting work contours
-
Using hyperlinks
-
Saving a view as a PDF
-
Using the Timeline view
-
Understanding program options
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 Document
-
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
-
Working with Web Part pages
-
-
Custom Lists
-
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
-
Modifying a task
-
Viewing a task list
-
Marking task completion
-
Deleting a task
-
-
Blogs
-
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
-
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
-
Microsoft Teams: Getting Started with Microsoft Teams
3 Hours
-
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
Microsoft Visio: Getting Started with Microsoft Visio
3 Hours
-
What is Visio?
-
Creating a New Diagram
-
The Visio Interface
-
Important Terminology
-
Getting Help
-
Modifying the Workspace
-
Shape Views
-
Floating and Docking Stencil Windows
-
Displaying and Using Favorites Stencil
-
Using Drawing Tools
-
Using the Pencil Tool to Create Your Own Shapes from Existing Shapes
-
Changing the Zoom Percentage
-
Magnification Tricks
-
Selecting, Resizing, Formatting, and Modifying a Shape
-
Adding Text to a Shape and Formatting Text
-
Rotating Shapes with or Without Text
-
Adding ScreenTips to Shapes
-
Adding a Comment to a Shape
-
Changing a Shape’s Line and Fill
-
Using Themes
-
Moving and Copying Shapes
-
Using the Dynamic Grid
-
Working with the Grid
-
Aligning and Distributing Shapes
-
Dragging Guides Off of the Rulers
-
Grouping and Ungrouping Shapes
-
Changing the Order of Shapes
-
Connecting Shapes
-
Connecting Shapes
-
Ungluing a Connector from a Shape
-
Switching from Any Tool Back to the Pointer Tool
-
Using AutoConnect
-
Changing the Shape of Connectors
-
Moving a Connector around an Object
-
Resetting a Connector
-
Adding Arrows and Other Shapes to the Beginning and/or End of Connectors
-
Creating and Using Custom Connectors
-
Working with Line Jumps
-
Creating, Changing, Moving, and Formatting Callouts
-
Callouts from Previous Versions of Visio
-
Containers
-
Creating an Empty Container
-
Using a Shape to Access Another Page
-
Accessing a Page with a Hyperlink
-
Shape Behaviors and Abilities
-
Working with Pages
-
Using Headers and Footers
-
Saving a Drawing as a Web Page
-
Printing a Drawing
-
Saving a Drawing as a Graphic File
-
Changing the Drawing Scale
-
Determining the Width, Height, and Angle of an Object
-
Displaying Height, Width or Angle with a Geometry Field
-
Displaying Height or Width with a Dimensioning Tool
-
Using Slide Snippets to create a Slide Show in PowerPoint
-
Creating a Custom Template
Microsoft Visio: Useful Features in Microsoft Visio
3 Hours
It is 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
Microsoft Whiteboard: Getting Started with Microsoft Whiteboard
90 Minutes
-
What is Whiteboard and how might you use it?
-
Where can you access and use Microsoft Whiteboard?
-
Adding content
-
Inserting documents
-
Inserting videos
-
Inserting links
-
Inserting reactions
-
Adding shapes
-
Drawing on an image
-
Handwriting on the screen
-
Adding images to the whiteboard
-
Modifying notes
-
Using notes and note grids
-
Adding and modifying text
-
Using templates
-
-
Using tools
-
Accessing Select, Inking, and Create tools
-
Accessing Profile, Share and Settings
-
Using the Eraser tool
-
Using and modifying Pens
-
Using the Ruler tool
-
Using the Lasso Select tool
-
-
Naming a whiteboard
-
Saving a whiteboard
-
Accessing your whiteboards
-
Clearing the canvas
-
Panning
-
Zooming
-
Moving from tool to tool and object to object
-
Things you can do to a picture
-
Locking an image to the background
-
Using Alignment Guides/Object Snapping
-
Working with Settings
-
Exporting content
-
Using collaborative cursors
-
Using enhanced inked shapes
-
Formatting the background
-
Making whiteboards read-only
-
Saving time with keyboard shortcuts
-
Continue working after a meeting
-
Deleting a whiteboard
Microsoft Windows 10/11: Getting Started with Windows 10/11
3 Hours
-
Getting Help
-
Personalizing the Desktop
-
Working with the Start Menu
-
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
-
Setting screen resolution
-
The Windows Clipboard
-
Cortana
-
Accessing the Windows Store
-
Using the Photos App
-
Windows Media Player
-
Deleting files and emptying/bypassing the Recycle Bin
-
Using screen capture tools
-
Using Aero features
-
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
Microsoft Word: Getting Started with Microsoft Word
3 Hours
-
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
Microsoft Word: Tabs, Tables, Graphics & Desktop Publishing
3 Hours
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
Microsoft Word: Creating Forms, Mail Merges, Envelopes and Labels
3 Hours
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
-
Microsoft Word: Working with Long Documents
3 Hours
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
-
Navigating to bookmarks
-
Locating bookmarks
-
-
Browsing by object
-
Adding borders to a paragraph
-
Scroll bar screen tips
-
Reducing the size of graphic content
-
Using built-in styles
-
Rearranging paragraphs in a document with heading styles
-
Using find and replace with styles
-
Working with Outline View
-
Displaying style names in the border
-
Working with multiple documents
-
Copying text between documents
-
Creating a Table of Contents
-
Creating an Index
-
Adding footnotes and endnotes
-
Creating hyperlinks within a document
Microsoft Word: Recording Macros and Using Automation Shortcuts
3 Hours
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
-
Microsoft Word: Useful Features in Microsoft Word
3 Hours
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
Microsoft Word: Introduction to Microsoft Word
6 Hours
-
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
Microsoft Word: Intermediate Microsoft Word
6 Hours
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
-
Microsoft Word: Advanced Microsoft Word
6 Hours
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
-
Novell GroupWise: Getting Started with Novell GroupWise
3 Hours
-
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
-
Sage Act!: Getting Started with Sage Act!
3 Hours
-
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
Sage Act!: Useful Features in Sage Act!
3 Hours
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
Tableau: Getting Started with Tableau Desktop
14 Hours over 2 Days
-
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
-
-
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
-
-
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
-
-
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)
-
Tableau: Intermediate Tableau Desktop
14 Hours over 2 Days
Displaying multiple measures in a visualization
-
Individual axes, blended axes, dual axes
-
Color coding dual axes
Combining data sets and data sources
-
Creating relationships
-
Creating joins
-
Creating unions
-
Using a calculation to create a join or relationship
-
Creating relationships across databases
-
Using data blending
-
Creating data extracts
Creating and using calculated fields
Creating and using level of detail (LOD) expressions
-
Fixed
-
Include
-
Exclude
Comparing measures to a goal or target
-
Creating bar in bar charts
-
Creating bullet charts
Showing the largest and the smallest values in a visualization
Creating visualizations that show distributions
-
Creating histograms
-
Creating box and whisker plots
-
Adding reference distributions to a visualization
Using advanced table calculations
-
Understanding scope and direction in Quick Table Calculations
-
Understanding the use of Specific Dimensions in partitioning (scope) and addressing (direction)
Understanding the Query Pipeline (Order of Operations)
-
Remedying order of operation issues
-
Converting a dimension filter to a context filer
-
Converting a table calculation to a FIXED level of detail expression
Handling special values
-
Dealing with null values
-
Dealing with tree maps that use fields with negative numbers
-
Dealing with unknown or ambiguous geographic locations
Working with reference lines and reference bands
-
Creating reference lines
-
Creating reference bands
Creating and using parameters
-
Creating Top N parameters
-
Using parameters to allow users to select dimensions and measures
-
Using parameters to allow users to select the value of a reference line
-
Creating a Top N% increase parameter
Defining subsets of your data
-
Creating and using sets
-
Using set actions to allow the user to change the members of a set
Creating motion charts
Creating dashboards
-
Using worksheet/dashboard filter actions and go to sheet actions
-
Moving between dashboards using navigation buttons
-
Sheet swapping
Creating stories
-
Annotating marks, points, and areas
-
Exporting a story to PowerPoint
Tableau: Tableau Prep Builder
14 Hours over 2 Days
Introduction to Tableau Prep Builder
-
Why Use Tableau Prep Builder?
-
Things You Can Do with Tableau Prep Builder
-
Where Does Prep Builder Fall in the Business Analytics Process?
-
The Tableau Prep Builder Interface
Connecting to Data Sources and Learning about Your Data
-
Connecting to Data
-
Using the Data Interpreter
-
Modifying Fields and Settings in the Input Pane
-
Learning about Your Data and Accessing the Tools to Fix It
-
Pausing Updates
Cleaning Data
-
Filtering Values
-
Changing Text to Uppercase/Lowercase
-
Removing Letters and Numbers from a Field
-
Removing Punctuation from a Field
-
Removing Extra Spaces from a Field
-
Grouping Values (Manually, by Pronunciation, by Common Characters, by Spelling)
-
Splitting Data in One Field into Multiple Fields
-
Creating Calculated Fields
-
Reusing Cleaning Steps or Changing Which Field They Apply To
Combining Data
-
Using Unions to Append Data
-
Dealing with Mismatched Fields after Creating a Union
-
Using Wildcards to Select Which Files to Union
-
Using Joins to Combine Data
-
Selecting Join Types
-
Viewing Join Type Results
-
Fixing Mismatched Fields
Shaping Data
-
Pivoting Data
-
Aggregating Data to Blend with a Data Source at a Different Level of Detail
Previewing Data in Tableau Desktop
Using Data Sampling
-
Selecting the Amount of Data to Work with In Tableau Prep Builde
Planning to Use Tableau Prep Builder