Explore Visit Apply Donate
  • 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 speadsheet terminology and Excel’s Windows components, discover how to use the help system and navigate worksheets and workbooks and how to enter and edit text, values, formulas, pictures, and to save workbooks in various formats. You will move and copy simple functions, basic formatting techniques and printing. Finally, you 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, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and save workbooks in various formats. You also will 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, you will create and modify charts, and learn how to manage large workbooks.

    Course Offerings

    Prerequisite: Excel Basic or equivalent experience

    This ILT Series course will teach students how to work with large worksheets in Microsoft Excel 2021, 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 Intermediate or equivalent experience

    In this ILT Series course, students will further build on the skills acquired in the Microsoft Excel 2021 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

    Get started with OneDrive for Business, the cloud-based file management system included with Microsoft Office. Covering both the desktop client app and the browser version, this course shows how to upload, share, copy, delete, and download files and folders, integrate with Office 365 Online and working on files simultaneously with coworkers.

    Course Offerings

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

    Discover the basic tools of word processing, including editing a document, formatting text and changing forms. Learn to cut and paste, spell check, and insert graphics and tables. Make a document interesting with a border, symbols or special characters.

    Course Offerings

  • Your Path to Personal & Professional Development