Executive Training
Word Processing
MicroSoft Word
Lesson One: Getting Familiar with Microsoft Word
The Microsoft Word Title Bar
The Microsoft Word Menu Bar
Microsoft Word Toolbars
The Ruler
Document View
Text Area
Exiting Microsoft Word
Lesson Two: Things You Need to Know About Microsoft Word
Click
Options
Highlighting Text
Highlighting Menu Items
Placing the Cursor
Menu Commands Using the Alt Key
Shortcut Notations
Starting a New Paragraph
Exiting Microsoft Word
Lesson Three: Microsoft Word Basic Features
Typing and Using the Backspace Key
The Delete Key
Inserting Text
Overtype
Bold, Underline, and Italicize with Micosoft Word
Save File and Exit Microsoft Word
Lesson Four: More Microsoft Word Basic Features
Open File
Cut and Paste
Copy and Paste
AutoText
Spell Check
Find and Replace
Font Size
Fonts
Save File and Exit Microsoft Word
Lesson Five: Working with Paragraphs
Space Before and Space After
Line Spacing
First-Line Indent
Indentation
Alignment
Hanging Indent
Save File and Exit Microsoft Word
Lesson Six: Tab Key, Bulleting, Numbering, Undo, Redo, Printing, and Help
The Tab Key
Bullets and Numbering
Undo & Redo
Save File
File Close
Open New File
Printing
Lesson Seven: Microsoft Word Tables
Creating a Table
Moving Around a Table
Entering Text into a Table
Selecting a Row and Bolding the Text
Right-Aligning Text
Adding a New Row to the End of the Table
Adding a New Row Within the Table
Resizing the Columns
Adding a New Column to a Table
Sorting a Table
The Sum Function
Deleting a Column
Deleting a Row
Recalculate
Merge Cells
Table Headings
Converting Text to a Table
Splitting a Table
Table AutoFormat
Save File
MicroSoft Powerpoint
Lesson 1: The PowerPoint Window
The Microsoft Office Button
The Quick Access Toolbar
The Title Bar
The Ribbon
Rulers
Slides, Placeholders, and Notes
Status Bar, Tabs, View Buttons, and More
Lesson 2: Creating Your First PowerPoint Presentation
Create a Title Slide
Create New Slides
Make Changes to Your Slides
Apply a Theme
Run Your PowerPoint Slide Show
Lesson 3: Animations, Transitions, Spell Check, Outline Tab, Slides Tabs, Sorter View, and Printing
Add Animations
Add Transitions
Spell Check
Use the Outline and Slides Tabs
Use Slide Sorter View
Print
MicroSoft Excel
Lesson 1: Entering Text and Numbers
The Microsoft Excel Window
Moving Quickly Around the Microsoft Excel Worksheet
Selecting Cells
Entering Data
Editing a Cell
Changing a Cell Entry
Wrapping Text
Deleting a Cell Entry
Entering Numbers as Labels or Values
Smart Tags
Saving a File
Closing Microsoft Excel
Lesson 2: Formatting Text and Performing Mathematical Calculations
Choosing a Default Font
Adjusting the Standard Column Width
Cell Alignment
Adding Bold, Underline, and Italic
Changing the Font, Font Size, and Font Color
Working with Long Text
Changing a Single Column Width
Moving to a New Worksheet
Setting the Enter Key Direction
Making Numeric Entries
Performing Mathematical Calculations
The AutoSum Icon
Automatic Calculation
Formatting Numbers
More Advanced Mathematical Calculations
Cell Addressing
Deleting Columns
Deleting Rows
Inserting Columns
Inserting Rows
Creating Borders
Merge and Center
Adding Background Color
Using Auto Format
Saving Your File
Closing Microsoft Excel
Lesson 3: Numbers and Mathematical Calculations
Reference Operators
Functions
Typing a Function
Calculating an Average
Calculating Min
Calculating Max
Calculating Count
Filling Cells Automatically
Printing
Print Preview
Saving Your File
Closing Microsoft Excel
Lesson 4: Creating Charts
Creating a Column Chart
Changing the Size and Position of a Chart
Modify Your Chart
Saving Your File
Closing Microsoft Excel
MicroSoft Access
Lesson 1: Getting Familiar with Microsoft Access
Getting Started
Understanding Security
The Navigation Pane
The Microsoft Office Button
The Quick Access Toolbar
The Title Bar
The Ribbon
Access Objects
Change Views
Close a Database and Exit Access
Create a Database
Create a Blank Database
Lesson 2: Creating Microsoft Access Tables
Understanding Tables
Name and Save a Table
Understanding Data Types
Explicitly Assign Data Types and Formats
Understanding Design View
Create a Lookup Column
Lesson 3: Working with Microsoft Access Tables
Enter Records
Import a Table into Access from Excel
Modify a Table
Move around a Table
Select Columns and Rows
Delete a Record
Resize a Column or Row
Lesson 4: Sorting, Filtering, and Creating Relationships
Sort a Table
Filter a Table
Apply a Specialized Filter
Hide Columns
Freeze Columns
Format a Table
Compute Totals
Find and Replace
Create Relationships
Lesson 5: Creating Microsoft Access Queries
Open Tables or Queries in Query Design View
Display All Records and All Fields
Change from Datasheet View to Query Design View
Retrieve a Single Column
Retrieve Multiple Columns
Sort a Query
Sort Multiple Columns in a Query
Retrieve Specific Records
Apply Multiple Criteria
Create a Query That Uses Two or More Tables
Save a Query
Modify a Query
Use a Query to Make a Table
Create a Parameter Query
Lesson 6: Creating Forms
Using the Form Button
Create a Split Form
Create a Multiple Items Form
Modify a Form
Lesson 7: Creating Reports
Use the Report Button
Use the Report Wizard
Modify a Report
Create Mailing Labels
Print a Report
Closing Microsoft Excel
Lesson 3: Numbers and Mathematical Calculations
Reference Operators
Functions
Typing a Function
Calculating an Average
Calculating Min
Calculating Max
Calculating Count
Filling Cells Automatically
Printing
Print Preview
Saving Your File
Closing Microsoft Excel
Lesson 4: Creating Charts
Creating a Column Chart
Changing the Size and Position of a Chart
Modify Your Chart
Desktop Publishing / Graphic Design
Corel Draw
Lesson One: Getting Familiar with Microsoft Word
The Microsoft Word Title Bar
The Microsoft Word Menu Bar
Microsoft Word Toolbars
The Ruler
Document View
Text Area
Exiting Microsoft Word
Lesson Two: Things You Need to Know About Microsoft Word
Click
Options
Highlighting Text
Highlighting Menu Items
Placing the Cursor
Menu Commands Using the Alt Key
Shortcut Notations
Starting a New Paragraph
Exiting Microsoft Word
Lesson Three: Microsoft Word Basic Features
Typing and Using the Backspace Key
The Delete Key
Inserting Text
Overtype
Bold, Underline, and Italicize with Micosoft Word
Save File and Exit Microsoft Word
Lesson Four: More Microsoft Word Basic Features
Open File
Cut and Paste
Copy and Paste
AutoText
Spell Check
Find and Replace
Font Size
Fonts
Save File and Exit Microsoft Word
Lesson Five: Working with Paragraphs
Space Before and Space After
Line Spacing
First-Line Indent
Indentation
Alignment
Hanging Indent
Save File and Exit Microsoft Word
Lesson Six: Tab Key, Bulleting, Numbering, Undo, Redo, Printing, and Help
The Tab Key
Bullets and Numbering
Undo & Redo
Save File
File Close
Open New File
Printing
Lesson Seven: Microsoft Word Tables
Creating a Table
Moving Around a Table
Entering Text into a Table
Selecting a Row and Bolding the Text
Right-Aligning Text
Adding a New Row to the End of the Table
Adding a New Row Within the Table
Resizing the Columns
Adding a New Column to a Table
Sorting a Table
The Sum Function
Deleting a Column
Deleting a Row
Recalculate
Merge Cells
Table Headings
Converting Text to a Table
Splitting a Table
Table AutoFormat
Save File
Illustrator
PhotoShop
Lesson 1: Entering Text and Numbers
The Microsoft Excel Window
Moving Quickly Around the Microsoft Excel Worksheet
Selecting Cells
Entering Data
Editing a Cell
Changing a Cell Entry
Wrapping Text
Deleting a Cell Entry
Entering Numbers as Labels or Values
Smart Tags
Saving a File
Closing Microsoft Excel
Lesson 2: Formatting Text and Performing Mathematical Calculations
Choosing a Default Font
Adjusting the Standard Column Width
Cell Alignment
Adding Bold, Underline, and Italic
Changing the Font, Font Size, and Font Color
Working with Long Text
Changing a Single Column Width
Moving to a New Worksheet
Setting the Enter Key Direction
Making Numeric Entries
Performing Mathematical Calculations
The AutoSum Icon
Automatic Calculation
Formatting Numbers
More Advanced Mathematical Calculations
Cell Addressing
Deleting Columns
Deleting Rows
Inserting Columns
Inserting Rows
Creating Borders
Merge and Center
Adding Background Color
Using Auto Format
Saving Your File
Closing Microsoft Excel
Lesson 3: Numbers and Mathematical Calculations
Reference Operators
Functions
Typing a Function
Calculating an Average
Calculating Min
Calculating Max
Calculating Count
Filling Cells Automatically
Printing
Print Preview
Saving Your File
Closing Microsoft Excel
Lesson 4: Creating Charts
Creating a Column Chart
Changing the Size and Position of a Chart
Modify Your Chart
Saving Your File
Closing Microsoft Excel
InDesign
Website Design & Development
HTML
Lesson One: Getting Familiar with Microsoft Word
The Microsoft Word Title Bar
The Microsoft Word Menu Bar
Microsoft Word Toolbars
The Ruler
Document View
Text Area
Exiting Microsoft Word
Lesson Two: Things You Need to Know About Microsoft Word
Click
Options
Highlighting Text
Highlighting Menu Items
Placing the Cursor
Menu Commands Using the Alt Key
Shortcut Notations
Starting a New Paragraph
Exiting Microsoft Word
Lesson Three: Microsoft Word Basic Features
Typing and Using the Backspace Key
The Delete Key
Inserting Text
Overtype
Bold, Underline, and Italicize with Micosoft Word
Save File and Exit Microsoft Word
Lesson Four: More Microsoft Word Basic Features
Open File
Cut and Paste
Copy and Paste
AutoText
Spell Check
Find and Replace
Font Size
Fonts
Save File and Exit Microsoft Word
Lesson Five: Working with Paragraphs
Space Before and Space After
Line Spacing
First-Line Indent
Indentation
Alignment
Hanging Indent
Save File and Exit Microsoft Word
Lesson Six: Tab Key, Bulleting, Numbering, Undo, Redo, Printing, and Help
The Tab Key
Bullets and Numbering
Undo & Redo
Save File
File Close
Open New File
Printing
Lesson Seven: Microsoft Word Tables
Creating a Table
Moving Around a Table
Entering Text into a Table
Selecting a Row and Bolding the Text
Right-Aligning Text
Adding a New Row to the End of the Table
Adding a New Row Within the Table
Resizing the Columns
Adding a New Column to a Table
Sorting a Table
The Sum Function
Deleting a Column
Deleting a Row
Recalculate
Merge Cells
Table Headings
Converting Text to a Table
Splitting a Table
Table AutoFormat
Save File
JavaScript
CSS
Lesson 1: Entering Text and Numbers
The Microsoft Excel Window
Moving Quickly Around the Microsoft Excel Worksheet
Selecting Cells
Entering Data
Editing a Cell
Changing a Cell Entry
Wrapping Text
Deleting a Cell Entry
Entering Numbers as Labels or Values
Smart Tags
Saving a File
Closing Microsoft Excel
Lesson 2: Formatting Text and Performing Mathematical Calculations
Choosing a Default Font
Adjusting the Standard Column Width
Cell Alignment
Adding Bold, Underline, and Italic
Changing the Font, Font Size, and Font Color
Working with Long Text
Changing a Single Column Width
Moving to a New Worksheet
Setting the Enter Key Direction
Making Numeric Entries
Performing Mathematical Calculations
The AutoSum Icon
Automatic Calculation
Formatting Numbers
More Advanced Mathematical Calculations
Cell Addressing
Deleting Columns
Deleting Rows
Inserting Columns
Inserting Rows
Creating Borders
Merge and Center
Adding Background Color
Using Auto Format
Saving Your File
Closing Microsoft Excel
Lesson 3: Numbers and Mathematical Calculations
Reference Operators
Functions
Typing a Function
Calculating an Average
Calculating Min
Calculating Max
Calculating Count
Filling Cells Automatically
Printing
Print Preview
Saving Your File
Closing Microsoft Excel
Lesson 4: Creating Charts
Creating a Column Chart
Changing the Size and Position of a Chart
Modify Your Chart
Saving Your File
Closing Microsoft Excel
Wordpress
Programming & Database
PHP
Lesson One: Getting Familiar with Microsoft Word
The Microsoft Word Title Bar
The Microsoft Word Menu Bar
Microsoft Word Toolbars
The Ruler
Document View
Text Area
Exiting Microsoft Word
Lesson Two: Things You Need to Know About Microsoft Word
Click
Options
Highlighting Text
Highlighting Menu Items
Placing the Cursor
Menu Commands Using the Alt Key
Shortcut Notations
Starting a New Paragraph
Exiting Microsoft Word
Lesson Three: Microsoft Word Basic Features
Typing and Using the Backspace Key
The Delete Key
Inserting Text
Overtype
Bold, Underline, and Italicize with Micosoft Word
Save File and Exit Microsoft Word
Lesson Four: More Microsoft Word Basic Features
Open File
Cut and Paste
Copy and Paste
AutoText
Spell Check
Find and Replace
Font Size
Fonts
Save File and Exit Microsoft Word
Lesson Five: Working with Paragraphs
Space Before and Space After
Line Spacing
First-Line Indent
Indentation
Alignment
Hanging Indent
Save File and Exit Microsoft Word
Lesson Six: Tab Key, Bulleting, Numbering, Undo, Redo, Printing, and Help
The Tab Key
Bullets and Numbering
Undo & Redo
Save File
File Close
Open New File
Printing
Lesson Seven: Microsoft Word Tables
Creating a Table
Moving Around a Table
Entering Text into a Table
Selecting a Row and Bolding the Text
Right-Aligning Text
Adding a New Row to the End of the Table
Adding a New Row Within the Table
Resizing the Columns
Adding a New Column to a Table
Sorting a Table
The Sum Function
Deleting a Column
Deleting a Row
Recalculate
Merge Cells
Table Headings
Converting Text to a Table
Splitting a Table
Table AutoFormat
Save File
Java
MySQL
Lesson 1: Entering Text and Numbers
The Microsoft Excel Window
Moving Quickly Around the Microsoft Excel Worksheet
Selecting Cells
Entering Data
Editing a Cell
Changing a Cell Entry
Wrapping Text
Deleting a Cell Entry
Entering Numbers as Labels or Values
Smart Tags
Saving a File
Closing Microsoft Excel
Lesson 2: Formatting Text and Performing Mathematical Calculations
Choosing a Default Font
Adjusting the Standard Column Width
Cell Alignment
Adding Bold, Underline, and Italic
Changing the Font, Font Size, and Font Color
Working with Long Text
Changing a Single Column Width
Moving to a New Worksheet
Setting the Enter Key Direction
Making Numeric Entries
Performing Mathematical Calculations
The AutoSum Icon
Automatic Calculation
Formatting Numbers
More Advanced Mathematical Calculations
Cell Addressing
Deleting Columns
Deleting Rows
Inserting Columns
Inserting Rows
Creating Borders
Merge and Center
Adding Background Color
Using Auto Format
Saving Your File
Closing Microsoft Excel
Lesson 3: Numbers and Mathematical Calculations
Reference Operators
Functions
Typing a Function
Calculating an Average
Calculating Min
Calculating Max
Calculating Count
Filling Cells Automatically
Printing
Print Preview
Saving Your File
Closing Microsoft Excel
Lesson 4: Creating Charts
Creating a Column Chart
Changing the Size and Position of a Chart
Modify Your Chart
Saving Your File
Closing Microsoft Excel