Workshop Descriptions
Microsoft Excel PivotTables Demystified
Are you wondering what Excel PivotTables reports can do for you? Wonder no longer! In this session, you will get not only an understanding of the fundamentals of PivotTables but also some practical examples of how you can use them to help you analyze your data and present your conclusions in compelling ways.
What will be covered?
- Getting your data ready for PivotTable Reports
- Creating PivotTables reports and using them to perform analysis and comparisons including counts and statistical functions
- Filtering your report to display subsets of the data and reveal hidden insights about your audiences, products and services, and other related parameters
Register, or Back to Schedule
Microsoft Excel Macros Demystified
You may have heard about Excel Macros and how they can automate repetitive tasks, and are curious about how you can leverage them in your daily work. This session is intended to provide you with an introduction to Excel Macros, including step-by-step demonstrations and instructions on how to put these Macros to use.
What will be covered?
- Recording Macros and getting an overview of the Macros scripting language (VBA), and how Macros work behind the scene to automate repetitive processes
- Writing Macros and accessing the properties and methods of Excel Objects such as workbooks, worksheets, and ranges, in order to add more significant functionally
Register, or Back to Schedule
Microsoft Word Styles and Table of Contents
If you’re using Microsoft Word, and still spending a lot time trying to format your documents and generate table of contents manually, or if you want to improve the look and feel of your documents and not to mention their usability, this session is for you and is intended to help you take your Microsoft Word skills to the next level.
What will be covered?
- Document manipulation and formatting, including dozens of navigation and formatting tips and shortcuts, formatting styles, headers and footers, bookmarks, and hyperlinks
- Automatically generating table of contents and easily update them as your document content evolves
Register, or Back to Schedule
Overcoming the E-mail Overload
This session is for executives, faculty members, and senior managers who receive a large number of e-mail messages, and who would like to manage it more effectively, significantly reduce the incoming volume, and streamline communication and task management with their staff. This session uses Microsoft Outlook and Google Mail to demonstrate the most innovative e-mail management techniques as well as provide tips on how to apply these techniques in other e-mail applications.
What will be covered?
Managing e-mail like a task, the anatomy of the e-mail task. Using the categories and labels for breakthrough productivity. Subject lines that matter and that get results. Techniques to significantly reduce incoming volume. Taking the load off of e-mail.
Register, or Back to Schedule
Staying Focused in an ADD World
This workshop is for executives, faculty members, and senior managers whose “attention” is in high demand, and who are faced with many competing priorities and receiving large number of requests from staff, students, and other stakeholders. This session also tackles the latest workplace and personal technologies that make it increasing challenging to stay focused on the current task or current thought. These technologies range from e-mail, IM, and mobile devices, to the latest Social Media platforms including Twitter, Facebook, LinkedIn, blogs, and the like.
What will be covered?
-
Managing the thought process.
-
Staying focused at the strategic level.
-
Managing focused and collaborative time moment by moment.
Register, or Back to Schedule
Google Docs & Drive Basics
In this session, you learn to create and manage documents, spreadsheets, and presentations, and access these from any device. This session also covers best practices for managing cloud-based files.
What will be covered?
- Intro to Google Docs Files: Creating, uploading, and organizing folders, documents, spreadsheets, presentations, and forms.
- Formatting and Formulas: Learning basic and advanced tricks to format content within documents and analyze data using formulas within spreadsheets.
- Document Collaboration: Learning how to share and collaborate on documents simultaneously with users within and outside of your organization.
Register, or Back to Schedule
Google Forms
This session is for business users who want to become more comfortable with the features and functionality of Google Docs, particularly in making forms. Participants will learn to create and manage forms, and how to access these from any device.
What will be covered?
- Intro to Google Docs and form files: Creating, uploading, and organizing forms.
- Learning basic and advanced tricks to for formatting and validating forms that can be shared from a local device or computer, published to the web, or embedded in a website.
Register, or Back to Schedule
Microsoft Excel PivotTables Advanced: Dynamic Ranges, Sorting/Grouping, and Calculated Formulas
If you have been using PivotTables and wondering what more you can do with them, or maybe running into obstacles and wishing you can get around them, this session will help you unleash the power of PivotTables and get outstanding results.
What will be covered?
- Handling dynamic ranges so that your PivotTables reports stay up-to-date as changes are made to the source data
- Sorting and grouping techniques so you an further analyze your data and get valuable insights
- Adding formulas to your PivotTables so they include the calculations and ratios that are specific to your needs.
Register, or Back to Schedule
