Microsoft Office Training in Austin, Beaumont, Houston and Online

COURSES LOCATIONS SCHEDULE

Training Locations

AUSTIN, TX:

Microsoft Office Training is available in the Austin metro area by request.

Please call Michela at 512-649-4077 for more information.

BEAUMONT, TX:

Microsoft Office classes scheduled in Beaumont, TX are organized by Connect Learning, so for the most recent schedule and location information, please visit their website: connectlearning.com


Instructors Can Travel to You!

OTHER LOCATIONS:

Onsite Classes

If you are located elsewhere, please contact us for information and a quote to schedule training at your location for your group. Courses can be customized to meet customer specific needs.

Online Training

If you are not near a classroom, online training is another option. Online courses are led live by the instructor, where you meet with the instructor online using online meeting software. You can ask questions just as you would in the classroom. A dual monitor setup is beneficial for this type of instruction, such as two separate computers or, two monitors on one computer. A headset with microphone is also recommended.


Learn Microsoft Office programs, like Access, Excel, PowerPoint and Word.



Courses Offered:

MICROSOFT OFFICE COURSE OUTLINES

Courses are listed in alphabetical order

Course Descriptions

Please contact us if you don't see the course you need in the list. Course descriptions and availability are subject to change.
Microsoft Project is not part of Microsoft Office, however, we do offer Microsoft Project training. More information can be found here: MICROSOFT PROJECT

Learn Microsoft Access in an instructor-led, hands-on 2-day training course.

Introduction/Intermediate Microsoft Access Course, 2 days

Format:

Instructor-Led, Classroom

Prerequisites:

An Understanding of Windows and the ability to use a mouse. Knowledge of Excel is also beneficial.

DAY 1 - Objectives:

  • Identify the basic components of an Access database.
  • Build the structure of a database.
  • Manage data in tables.
  • Query a database.
  • Design forms.

DAY 2 - Objectives:

  • Streamline data entry and maintain data integrity
  • Join tables to retrieve data from unrelated tables.
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify Data using queries.
  • Improve forms.
  • Customize reports to organize the displayed information and produce specific print layouts.
  • Share data between Access and other applications.

Pdf Detailed Course Outline:

pdf Outline

Advanced Microsoft Access Course, 1 day

Format:

Instructor-Led, Classroom

Prerequisites:

An Understanding of Windows/Mac and the ability to use a mouse. Must have attended Level 1 Introductory Acrobat course or have equivalent knowledge.

What's Covered:

Accessibility and Adobe PDF
Tagging PDF Documents
Accessibility Options from External Applications
Accessible Forms and Using LiveCycle Designer
Reading Order
Verifying PDF Accessibility
Additional Accessibility Settings

Pdf Detailed Course Outline:

pdf Outline

Learn to use Microsoft Excel in training that is hands-on and instructor-led. Small class sizes.

Introduction to Excel, 1 Day

Format:

Instructor-Led, Classroom or Online

Prerequisites:

An understanding of Windows and the ability to use a mouse.

What's Covered:

Exploring Excel
Developing Basic Skills
Creating Formulas
Formatting Data
Mastering Workbook Skills
Printing Worksheets

Pdf Detailed Course Outline:

pdf Outline

Intermediate Excel, 1 Day

Format:

Instructor-Led, Classroom or Online

Prerequisites:

Introduction to Excel course or equivalent knowledge.

What's Covered:

Working with Frequently used Functions
Improving Workbook Skills
Advanced Printing
Working with Styles and Templates

Pdf Detailed Course Outline:

pdf Outline

Advanced Excel, 2 Days

Format:

Instructor-Led, Classroom or Online

Prerequisites:

Introduction & Intermediate Excel courses or equivalent knowledge.

What's Covered:

Working with Conditional Formulas
Working with Conditional Formatting
Performing Calculations with Time
Working with Hyperlinks
Refining Formulas
Working with Data Validation
Using What-If Analysis
Using Lookup Functions
Working with Data Lists
Creating Custom Views Using the Auditing Toolbar
Advanced Features
Excel and the Internet
Sharing Workbooks
Introduction to Working with Macros

Pdf Detailed Course Outline:

pdf Outline

Excel Charts, 1 Day

Format:

Instructor-Led, Classroom or Online

