Explore Visit Apply
  • MS Office Classes.
     

Microsoft Office Classes

  • Our rotating course offerings include:

    * Designates upcoming class dates listed

  • Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience

    After an introduction to Word’s window components, participants will learn how to use the Help system and navigate documents. They will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, and insert graphics.

    Course Offerings

    • Check back soon.

    Prerequisite: Word Basic or equivalent experience

    Participants will work with styles, sections and columns and will use the Navigation pane to work with outlines. You will format tables, print labels and envelopes, and work with graphics. You also will use document templates, manage document revisions and work with Web features.

    Course Offerings

    • Please check back!

    Prerequisite: Basic Computer

    Whether looking to enhance your basic skills with Word or learn new ones, this hands-on “tips and tricks” class is ideal. This class will cover and expand on the basics functions. Time will be available to ask questions.

    Course Offerings:

    • Check back.

    Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience

    After an introduction to spreadsheet terminology and Excel’s window components, participants will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. We will cover simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.

    Course Offerings

    Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience

    After an introduction to spreadsheet terminology and Excel’s window components, participants will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. We will cover simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.

    Course Offerings

    • Check back soon.

    Prerequisite: Excel Basic or equivalent experience

    This ILT Series course will teach students how to work with large worksheets in Microsoft Excel 2019, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, and using workbook styles and themes. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.

    Course Offerings

    Prerequisite: Excel Basic or equivalent experience

    This ILT Series course will teach students how to work with large worksheets in Microsoft Excel 2016, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, and using workbook styles and themes. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.

    Course Offerings

    • Check back soon.

    Prerequisite: Excel Intermediate or equivalent experience

    In this ILT Series course, students will further build on the skills acquired in the Microsoft Excel 2019 Basic and Intermediate courses. They will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.

    Course Offerings

    Prerequisite: Excel Intermediate or equivalent experience

    In this ILT Series course, students will further build on the skills acquired in the Microsoft Excel 2016 Basic and Intermediate courses. They will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.

    Course Offerings

    • Please check back!

    Prerequisite: Basic Computer

    Whether looking to enhance on your basic skills with Excel or learn new ones, this hands on “tips and tricks” class is ideal. This class will cover and expand on the basics functions. Time will be available to ask any questions.

    Course Offerings

    • Check back.

    Prerequisites: Windows Operating System experience

    After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

    Course Offerings

    • Please check back!

    Participants will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and sub datasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and Pivot Charts.

    Course Offerings

    • Please check back!

    Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience

    After an introduction to PowerPoint’s window components and Help system, students will learn to create, save, and rearrange presentations. Then they will format text, use drawing objects, work with graphics, and insert tables and charts. They will then learn to use templates and themes, slide masters, and transition effects. Finally, students will learn to proof, run, and print presentations.

    Course Offerings

    • Check back.

    Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience

    Class covers Outlook 2019 Mail, Calendars, People, and Tasks. Manage incoming and outgoing email messages, work with attachments, and create folders. Customize and sort messages, create signatures and stationery, and manage junk mail. Schedule and edit appointments, events and meetings. Customize and print calendar views. Create and manage contact information and contact groups. Create and manage tasks, To-Do lists and Notes.

    Course Offerings

    Microsoft Power BI is designed for the purpose of providing professionals with the ability to create data driven visualization by exploring, analyzing and reporting insights and trends from data. In this class, you will learn how to quickly create visualizations of connected data to gain insights, show trends and create reports. Microsoft Power BI's features will take you far beyond what can be found in spreadsheets and will allow you to create compelling and interactive worksheets, dashboards and stories to bring data to life and turn data into action.

    Course Offerings

    • Check back soon.

    Remember keeping diaries or journals? Some people write faithfully, and others tire of the writing quickly. Finding a passage you wrote way back when means pouring through pages and pages of entries before you find it again. But what if there was an easier (and more fun) way to keep track of your gardening notes? OneNote can do this, and it comes free with every installed version of Microsoft Office! All you need is to be very comfortable with a computer, and you will love this class.

    Course Offerings

    • Check back.

  • 4

    ways to register:

    Questions: 402-437-2700

  • Your Path to Personal & Professional Development