Office Bootcamp 201 – Microsoft Office Bootcamp Intermediate/Advanced

Class Description
Microsoft Office remains the world’s most powerful and widely used productivity suite. This 5-day Microsoft Office 201 training bundle includes intermediate and advanced levels of Word, Excel, PowerPoint, Outlook, and Access. No matter where Participants career takes Participants, rise above the rest. Participants can receive an expert’s understanding of Office with this complete intermediate/advanced Microsoft Office boot camp. Our instructors are industry professionals and that will teach Participants how to advance Participants MS Office skillset and will also show Participants pitfalls, best practices, and shortcuts. They are well versed in Microsoft Office and will show Participants how to increase Participants proficiency and how to work smart within each application.

Course Benefits
With the intermediate/advanced MS Office skills Students learn in this Bootcamp, Students will have increased confidence, job marketability, improved academic performance, and be productive in the workplace.

Gain the skills next level of MS Office skills and express Students ideas, solve problems and connect with people.

Suggested Prerequisites
Basic computer skills.
We also recommend that you have the MS Office software before starting the class.

Course Outline
Word:

  • Learn to use Word’s advanced editing tools
  • Work with images: placing, sizing, wrapping text, and using borders and effects
  • Adjust page orientation and layout
  • Work with columns
  • Work with page and section breaks
  • Understand document views, multiple window views, and the navigation pane
  • Work with tables of contents
  • Work with footnotes and endnotes
  • Use comments
  • Use track changes including accepting and rejecting changes
  • Compare and combine documents
  • Protect documents

Excel:

  • Use formulas and functions
  • Create and modify charts
  • Convert, sort, filter, and manage lists
  • Insert and modify illustrations in a worksheet
  • Use conditional formatting and styles
  • Create pivot tables and charts
  • Collaborate with others by protecting worksheets and workbooks
  • Create, use, edit, and manage macros
  • Import and export data

PowerPoint:

  • Creating and managing presentations
  • Working with text, tables, placeholders, and content
  • Inserting graphics, shapes, diagrams, charts and pictures
  • Adding sound and movement slides
  • Rehearsing and set slide timings
  • Managing add-ins and security options
  • Creating custom presentation elements, themes, masters, and layouts
  • Create customized presentations with templates
  • Add special effects
  • Use the slide, notes, and handout masters
  • Create, edit, and import charts
  • Manage hyperlinks
  • Securing, saving and sharing presentations in multiple formats

Outlook:

  • Creating, updating and assigning tasks
  • Tracking task requests
  • Changing Students task view
  • Creating signatures and themes
  • Formatting outgoing messages
  • Grouping Students mailbox items
  • Filtering messages
  • Setting up multiple Outlook accounts
  • Understanding POP vs IMAP Email Programs
  • Improving Students searches
  • Removing clutter
  • Working with advanced Outlook features

Access:

  • Understanding database concepts and relational database techniques
  • Exploring tables, forms, queries, and reports
  • Previewing and printing database objects
  • Creating databases and simple tables
  • Creating databases from templates
  • Defining relationships between tables
  • Creating forms
  • Arranging the layout of forms
  • Displaying data and sorting information in tables
  • Filtering information using forms
  • Saving filters as queries
  • Maintaining data integrity with datatypes
  • Validating data
  • Allowing multicolumn lookup lists
  • Creating queries using a wizard
  • Creating queries manually
  • Updating and deleting records
  • Adding sub-forms
  • Adding form controls
  • Creating custom reports
  • Modifying report content
  • Importing and exporting data
  • Importing from other Access databases and Excel
  • Importing from Outlook
  • Importing from SharePoint
  • Exporting to Access, Word, SharePoint and more
  • Protecting databases and adding security
  • Preventing database problems

Related Classes

Our goal is to make sure your class meets your objectives, not ours. Therefore, all of our outlines are treated as guides to help steer the workshop. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.

Locations