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.

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.

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.

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.

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

Microsoft® Word 2021 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you'll learn how to use Word 2021 to create and edit simple documents, format documents, add tables and lists, add design elements and layout options, and proof documents.

Prerequisite: Word Basic or equivalent experience

In this course, you will work with features such as formats, styles and templates to create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers.

This course provides an introduction to Power Automate and Power Automate Desktop, offering participants the ability to streamline repetitive tasks with little or no programming experience. Students will learn to build automated workflows and exercise light computational logic in a user-friendly environment. This program enables non-coders to create customized solutions to enhance efficiency, optimize processes, and increase productivity through automation.

This course is designed to help you master Microsoft® Teams®, the key communications tool in the suite of Microsoft® 365® productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources.