Skip to content Skip to navigation

Stanford Webathon -- March 2015

Two days of webinars for one low price - $85 each day!

Thursday, March 5 and/or Thursday, March 12

 

This two-day webathon features online training sessions you take directly from your computer, on topics to help improve your productivity. A day of webinars costs only $85 -- you pick and choose the webinars you want to attend. STAP and Educational Assistance funds apply!

Each 40-minute webinar, sponsored by IT Services Technology Training, is followed by an optional 10-minute Q&A.
 

Click any course below for a short description

March 5 Webinars

REGISTER for the day -- only $85

Time

March 12 Webinars

REGISTER for the day -- only $85

Time

MS Excel PivotTables Demystified

9 AM - 9:40 AM

Google Docs & Drive Basics
(Beginner Level)

9 AM - 9:40 AM

MS Excel Macros Demystified

10 AM - 10:40 AM

Creating Compelling Presentations with Prezi

10 AM - 10:40 AM

MS Word Styles and Table of Contents

11 AM - 11:40 AM

Twitter and LinkedIn Basics
(Beginner Level)

11 AM - 11:40 AM

MS PowerPoint Tips and Tricks

12 PM - 12:40 PM

Google Forms

12 PM - 12:40 PM

MS Excel Lists:
Validating, Sorting, and Filtering

1 PM - 1:40 PM

Google Docs & Drive: Tips and Tricks
(Intermediate Level)

1 PM - 1:40 PM

MS Excel Pivot Tables Advanced:
Dynamic Ranges, Sorting/Grouping, and Calculated Formulas

2 PM - 2:40 PM

Google Analytics
Fundamentals

2 PM - 2:40 PM

MS Excel Macros:
Events and Forms

3 PM - 3:40 PM

Twitter & LinkedIn: Tips and Tricks
(Intermediate Level)

3 PM - 3:40 PM

Project Management with MS Project I
(Beginner Level)

4 PM - 4:40 PM

Project Management with MS Project II
(
Intermediate Level)

4 PM - 4:40 PM

 

Please Note: After enrolling in STARS, you will receive an email at least two days prior to the Webathon with links to each Webinar. From there you get to choose which Webinar you would like to take.


Cancelation Policy: ​Technology Training requires 5 full business days notice before the Webathon date in order to reimburse your funds.

 

Questions?
Contact Technology Training at:
(650) 723-4391
techtraining@stanford.edu

techtraining.stanford.edu


Webinar Descriptions

 

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:

  1. Getting your data ready for PivotTable Reports
  2. Creating PivotTables reports and using them to perform analysis and comparisons including counts and statistical functions
  3. 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 Top



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:

  1. Recording Macros and getting an overview of the Macros scripting language (VBA), and how Macros work behind the scene to automate repetitive processes
  2. 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 Top



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:

  1. 1. Document manipulation and formatting, including dozens of navigation and formatting tips and shortcuts, formatting styles, headers and footers, bookmarks, and hyperlinks
  2. 2. Automatically generating table of contents and easily update them as your document content evolves

Register or Back to Top



PowerPoint Tips & Tricks

In this session, you learn powerful techniques that can help them save significant time, better manipulate and format presentations, convey information in a compelling way, and collaborate with others more effectively.

What will be covered:

  1. Formatting tips ranging from dozens of navigation and formatting tips and shortcuts, to introducing the powerful concept of Master slides
  2. Data presentation tips including creating tables, charts, and diagrams from within PowerPoint, as well as importing them from other applications such as Excel and Word
  3. Using SmartArt to add visual elements that add impact to your presentation

Register or Back to Top



Excel Lists: Validation, Sorting, Filtering

Now that you have lists in your Excel spreadsheets (such as list of employees, students, classes, transactions, events, experiments, or whatever your data is), how can you work with the data in these lists, validate entry of new items, and sort and analyze and leverage your data. In this session we explore working with lists in Excel and cover a wide range of topics related to lists.

What will be covered:

  • Data validation, conditional formatting, sorting and filtering techniques
  • Advanced filtering including eliminating duplicates from  your lists
  • Database functions, including VLookup, to help you easily summarize totals, counts, and averages, and selected segments within your lists

Register or Back to Top



​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:

  1. Handling dynamic ranges so that your PivotTables reports stay up-to-date as changes are made to the source data
  2. Sorting and grouping techniques so you an further analyze your data and get valuable insights
  3. Adding formulas to your PivotTables so they include the calculations and ratios that are specific to your needs

Register or Back to Top



Excel Macros: Events and Forms

You may have used Excel Macros to automate repetitive tasks, and maybe even ventured into writing scripts, but wondered what more you can do with Macros. In this session we explore two important aspects of Macros which are events and forms which will help you add more advanced functionality to your Excel Workbooks.

What will be covered:

  1. Using Macros to respond to user events and therefore making your workbooks more user friendly and better addressing the specific needs of your users.
  2. Using Macros to create forms and build form functionality in order to minimize data entry errors, increase efficiency, and incorporate custom calculations that are tailored for your business needs.

