Technology Training from Savvy Training University

Stop requesting IT support. Learn the skills that will set you apart!

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

In this webinar participants will learn how to set up custom number formats for a variety of scenarios: • displaying negative numbers in red and with brackets • formatting mobile phone numbers correctly • displaying numbers and text together and still calculating correctly • displaying leading zeros • hiding formula results that are zero • displaying the day of the week • to be saved as a style and to be used in new worksheets Please plan to dedicate approximately 60 minutes to view this webinar. Read More

PivotTables can be used to summarize and analyze almost any type of data. They provide a way to extract data from a large group of information and present it in several different formats, which are often more meaningful, user-friendly, and easy to understand. In this webinar participants will learn: • how to create a pivot table 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 an PivotTable Please plan to dedicate approximately 60 minutes to view this webinar. Read More

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

Shopping Cart

Your cart is empty