Spring Productivity Webathon | April 12, 2016
Only $12.95 for a full day of training!
*Please note that all webinars will be recorded, so if you can't attend all the sessions, go ahead and sign up and we'll send you the recordings after.
#1 ReviewReview the webinars topics and times below. Each webinar is 30 min. followed by an optional, 10-min. Q&A. |
#2 Sign UpClick to purchase your seat.(Deadline is Friday, April 8.) |
#3 JoinYour login will be sent to you within 24-48 hours. When the webinar time arrives, use your login to join from the comfort of your desk. |
#1 SelectReview the topics below and decide on the desired topic(s) and date(s). Each webinar is 30 minutes long followed by an optional, 10-minute Q&A.#2 RegisterRegister in the registration form on the left. Indicate the webinar topic(s) you'd like to attend in the box marked "Message." Deadline to register is 24 hours before the start of the webinar.#3 JoinYour login will be sent to you within 24-48 hours. When the time comes, use your login to join the class from the comfort of your desk. |
Important: Please check to see that you have the necessary system requirements for our webinar delivery platforms at the following link - OnlineMeetingNow.
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
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
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
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.
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.
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.
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.
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.