Register or Back to Top



Project Management with Microsoft Project I

In this session, you learn the fundamentals of Microsoft Project, and how to get started with this tool to help you plan your projects, communicate your plans, and work more effectively with your project team and your other stakeholders. This session is ideal for first time users of Microsoft Project, and for those who may have use it in the past but need a refresher and recommendations on best practices.

What will be covered:

  1. Creating tasks and establishing task relationships
  2. Identifying resources and assigning them to tasks
  3. Identifying the critical path of your project
  4. Using summary tasks and milestones to better track progress

Using views and reports to stay up-to-date and communicate to others

Register or Back to Top



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:

  1. Intro to Google Docs Files: Creating, uploading, and organizing folders, documents, spreadsheets, presentations, and forms.
  2. Formatting and Formulas: Learning basic and advanced tricks to format content within documents and analyze data using formulas within spreadsheets.
  3. Document Collaboration: Learning how to share and collaborate on documents simultaneously with users within and outside of your organization.

Register or Back to Top



Creating Compelling Presentations with Prezi

This workshop is for anyone that would like to learn more about Prezi, the cloud-based presentation software and storytelling tool. In this session, we will provide an overview of the product and key features. We’ll also explore the robust sharing capabilities.

What will be covered:

  1. Creating a presentation: Selecting a template and creating a new presentation or importing an existing PowerPoint presentation.
  2. Frames, Layouts, and Paths.

Sharing Your Prezi: Inviting others to view your presentation in real-time or generating a URL to allow for viewing without logging in.

Register or Back to Top



Twitter and LinkedIn Basics

If you are still wondering what Twitter is about, and/or have a LinkedIn account but haven’t done much with it, this session is intended to give you an overview of these two platforms, step-by-step demonstrations of how they work, and how to start utilizing these platforms for business.

What will be covered:

  1. An overview of Twitter for beginners highlighting its key capabilities and how to leverage the platform, including: composing a tweet, retweeting, replying, and sending a direct message; hashtag basics; getting to know the Connect and Discover features; basic search, and settings.
  2. An overview of LinkedIn for beginners also highlighting its key capabilities and demonstrations of how to leverage this platform, which will include: using LinkedIn as an information and content resource; changing your homefeed view; sharing options, how to post a great update, sharing to multiple groups at once; profile basics; how to search for, join, and participate in groups.

Register or Back to Top



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:

  1. Intro to Google Docs and form files: Creating, uploading, and organizing forms.
  2. 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 Top
 



Google Docs & Drive Tips and Tricks

This workshop is for users who are familiar with Google Docs & Drive and would like to learn more tips and techniques for improving their skills and taking advantage of the more advanced functionality in the platform.

What will be covered:

  1. Advanced Spreadsheet Techniques: Learn new formulas that you can use to calculate data and manage responses from Google Forms.
  2. Document Collaboration: Work together on documents in real time and share ideas through the chat window
  3. Document Organization: Learn best practices for organizing and sharing your files
  4. Chrome Extensions and Google Drive Apps: Add apps and extensions that integrate easily to make tasks less time consuming
  5. 2-Step Verification: Set up 2-step verification to add enhanced security to your files

Register or Back to Top



Google Analytics Fundamentals

Google Analytics allows you to monitor and analyze the performance of your websites, apps, and advertising campaigns. After this session, participants can expect to have an understanding of how to set up tracking for a website, and how to view and create custom reports based on user-assigned parameters.

What will be covered:

  1. Fundamentals of Web Analytics: A brief tutorial of the importance of web analytics and how Google Analytics works
  2. Account Overview and Analytics Tracking Code: Exploring best practices for setting up an account that will track performance accurately
  3. Standard Reporting: Navigate the standard reports and understand their purposes

Register or Back to Top



Twitter & LinkedIn Tips and Tricks

Now that you are familiar with Twitter and LinkedIn, are you truly leveraging these platforms in your work and career development? This session provides you with valuable tips and techniques to help you gain additional insights into how to use these platforms more strategically and purposefully to achieve significant business and personal results.

What will be covered:

  1. A more in-depth walk through of Twitter capabilities and best practices to increase your reach and effectiveness, including: advanced hashtag use and best practices for tweet composition; enhancing your profile; advanced search; creating lists; managing your tweets through HootSuite.
  2. A more in-depth look at LinkedIn also highlighting more advanced capabilities and best practices, such as: how to create an “All-Star” profile; LinkedIn Advanced search, connecting, and networking options; how to use InMail and premium account options; advanced networking through groups.

Register or Back to Top



Project Management with Microsoft Project II

In this session, you learn more advanced features of Microsoft Project, which helps you not only plan your projects well, but also manage the implementation successfully and adapt to unexpected changes and demands.

What will be covered:

  1. Managing resource calendars to accommodate different shifts and nonworking times
  2. Defining task constraints to best represent actual project developments
  3. Performing resource leveling to handle resource shortages and conflicts
  4. Updating progress including percentage of completion or actual dates

Register or Back to Top

Last modified February 26, 2015