TeachUcomp, Inc. Free Demonstration Offer

United States and Canada Registration.

Outside the U.S. and Canada? Register here.

To take advantage of this special offer, simply complete the form below. It’s that easy.

* Required fields.

*First Name:

*Last Name:

Organization Name:

Organization Type:

*Address:

*City:

*State/Province:

*Zip/Postal:

*Country:

*Daytime Phone:
 (Digits only. No punctuation. Area code and phone. Ex: 1112223333.)

* E-Mail:

*Your Training Choice:

 

 

Note: We will never sell, rent, trade or share your personal information with any outside source, unless required to do so by law. Your information will be used to create a free TeachUcomp, Inc. account and to contact you regarding this offer. You are under no obligation and may unsubscribe at any time.
 

Want to see what’s covered? Choose an application to see the full syllabus.

Access Course Syllabus

Getting Acquainted with Access
1. Creating a New Database
2. Overview of a Database
3. The Access Interface
4. Touch Mode
5. Viewing Database Objects in the Navigation Bar
6. Opening and Closing Databases

Creating Relational Database Tables
1. The "Flat File" Method of Data Storage
2. The Relational Model of Data Storage
3. Tips for Creating a Relational Database
4. Creating Relational Database Tables
5. Assigning a Primary Key to a Table

Using Tables
1. Using Datasheet View
2. Navigating in Datasheet View
3. Adding Records in Database View
4. Editing and Deleting Records in Datasheet View
5. Inserting New Fields
6. Renaming Fields
7. Deleting Fields

Field Properties
1. Setting Field Properties
2. The 'Field Size' Property
3. The 'Format' Property for Date/Time Fields
4. The 'Format' Property for Logical Fields
5. Setting Default Values for Fields
6. Setting Input Masks
7. Setting Up Validation Rules and Responses
8. Requiring Field Input
9. Allowing Zero Length Entries

Joining Tables in a Database
1. The Relationships Window
2. Enforcing Referential Integrity
3. Creating Lookup Fields

Indexing Tables
1. Indexes
2. Creating Indexes
3. Deleting Indexes

Queries
1. Using the Simple Query Wizard
2. Designing Queries
3. Joining Tables in a Query
4. Adding Criteria to the QBE Grid
5. Running A Query
6. How is Using the QBE Grid Writing SQL Code?
7. Sorting Query Results
8. Hiding Fields in a Query
9. Using Comparison Operators
10. Using 'AND' and 'OR' Conditions

Advanced Queries
1. Using the 'BETWEEN...AND' Condition
2. Using Wildcard Characters in Criteria
3. Creating a Calculated Field
4. Creating 'Top Value' Queries
5. Function Queries
6. Parameter Queries

Advanced Query Types
1. Make-Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The 'Find Duplicates' Query
7. The 'Find Unmatched' Query

Creating Forms
1. Forms Overview
2. The Form Wizard
3. Creating AutoForms
4. Using Forms
5. Form and Report Layout View
6. Form and Report Design View
7. Viewing the Ruler and Gridlines
8. The 'Snap to Grid' Feature
9. Creating a Form in Design View
10. Modifying Form Selections in Design View

Form & Report Controls
1. Selecting Controls
2. Deleting Controls
3. Moving and Resizing Controls
4. Sizing Controls 'To Fit'
5. 'Nudging' Controls
6. Aligning, Spacing and Sizing Controls
7. Formatting Controls
8. Viewing Control Properties

Using Controls
1. The Controls Group
2. Adding Label Controls
3. Adding Logos and Image Controls
4. Adding Line and Rectangle Controls
5. Adding Combo Box Controls
6. Adding List Box Controls
7. Setting Tab Order

Subforms
1. Creating Subforms
2. Using the Subform/Subreport Control

Reports
1. Using the Report Wizard
2. Using Basic Reports
3. Creating a Report in Design View
4. Sorting and Grouping Data in Reports
5. Creating Calculated Fields

Subreports
1. Creating Subreports

Charting Data
1. Using Charts

Macros
1. Creating a Standalone Macro
2. Assigning Macros to a Command Button
3. Using Program Flow with Macros
4. Creating Autoexec Macros
5. Creating Data Macros
6. Editing Named Data Macros
7. Renaming and Deleting Named Data Macros

Switchboard and Navigation Forms
1. Creating a Switchboard Form
2. Creating a Navigation Form
3. Controlling Startup Behavior

Advanced Features
1. Getting External Data
2. Exporting Data
3. Setting a Database Password

Helping Yourself
1. Using Access Help
2 The Tell Me Bar- 2016 Only

Accounting Course Syllabus

Introduction and Overview
1. What is Accounting?
2. Accounting Methods
3. Ethics in Financial Reporting
4. Introduction to Financial Statements
5. Business Activities
6. GAAP
7. Sarbanes-Oxley Act
8. Accrual vs. Cash Basis of Accounting

Financial Statements
1. Balance Sheets
2. Accounting Transactions
3. Debits and Credits
4. T-Accounts and Journal Entries
5. The Balance Sheet
6. Income Statements
7. Retained Earnings Statement
8. Statement of Cash Flows

Assets

1. Introduction to Assets
2. Current Assets
3. Property, Plant and Equipment
4. Long-Term Investments
5. Intangible Assets
6. Depreciation

Liabilities
1. Introduction to Liabilities
2. Current Liabilities
3. Notes Payable
4. Sales Tax Payable
5. Unearned Revenue
6. Payroll Payable
7. Long-Term Liabilities

Other Accounting Transactions
1. The Trial Balance
2. Adjusting Entries
3. Closing the Books
4. Sales Revenues, Gross Profits & Operating Activities

Inventory
1. Classifying Inventory
2. Determining Inventory Quantities
3. Cost of Goods Sold
4. FIFO and LIFO
5. Average Cost Method

Stockholder’s Equity

1. Corporate Form of Organization
2. Stock Issue Considerations
3. Accounting for Treasury Stock
4. Preferred Stock
5. Dividends and Retained Earnings

Managerial Accounting
1. Introduction to Managerial Accounting
2. Code of Ethics for Managerial Accounting
3. Managerial Cost Concepts
4. Other Managerial Concepts

Cost Accounting Systems
1. Cost Accounting Systems
2. Job Order Flow
3. Reporting Job Order Costing
4. Process Cost Systems
5. Activity Based Costing

Accounts Payable
1. Accounts Payable
2. Early Payment Discounts

Behavior of Costs and Expenses
1. Cost Behavior
2. Break-Even Analysis and Contribution Margin Ratio
3. Margin of Safety

Basic Banking

1. Making Deposits and Transfers
2. Reconciling Bank Accounts

Cost Controlling

1. Budgetary Control
2. Static and Flexible Budgets
3. Responsibility Accounting
4. Standard Costs
5. Analyzing and Reporting Variances

Profit and Budget Planning
1. Budgeting Basics
2. Preparing the Operating Budgets
3. Preparing the Financial Budgets

Management Decision Making

1. Introduction to Management Decision Making
2. Incremental Analysis
3. Capital Budgeting and Annual Rate of Return
4. Other Tools for Analysis and Decision Making

Acrobat Course Syllabus

Getting Acquainted with Acrobat
1. Introduction to Adobe Acrobat Pro and PDFs
2. The Acrobat Environment
3. The Acrobat Home View
4. The Acrobat Tools View
5. The Acrobat Document View
6. The Menu Bar
7. Toolbars in Acrobat
8. The Common Tools Toolbar
9. Customizing the Common Tools Toolbar
10. Customizing the Quick Tools Toolbar
11. The Page Controls Toolbar
12. Resetting All Customizable Toolbars
13. Showing and Hiding All Toolbars and the Menu Bar
14. The Navigation Pane

15. The Tools Center
16. Customizing the Tools Pane

Opening and Viewing PDFs
1. Opening PDFs
2. Selecting and Copying Text and Graphics
3. Rotating Pages
4. Changing the Viewing Options
5. Using the Zoom Tools
6. Reviewing Preferences
7. Finding Words and Phrases
8. Searching a PDF and Using the Search Pane
9. Sharing PDFs by Email
10. Sharing PDFs with Adobe Send and Track

Creating PDFs
1. Creating New PDFs
2. Creating PDFs from a File
3. Creating PDFs from Multiple Files
4. Creating Multiple PDF Files at Once

5. Creating PDFs from Scanned Documents
6. Creating PDFs Using the PDF Printer
7. Creating PDFs from Web Pages Using a Browser
8. Creating PDFs from Web Pages Using Acrobat
9. Creating PDFs from the Clipboard
10. Creating PDFs Using Microsoft Office
11. Creating PDFs in Excel, PowerPoint, and Word
12. Creating PDFs in Adobe Applications
13. Creating PDFs in Outlook
14. Converting Folders to PDF in Outlook

Custom PDF Creation Settings
1. PDF Preferences in Excel, PowerPoint, and Word
2. Adobe PDF Settings
3. Creating and Modifying Preset Adobe PDF Settings
4. The General Category in Preset Adobe PDF Settings
5. The Images Category in Preset Adobe PDF Settings
6. The Fonts Category in Preset Adobe PDF Settings
7. The Color Category in Preset Adobe PDF Settings
8. The Advanced Category in Preset Adobe PDF Settings
9. The Standards Category in Preset Adobe PDF Settings
10. Create PDF and Email in Excel, PowerPoint, and Word
11. Mail Merge and Email in Word
12. Create and Review in Excel, PowerPoint, and Word
13. Importing Acrobat Comments in Word
14. Embed Flash in PowerPoint and Word
15. PDF Settings and Automatic Archival in Outlook

Basic PDF Editing
1. Initial View Settings for PDFs
2. Full Screen Mode
3. The Edit PDF Tool
4. Adding, Formatting, Resizing, Rotating and Moving Text
5. Editing Text
6. Managing Text Flow with Articles
7. Adding and Editing Images
8. Changing the Page Number Display
9. Cropping Pages and Documents

Advanced PDF Settings
1. Adding and Removing Watermarks
2. Adding and Removing Page Backgrounds
3. Adding Headers and Footers
4. Attaching Files to a PDF
5. Adding Metadata
6. Optimizing a PDF for File Size and Compatibility

Bookmarks
1. Using Bookmarks in a PDF
2. Modifying and Organizing Bookmarks
3. Assigning Actions to Bookmarks

Adding Multimedia Content and Interactivity
1. Creating and Editing Buttons
2. Adding Video, Sound, and SWF Files
3. Adding 3D Content to PDFs
4. Adding Page Transitions

Combining and Rearranging PDFs
1. Extracting and Replacing Pages
2. Splitting a PDF into Multiple Files
3. Inserting Pages from Files and Other Sources
4. Moving and Copying Pages
5. Combining PDFs

Exporting and Converting Content
1. Exporting Text
2. Exporting Images
3. Exporting PDFs to Microsoft Word
4. Exporting PDFs to Microsoft Excel
5. Exporting PDFs to Microsoft PowerPoint

Collaborating
1. Methods of Collaborating
2. Sending for Email Review
3. Sending for Shared Review
4. Reviewing Documents
5. Adding Comments and Annotation
6. The Comment Pane
7. Advanced Comments List Option Commands
8. Enabling Extended Commenting in Acrobat Reader
9. Using Drawing Tools
10. Stamping and Creating Custom Stamps
11. Importing Changes in a Review
12. Using Tracker to Manage PDF Reviews

Creating and Working With Portfolios
1. Creating a PDF Portfolio
2. PDF Portfolio Views
3. Using Layout View
4. Managing Portfolio Content
5. Using Details View
6. Setting Portfolio Properties

Getting Started With Forms
1. Creating a Form from an Existing PDF
2. Designing a Form in Microsoft Word
3. Creating a Form from a Scanned Document
4. Creating Forms from Image Files
5. Creating Text Fields
6. Creating Radio Buttons and Checkboxes
7. Creating Drop-Down and List Boxes
8. Creating Buttons
9. Creating a Digital Signature Field
10. General Properties of Form Fields
11. Appearance Properties of Form Fields
12. Position Properties of Form Fields
13. Options Properties of Form Fields
14. Actions Properties of Form Fields
15. Selection Change and Signed Properties of Form Fields
16. Format Properties of Form Fields
17. Validate Properties of Form Fields
18. Calculate Properties of Form Fields
19. Align, Center, Match Size, and Distribute Form Fields
20. Setting Form Field Tab Order
21. Enabling Users and Readers to Save Forms
22. Distributing Forms
23. Responding to a Form
24. Collecting Distributed Form Responses
25. Managing a Form Response File
26. Using Tracker with Forms

Professional Print Production
1. Overview of Print Production Support
2. Previewing Color Separations
3. Color Management and Conversion
4. Using the Object Inspector
5. Using the Preflight Dialog Box
6. Correcting Hairlines
7. Saving as a Standards-Compliant PDF

Scanning and Optical Character Recognition
1. Recognizing Text in a Scanned PDF
2. Recognizing Text in PDFs
3. Reviewing and Correcting OCR Suspects

Automating Routine Tasks
1. Using Actions
2. Creating Custom Actions
3. Editing and Deleting Custom Actions
4. Sharing Actions

Document Protection and Security
1. Methods of Securing a PDF
2. Password-Protecting a PDF
3. Creating and Registering Digital IDs
4. Using Certificate Encryption
5. Creating a Digital Signature
6. Digitally Signing a PDF
7. Certifying a PDF
8. Signing Documents with Adobe Sign
9. Getting Others to Sign Documents
10. Redacting Content in a PDF
11. Redaction Properties
12. Revealing and Clearing Hidden Information

