Technology Training for Today's Essential Office Skills

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

This webinar will cover the following: • setup worksheet to track date, witness, party, attorney, start time, end time and total time • format time entries • add formula to calculate total time • format as table • create range names • create a SUMIF formula to track how much time each party has used during a trial. • data validation • create a macro to enter time in a specified format • create keyboard shortcut and toolbar button for running macro Please plan to dedicate approximately 60 minutes to view this webinar. Read more

Learn how to use the following text functions in Excel: Left, Right, Mid, Len, Trim, Upper, Lower, Proper, Text Join, Concatenate and Transpose. Please plan to dedicate approximately 60 minutes to view this webinar. Read more

This webinar will demonstrate the following types of data validation to ensure clean data entry in a spreadsheet: • Allow uppercase entries only • Prevent invalid dates • Create drop-down lists • Dependent drop-down lists • Prevent duplicate values • Allow only numeric or text entries • Validate an entry based on another cell • Allow entry of weekdays only • Restrict text length • Entries contain specific text • Create meaningful error messages Please plan to dedicate approximately 60 minutes to view this webinar. Read more

During this webinar participants will learn: • how to create a PivotTable from existing data • how to use a filter to narrow down the data in a PivotTable to view only the information required • how to add a slicer to make filtering even easier • how to create a PivotChart from a PivotTable Please plan to dedicate approximately 60 minutes to view this webinar. Read more