Technology Training for Today's Essential Office Skills

This webinar will start with a review of PivotTable creation and expand on PivotTables exploring some of the more advanced features including: • Changing Report Layout • Expanding, Collapsing, or Showing Details • Grouping Fields • Adding Subtotals • Creating a Calculated Field • Sorting • Creating a Timeline to Filter Dates • Refreshing and Updating Automatically using a Macro Please plan to dedicate approximately 60 minutes to view this webinar. Read more

In this webinar you learn how to use Power Query (Get & Transform) to automate the process of importing, cleaning and consolidating data from a variety of sources into Excel. Topics will include: • Power Query Overview • Unpivot Data for Pivot Tables • Append Multiple Files into One Table • Merge Tables (similar to VLookup) Please plan to dedicate approximately 60 minutes to view this webinar. Read more

Data Validation is an underutilized tool in Excel. This feature provides a method of limiting mistakes and ensuring clean data on entry. Without clean data, PivotTables, charts and formulas will not function correctly. This webinar will demonstrate the following types of data validation: o Allow uppercase entries only o Prevent invalid dates o Create drop down lists o Dependent drop down lists o Prevent duplicate values o Allow only numeric or text entries o Validate an entry based on another cell o Allow entry of weekdays only o Restrict text length o Entries contain specific text o Create meaningful error messages Please plan to dedicate approximately 60 minutes to view this webinar. Read more

This webinar will cover date and time formulas, IF formula to calculate if there is overtime, and cell protection so only the fields that need to be filled in will be accessible. Please plan to dedicate approximately 50 minutes to view this webinar.  [The webinar ends at 48 minutes and there is "dead" air at the end.  You can safely close the video at the 48 minute mark.] Read more

Power BI Desktop is a free, self-service data analysis and report authoring tool. It can connect to more than 70 on-premises and cloud data sources to turn information into interactive visuals. The webinar will demonstrate using an Excel workbook and a website as data sources. Participants will learn how to: * Connect to data * Transform and clean data to create a data model * Create visuals, such as charts or graphs, that provide visual representations of the data * Create reports and dashboards that are collections of visuals, on one or more report pages * Share reports with others by using the Power BI service  Please plan to dedicate approximately 60 minutes to view this webinar. Read more

This webinar will cover the following features in the Styles group on the ribbon in Excel: • Conditional Formatting • Format as Table • Cell Styles Please plan to dedicate approximately 60 minutes to view this webinar. Read more