Adobe Reader and Document Cloud
1. Opening and Navigating PDFs in Reader
2. Adding Comments
3. Digitally Signing a PDF
4. Adobe Document Cloud

Adobe Acrobat Help
1. Adobe Acrobat Help

Crystal Reports Course Syllabus

The Crystal Reports Environment
1. Starting Crystal Reports
2. The Menu Bar
3. Using Toolbars
4. The Design View

Creating Data Connections
1. Creating a New Blank Report
2. The Database Expert
3. Access/Excel (DAO)
4. ADO.NET (XML)
5. Database Files
6. Java Beans Connectivity
7. JDBC (JNDI)
8. ODBC (RDO)
9. OLAP
10. OLE DB (ADO)
11. Salesforce.com
12. SAP BW MDX Query
13. SAP Info Sets
14. SAP Operational Data Source
15. SAP Table, Cluster, or Function
16. Universes
17. XML and Web Services
18. Repository
19. More Data Sources
20. Selecting Report Data and Tables
21. The Data Explorer

Creating Basic Reports
1. Adding Data Fields to a Report
2. Browsing Field Data
3. Selecting, Moving, and Resizing Fields
4. Using the “Size” and “Align” Commands
5. Creating Text Objects
6. Saving a Report
7. Previewing a Report
8. Refreshing the Report Data

Linking Tables in a Report
1. Basic Table Structures and Terms
2. Linking Multiple Tables
3. Table Joins
4. Enforcing Table Joins and Changing Link Types

Basic Formatting Techniques
1. Formatting Report Objects
2. The "Common" Tab of the Format Editor
3. The "Number" Tab of the Format Editor
4. The "Font" Tab of the Format Editor
5. The "Border" Tab of the Format Editor
6. The "Date and Time" Tab of the Format Editor
7. The "Paragraph" Tab of the Format Editor
8. The "Picture" Tab of the Format Editor
9. The "Boolean" Tab of the Format Editor
10. The "Hyperlink" Tab of the Format Editor
11. The "Subreport" Tab of the Format Editor
12. Drawing Lines
13. Drawing Boxes
14. Format Painter
15. Formatting Part of a Text Object
16. The Template Expert
17. Inserting Pictures

Record Selection
1. The Select Expert
2. Setting Multiple Filters
3. Editing the Selection Formula

Sorting and Grouping Records
1. The Record Sort Expert
2. The Group Expert
3. Managing Groups
4. Summarizing Groups
5. Hierarchical Groupings
6. The Group Sort Expert

Printing Reports
1. Inserting Special Fields
2. Page Setup
3. Printing Reports

Using Formulas
1. Crystal Reports Formula Syntax
2. The Formula Workshop- Formula Editor Window
3. Creating Formula Fields
4. Crystal Syntax
5. Basic Syntax
6. Finding Function and Operator Assistance

Advanced Formatting
1. The Highlighting Expert
2. The Section Expert
3. Conditionally Formatting a Section
4. Conditionally Formatting a Field
5. Manipulating Multiple Sections

Summary Reports
1. Summarizing Report Data
2. Using the DrillDownGroupLevel Feature

Charting
1. The Chart Expert
2. Editing Charts
3. Setting General Chart Options
4. Formatting Selected Chart Items
5. Formatting a Data Series
6. Formatting Chart Gridlines
7. Setting Chart Axes Options
8 . Adding Chart Trendlines
9 . Modifying a 3D Chart View
10. Using Chart Templates
11. Auto-Arranging Charts

Advanced Reporting Tools
1. Using Running Totals
2. Creating Parameter Fields
3. Parameterized Record Selection
4. Creating Subreports
5. Report Alerts
6. Report Alert Functions

Advanced Formula Creation
1. Evaluation Time Functions
2. Declaring Variables
3. Using and Displaying Variables
4. Using Array Values
5. Using “If… Then… Else…” Statements
6. Using the “Select/Case” Statement
7. Using “For” Loops
8. Using “Do… While” Loops
9. The IIF Function

Advanced Reporting
1. Creating a Report Template
2. Exporting Report Results
3. Exporting as HTML
4. Setting Default Options
5. Setting Report Options

Using Report Wizards
1. Using the Report Wizards
2. Report Wizard Types
3. Creating a Cross-Tab Report

Advanced Database Concepts
1. Viewing the SQL Code
2. Using Table Aliases
3. Verifying the Database
4. Setting the Datasource Location
5. Mapping Fields

Dreamweaver Course Syllabus

Getting Acquainted with Dreamweaver
1. The Dreamweaver Environment
2. The Designer Workspace
3. The Menu Bar
4. The Designer View Icons
5. The Designer View Toolbar
6. Working With Panels
7. The Properties Inspector
8. The Insert Panel
9. Other Common Panels

Creating a Website
1. About New Websites
2. The Root Folder
3. Defining a Website
4. Creating a New Web Page
5. Saving and Closing Web Pages
6. Opening Saved Web Pages
7. Previewing Web Pages
8. Multi-Browser Previews

All About Text
1. Working With Text
2. Exploring Heading Levels
3. Formatting Text Color
4. Changing a Web Page's Background Color
5. Aligning Text
6. Creating Paragraphs
7. Working With Fonts
8. Using Custom Fonts
9. Using Bold and Italics With Text
10. Creating Lists
11. Special Characters
12. Creating Block Quotes

All About Images
1. Using Images in a Web Page
2. Image File Types
3. Commonly Used Web Images
4. Inserting Images Into a Web Page
5. Image Properties
6. Borders and Spacing Around Images
7. Using Background Images
8. Resizing Images
9. Cropping Images
10. Using Images and Text Together
11. When to Use Outside Imaging Programs
12. Opening an Image in Adobe Photoshop
13. Cropping an Image Using Photoshop
14. Saving an Image Using Photoshop
15. Resizing an Image Using Photoshop
16. Working with Custom Fonts in Photoshop

All About Hyperlinks
1. Inserting a Hyperlink Into a Web Page
2. Turning Images Into Hyperlinks
3. Creating Image Maps
4. Named Anchor Links
5. Adding an Email Link to a Web Page
6. Changing the Appearance of Hyperlinks

Using Frames
1. Using Frames
2. Adding Content to Frames
3. Naming Frames
4. Deleting Frames
5. Linking to Frames

Tables
1.When to Use Tables
2. Creating Tables
3. Inserting and Editing Content in Tables
4. Editing Rows and Columns
5. Table Borders and Backgrounds
6. Spacing and Padding in Table Cells
7. Merging and Splitting Table Cells

CSS Basics
1. Working with Cascading Style Sheets
2. Editing CSS Styles
3. Creating Class Styles
4. Applying Class Styles
5. Editing Class Styles
6. Customizing HTML Tags
7. Modifying Fonts Using CSS

CSS Layouts and AP Divs
1. Creating External Style Sheets
2. Attaching External Style Sheets
3. Editing an External Style Sheet
4. Absolute Positioning Versus Relative Positioning
5. About AP Divs
6. Nested AP Divs
7. Designing a Web Page Using CSS Layouts
8. Editing CSS Layouts
9. Inserting an Image Into a Header
10. Adding Images to a CSS Layout

Spry Widgets & Forms
1. Spry Widgets, Behavior Events and Actions
2. Creating a Drop-Down Menu
3. Editing a Drop-Down Menu
4. Creating Tabbed Panels
5. Adding Content to Tabbed Panels
6. Editing Tabbed Panels
7. Open Browser Window Behavior
8. About Forms
9. Adding Text Fields to Forms
10. Inserting Checkboxes Into Forms
11. Inserting Radio Buttons Into Forms
12. Inserting Lists and Menus Into Forms
13. Adding Buttons to Forms

Publishing Your Website
1. Domain Names Versus Web Hosting
2. When is my site ready to publish?
3. Setting Up a Remote Site
4. Connecting to a Remote Server
5. Putting Files on the Remote Site
6. Canceling Uploads and Deleting Remote Site Files
7. Downloading Files from the Remote Site

Website Management
1. Site Assets
2. Changing Links Site-Wide
3. Finding and Replacing Text
4. Site Reports
5. Checking Files In and Out
6. Using Design Notes

Adobe Bridge
1. The Adobe Bridge Environment
2. Display Options
3. Compact Mode
4. Navigating, Opening & Placing Files
5. Searching for Files and Folders
6. Labeling and Rating Files
7. Sorting and Filtering Files
8. Copying, Moving and Deleting Files
9. Stacking and Unstacking
10. Previewing Images and the Loupe Tool
11. Rotating Images
12. Viewing a Slideshow
13. Viewing and Editing Metadata
14. Keywords

Excel Course Syllabus

Getting Acquainted with Excel

1. About Excel
2. The Excel Environment
3. The Title Bar
4. The Ribbon
5. The "File" Tab and Backstage View
6. Scroll Bars
7. The Quick Access Toolbar
8. Touch Mode
9. The Formula Bar
10. The Workbook Window
11. The Status Bar
12. The Workbook View Buttons
13. The Zoom Slider
14. The Mini Toolbar
15. Keyboard Shortcuts

File Management

1. Creating New Workbooks
2. Saving Workbooks
3. Closing Workbooks
4. Opening Workbooks
5. Recovering Unsaved Workbooks
6. Opening a Workbook in a New Window
7. Arranging Open Workbook Windows
8. Freeze Panes
9. Split Panes
10. Hiding and Unhiding Workbook Windows
11.Comparing Open Workbooks
12. Switching Open Workbooks
13. Switching to Full Screen View
14. Working With Excel File Formats

Data Entry
1. Selecting Cells
2. Entering Text into Cells
3. Entering Numbers into Cells
4. AutoComplete
5. Pick from Drop-Down List
6. Flash Fill
7. Selecting Ranges
8. Ranged Data Entry
9. Using AutoFill

Creating Formulas
1. Ranged Formula Syntax
2. Simple Formula Syntax
3. Writing Formulas
4. Using AutoSum
5. Inserting Functions
6. Editing a Range
7. Formula AutoCorrect
8. AutoCalculate
9. Function Compatibility

Copying & Pasting Formulas
1. Relative References and Absolute References
2. Cutting, Copying, and Pasting Data
3. AutoFilling Cells
4. The Undo Button
5. The Redo Button

Columns & Rows
1. Selecting Columns & Rows
2. Adjusting Column Width and Row Height
3. Hiding and Unhiding Columns and Rows
4. Inserting and Deleting Columns and Rows

Formatting Worksheets
1. Formatting Cells
2. The Format Cells Dialog Box
3. Clearing All Formatting from Cells
4. Copying All Formatting from Cells to Another Area

Worksheet Tools
1. Inserting and Deleting Worksheets
2. Selecting Multiple Worksheets
3. Navigating Worksheets
4. Renaming Worksheets
5. Coloring Worksheet Tabs
6. Copying or Moving Worksheets

Setting Worksheet Layout
1. Using Page Break Preview
2. Using the Page Layout View
3. Opening The Page Setup Dialog Box
4. Page Settings
5. Setting Margins
6. Creating Headers and Footers
7. Sheet Settings

Printing Spreadsheets
1. Previewing and Printing Worksheets

Helping Yourself
1. Using Excel Help
2. The Tell Me Bar- 2016 Only
3. The Smart Lookup and Insights- 2016 Only

Creating 3D Formulas
1. Creating 3D Formulas
2. 3D Formula Syntax
3. Creating 3D Range References

Named Ranges
1. Naming Ranges
2. Creating Names from Headings
3. Moving to a Named Range
4. Using Named Ranges in Formulas
5. Naming 3D Ranges
6. Deleting Named Ranges

Conditional Formatting and Cell Styles
1. Conditional Formatting
2. Finding Cells with Conditional Formatting
3. Clearing Conditional Formatting
4. Using Table and Cell Styles

Paste Special
1. Using Paste Special
2. Pasting Linked Formulas

Sharing Workbooks
1. About Sharing Workbooks
2. Simplified Workbook Sharing in Excel 2016
3. Traditional Workbook Sharing
4. Highlighting Changes
5. Reviewing Changes
6. Using Comments
7. Compare and Merge Workbooks

Auditing Worksheets
1. Auditing Worksheets
2. Tracing Precedent and Dependent Cells
3. Tracing Errors
4. Error Checking
5. Using the Watch Window
6. Cell Validation

Outlining Worksheets
1. Using Outlines
2. Applying and Removing Outlines

Consolidating Worksheets
1. Consolidating Data

Tables
1. Creating a Table
2. Adding an Editing Records
3. Inserting Records and Fields
4. Deleting Records and Fields

Sorting Data
1. Sorting Data
2. Custom Sort Orders

Filtering Data
1. Using AutoFilters
2. Using the Top 10 AutoFilter
3. Using a Custom AutoFilter
4. Creating Advanced Filters
5. Applying Multiple Criteria
6. Using Complex Criteria
7. Copying Filter Results to a New Location
8. Using Database Functions

Using What-If Analysis
1. Using Data Tables
2. Using Scenario Manager
3. Using Goal Seek
4. Forecast Sheets- 2016 Only

Table-Related Functions
1. The Hlookup and Vlookup Functions
2. Using the IF, AND, and OR Functions

Sparklines
1. Inserting and Deleting Sparklines
2. Modifying Sparklines

