Technology Training from Savvy Training University

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

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

Participants will learn how to customize the Quick Access toolbar and ribbon with built-in Word commands and simple macros. Macros demonstrated will include inserting page numbering, filename and path, using a letter template, and a shortcut to access a specific folder. Once the customization has been completed, participants will also learn how to share customization with other users. Please plan to dedicate approximately 60 minutes to view this webinar. Read More

Participants will learn how to create a custom dialog box in a letter template using Visual Basic for Applications (VBA). The dialog box will include a dropdown list of names that is imported from an Excel spreadsheet. Upon selection, the name will be added to the signature block and additional information pulled from the spreadsheet and inserted into the letter (e.g., email address, direct line and initials). Please plan to dedicate approximately 70 minutes to view this webinar. Read More

This webinar will explore the basics of creating and editing styles and discuss how to update the Normal template and saving as a new style set. Please plan to dedicate approximately 60 minutes to view this webinar. Read More

Shopping Cart

Your cart is empty