Prerequisites:

Introduction to and Intermediate Excel courses or equivalent knowledge.

What's Covered:

Learn to create a wide range of charts from the basic Column, Pie and Stock charts through combination (Bar and Line) charts to the more exotic waterfall and floating charts. Polish charts by learning how to refine the chart’s format.

Creating Charts
Formatting Charts
Working with Chart Types
Printing Charts

Pdf Detailed Course Outline:

pdf Outline

Excel Pivot Tables, 1 Day

Format:

Instructor-Led, Classroom or Online

Prerequisites:

Introduction to and Intermediate Excel courses or equivalent knowledge.

What is a Pivot Table?

More than a simple data table, a Pivot Table allows you to group information—by date, value, or by category and display varying levels of detail.

What's Covered:

Introducing Pivot Tables
Creating a Pivot Table
Modifying a Pivot Table
Summarizing Data
Formatting a Pivot Table
Sorting and Filtering within a Pivot Table
Creating a Pivot Table from External Data
Creating Calculations in a Pivot Table
Enhancing Pivot Table Formatting
Creating a Pivot Table Chart
Printing and Extracting Data from a Pivot Table

Pdf Detailed Course Outline:

pdf Outline

Microsoft Powerpoint course descriptions

Microsoft PowerPoint 2-Day Comprehensive Course

Format:

Instructor-Led, Classroom

Prerequisites:

An Understanding of Windows and the ability to use a mouse.

What's Covered:

Exploring PowerPoint
Developing Basic Sills
Working with Graphics
Working with Tables
Working with Charts
Working with Slide Masters
Working with Themes and Transitions
Running a Slide Show

Pdf Detailed Course Outline:

pdf Outline

Learn to use Microsoft Publisher in a hands-on, instructor-led course

Introduction to Microsoft Publisher, 1 day

Format:

Instructor-Led, Classroom

Prerequisites:

An Understanding of Windows and the ability to use a mouse.

What's Covered:

Begin working on a publication

Modify the layout and structure of a publication

Format text in a publication

Edit the contents in a publication

Format graphics in a publication

Prepare a publication for distribution


Learn to use Microsoft Visio in a hands-on and instructor-led class.

Microsoft Visio Comprehensive Course, 2 days

Format:

Instructor-Led, Classroom

Prerequisites:

An Understanding of Windows and the ability to use a mouse.

What's Covered:

Explore the Visio interface.
Create a route map.
Modifying Diagram Shapes.
Create process diagrams.
Create an organization chart.
Create a custom shape.
Design a custom stencil.
Design styles and templates.
Design a floor plan.
Represent external data in Visio.
Share drawings.

Pdf Detailed Course Outline:

pdf Outline



Introduction to Microsoft Word Course, 1 day

Format:

Instructor-Led, Classroom or Online

Prerequisites:

An Understanding of Windows and the ability to use a mouse.

What's Covered:

Exploring Word
Developing Basic Skills
Formatting the document
Printing the document
Using Bullets and Numbers
Setting Tabs
Working with AutoCorrect

Pdf Detailed Course Outline:

pdf Outline

Intermediate Microsoft Word Course, 1 day

Format:

Instructor-Led, Classroom or Online

Prerequisites:

Introduction to Microsoft Word course or equivalent knowledge.

What's Covered:

Beyond Basic Formatting
Working with Borders and Shading
Working with Quick Styles
Working with Building Blocks
Creating and Using Quick Parts
Using Find and Replace
Working with Basic Headers and Footers
Working with Tables
Adding formulas to a Table
Pasting an Excel Worksheet into Word

Pdf Detailed Course Outline:

pdf Outline

Working with Mail Merge


Advanced Microsoft Word Course, 1 day

Format:

Instructor-Led, Classroom or Online

Prerequisites:

Introduction to Microsoft Word course or equivalent knowledge.

What's Covered:

Working with Styles
Working with Long Documents
Working with Templates
Working with Forms

Pdf Detailed Course Outline:

pdf Outline

Note:

Please use the content in these outlines as a general guide as to the topics that will be taught. We cannot guarantee that all the topics listed in an outline will be covered during your particular class. Based on student need, your instructor may have to adjust the course content to suit your class, unexpected events, as well as the composition and skill level of the students in attendance.