Creating Charts In Excel
1. Creating Charts
2. Selecting Charts and Chart Elements
3. Adding Chart Elements
4. Moving and Resizing Charts
5. Changing the Chart Type
6. Changing the Data Range
7. Switching Column and Row Data
8. Choosing a Chart Layout
9. Choosing a Chart Style
10. Changing Color Schemes
11. Printing Charts
12. Deleting Charts

Formatting Charts in Excel
1. Formatting Chart Objects
2. Inserting Objects into a Chart
3. Formatting Axes
4. Formatting Axis Titles
5. Formatting a Chart Title
6. Formatting Data Labels
7. Formatting a Data Table
8. Formatting Error Bars
9. Formatting Gridlines
10. Formatting a Legend
11. Formatting Drop and High-Low Lines
12. Formatting Trendlines
13. Formatting Up/Down Bars
14. Formatting the Chart and Plot Areas
15. Naming Charts
16. Applying Shape Styles
17. Applying WordArt Styles
18. Saving Custom Chart Templates

Data Models
1. Creating a Data Model from External Relational Data
2. Creating a Data Model from Excel Tables
3. Relating Tables in a Data Model
4. Managing a Data Model

PivotTables and PivotCharts
1. Creating Recommended PivotTables
2. Manually Creating a PivotTable
3. Creating a PivotChart
4. Manipulating a PivotTable or PivotChart
5. Changing Calculated Value Fields
6. Formatting PivotTables
7. Formatting PivotCharts
8. Setting PivotTable Options
9. Sorting and Filtering Using Field Headers

PowerPivot
1. Starting PowerPivot
2. Managing the Data Model
3. Calculated Columns and Fields
4. Measures
5. Creating KPIs
6. Creating and Managing Perspectives
7. PowerPivot PivotTables and PivotCharts

Power View
1. Starting Power View
2. Adding Report Visualizations
3. Changing the Layout of Report Visualizations
4. Using Undo and Redo in Power View
5. Formatting the Power View Sheet
6. Creating Multiples in a Chart
7. Filtering Power View Using the Filter Data
8. Cross-Filtering Visualizations

Slicers and Timelines
1. Inserting and Deleting Slicers
2. Modifying Slicers
3. Inserting and Deleting Timelines
4. Modifying Timelines

Security Features
1. Unlocking Cells
2. Worksheet Protection
3. Workbook Protection
4. Password Protecting Excel Files

Making Macros
1. Recording Macros
2. Running and Deleting Recorded Macros
3. The Personal Macro Workbook

HTML and CSS Course Syllabus

Getting Acquainted with HTML
1. Introduction to the Internet
2. Introduction to HTML Terminology
3. Options for Writing HTML
4. Unicode Transformation Format (UTF)
5. HTML5 Resources

New for HTML5
1. What's different in HTML5?
2. !DOCTYPE in HTML5

Designing a Webpage
1. Design Considerations and Planning
2. Basic Tags and Document Structure
3. HTML Tags
4. Head Tags
5. Title Tags
6. Body Tags
7. Metadata
8. Saving an HTML Page

Page Formatting
1. Adding a New Paragraph
2. Adding a Line Break
3. Inserting Blank Space
4. Preformatted Text
5. Changing a Pages's Background Color
6. Div Element

Text Items and Objects
1. Headings
2. Comments
3. Block Quotes
4. Horizontal Lines
5. Special Characters

Creating Lists
1. Numbered (Ordered) Lists
2. Bulleted (Unordered) Lists
3. Nested Lists
4. Definition Lists

Links
1. What are Links?
2. Text Links
3. Image Links
4. Opening a Page in a New Window or Tab
5. Setting All Links on a Page to Open in a New Window or Tab
6. Linking to an Area on the Same Page (Bookmarks)
7. Linking to an E-mail Address
8. Linking to Other Types of Files

Images
1. Introduction to Images for Webpages
2. Adding Images to Webpages
3. Re-Sizing an Image
4. Alternative (ALT) Text
5. Image Labels

Basic Tables
1. Inserting a Table
2. Table Borders
3. Table Headers

Iframes
1. What is an Iframe?
2. Inserting Iframes
3. Setting Height and Width
4. Using an Iframe for a Link Target

Forms
1. About Forms
2. Sending to E-mail
3. Text Boxes
4. Text Areas
5. Check Boxes
6. Menu Lists
7. Radio Buttons
8. Submit Button
9. Reset Button
10. Changing the Tab Order

Video and Audio
1. About Video and Audio Files
2. Linking to Video and Audio Files
3. Adding Video
4. Adding Audio
5. Using YouTube to Display Video

Troubleshooting
1. Troubleshooting

Cascading Style Sheets
1. What are Cascading Style Sheets?
2. CSS Syntax
3. Creating an Internal CSS
4. Linking to a CSS
5. Adding Comments and Notes to a CSS
6. Creating an Internal Style Sheet
7. ID and Class
8. Inline Styling

Working With Text in CSS
1. Emphasizing Text (Bold and Italic)
2. Decoration
3. Indentation
4. Transformation
5. Text Alignment
6. Fonts
7. Font Sizes
8. Letter Spacing (Kerning)
9. Line Spacing (Leading)
10. Text Color
11. Margins
12. Padding
13. Borders
14. Styling Links
15. Number and Bullet Styles
16. Sizing Elements
17. Text Wrapping
18. Shadowing

Creating Backgrounds in CSS
1. Colors
2. Images
3. Fixed Images

Images in CSS
1. Opacity
2. Floating Images
3. Image Galleries
4. Image Sprites

Box Model in CSS
1. What is a box model?
2. Margin
3. Padding
4. Border
5. Outline

Working With Elements in CSS
1. Display and Visibility
2. Grouping and Nesting
3. Dimensions and Elements
4. Positioning
5. Floating
6. Pseudo-Classes/Pseudo-Elements

Adding a Navigation Bar in CSS
1. Vertical Navigation Bar
2. Horizontal Navigation Bar - Inline
3. Horizontal Navigation Bar - Floating

CSS Tables
1. Borders
2. Collapsed Borders
3. Table Width and Cell Height
4. Table Color
5. Table Text Alignment
6. Table Padding

Working With Transforms in CSS
1. What are transforms?
2. 2D Transforms
3. 3D Transforms

Transitions and Animations in CSS
1. Transitions
2. Animations

CSS Shorthand
1. Shorthand Properties

Interview Course Syllabus

Before You Get the Interview
1. Introduction to Interviewing
2. Write an Effective Resume
3. Develop Great References
4. Use Technology Wisely
5. Dress the Part
6. Other Considerations

Once the Interview is Scheduled
1. Research the Company
2. Practice, Practice, Practice
3. Prepare for the Interview
4. Stay Healthy
5. Grooming for Success

During the Interview
1. Types of Interviews
2. Make a Great First Impression
3. General Strategies for Answering Questions
4. Mirroring
5. Representational Systems
6. Body Language Dos
7. Body Language Don'ts
8. Tips and Tricks
9. Ending the Interview

After the Interview
1. Take Notes
2. Thank the Interviewer
3. Following Up
4. The Second Interview

Practice Questions
1. The Behavioral Interview
2. Practice Questions 1-5
3. Practice Questions 6-10
4. Practice Questions 11-15

Conclusion
1. Further Study
2. Conclusion

JavaScript Course Syllabus

Getting Acquainted with JavaScript
1. Introduction to JavaScript
2. JavaScript vs. Java
3. The Tag
4. External JavaScript
5. Uses for JavaScript

The Makeup of JavaScript
1. JavaScript Statements
2. Code and Code Blocks
3. Whitespace
4. Case Sensitivity
5. Breaking Up a Line of Code

JavaScript Comments
1. Single Line Comments
2. Multi-Line Comments
3. End of Line Comments
4. Using Comments to Stop Execution

JavaScript Variables
1. What are JavaScript Variables?
2. Syntax for Text and Numerical Values
3. Creating (Declaring) Variables
4. Re-Declaring Variables
5. Undefined Value
6. Using One Statement for Multiple Variables
7. Local Variables and Global Variables

Exploring JavaScript Data Types
1. Dynamic Data Types in JavaScript
2. Null
3. Number
4. String
5. Boolean
6. Array
7. Object

JavaScript Objects
1. Creating Objects
2. Accessing Object Properties
3. Accessing Object Methods

JavaScript Functions
1. JavaScript Function Definition and Syntax
2. Functions with a Return Value
3. Calling a Function with Arguments
4. Assigning Values to Undeclared Variables

JavaScript Operators
1. Arithmetic Operators
2. Assignment Operators
3. Adding Strings and Numbers
4. Comparison Operators
5. Logical Operators
6. Conditional Operators

JavaScript Conditions
1. If Statements
2. The Switch Statement

JavaScript Loops
1. The FOR Loop
2. The FOR…IN Loop
3. The WHILE Loop
4. The DO…WHILE Loop

JavaScript Break and Continue
1. The Break Statement
2. The Continue Statement
3. JavaScript Labels

JavaScript Errors
1. The Try…Catch Statement
2. The Throw Statement

JavaScript Form Validation
1. Form Validation
2. E-Mail Validation

JavaScript RegExp Object
1. RegExp Definition and Modifiers
2. RegExp Special Characters
3. RegExp Methods

JavaScript Hoisting
1. Declarations
2. Initializations

JavaScript USE STRICT Directive
1. What is the USE STRICT Directive and Why Use It?
2. What’s Not Allows in STRICT Mode?

JavaScript HTML DOM
1. What is HTML DOM?
2. HTML DOM Methods and Properties
3. HTML DOM Document
4. Finding HTML Elements
5. Changing the Output Stream
6. Changing the Value of an Attribute
7. Changing CSS

HTML DOM Events
1. Using Events
2. The ONCHANGE Event

HTML DOM Navigation
1. DOM Nodes
2. Node Relationships
3. Child Nodes and Values
4. NODE…Properties
5. HTML DOM Nodelist
6. Root Nodes

Adding and Removing DOM Nodes
1. Creating New HTML Elements (Nodes)
2. Removing Existing HTML Elements (Nodes)
3. Replacing HTML Elements (Nodes)

JavaScript Browser Object Model (BOM)
1. What is the Browser Object Model (BOM)?
2. The Window Object
3. Window Size Properties
4. Other Window Methods and Properties

Window Screen Object
1. What does the Window Screen Object Do?
2. Window Screen Object Properties.

Window Location Object
1. What does the Window Location Object Do?
2. Window Location HREF Property
3. Window Location PATHNAME Property
4. Window Location ASSIGN() Method

Window History Object
1. What does the Window History Object Do?
2. Window History Back and Forward Methods

Window Navigator Object
1. What does the Window Navigator Object Do?

JavaScript Popup Boxes
1. The Alert Box
2. The Confirm Box
3. The Prompt Box

JavaScript Timing Events
1. What are JavaScript Timing Events?
2. SETINTERVAL() and CLEARINTERVAL() Methods
3. SETTIMEOUT() and CLEARTIMEOUT() Methods
4. Creating a Clock

JavaScript Cookies
1. What are Cookies?
2. Working with Cookies

The JavaScript Console Object
1. The Console Object
2. Inline Grouping
3. Timers
4. String Substitution

Advanced JavaScript Objects
1. The Object Literal and the Keyword New
2. Using an Object Constructor
3. JavaScript Prototype
4. Mutable Objects and Immutable Primitive Values
5. JavaScript Object Properties
6. Adding New Properties and Deleting Properties

Number Object
1. What is a Number Object?
2. Hexadecimal Numbers
3. NaN – Not a Number
4. Infinity

String Object
1. Using the String Object
2. String Properties and Methods
3. Special Characters

Date Object
1. The Date Object
2. Set and Compare Dates
3. Convert the Date to a String

Array Object
1. Create and Access an Array Object
2. Joining Arrays
3. Working with Arrays

Math Object
1. The Math Object and Mathematical Constants
2. Math Object Methods

JavaScript Libraries (Frameworks)
1. JavaScript Libraries or Frameworks
2. Testing jQuery

OneNote Course Syllabus

Getting Acquainted with OneNote
1. The OneNote Environment
2. The Title Bar
3. The Ribbon
4. The "File" Tab and Backstage View
5. The Quick Access Toolbar
6. The Scroll Bars
7. The Mini Toolbar

Getting Started
1. Opening, Saving and Closing Notebooks
2. Creating New Notebooks
3. Creating, Moving and Deleting Sections and Pages
4. Creating, Moving and Deleting Subpages

Notes
1. Creating a Basic Note
2. Quick Notes
3. Copying and Pasting Content
4. Screen Clippings
5. Adding Pictures
6. Adding Audio & Video Files
7. Inserting Online Video
8. Recording Audio & Video Files
9. Adding Other Types of Files
10. Embedding an Excel Spreadsheet
11. Adding Mathematical Equations
12. Quick Filing - Sending Information to OneNote

Formatting Notes
1. Basic Text Formatting
2. Bullets and Numbering
3. Checking Spelling
4. Setting Default Proofing Options

Working with Microsoft Outlook
1. Inserting Outlook Meetings
2. Sending Notebook Pages via Microsoft Outlook
3. Working with Microsoft Outlook Tasks

Tables
1. Creating a Table
2. Working with Columns and Rows
3. Formatting Tables and Table Data
4. Moving Tables and Table Data

Writing Tools
1. Pen Mode
2. Formatting Written Notes & Drawings
3. Adding and Removing Note Space
4. Converting Handwriting to Type

