Technology Training for Today's Essential Office Skills

In this 30-minute session, we will cover how to do the following: Use Flash Fill to separate first and last names, extract parts of text from a cell, format phone numbers or other data Use freeze panes for better navigation Convert data to a table Use conditional formatting to create banded rows Automatically insert decimal points when entering numbers Insert a line break to enter more than one line in a cell Apply formatting and functions across multiple sheets Please plan to dedicate approximately 35 minutes to view this webinar. Read more

This introductory Excel course will cover: • Parts of a workbook • Entering data and auto fill • Basic formulas • Reading in data from other cells • Headers, footers and printing • Formatting worksheets Please plan to dedicate approximately 60 minutes to view this webinar. Read more

There are hundreds of built-in functions in Excel that are available if you know what to do. Join Lori as she demonstrates a variety of useful functions and how to set the relevant function arguments. This session will also cover some logical functions such as VLOOKUP, IF, SUMIF, and COUNTIF. Please plan to dedicate approximately 45 minutes to view this webinar. Read more

This webinar will cover commonly used Excel functions, including IFS (found in Excel 2016 and later) and a brand-new and very exciting function found in Excel 365, XLOOKUP. Please plan to dedicate approximately 45 minutes to view this webinar. Read more

This webinar will include date and time functions including WORKDAY, EDATE, EOMONTH, DATE, WEEKDAY, SUMPRODUCT, NETWORKDAY, MOD, DATEDIF, DAY, and DAY. Please plan to dedicate approximately 45 minutes to view this webinar. Read more

Excel allows you to easily evaluate some existing data and perform a “what if” analysis. This webinar will introduce the following What If features: Goal Seek Solver Data Table Scenario Manager Forecast Sheet ​​Please plan to dedicate approximately 60 minutes to view this webinar. Read more