You're browsing Microsoft Office Classes in Online

Explore more advanced features of Microsoft Excel. Topics include using formulas and functions, absolute cell references, data sorting and filtering, and conditional formatting. To participate hands-on in this class, it is advised that you have one of the following versions of Excel: PC - 2010, 2013 , 2016 , 2019 Mac - 2016 , 2019 You will...

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

MS Word for Windows allows you to create and format personal and professional documents and tables of all kinds. Level 1 teaches basic skills to create, edit, and format texts. Students must have MS Office Word software installed on their computer. Previous knowledge or experience: Understanding of the basics of Windows Note: Class time...

Learn how to create documents, apply good formatting, and to save and share your work using Microsoft Word. You will receive an email 2 hours before the class starts with the link to join the virtual class.  *Please note that some people using older or less common email addresses have experienced issues with receiving emails from TechConnect....

Learn more about creating a slideshow presentation using Microsoft PowerPoint. Topics include creating and editing slides, editing master slides, adding animations, and running your slideshow. More Info Skill prerequisites: Keyboard and mouse skills Audience: Adults Instructors will send out an email two hours before the class starts

This class will cover the most popular lookup method in Excel, VLOOKUP, which is used to search for and retrieve information in data sets, and work with the results. To participate hands-on in this class, it is advised that you use one of the following versions of Excel: PC - 2007 , 2010 , 2013 , 2016 , 2019 Mac - 2016 , 2019 Must...

This class covers how to take the basic logic from Class 1 and use it to create functions that process data based on conditions. Topics include SUMIF/AVERAGEIF/COUNTIF and SUMIFS/AVERAGEIFS/COUNTIFS. Skills required: Be able to write a basic formula and function Be able to write Relative and Absolute cell references Have Taken Class 1 or understand...

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

This class will cover how to customize charts to better visualize information, as well as the pros and cons of various chart types.  Topics include : Formatting charts, adding and customizing chart elements, creating mixed charts, chart analysis tools, and sparklines. To participate hands-on in this class, it is advised that you use one of...

PowerPoint is used to develop presentation materials. We’ll create text, charts and graphs to be used in electronic presentations or handouts. We’ll also work with slide masters and templates, create objects and use clip art. You will also learn how to apply transitions for electronic presentations.

In this class you’ll learn how to create and send messages, sort emails, work with e-mail messages, schedule appointments, insert events, add and edit contacts, create and edit tasks, work with calendar features, and much more!

Students will learn how to work with templates, create baseline plans, monitor and update projects, analyze project statistics, handle delays and conflicts, create reports, consolidate project files, share resources, and customize Project. Students will also learn how to integrate Project data with other Office applications.

Students will learn how to customize Outlook and work with address books. They will search and filter mail folders, and apply and customize categories. Students will also work with personal, public, and offline folders. Finally, students will organize folders and set rules.

This class will cover Pivot Tables, a powerful tool used to analyze relationships between data.  We will cover setting up data for use in Pivot Tables, how to format results, filtering techniques, and interactive elements.  To participate hands-on in this class, it is advised that you have one of the following versions of Excel: PC...