Viewing and Organizing Information
1. Organizing the OneNote Interface
2. Creating New Windows
3. Searching Content in a Notebook
4. Wiki Linking
5. Tagging Notes
6. Working with Sections
7. Section Groups

Stationery and Templates

1. Applying Templates and Stationery
2. Custom Templates
3. Choosing a Default Template

Formatting Pages

1. Defining Paper Size and Margins
2. Formatting Page Backgrounds
3. Adding a Background Graphic

Printing
1. Previewing and Printing

Sharing Notebooks & Collaborating
1. Saving and Exporting Notebooks to Share
2. Creating a Shared Notebook and Inviting Others to Share
3. Sharing Notes in an Outlook Meeting Invitation
4. Synching Notebooks
5. Sending Pages in Various Formats
6. Author Indicators
7. Finding Newly Added Content with Highlighting
8. Page Versions
9. The Notebook Recycle Bin

Researching with OneNote
1. Linked Notes
2. The Research Pane
3. Translating Text with the Mini Translator

Changing OneNote Options
1. Customizing the Quick Access Toolbar and Ribbon
2. Changing OneNote Options

Helping Yourself
1. Using OneNote Help

Outlook Course Syllabus

Getting Acquainted with Outlook
1. The Outlook Environment
2. The Title Bar
3. The Ribbon
4. The Quick Access Toolbar
5. Touch Mode
6. The Navigation Bar, Folder Pane, Reading Pane, and To-Do Bar
7. What's New in Outlook 2016

Making Contacts
1. The People Folder
2. Customizing the Contacts Folder View
3. Creating Contacts
4. Basic Contact Management
5. Printing Contacts
6. Creating Contact Groups
7. Categorizing Contacts
8. Searching for Contacts
9. Calling Contacts
10. Mapping a Contact's Address

E-Mail
1. Using the Inbox
2. Changing the Inbox View
3. Message Flags
4. Searching for Messages
5. Creating, Addressing, and Sending Messages
6. Checking Message Spelling
7. Setting Message Options
8. Formatting Messages
9. Using Signatures
10. Replying to Messages
11. Forwarding Messages
12. Sending Attachments
13. Sharing a OneDrive File as an Attachment- 2016 Only
14. Opening Attachments
15. Ignoring Conversations

The Sent Items Folder
1. The Sent Items Folder
2. Resending Messages
3. Recalling Messages

The Outbox Folder
1. Using the Outbox

Using the Calendar
1. The Calendar Window
2. Switching the Calendar View
3. Navigating the Calendar
4. Appointments, Meetings and Events
5. Manipulating Calendar Objects
6. Setting an Appointment
7. Scheduling a Meeting
8. Checking Meeting Attendance Status
9. Responding to Meeting Requests
10. Scheduling an Event
11. Setting Recurrence
12. Printing the Calendar
13. Join Skype Meeting in Outlook 2016
14. Meeting Notes

Tasks
1. Using Tasks
2. Printing Tasks
3. Creating a Task
4. Setting Task Recurrence
5. Creating a Task Request
6. Responding to Task Requests
7. Sending Status Reports
8. Deleting Tasks

Deleted Items
1. The Deleted Items Folder
2. Permanently Deleting Items
3. Recovering Deleted Items
4. Recovering and Purging Permanently Deleted Items

Groups
1. Accessing Groups
2. Creating a New Group
3. Adding Members to Groups
4. Contributing to Groups
5. Managing Files in Groups
6. Accessing the Group Calendar
7. Subscribing to and Unsubscribing from Groups
8. Leaving Groups
9. Editing, Managing and Deleting Groups

The Journal Folder

1. The Journal Folder
2. Switching the Journal View
3. Recording Journal Items
4. Opening Journal Entries and Documents
5. Deleting Journal Items

Public Folders

1. Creating Public Folders
2. Setting Permissions
3. Folder Rules
4. Copying Public Folders

Personal and Private Folders
1. Creating a Personal Folder
2. Setting AutoArchiving for Folders
3. Creating Private Folders
4. Creating Search Folders

Notes
1. Creating and Using Notes

Advanced Mailbox Options
1. Creating Mailbox Rules
2. Creating Custom Mailbox Views
3. Handling Junk Mail
4. Color Categorizing
5. Advanced Find
6. Mailbox Cleanup

Outlook Options
1. Using Shortcuts
2. Adding Additional Profiles
3. Adding Additional Services
4. Outlook Options
5. Using Outlook Help

Delegates
1. Creating a Delegate
2. Acting as a Delegate
3. Deleting Delegates

Outlook on the Web Course Syllabus

Getting Acquainted with Outlook on the Web
1. Introduction to the Outlook on the Web
2. What is the Outlook on the Web?
3. Starting Outlook on the Web
4. The Outlook on the Web Environment
5. System Requirements for the Outlook on the Web
6. Using the Outlook on the Web (Light) Version
7. Applying a Theme
8. Adding and Managing Add-ins

E-Mail
1. Using the Inbox
2. Creating and Addressing Messages
3. Entering and Formatting Messages
4. Checking Message Spelling
5. Saving Message Drafts
6. Sending Attachments from OneDrive
7. Sending Local Attachments
8. Inserting Pictures
9. Sending a Message
10. Receiving E-Mail Messages
11. Opening Messages
12. Printing Messages
13. Downloading Attachments
14. Replying to Messages
15. Forwarding Messages
16. Ignoring a Conversation Thread
17. The Deleted Items Folder
18. Permanently Deleting Items
19. Recovering Deleted Items

Managing Items
1. Creating and Managing Categories
2. Categorizing Items
3. Marking Messages as Read or Unread
4. Flagging Items
5. Marking Messages as Junk
6. Pinning Messages
7. Archiving Messages
8. Changing the Display of Messages in the Inbox Pane

Mailbox Management
1. Creating and Using Inbox and Sweep Rules
2. Creating a Folder
3. Moving and Copying Messages
4. Managing the Favorites Folder List
5. Filtering and Sorting Messages in the Inbox Pane
6. Setting and Managing Folder Permissions
7. Finding Items

E-Mail Options
1.Creating and Using E-Mail Signatures
2. Using Automatic Replies (Out of Office Assistant)
3. Changing Your Password
4. Viewing Your Mailbox Usage
5. Enabling Online Access

Calendar
1. Opening the Calendar
2. Navigating Calendar Dates
3. Creating Appointments and Events
4. Canceling Appointments and Events
5. Creating Recurring Appointments and Events
6. Printing the Calendar
7. Sharing Calendars
8. Managing Multiple Calendars
9. Adding Shared Calendars
10. Using the Scheduling Assistant
11. Using the Suggested Meetings App
12. Accessing Calendar Options
13. Changing Automatic Processing Settings
14. Changing the Calendar Appearance
15. Changing the Notifications Settings
16. Publishing Calendars
17. Changing Reminders Settings

Meetings
1. Creating a Meeting Request
2. Responding to Meeting Requests
3. Viewing Meeting Request Responses
4. Editing and Updating Meetings
5. Creating Recurring Meetings

People
1. Creating a New Contact
2. Adding Contacts from E-Mail
3. Creating a Contact List
4. Linking Contacts
5. Finding Contacts
6. Connecting to Social Networks
7. Using the Directory
8. Importing Contacts

Tasks
1. Creating a New Task
2. Editing Tasks
3. Attaching Files to Tasks
4. Viewing Tasks and Flagged Items
5. Sorting Tasks
6. Filtering Tasks
7. Deleting Tasks

Groups
1. Accessing Groups
2. Creating a New Group
3. Adding Members to Groups
4. Contributing to Groups
5. Managing Files in Groups
6. Accessing the Group Calendar
7. Changing the View of Groups
8. Subscribing to and Unsubscribing from Groups
9. Leaving Groups
10. Editing, Managing, and Deleting Groups

Peachtree Course Syllabus

Getting Acquainted with Peachtree
1. The Peachtree Environment
2. The Peachtree Navigation Centers
3. Using the Menu Bar
4. Using the Main Application Toolbar
5. Learning Common Business Terms

Setting Up a Company
1. Creating a Peachtree Company
2. Setting Customer Defaults
3. Setting Vendor Defaults
4. Setting Inventory Defaults
5. The Payroll Setup Wizard
6. Setting Payroll & Employee Defaults
7. Setting Job Defaults
8. Making a Backup
9. Restoring from a Backup File

Using the General Ledger
1. General Ledger Default Settings
2. Adding Accounts
3. Deleting Accounts
4. Adding Beginning Account Balances
5. Adding General Journal Entries
6. Basic General Ledger Reports
7. Entering Account Budgets

8. The Cash Account Register

Starting Accounts Receivable
1. Setting Up Accounts Receivable Defaults
2. Adding Customers
3. Adding Customer Beginning Balances
4. Setting Statement and Invoice Defaults
5. Sales Orders & Invoicing
6. The Sales Orders Window
7. The Sales/Invoicing Window
8. The Receipts Window
9. Statements and Finance Charges
10. Selecting Deposits
11. Changing a Record ID

Starting Accounts Payable
1. Setting Up Accounts Payable Defaults
2. Adding Vendors
3. Adding Beginning Balances for Vendors
4. The Purchase Orders Window
5. Entering a Drop Shipment
6. Select for Purchase Orders
7. The Purchases/Receive Inventory Window
8. The Payments Window
9. The Select For Payment Window

Adding Inventory
1. Adding Inventory
2. Removing Inventory
3. Entering Inventory Beginning Balances
4. Building and Unbuilding Assemblies
5. Making Inventory Adjustments
6. Changing Item Prices

Creating Payroll
1. Adding Employees
2. Adding Employee Beginning Balances
3. Paying a Group of Employees
4. Paying an Employee
5. Creating Payroll Formulas
6. Elements of Payroll Formulas

Account Management
1. Writing Checks
2. Voiding Checks
3. Reconciling Bank Accounts
4. Changing the Accounting Period

Using Sales Tax
1. The Sales Tax Wizard
2. Sales Tax Authorities
3. Sales Tax Codes & Exempt Sales
4. Collecting Sales Tax
5. Paying Sales Taxes

Using Quotes
1. Entering Quotes
2. Converting Quotes

Job Tracking
1. Setting Up a Job
2. Setting Job Defaults
3. Entering Beginning Balances for Jobs
4. Making Purchases for a Job
5. Invoicing for Job Purchases
6. Job Tracking

Time and Billing
1. Adding Time Ticket Employees
2. Entering Activity Items
3. Entering Charge Items
4. Entering Time Tickets
5. Entering Expense Tickets
6. Billing Time and Expense Tickets

Changing System Settings
1. Changing Posting Methods
2. Posting/Unposting
3. Memorized Transactions
4. Using the Purge Wizard
5. Using the Year-End Wizard

Reporting
1. The Cash Manager
2. The Collection Manager
3. The Payment Manager
4. The Financial Manager
5. Find on Report
6. Preset Reports
7. Report Groups
8. Modifying Reports
9. Exporting Reports to Excel
10. Importing & Exporting Data
11. Exporting to PDF
12. Modifying Screen Templates
13. Modifying Forms

The Internal Accounting Review
1. Using the Internal Accounting Review

Action Items
1. Events
2. To-Do Items
3. Alerts

Options
1. Changing Global Options
2. Changing the System Date

Assets and Liabilities
1. Assets and Liabilities
2. Creating an Other Current Assets Account
3. Subtracting Value from an Other Current Assets Account
4. Creating a Fixed Assets Account
5. Accumulated Depreciation
6. Liability Accounts
7. Paying on a Long Term Liability
8. Equity

Credits
1. Entering Credit Memos
2. Applying Credit Memos
3. Entering Vendor Credit Memos

Help
1. Using the Contents
2. Using the Index
3. Using the Search Feature

Photoshop Course Syllabus

Getting Acquainted with Photoshop
1. The Photoshop Environment
2. Palettes and the Palette Well
3. Creating Custom Workspaces
4. Opening Images
5. Using the File Browser
6. Image Magnification
7. Viewing Document Information
8. Moving the Image
9. Undoing Mistakes and The History Palette
10. Displaying Drawing Guides
11. Making Measurements
12. Adding Annotations
13. Setting Preferences

Adobe Bridge
1. The Adobe Bridge Environment
2. Display Options
3. Compact Mode
4. Navigating, Opening & Placing Files
5. Searching for Files and Folders
6. Labeling and Rating Files
7. Sorting and Filtering Files
8. Copying, Moving and Deleting Files
9. Stacking and Unstacking
10. Previewing Images and the Loupe Tool
11. Rotating Images
12. Viewing a Slideshow
13. Viewing and Editing Metadata
14. Keywords
15. Mini Bridge

Basic Image Manipulation
1. Bitmap Images
2. Vector Images
3. Image Size and Resolution Settings
4. Scanning Images
5. Creating New Images
6. Placing Files

Color Basics
1. Color Modes and Models
2. Color Mode Conversion
3. Previewing Color Differences Between Operating Systems
4. Color Management
5. Foreground and Background Colors
6. Using the Color Picker
7. Selecting Colors with the Color Palette
8. Selecting Colors with the Eyedropper Tool
9. Selecting Colors with the Swatches Palette

Painting Tools
1. Painting Tools
2. The Brush Tool
3. Blending Modes
4. The Pencil Tool
5. The Color Replacement Tool
6. The Eraser Tool
7. The Magic Eraser Tool
8. The Background Eraser Tool
9. Using the Art History Brush
10. Using the History Brush
11. Using the Mixer Brush

