Course Listing

Windows Operating System


(Windows 10) Introduction to Windows and File Management
  • Understanding the Personal Computer desktop
  • Locating and starting programs in the Start Menu
  • Using the mouse and keyboard proficiently
  • Using Cortana 
  • Changing some common computer settings (mouse, desktop background and screen resolution)
  • Installing and uninstalling new software programs
  • Moving, sizing and manipulating multiple windows
  • Using the Recycle Bin
  • Using File Explorer to locate files
  • Locating and starting programs without the menu
  • Multitasking
  • Creating shortcut icons on the desktop (and icons on the Taskbar)
  • File Management (disk drives, using folders, creating new folders, moving, copying, deleting files)
  • Data integration (moving data between programs)
  • Using Media tools (images, song tracks and video)

Microsoft 365 (Formerly Microsoft Office)


ACCESS

(Access Level 1) Introduction to Data Management using Access
  • Database concepts
  • Examination of a sample database
  • Creating a new database
  • Creating database tables and adjusting table properties
  • Creating Access select queries
  • Creating an Access form by using a wizard
  • Creating a simple report by using the Access report wizard

EXCEL

(Excel Level 1) Introduction to Spreadsheets using Excel

The Excel Level 1 course is your perfect introduction to Excel.
Learn many entry level skills and activities such as:

  • Overview of the excel interface
  • Navigating among cells and sheets
  • Working with worksheet contents
  • Inserting, moving, deleting and other sheet activities
  • Finding and using an excel template
  • Using formulas and functions
  • Creating lists and custom lists
  • Inserting comments and managing them
  • Backstage view functions
  • Excel printing preview and setup
  • Importing data
  • And more!
(Excel Level 2) Intermediate Spreadsheet Concepts using Excel

The Excel Level 2 course is your perfect continuation to Excel.
Learn many intermediate level skills and activities such as:

  • Referencing cell, sheets, and workbooks
  • Working with conditions
  • Using define name
  • Formula auditing
  • Overview of charting
  • Data management
  • Freezing panes
  • Splitting windows
  • Sorting data
  • Protecting worksheets
  • Setting permissions
  • And more!
(Excel Level 3) Intermediate+ Spreadsheet Concepts using Excel

The Excel Level 3 course is your next step in Excel learning.
Learn many more intermediate level skills and activities such as:

  • Using data validation
  • Advanced conditional formatting
  • Using filters
  • Consolidating data
  • Using data tables
  • Creating and using a pivot table
  • Advanced pivot table features
  • Getting data from and interacting with other programs
  • Automating activities by using macros
  • Using the geography tool
  • Importing data from the web

OUTLOOK

(Outlook) Introduction to Outlook and use as a Contact Manager
  • Overview of Outlook modules
  • Sending and receiving e-mail
  • Reply, Reply to all and Forwarding e-mail
  • Creating a draft e-mail
  • Managing Outlook folders
  • Organizing e-mail using Rules and Alerts
  • Managing Contacts
  • Creating a Contact Group
  • Using the Calendar
  • Creating Multiple Calendars
  • Sharing a Calendar
  • Categorizing
  • Using the Task Manager
  • Using the Notes feature

POWERPOINT

(PowerPoint Level 1) Creating Professional Presentations
  • Slide show concepts
  • Creating a slideshow using a template
  • Using Slide Designer (O365 only)
  • Modifying slide content
  • Inserting, moving and deleting slides
  • Adding digital graphics and video to a slide show
  • Adding transitions and animations to a slide show
  • Running a slide show professionally
  • Creating a photo album
  • Adding a background sound to a slide show
(PowerPoint Level 2) Intermediate PowerPoint skills and tools
  • Critiquing an existing PowerPoint presentation
  • Hiding slides, secret doors and other presentation skills
  • Animating objects for visual impact
  • Morphing and animating graphics across slides (O365 only)
  • Applying multiple design templates in the same presentation
  • Creating mini presentations that interact
  • Applying multiple transition selections in a single presentation
  • Hyperlinking to files, Web pages and other objects
  • Adding and editing audio and video clips in a presentation
  • Using PowerPoint to create

WORD

(Word Level 1) Introduction to Document Processing using Word
  • Exploring the Microsoft application ribbon
  • Creating, saving and opening a simple document
  • Editing a document
  • Formatting document content professionally
  • Using Find and Replace to modify a document
  • Using productivity tools (Spelling Checker, AutoCorrect, AutoText, Smart Tags)
  • Creating lists of data items
  • Printing concepts
  • Using tables to display content powerfully
  • Discovering sources for document templates
(Word Level 2) Creating Professional Reports using Word
  • Using styles to format reports professionally
  • Using referencing tools (Table of Contents, Footnotes, Endnotes)
  • Using page breaks, section breaks, headers and footers and page numbering
  • Inserting graphics and other objects in a report
  • Creating and managing content in newsletter style columns
  • Performing a Mail Merge using Excel and Outlook Data
  • Creating a report for distribution in Adobe PDF format
(Word Level 3) Working with Large Documents
  • Collaborating with colleagues (O365 only)
  • Inserting comments, editing comments, formatting comments
  • Tracking changes and Accepting or Rejecting changes
  • Comparing Documents
  • Creating an Interactive Web Page in Word
  • Creating an Interactive Form in Word
  • Working with Graphic Objects
  • Working with SmartArt
  • Master and Subdocuments
  • Creating and Managing Word Macros

Special Interest


(Microsoft Edge) Introduction to the Internet
  • Internet concepts
  • Characteristics of Web pages and navigating through a Web site
  • Browser basics
  • Using search engines to find information efficiently
  • Capturing information and graphics from web pages to be used in reports
  • Web sites of interest to knowledge workers
  • Security and other Web-related issues

Registration Terms and Conditions

A deposit of 50% of the before-tax price of the course is required at the time of registration. The balance of the registration fee, including all applicable taxes, is payable before the day the class commences. Notice of two business days is required to cancel or reschedule a class. Registration deposits are non-refundable. Students that need to cancel or reschedule may use the deposit toward any course within three months of the original registration date. After three months, any portion of an unused deposit will be forfeited. If the student has paid in full for a course and does not want to reschedule and provides notice of 2 business days for cancellation, a refund, less the 50% deposit, will be issued for the registration.

To register directly or get further information email:

training@shawcsit.com