Technology Training for Today's Essential Office Skills

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

This course will cover: • Formatting as a Table • Sort • Filter • Using Text to Columns to split columns • Groups/Subtotals, and Outlines Please plan to dedicate approximately 45 minutes to view this webinar. Read more

Discover some great tips for working with Excel. Included: • Adding date or time stamp to any cell • Using Fill Handle • Format Painter • Autosum shortcut • Creating exact copy of existing worksheet • Find a sum without using a formula • Using Center Across Selection instead of merging cells • Quick Analysis Tool • Transposing data • Using named ranges Please plan to dedicate approximately 60 minutes to view this webinar. Read more

Get visual with your data. We'll cover the following in this class: • Column charts • Pie charts • Waterfall, funnel or stock charts (new in Office 365 and 2019) • Map charts (new in Office 365 and 2019) • Simple Pivot Charts Please plan to dedicate approximately 60 minutes to view this webinar. Read more