Brush Settings
1. Using the Brushes Palette
2. Creating Custom Brush Tips by Selection
3. Creating Custom Brush Tips in the Brushes Palette
4. Setting Shape Dynamics
5. Setting Brush Scattering
6. Setting Brush Texture
7. Setting Dual Brushes
8. Setting Color Dynamics
9. Setting Other Dynamics
10. Miscellaneous Brush Settings
11. Clearing Brush Settings
12. Saving a Customized Brush
13. Saving a Customized Brush Library

Making Selections
1. Selection Basics
2. Making Pixel Selections
3. The Marquee Tools
4. Refining Edges of Selections
5. The Lasso Tools
6. The Magic Wand Tool
7. The Quick Selection Tool
8. Selecting by Color Range
9. Adjusting Pixel Selections
10. The Extract Command
11. Copying and Pasting Pixel Selections
12. Saving and Loading Selections

Filling and Stroking
1. Applying Fills
2. Using the Paint Bucket Tool
3. Using the Gradient Tool
4. Using the Gradient Editor
5. Using Patterns
6. Using the Pattern Maker
7. Stroking

Layers
1. Using Layers and Layer Groups/Sets
2. Creating Layers and Layer Groups/Sets
3. Stacking and Linking Layers
4. Moving Layer Content with the Move Tool
5. Locking Layers
6. Common Layer Management Tasks
7. Merging and Flattening Layers

Advanced Layers
1. Layer Styles
2. Adjustment Layers and Fill Layers
3. The Adjustments Panel
4. Masking Layers
5. The Masks Panel
6. Creating Clipping Groups
7. Creating Knockouts
8. Smart Objects
9. Smart Filters

Text
1. Text Basics
2. Entering Text
3. Selecting Text
4. Editing the Bounding Box
5. Creating a Type Selection
6. Applying Effects to Type Layers
7. Using the Character Palette
8. Checking for Spelling Errors
9. Using the Paragraph Palette

Drawing
1. Raster vs. Vector
2. Shape Layers and Shape Options
3. Using the Shape Tools
4. Using the Pen Tools
5. Using the Anchor Point Tools
6. Using the Paths Palette
7. Working with Paths

Using Channels and Masking
1. Using the Channels Palette
2. Using Channels
3. Spot Colors
4. Blending Channels and Layers
5. Masks
6. Using Alpha Channels

Manipulating Images
1. Changing the Canvas Size
2. Rotating and Flipping Images
3. The Rotate View Tool
4. Cropping Images
5. The Perspective Crop Tool
6. The Slice Tools
7. The Free Transform Command
8. The Smudge Tool
9. Blurring and Sharpening Images
10. Using the Dodge Tool and the Burn Tool
11. The Sponge Tool
12. Filters and The Filter Gallery
13. The Liquify Command
14. Vanishing Point
15. Content-Aware Scaling
16. The Puppet Warp Tool

17. The Clone Stamp Tool
18. The Pattern Stamp Tool
19. The Healing Brush Tool
19. The Spot Healing Brush Tool
20. The Patch Tool
21. The Content-Aware Move Tool
22. The Red Eye Tool

Saving Images
1. Saving Images
2. The Save for Web & Devices Dialog Box

Printing
1. Printing Images
2. Setting Printing Options

Automating Tasks
1. Actions and the Actions Palette
2. Playing Actions
3. Editing Actions
3. Playing Pre-Loaded Actions

Help
1. Photoshop Help
2. System Info
3. Online Updates

Photoshop Elements Course Syllabus

Getting Acquainted with Photoshop Elements
1. Introduction to Photoshop Elements
2. The Welcome Screen
3. Changing the Start-Up Mode
4. eLive

Importing Photos Into the Organizer
1. The Organizer Environment
2. JPEG and Camera Raw
3. Importing Photos from Files and Folders
4. Importing Photos from Cameras and Card Readers
5. Importing Photos from a Scanner
6. Importing Photos in Bulk
7. Setting Watch Folders (Windows Only)

Using the Organizer
1. Grid, Single Photo, and Full Screen Views
2. Creating and Using Albums
3. Photo Sharing
4. Managing Albums
5. The Taskbar
6. Creating a New Catalog
7. Renaming Images

8. Creating Keyword Tags
9. Creating New Tag Categories
10. Assigning and Managing Tags and Ratings
11. Stacking and Unstacking
12. Assigning Digital Notes
13. Sorting Images
14. Searching and Finding Your Images
15. Date View and Timeline View
16. Back Up and Restore a Catalog
17. Managing Files in the Organizer

Camera Raw
1. About Processing Camera Raw Files
2. Opening a Camera Raw Image from the Organizer
3. Opening a Camera Raw Image from the Editor
4. The Camera Raw Dialog Box in the Editor
5. Camera Raw Tools
6. Camera Calibration Settings
7. Applying and Saving Custom Camera Settings

8. Adjusting White Levels
9. Making Basic Tonal Adjustments
10. Making Image Detail Adjustments
11. Opening a Copy of the Camera Raw File in the Editor
12. Saving a Camera Raw File as a DNG File

Edit Modes
1. The Different Edit Modes
2. The Expert Edit Mode Environment
3. The Panel Bin and Taskbar
4. The Photo Bin
5. The Undo Command and Undo History Panel
6. Opening Images
7. Image Magnification
8. Viewing Document Information
9. Moving the Image
10. Setting Preferences
11. Quick Edit Mode
12. Guided Edit Mode

Basic Image Manipulation
1. Bitmap Images
2. Vector Images
3. Image Size and Resolution Settings
4. Creating New Images
5. Placing Files
6. Displaying Drawing Guides

Color Basics
1. Color Modes and Models
2. Color Mode Conversion
3. Color Management
4. Foreground and Background Colors
5. Using the Color Picker
6. Selecting Colors with the Color Picker Tool
7. Selecting Colors with the Swatches Panel

Painting Tools
1. Painting Tools
2. The Brush Tool
3. Blending Modes
4. The Impressionist Brush
5. The Pencil Tool
6. The Color Replacement Tool
7. The Eraser Tool
8. The Magic Eraser Tool
9. The Background Eraser Tool
10. The Smart Brush Tools

Brush Settings
1. Using the Brush Preset Picker
2. Loading New Brush Sets
3. Creating Custom Brush Presets
4. Creating Brush Tips from Selections
5. Setting Shape Dynamics
6. Resetting the Brush and Tool Settings

Making Selections
1. Selection Basics
2. Making Pixel Selections
3. The Marquee Tools
4. The Lasso Tool
5. The Polygonal Lasso Tool
6. The Magnetic Lasso Tool
7. The Magic Wand Tool
8. The Auto Selection Tool
9. The Selection Brush Tool
10. The Refine Selection Brush Tool
11. The Quick Selection Tool
12. Modifying Pixel Selections
13. Refining Selection Edges
14. Transforming Selections
15. Copying and Pasting Pixel Selections
16. Saving and Loading Selections

Filling and Stroking
1. Applying Fills
2. Using the Paint Bucket Tool
3. Using the Gradient Tool
4. Using the Gradient Editor
5. Using Patterns
6. Stroking

Layers
1. About Layers and the Layers Panel
2. Layer Types
3. Creating New Layers
4. Converting a Background Layer
5. Selecting Layers
6. Hiding and Showing Layers
7. Duplicating Layers
8. Stacking and Linking Layers
9. Linking Layers
10. Grouping Layers
11. Color Coding Layers
12. Moving Layer Content with the Move Tool
13. Locking Pixels in Layers
14. Renaming Layers and Deleting Layers
15. Merging Layers and Flattening Layers
16. Layer Styles
17. Adjustment Layers and Fill Layers
18. Creating Clipping Groups
19. Layer Masks

Text
1. Text Basics
2. Creating Point Text
3. Creating Paragraph Text
4. Selecting Text
5. Manipulating and Moving Text Boxes
6. Creating a Type Mask
7. Warping Text
8. Applying Layer Styles to Text Layers
9. Simplifying Text
10. Text on Selections, Shapes and Custom Paths Tools

Drawing
1. Raster vs. Vector
2. Shape Layers and Shape Options
3. Using the Shape Tools
4. The Cookie Cutter Tool

Manipulating Images
1. Changing the Canvas Size
2. Rotating and Flipping Images
3. Cropping Images
4. The Free Transform Command
5. The Smudge Tool
6. Blurring and Sharpening Images
7. Using the Dodge Tool and the Burn Tool
8. The Sponge Tool
9. Filters and The Filter Gallery
10. The Liquify Command
11. Applying Effects
12. The Clone Stamp Tool
13. The Recompose Tool
14. Photomerge

15. The Pattern Stamp Tool
16. The Healing Brush Tool
17. The Spot Healing Brush Tool
18. The Straighten Tool
19. The Content-Aware Move Tool
20. Correcting Camera Distortions

Enhancing Photos
1. Auto Fixes
2. The Red Eye Removal Tool
3. Adjusting Shadows/Highlights
4. Adjusting Brightness/Contrast
5. Using Levels
6. Removing Color Casts
7. Hue/Saturation
8. Removing Color
9. Replacing Color
10. Color Curves
11. Adjusting Skin Tone
12. Defringing Layers
13. Adjust Smart Fix
14. Convert to Black and White
15. Haze Removal
16. Adjust Sharpness
17. Open Closed Eyes
18. Adjust Facial Features
19. Shake Reduction
20. Unsharp Mask
21. Repairing Photos

Saving Images
1. Saving Images
2. The Save for Web Dialog Box

Printing, Sharing & Creating

1. Printing Images
2. Creation Wizards
3. Creating a Slide Show
4. Editing a Slide Show
5. Sharing Your Creations

Help
1. Elements Help
2. System Info
3. Online Updates

PowerPoint Course Syllabus

Getting Acquainted with PowerPoint

1. The PowerPoint Environment
2. The Title Bar
3. The Ribbon
4. The "File" Tab and Backstage View
5. The Quick Access Toolbar
6. Touch/Mouse Mode
7. The Scroll Bars
8. The Presentation View Buttons
9. The Zoom Slider
10. The Status Bar
11. The Mini Toolbar
12. Keyboard Shortcuts
13. What's New in PowerPoint 2016

Creating Basic Presentations
1. Opening Presentations
2. Closing Presentations
3. Creating New Presentations
4. Saving Presentations
5. Recovering Unsaved Presentations
6. Inserting New Slides
7. Applying Slide Layouts
8. Sharing Presentations
9. Working with PowerPoint File Formats

Using Presentation Views
1. Normal View
2. Outline View
3. Slide Sorter View
4. Notes Page View
5. Slide Show View
6. Reading View

Using Text
1. Adding Text to Slides
2. Basic Object Manipulation
3. Font Formatting
4. Paragraph Formatting
5. Applying Custom Bullets and Numbering
6. Using Tabs
7. Setting Text Options
8. Checking Spelling

Using Pictures
1. Inserting Pictures Saved Locally
2. Inserting Online Pictures
3. Basic Graphic Manipulation
4. Using Picture Tools
5. Using the Format Picture Task Pane
6. Fill and Line Settings
7. Effects Settings
8. Size and Properties Settings
9. Picture Settings

Using SmartArt
1. Inserting and Manipulating SmartArt
2. Formatting SmartArt

Using Slide Show View
1. Running a Slide Show
2. Using Custom Shows

Printing Your Presentation
1. Changing Slide Size
2. Setting the Slide Header and Footer
3. Previewing and Printing Presentations

Helping Yourself
1. Using PowerPoint Help
2. The Tell Me Bar
3. Smart Lookup and Insights

Applying Animation
1. Adding Slide Transition Animation
2. Adding Object Animation

Drawing Objects
1. Inserting Shapes
2. Formatting Shapes
3. Inserting WordArt

Inserting Video and Sound
1. Inserting Videos
2. Inserting Audio
3. Animating Multimedia Playback
4. Recording a Sound
5. Screen Recording

Using Themes
1. Applying Themes
2. Creating Custom Color Schemes
3. Creating Custom Font Schemes
4. Customizing the Slide Background

Using Presentation Masters
1. Using Slide Masters and Slide Layouts
2. Using the Notes Master
3. Using the Handout Master
4. Saving a Presentation Template

Setting Up the Presentation
1. Setting Up the Slide Show
2. Recording Narration
3. Rehearsing Timings

Applying Actions
1. Inserting Actions
2. Inserting Hyperlinks

Inserting Charts, Tables, and Objects
1. Inserting Charts
2. Inserting Tables
3. Inserting Objects

Setting PowerPoint Options
1. Setting PowerPoint Options

Project Course Syllabus

Getting Acquainted with Project
1. About Project
2. Starting Project
3. Project Management Terms and Concepts
4. The Project Environment
5. The Title Bar
6. The Ribbon
7. The "File" Tab and Backstage View
8. The Scroll Bars
9. The Quick Access Toolbar
10. The Entry Bar
11. The Status Bar
12. Touch Mode

Project Basics
1. Opening Projects
2. Closing Projects
3. Creating New Projects
4. Saving Projects
5. Changing Project Views
6. Planning a Project

Tasks
1.Creating Tasks
2. Editing and Deleting Tasks
3. Setting Task Duration
4. Linking Tasks
5. Marking Milestones
6. Using Phases and Summary Tasks
7. Using Task Notes

Resources
1. Project Resources Overview
2. Creating Work Resources
3. Creating Material Resources
4. Creating Cost Resources
5. Entering Costs for Project Resources
6. Scheduling Work Resources
7. Creating New Base Calendars

Resource and Task Assignment
1. Assigning Work Resources to Tasks
2. Assigning Material Resources to Tasks
3. Assigning Cost Resources to Tasks
4. The Team Planner

Tracking Project Tasks
1. Creating Project Baselines
2. Updating Multiple Tasks in a Project
3. Updating Tasks Individually
4. Rescheduling Uncompleted Work

Formatting Gantt Chart Views

1. Formatting Text in a Gantt Chart
2. Formatting Gridlines in a Gantt Chart
3. Formatting the Task Bar Layout in a Gantt Chart
4. Formatting Columns in Gantt Charts
5. Applying Bar and Gantt Chart Styles
6. Drawing Objects
7. Formatting Timescale in Gantt Charts
8. Creating Custom Views

Other Project Views
1. Using Timeline View
2. Creating Multiple Timelines
3. The Task Usage View
4. The Network Diagram View
5. The Calendar View
6. Printing Views

Advanced Task Management

1. Setting Task Lead and Lag Time
2. Using Task Constraints
3. Task Types
4. Setting Deadlines
5. Interrupting Tasks
6. Moving and Rescheduling Tasks
7. Inspecting Tasks
8. Creating Recurring Tasks
9. Entering Fixed Costs
10. Critical Paths
11. Using WBS Codes

Advanced Resource Management
1. Applying Multiple Resource Rates
2. Advanced Resource Availability
3. Using Work Contours
4. Material Resource Consumption Rates
5. Delaying Resource Assignments

Advanced Project Tracking
1. Monitoring Resource Allocation
2. Leveling Overallocated Resources
3. Monitoring Project Costs
4. Monitoring Project Statistics

Advanced Project Tools
1. Using the Organizer
2. Making Macros
3. Customizing the Ribbon
4. Creating and Linking Resource Pools
5. Using and Updating Resource Pools
6. Consolidating and Linking Multiple Projects

Reporting
1. Using Earned Value Analysis
2. Creating Basic Reports
3. Selecting Report Objects
4. Changing the Report View
5. Basic Report Formatting
6. Inserting Report Objects
7. Managing Reports
8. Basic Page Setup for Reports
9. Advanced Page Setup for Reports
10. Printing Reports

Modifying Report Objects
1. Selecting, Moving and Resizing Report Charts
2. Using the Field List with Report Charts
3. Designing Report Charts
4. Formatting Report Charts
5. Using Report Tables
6. Designing Report Tables
7. Setting Report Table Layout Options
8. Modifying Pictures, Text Boxes and Shapes
9. Formatting Text Boxes and Shapes
10. Formatting Report Pictures

Visual Reporting
1. Using Visual Reports

Publisher Course Syllabus

Getting Acquainted with Publisher
1. The Publisher Environment
2. The Title Bar
3. The Ribbon
4. The File Tab and Backstage View
5. The Quick Access Toolbar
6. Touch Mode
7. The Scroll Bars
8. The Page Layout View Buttons
9. The Zoom Slider and Zoom Button
10. The Status Bar
11. The Mini Toolbar
12. Keyboard Shortcuts

Creating Basic Publications
1. Creating New Publications
2. Changing the Publication Template
3. Using Business Information
4. Saving Publications
5. Closing Publications
6. Opening Publications
7. Inserting New Pages
8. Deleting Pages
9. Moving Pages

Basic Skills
1. Inserting Text Boxes
2. Inserting Shapes
3. Adding Text to Shapes
4. Inserting Pictures Saved Locally
5. Inserting Online Pictures
6. Inserting Picture Placeholders

7. Using the Scratch Area

8. Moving, Resizing, and Rotating Objects

9. Deleting Objects

10. Using Find and Replace

11. Using AutoCorrect

12. Inserting WordArt

Formatting Objects
1. Formatting Text
2. Formatting Shapes
3. Formatting Pictures

Using Building Blocks
1. Creating Basic Building Blocks
2. Using Building Blocks

Master Pages
1. Using Master Pages

Customizing Schemes
1. Creating a Custom Color Scheme
2. Creating a Custom Font Scheme
3. Customizing Page Backgrounds

Using Tables
1. Creating and Deleting Tables
2. Selecting Table Elements
3. Inserting and Deleting Columns and Rows
4. Merging Text in Table Cells
5. Modifying Text in Table Cells
6. Formatting Tables

Page Setup and Layouts
1. Using Page Setup
2. Using Layout Guides
3. Using the Rulers

Mailings
1. Mail Merge
2. The Step by Step Mail Merge Wizard
3. Creating a Data Source
4. Selecting Recipients
5. Inserting and Deleting Merge Fields
6. Previewing a Merge
7. Detaching the Data Source
8. Finishing a Mail Merge
9.Merging a Catalog

Printing
1. Previewing and Printing
2. Using the Pack and Go Feature
3. Sharing and Exporting Publications

Helping Yourself
1. Using Publisher Help

QuickBooks Course Syllabus

The QuickBooks Environment
1. The Home Page

2. The Centers

3. The Menu Bar and Keyboard Shortcuts
4. The Open Window List
5. The Icon Bar
6. Customizing the Icon Bar
7. The Chart of Accounts
8. Accounting Methods
9. Financial Reports

Creating a QuickBooks Company File
1. Using Express Start
2. Using the EasyStep Interview
3. Returning to the Easy Step Interview
4. Creating a Local Backup Copy
5. Restoring a Company File from a Local Backup Copy
6. Setting Up Users
7. Single and Multiple User Modes
8. Closing Company Files
9. Opening a Company File

Using Lists
1. Using Lists
2. The Chart of Accounts
3. The Customers & Jobs List
4. The Employees List

5. The Vendors List

6. Using Custom Fields
7. Sorting List
8. Inactivating and Reactivating List Items
9. Printing Lists
10. Renaming & Merging List Items
11. Adding Multiple List Entries from Excel

Setting Up Sales Tax

1. The Sales Tax Process
2. Creating Tax Agencies
3. Creating Individual Sales Tax Items
4. Creating a Sales Tax Group
5. Setting Sales Tax Preferences
6. Indicating Taxable & Non-taxable Customers and Items

Setting Up Inventory Items
1. Setting Up Inventory
2. Creating Inventory Items
3. Creating a Purchase Order
4. Receiving Items with a Bill
5. Entering Item Receipts
6. Matching Bills to Item Receipts
7. Adjusting Inventory

Setting Up Other Items

1. Service Items
2. Non-Inventory Items
3. Other Charges
4. Subtotals
5. Groups
6. Discounts
7. Payments
8. Changing Item Prices

Basic Sales
1. Selecting a Sales Form
2. Creating an Invoice
3. Creating Batch Invoices
4. Creating a Sales Receipt
5. Finding Transaction Forms
6. Previewing Sales Forms
7. Printing Sales Forms

Using Price Levels
1. Using Price Levels

Creating Billing Statements

1. Setting Finance Charge Defaults
2. Entering Statement Charges
3. Applying Finance Charges and Creating Statements

Payment Processing
1. Recording Customer Payments
2. Entering a Partial Payment
3. Applying One Payment to Multiple Invoices
4. Entering Overpayments
5. Entering Down Payments or Prepayments
6. Applying Customer Credits
7. Making Deposits
8. Handling Bounced Checks

Handling Refunds
1. Creating a Credit Memo and Refund Check
2. Refunding Customer Payments

Entering and Paying Bills

1. Setting Billing Preferences
2. Entering Bills
3. Paying Bills
4. Early Bill Payment Discounts
5. Entering a Vendor Credit
6. Applying a Vendor Credit

Using Bank Accounts
1. Using Registers
2. Writing Checks
3. Writing a Check for Inventory Items

4. Printing Checks
5. Transferring Funds

6. Reconciling Accounts
7. Voiding Checks

Paying Sales Tax
1. Sales Tax Reports
2. Using the Sales Tax Payable Register
3. Paying Your Tax Agencies

Reporting
1. Graph and Report Preferences
2. Using QuickReports
3. Using QuickZoom
4. Preset Reports
5. Modifying a Report
6. Rearranging and Resizing Report Columns
7. Memorizing a Report
8. Memorized Report Groups
9. Printing Reports
10. Batch Printing Forms
11.Exporting Reports to Excel
12. Saving Forms and Reports as PDF Files
13. Comment on a Report
14. Process Multiple Reports
15. Scheduled Reports

Using Graphs
1. Using Graphs
2. Company Snapshot

Customizing Forms
1. Creating New Form Templates
2. Performing Basic Customization
3. Performing Additional Customization
4. The Layout Designer
5. Changing the Grid and Margins in the Layout Designer
6. Selecting Objects in the Layout Designer
7. Moving and Resizing Objects in the Layout Designer
8. Formatting Objects in the Layout Designer
9. Copying Objects and Formatting in the Layout Designer
10. Adding and Removing Objects in the Layout Designer
11. Aligning and Stacking Objects in the Layout Designer
12. Resizing Columns in the Layout Designer

Estimating
1. Creating a Job
2. Creating an Estimate
3. Duplicating Estimates
4. Invoicing From Estimates
5. Updating Job Statuses
6. Inactivating Estimates
7. Making Purchases for a Job
8. Invoicing for Job Costs
9. Using Job Reports

Time Tracking
1. Tracking Time and Printing a Blank Timesheet
2. Weekly Timesheets
3. Time/Enter Single Activity
4. Invoicing from Time Data
5. Using Time Reports
6. Tracking Vehicle Mileage

7. Charging Customers for Mileage

Payroll
1. The Payroll Process
2. Creating Payroll Items
3. Setting Employee Defaults
4. Setting Up Employee Payroll Information
5. Creating Payroll Schedules
6. Creating Scheduled Paychecks
7. Creating Unscheduled Paychecks
8. Creating Termination Paychecks
9. Voiding Paychecks
10. Tracking Your Tax Liabilities
11. Paying Your Payroll Tax Liabilities
12. Adjusting Payroll Liabilities
13. Entering Liability Refund Checks
14. Process Payroll Forms
15. Tracking Workers Compensation

Using Credit Card Accounts

1. Creating Credit Card Accounts
2. Entering Credit Card Charges
3. Reconciling and Paying Credit Cards

Assets and Liabilities
1. Assets and Liabilities
2. Creating and Using an Other Current Asset Account
3. Removing Value from Other Current Asset Accounts
4. Creating Fixed Asset Accounts
5. Creating Liability Accounts
6. Setting the Original Cost of Fixed Assets
7. Tracking Depreciation
8. The Loan Manager
9. The Fixed Asset Item List

Equity Accounts
1. Equity Accounts
2. Recording an Owner's Draw
3. Recording a Capital Investment

Writing Letters With QuickBooks
1. Using the Letters and Envelopes Wizard
2. Editing Letter Templates

Company Management
1. Viewing Your Company Information
2. Setting Up Budgets
3. Using the To Do List
4. Using Reminders and Setting Preferences
5. Making General Journal Entries
6. Using the Cash Flow Projector

Using QuickBooks Tools

1. Company File Cleanup
2. Exporting List Data to an IIF File
3. Advanced Importing of Data
4. Updating QuickBooks
5. Using the Calculator
6. Using the Portable Company Files
7. Using the Calendar
8. The Income Tracker
9. The Bill Tracker
10. The Lead Center

Using the Accountant's Review

1. Creating an Accountant's Copy
2. Transferring an Accountant's Copy
3. Importing Accountant's
4. Removing Restrictions

Using the Help Menu
1. Using Help

QuickBooks Online Course Syllabus

The QuickBooks Online Plus Environment
1. The Dashboard Page
2. The Create Menu
3. The Navigation Bar
4. The Gear

Creating a Company File
1. Signing Up for QuickBooks Online Plus
2. Importing Company Data from a QuickBooks Desktop Version
3. Creating a New Company File
4. How Backups Work in QuickBooks Online Plus
5. Setting Up and Managing Users
6. Transferring the Master Administrator
7. Customizing Company File Settings
8. Customizing Billing and Subscription Settings
9. Customizing Sales Settings
10. Customizing Expenses Settings
11. Customizing Payment Settings
12. Customizing Advanced Settings
13. Signing Out of QuickBooks Online
14. Switching Company Files
15. Cancelling a Company File

Using Pages and Lists
1. Using Lists and Pages
2. The Chart of Accounts
3. Adding New Accounts
4. Assigning Account Numbers
5. Adding New Customers
6. The Customers Page and List
7. Adding Employees to the Employees List
8. Adding New Vendors
9. The Vendors Page and List
10. Sorting Lists
11. Inactivating and Reactivating List Items
12. Printing Lists
13. Renaming and Merging List Items
14. Importing List Entries from a CSV or Excel File

Setting Up Sales Tax
1. The Sales Tax Process in QuickBooks Online
2. Enabling Sales Tax and Sales Tax Settings
3. Adding, Editing, and Deactivating Sales Tax Rates and Agencies
4. Setting a Default Sales Tax
5. Indicating Taxable & Non-Taxable Customers and Items

Setting Up Inventory Items
1. Setting Up Inventory
2. Creating Inventory Items
3. Enabling Custom Fields in Purchase Orders
4. Creating a Purchase Order
5. Applying Purchase Orders to Vendor Transactions
6. Adjusting Inventory

Setting Up Other Items
1. Creating a Product or Service Item
2. Creating a Bundle
3. Creating a Discount Line Item
4. Creating a Payment Plan
5. Changing Item Prices

Basic Sales
1. Enabling Custom Fields in Sales Forms
2. Creating an Invoice
3. Creating a Recurring Invoice
4. Creating Batch Invoices
5. Creating a Sales Receipt
6. Finding Transaction Forms
7. Previewing Sales Forms
8. Printing Sales Forms
9. Grouping and Subtotaling Items in Invoices
10. Grouping and Hiding Item Display in Service Only Invoices
11. Entering a Delayed Charge
12. Managing Sales Transactions
13. Sending Invoice Links

Creating Billing Statements
1. Entering Customer Charges
2. Creating Finance Charge Items
3. Creating Finance Charge Invoices
4. Creating Customer Statements

Payment Processing
1. Recording Customer Payments
2. Entering a Partial Payment
3. Applying One Payment to Multiple Invoices
4. Entering Overpayments
5. Entering Down Payments or Prepayments
6. Applying Customer Credits
7. Making Deposits
8. Handling Bounced Checks by Invoice
9. Handling Bounced Checks by Check
10. Handling Bounced Checks by Journal Entry
11. Handling Bad Debt

Handling Refunds
1. Creating a Credit Memo and Refund Check
2. Refunding Customer Payments
3. Entering a Delayed Credit

Entering And Paying Bills
1. Entering Bills
2. Paying Bills
3. Creating Terms for Early Bill Payment
4. Early Bill Payment Discounts
5. Entering a Vendor Credit
6. Applying a Vendor Credit
7. Managing Expense Transactions

Using Bank Accounts
1. Using Registers
2. Writing Checks
3. Writing a Check for Inventory Items

4. Printing Checks
5. Transferring Funds Between Accounts
6. Reconciling Accounts
7. Voiding Checks
8. Creating an Expense
9. Managing Bank and Credit Card Transactions
10. Managing Bank Transaction Rules

Paying Sales Tax
1. Sales Tax Reports
2. Using the Sales Tax Payable Register
3. Paying Your Tax Agencies

Reporting
1. Creating Customer and Vendor QuickReports
2. Creating Account QuickReports
3. Using QuickZoom
4. Preset Reports
5. Basic Preset Report Customization
6. Customizing General Report Settings
7. Customizing Rows and Columns Report Settings
8. Customizing Aging Report Settings
9. Customizing Filter Report Settings
10. Customizing Header and Footer Report Settings
11. Resizing Report Columns
12. Emailing, Printing, and Exporting Preset Reports
13. Saving Customized Reports
14. Using Report Groups
15. Management Reports
16. Customizing Management Reports

Using Graphs
1. Company Snapshot

Customizing Forms
1. Creating Custom Form Styles
2. Custom Form Design Settings
3. Custom Form Content Settings
4. Custom Form Emails Settings
5. Custom Form Payments Settings
6. Managing Custom Form Styles

Estimating
1. Using Sub-Customers for Jobs
2. Enabling and Creating Estimates
3. Changing the Term “Estimate”
4. Invoicing from an Estimate
5. Duplicating Estimates
6. Using an Estimate with Multiple
Invoices
7. Changing the Estimate Status
8. Entering Expenses for Jobs
9. Invoicing for Job Costs
10. Using Job Reports
11. Deleting Estimates

Time Tracking
1. Tracking Time and Printing Timesheets
2. Weekly Timesheets
3. Single Time Activity
4. Invoicing from Time Data
5. Using Time Reports
6. Entering Bills for Mileage

Payroll
1. The Payroll Process
2. Creating Employee Deductions and Company Contributions & Garnishments
3. Adding Additional Pay Types for Employees
4. Editing Employee Information
5. Creating Payroll Schedules
6. Creating Scheduled Paychecks
7. Creating One Paycheck at a Time
8. Creating Commission Only or Bonus Only Paychecks
9. Handling Terminated Employees
10. Edit, Delete, or Void Paychecks
11. Tracking Your Tax Liabilities
12. Paying Payroll Tax Liabilities
13. Adjusting Fringe Benefits
14. Process Payroll Forms
15. Tracking Workers’ Compensation
16. Manually Recording External Payroll

Using Credit Card Accounts
1. Creating Credit Card Accounts
2. Entering Charges on Credit Cards
3. Entering Credit Card Credits
4. Reconciling and Paying Credit Cards

Assets and Liabilities
1. Assets and Liabilities
2. Creating and Using Other Current Asset Accounts
3. Removing Value from Other Current Asset Accounts
4. Creating Fixed Asset Accounts
5. Creating Liability Accounts
6. Setting the Original Cost of the Fixed Asset
7. Tracking Depreciation

Equity Accounts

1. Equity Accounts
2. Recording an Owner's Draw
3. Recording a Capital Investment

Company Management
1. Viewing Your Company Information

2. Setting Up Budgets
3. Using the Reminder List
4. Making General Journal Entries

Using QuickBooks Tools
1. Exporting Report and List Data to Excel
2. Using the Audit Log

Using QuickBooks Other Lists
1. Using the Recurring Transactions List
2. Using the Location List
3. Using the Payment Methods List
4. Using the Terms List
5. Using the Classes List
6. Using the Attachments List

Allowing Accountant Access
1. Inviting Your Accountant

Using Help, Feedback and Apps
1. Using the Help Menu
2. Submitting Feedback
3. Extending QuickBooks Online Using Apps

Resume Writing Course Syllabus

Introduction to Resume Writing
1. The Function of a Resume
2. Types of Resumes
3. How Long Should Your Resume Be?
4. Fonts, Margins and Printing
5. File Formats

Section Headings
1. Developing a "Master Resume"
2. Resume Header
3. Objective/Summary/Profile
4. Experience
5. Education
6. Skills
7. Involvement
8. Research
9. Awards
10. Publications
11. Activities
12. Work Status
13. Tailoring Your Resume

Understanding Keywords
1. About ATS
2. Researching Keywords
3. Using Keywords in Your Resume

Covering All The Bases
1. The Cover Letter
2. Developing Professional References
3. Other Preparations

Review Questions
1. Review Questions 1-5
2. Review Questions 6-10
3. Review Questions 11-15

Conclusion
1. Further Study
2. Conclusion

Sage 50 Course Syllabus

Getting Acquainted with Sage 50
1. The Sage 50 Environment
2. The Sage 50 Navigation Centers
3. Using the Menu Bar
4. Learning Common Business Terms

Setting Up a Company
1. Creating a Sage 50 Company
2. Setting Customer Defaults
3. Setting Vendor Defaults
4. Setting Inventory Defaults
5. The Payroll Setup Wizard
6. Setting Employee Defaults
7. Setting Job Defaults
8. Making a Backup
9. Restoring from a Backup File
10. Setting up Security and Creating Users

Using the General Ledger
1. General Ledger Default Settings
2. Adding Accounts
3. Deleting Accounts
4. Adding Beginning Account Balances
5. Adding General Journal Entries
6. Basic General Ledger Reports
7. Entering Account Budgets

8. The Cash Account Register

Using Sales Tax
1. The Sales Tax Wizard
2. Collecting Sales Tax
3. Paying Sales Taxes

Entering Records
1. Entering Customer Records
2. Entering Customer Beginning Balances
3. Entering Vendor Records
4. Entering Vendor Beginning Balances
5. Entering Inventory
6. Entering Inventory Beginning Balances
7. Changing a Record ID

Accounts Receivable
1. Setting Statement and Invoice Defaults
2. Quotes, Sales Orders and Invoicing
3. Entering Quotes
4. Converting Quotes
5. The Sales Orders Window
6. The Proposals Window
7. The Sales/Invoicing Window
8. Entering and Applying Credit Memos
9. The Receive Money Window
10. Statements and Finance Charges
11. Selecting Deposits

Accounts Payable
1. The Purchase Orders Window
2. Entering a Drop Shipment
3. Select for Purchase Orders
4. The Purchases/Receive Inventory Window
5. The Payments Window
6. The Select For Payment Window
7. Entering Vendor Credit Memos

Managing Inventory
1. Building and Unbuilding Assemblies
2. Making Inventory Adjustments
3. Changing Item Prices

Creating Payroll
1. Adding Employees
2. Adding Employee Beginning Balances
3. Performance Reviews and Raise History
4. Paying a Group of Employees
5. Paying an Employee

Account Management
1. Writing Checks
2. Voiding Checks
3. Reconciling Bank Accounts
4. Changing the Accounting Period

Job Tracking
1. Setting Up a Job
2. Creating Custom Fields for Jobs
3. Creating Phases for Jobs
4. Creating Cost Codes for Phases
5. Entering Beginning Balances for a Job
6. Making Purchases for a Job
7. Invoicing for Job Purchases
8. Job Tracking
9. Entering Change Orders for a Job

Time and Billing
1. Adding Time Ticket Employees
2. Entering Activity Items
3. Entering Charge Items
4. Entering Time Tickets
5. Entering Expense Tickets
6. Billing Time and Expense Tickets

Changing System Settings
1. Changing Your Company's Posting Methods
2. Posting/Unposting
3. Memorized Transactions
4. Using the Purge Wizard
5. Using the Year-End Wizard

Reporting
1. The Cash Manager
2. The Collection Manager
3. The Payment Manager
4. The Financial Manager
5. Find on Report
6. Previewing and Printing Preset Reports
7. Report Groups
8. Modifying Reports
9. Exporting Reports to Excel
10. Importing and Exporting Data
11. Exporting Reports to PDF
12. Modifying Task Window Screen Templates
13. Modifying Forms

The Internal Accounting Review
1. Using the Internal Accounting Review

Action Items
1. Events
2. To-Do Items
3. Alerts

Options
1. Changing Global Options
2. Changing the System Date

Assets and Liabilities
1. Assets and Liabilities
2. Creating an Other Current Assets Account
3. Subtracting Value from an Other Current Assets Account
4. Creating a Fixed Assets Account
5. Accumulated Depreciation
6. Liability Accounts
7. Paying on a Long Term Liability
8. Equity

Help
1. Using the Contents
2. Using the Index
3. Using the Search Feature

SQL Course Syllabus

Introduction to Databases and SQL
1. Overview of a Database
2. The "Flat-File" Method of Data Storage
3. The Relational Model of Data Storage
4. Tips for Creating a Relational Database
5. What is SQL?
6. Using SQL in Access 2013

Data Definition Language
1. The CREATE Statement
2. The CREATE DATABASE Statement
3. The CREATE TABLE Statement
4. The CREATE INDEX Statement
5. SQL Constraints
6. The DROP Statement
7. The ALTER TABLE Statement
8. NULL Values in SQL
9. Data Types in SQL
10. Auto-Increment in SQL

Data Manipulation Language
1. The INSERT Statement
2. The UPDATE Statement
3. The DELETE Statement
4. The SELECT Statement
5. The WHERE Clause
6. Criteria Notation and Wildcard Characters in the WHERE Clause
7. The ORDER BY Clause
8. The GROUP BY Clause and Aggregate Functions
9. The JOIN Clause
10. The UNION Operator
11. The SELECT INTO Statement
12. The INSERT INTO SELECT Statement
13. Subqueries

Data Control Language
1. The CREATE USER and CREATE ROLE Statements
2. Privileges
3. The GRANT Statement
4. The REVOKE Statement
5. The ALTER USER and ALTER ROLE Statements
6. The DROP USER and DROP ROLE Statements

Transaction Control Language
1. The TRANSACTION Statement

SQL Functions and Aliases
1. Understanding SQL Functions
2. Calculated Fields and Column Aliases
3. Table Aliases

Views
1. About Views
2. The CREATE VIEW Statement
3. The ALTER VIEW Statement
4. The DROP VIEW Statement

Windows Course Syllabus

Introduction to Windows
1. About Windows
2. Sign in to Windows 10 with a Microsoft User Account
3. The Mouse
4. Touch Gestures in Windows 10

5. The Windows Desktop
6. The Start Button
7. The Start Menu in Windows 10

8. Customizing the Start Menu in Windows 10

9. The Start Screen in Windows 10
10. Customizing the Start Screen in Windows 10

11. Choosing the Start Menu or Start Screen

12. Tablet Mode Settings in Windows 10
13. Using Tablet Mode in Windows 10
14. Text Search in Windows 10
15. Search Using Cortana in Windows 10

16. Universal App Windows in Windows 10
17. App Snapping in Windows 10
18. Resizing a Desktop Window
19. Scrolling a Window
20. Shutting Down Windows
21. Downloading Apps from the Windows Store

22. Sign-in with a PIN or Picture
23. Changing or Removing a PIN or Picture Password

File Explorer
1. File Explorer in Windows 10
2. Navigating Folders
3. Changing Folder Views
4. Sorting Folder Contents
5. Selecting Files
6. Opening a File
7. Reopening a Frequently Opened Folder
8. Creating a New Folder
9. Renaming Files and Folders
10. Cutting, Copying, and Pasting Files and Folders
11. Burning a CD or DVD
12. Deleting Files
13. Managing Libraries in Windows 10
14. Managing the Computer and Drives in Windows 10
15. Quick Access in Windows 10
16. OneDrive Folders in File Explorer
17. Zip Folders in File Explorer
18. Unzip Files in File Explorer

Windows 10 Settings
1. Windows 10 Settings

System Settings
1. Accessing the “System” Settings
2. Changing the Display Settings
3. Notification and Action Settings
4. Managing Apps and Features
5. Multitasking Settings in Windows 10
6. Battery Saver Settings in Windows 10
7. Power and Sleep Settings in Windows 10
8. Manage Storage Space in Windows 10
9. Download and Manage Offline Maps in Windows 10
10. Set the Default Apps in Windows 10
11. View Information About Your Device

Devices Settings
1. Accessing the “Devices” Settings
2. Managing Printers and Scanners
3. Managing Other Connected Devices
4. Mouse and Touchpad Settings
5. Typing Settings
6. AutoPlay Settings

Network and Internet Settings
1. Accessing the “Network and Internet” Settings
2. Connect to Wi-Fi Networks and Manage Wi-Fi Settings
3. Airplane Mode Settings
4. View Data Usage
5. VPN Settings
6. Dial-up Settings
7. Ethernet Settings
8. Proxy Settings

Personalization Settings
1. Accessing the “Personalization” Settings
2. Changing the Background Settings
3. Changing the Color Settings
4. Lock Screen and Screen Saver Settings
5. Theme, Sound, and Desktop Icon Settings
6. Start Settings

Accounts Settings
1. Accessing the “Accounts” Settings
2. Managing Your Account Settings
3. Manage Sign-in Options for Your Device
4. Managing Work Access Account Settings
5. Managing Family and Other Users
6. Managing Sync Settings

Time and Language Settings
1. Accessing the “Time and Language” Settings
2. Date and Time Settings
3. Region and Language Settings
4. Speech Settings

Ease of Access Settings
1. Accessing the “Ease of Access” Settings
2. Narrator Settings
3. Magnifier Settings
4. High Contrast Settings
5. Closed Captions Settings
6. Keyboard Accessibility Settings
7. Mouse Accessibility Settings
8. Cursor and Other Visual Accessibility Settings

Privacy Settings
1. Accessing the “Privacy” Settings
2. General Privacy Settings
3. Location Privacy Settings
4. Camera Privacy Settings
5. Microphone Privacy Settings
6. Speech, Inking, and Typing Privacy Settings
7. Account Info Privacy Settings
8. Contacts Privacy Settings
9. Calendar Privacy Settings
10. Messaging Privacy Settings
11. Radios Privacy Settings
12. Privacy Settings for Other Devices
13. Feedback and Diagnostics Privacy Settings
14. Background Apps Privacy Settings

Update and Security Settings
1. Accessing the “Update and Security” Settings
2. Windows Update Settings
3. Windows Defender Settings
4. Backup Settings
5. Recovery Settings
6. Activation Settings
7. Developer Settings

Control Panel Settings
1. The Control Panel
2. File History
3. System Restore
4. Audio Adjustment
5. Adding Devices and Printers
6. Installing and Uninstalling Software

Desktop Management
1. The Recycle Bin
2. Creating Desktop Shortcuts
3. Pinning Items to the Taskbar
4. Moving and Resizing the Taskbar
5. Setting the Date and Time Display
6. The Action Center
7. Virtual Desktops
8. OneDrive Settings
9. Using Cortana

Creating Documents
1. Starting WordPad and Creating a New Document
2. Copying and Pasting Text
3. Formatting Text
4. Saving a Document
5. Opening a Document
6. Printing a Document
7. Closing a Document

Drawing Pictures
1. Starting Paint and Creating a New Document
2. Drawing Shapes and Lines
3. Adding Text
4. Erasing Parts of a Picture
5. Saving a Picture
6. Opening a Picture

Using the Internet and Microsoft Edge
1. About the Internet
2. Connecting to the Internet
3. The Microsoft Edge Interface
4. Viewing Web Pages in Microsoft Edge
5. Find Text in Web Pages in Microsoft Edge
6. Reading View in Microsoft Edge
7. Add a Favorite to Microsoft Edge
8. Add a Page to the Reading List
9. Manage Favorites in the Hub
10. Manage the Reading List in the Hub
11. Manage Browser History in the Hub
12. Manage Downloads in the Hub
13. Make a Web Note in Microsoft Edge
14. Sharing Web Pages in Microsoft Edge
15. Opening a New Window or New InPrivate Window
16. Zoom Web Pages in Microsoft Edge
17. Print Web Pages in Microsoft Edge
18. Settings in Microsoft Edge
19. Advanced Settings in Microsoft Edge
20. Using Cortana in Microsoft Edge
21. Windows Defender in Windows 10

Printing Information
1. Selecting a Printer
2. General Printing Options
3. Managing Print Jobs

Word Course Syllabus

Getting Acquainted with Word
1. About Word
2. The Word Environment
3. The Title Bar
4. The Ribbon
5. The "File" Tab and Backstage View
6. The Quick Access Toolbar
7. Touch Mode
8. The Ruler
9. The Scroll Bars
10. The Document View Buttons
11. The Zoom Slider
12. The Status Bar
13. The Mini Toolbar
14. Keyboard Shortcuts

Creating Basic Documents
1. Opening Documents
2. Closing Documents
3. Creating New Documents
4. Saving Documents
5. Recovering Unsaved Documents
6. Entering Text
7. Moving through Text
8. Selecting Text
9. Non-Printing Characters

Document Views
1. Changing Document Views
2. Showing and Hiding the Ruler
3. Showing and Hiding Gridlines
4. Showing and Hiding the Navigation Pane
5. Zooming the Document
6. Opening a Copy of a Document in a New Window
7. Arranging Open Document Windows
8. Split Window
9. Comparing Open Documents
10. Switching Open Documents
11. Switching to Full Screen View
12. Working with Word File Formats

Basic Editing Skills
1. Deleting Text
2. Cutting, Copying, and Pasting
3. Undoing and Redoing Actions
4. Finding and Replacing Text
5. Selecting Text and Objects

Basic Proofing Tools
1. The Spelling and Grammar Tool
2. Setting Default Proofing Options
3. Using the Thesaurus
4. Finding the Word Count
5. Translating Documents

Font Formatting
1. Formatting Fonts
2. The Font Dialog Box
3. The Format Painter
4. Applying Styles to Text
5. Removing Styles from Text

Formatting Paragraphs
1. Aligning Paragraphs
2. Indenting Paragraphs
3. Line Spacing and Paragraph Spacing

Document Layout
1. About Documents and Sections
2. Setting Page and Section Breaks
3. Creating Columns in a Document
4. Creating Column Breaks
5. Using Headers and Footers
6. The Page Setup Dialog Box
7. Setting Margins
8. Paper Settings
9. Layout Settings
10. Adding Line Numbers
11. Hyphenation Settings

Using Templates
1. Using Templates
2. Creating Personal Templates

Printing Documents
1. Previewing and Printing Documents

Helping Yourself
1. Using Word Help
2. The Tell Me Bar- 2016 Only
3. Smart Lookup and Insights- 2016 Only

Working with Tabs
1. Using Tab Stops
2. Using the Tabs Dialog Box

Pictures and Media
1. Inserting Online Pictures
2. Inserting Your Own Pictures
3. Using Picture Tools
4. Using the Format Picture Task Pane
5. Fill & Line Settings
6. Effects Settings
7. Layout & Properties Settings
8. Picture Settings
9. Inserting Screenshots
10. Inserting Screen Clippings
11. Inserting Online Video

Drawing Objects
1. Inserting Shapes
2. Inserting WordArt
3. Inserting Text Boxes
4. Formatting Shapes
5. The Format Shape Task Pane
6. Inserting SmartArt
7. Design and Format SmartArt
8. Inserting Charts

Using Building Blocks
1. Creating Building Blocks
2. Using Building Blocks

Styles
1. About Styles
2. Applying Styles
3. Showing Headings in the Navigation Pane
4. The Styles Task Pane
5. Clearing Styles from Text
6. Creating a New Style
7. Modifying an Existing Style
8. Selecting All Instances of a Style in a Document
9. Renaming Styles
10. Deleting Custom Styles
11. Using the Style Inspector Pane
12. Using the Reveal Formatting Pane

Themes and Style Sets
1. Applying a Theme
2. Applying a Style Set
3. Customizing Theme Colors
4. Customizing Theme Fonts
5. Selecting Theme Effects

Page Backgrounds
1. Applying Watermarks
2. Creating Custom Watermarks
3. Removing Watermarks
4. Selecting a Page Background Color or Fill Effect
5. Applying Page Borders

Bullets and Numbering
1. Applying Bullets and Numbering
2. Formatting Bullets and Numbering
3. Applying a Multilevel List
4. Modifying a Multilevel List Style

Tables
1. Using Tables
2. Creating Tables
3. Selecting Table Objects
4. Inserting and Deleting Columns and Rows
5. Deleting Cells and Tables
6. Merging and Splitting Cells
7. Adjusting Cell Size
8. Aligning Text in Table Cells
9. Converting a Table into Text
10. Sorting Tables
11. Formatting Tables
12. Inserting Quick Tables

Table Formulas
1. Inserting Table Formulas
2. Recalculating Word Formulas
3. Viewing Formulas vs. Formula Results
4. Inserting a Microsoft Excel Worksheet

Inserting Page Elements

1. Inserting Drop Caps
2. Inserting Equations
3. Inserting Ink Equations
4. Inserting Symbols
5. Inserting Bookmarks
6. Inserting Hyperlinks

Outlines
1. Using Outline View
2. Promoting and Demoting Outline Text
3. Moving Selected Outline Text
4. Collapsing and Expanding Outline Text

Mailings
1. Mail Merge
2. The Step by Step Mail Merge Wizard
3. Creating a Data Source
4. Selecting Recipients
5. Inserting and Deleting Merge Fields
6. Error Checking
7. Detaching the Data Source
8. Finishing a Mail Merge

Sharing Documents
1. Simplified Document Sharing in Word 2016
2. Inserting Comments
3. Sharing by Email
4. Presenting Online
5. Posting to a Blog
6. Saving as a PDF or XPS File
7. Saving as a Different File Type

Creating a Table of Contents
1. Creating a Table of Contents
2. Customizing a Table of Contents
3. Updating a Table of Contents
4. Deleting a Table of Contents

Creating an Index
1. Creating an Index
2. Customizing an Index
3. Updating an Index

Citations and Bibliography
1. Select a Citation Style
2. Insert a Citation
3. Insert a Citation Placeholder
4. Managing Sources
5. Editing Sources
6. Creating a Bibliography

Captions
1. Inserting Captions
2. Inserting a Table of Figures
3. Inserting a Cross-Reference
4. Updating a Table of Figures

Creating Formats
1. Displaying the Developer Tab
2. Creating a Form
3. Inserting Controls
4. Repeating Section Content Control
5. Adding Instructional Text
6. Protecting a Form

Making Macros
1. Recording Macros
2. Running and Deleting Recorded Macros
3. Assigning Macros

Word Options
1. Setting Word Options
2. Setting Document Properties
3. Checking Accessibility

Document Security
1. Applying Password Protection to a Document
2. Removing Password Protection from a Document
3. Restrict Editing within a Document
4. Removing Editing Restrictions from a Document

WordPress Course Syllabus

Introduction to WordPress
1. Introduction to WordPress
2. WordPress.com vs. WordPress.org
3. Installing and Running WordPress
4. Logging into the Admin Area
5. The WordPress Interface and Dashboard
6. The WordPress Toolbar

Creating Posts
1. Posts vs. Pages
2. Creating a New Post
3. The Formatting Toolbar
4. Copying and Pasting Content
5. Text Formatting
6. Creating Links
7. Adding Images
8. Using Featured Images
9. Adding Images from a URL
10. Adding an Image Gallery
11. Saving a Draft
12. Using Revisions to Compare and Restore
13. Publishing Posts
14. Using Categories and Tags
15. Using the Read More Tag and Excerpts
16. Managing Comments

Creating Pages
1. Creating Basic Pages
2. Page Hierarchy
3. Using Page Templates
4. Creating a Static Front (Home) Page
5. Managing Pages and Posts
6. Quick Edit
7. Bulk Edit

Managing Media
1. Managing Images, Video and Other Media
2. Bulk Deleting Media
3. Managing Media Settings
4. Editing Images in the Media Library
5. Editing Video Information in the Media Library
6. Editing Audio File Information in the Media Library
7. Editing Other File Information in the Media Library
8. Inserting a Video into a Page or Post
9. Inserting a Video Playlist into a Page or Post
10. Inserting an Audio File into a Page or Post
11. Inserting an Audio Playlist into a Page or Post

Creating Portfolios
1.Creating a Portfolio
2. Portfolio Categories
3. Managing Portfolios

WordPress Plugins
1. Installing Plugins
2. Installing a Form Plugin
3. Installing a Social Media Button Plugin
4. Installing an E-Commerce Plugin

Themes and Customizing Site Appearance
1. Selecting and Changing Themes
2. The Theme Customizer
3. Custom Header Images
4. Custom Menus
5. Using Widgets
6. Installing Themes from the WordPress Theme Directory
7. Installing Custom Themes
8. Customizing WordPress for Mobile

Managing Your User Profile
1. Managing Your User Profile
2. Creating a Gravatar Profile
3. Adding and Managing Users
4. General Settings
5. Writing Settings
6. Reading Settings
7. Discussion Settings
8. Media Settings
9. Importing and Exporting Content

Attracting and Keeping an Audience
1. Creating Permalinks
2. Search Engine Optimization
3. Moderating Comments

Maintenance and Security
1. How WordPress Works
2. Manually Installing Themes and Plugins
3. Updating WordPress
4. Security and Backup Plugins

TOP