Jan 22, 2020, 12pm to 1pm EST

Pivot Tables Made Simple

Take Control of Your Data

Presented By Jesse O'Neil

What is covered in this webinar?

  • Pivot Tables; Charts; Slicers
  • What are PivotTables used for?
  • Best practices on creating PivotTables
  • Adding pizazz
  • Analyzing the data
  • Different types of data - How Pivot Tables could be useful with these different data types from different industries.

Why should I register?

This webinar will make Pivot Table confusion a thing of the past. In this webinar you will be taken through everything to-do about Pivot Tables. From the very basics, to best practices and ending on adding "pizazz" to your Pivot Tables, no stone will be left unturned in this webinar.

February 19th, 2020 12pm to 1pm EST

Excel Tips and Tricks

Creating Content Can Be Time Consuming, But It Doesn’t Have to Be!

Presented By Jesse O'Neil

What is covered in this webinar?

  • 10 Magical Ways to use Flash Fill
  • Extracting Text/Combining Text and Changing Case
  • Extracting; Dates/Numbers from Text/Parts of Numbers/Extracting Hours and Minutes
  • Adding Text to Numbers
  • ​Removing Unnecessary Spacing
  • Becoming More Efficient by Using Excel’s Fill Handle
  • Duplicating Things/Deleting Things
  • Creating A Sequence or Pattern
  • Using Excel’s Smart Tag to select More Fill Options
  • ​Using the Fill Handle as Flash Fill
  • Using Excel's Formula Auditing tools/Error checking
  • Tracing precedents/dependents
  • Evaluating formulas

Why should I register?

 Impress your colleagues with your Excel prowess with these easy-to-use tips and tricks!

Attend this webinar if you would like a glimpse into some of the lesser-known applications of Excel's efficiency features. You will get practical demonstrations of how to use Excel's Flash Fill and Fill Handle features. You will also be taught how to take a complicated spreadsheet and make sense of it all.

March 17th, 2020, 12pm to 1pm EST

Microsoft Word – You Are Doing It Wrong…

That's Okay, So Is Everyone Else

Presented By Jesse O'Neil

What is covered in this webinar?

  • Tables
  • Tabs
  • Styles
  • Themes
  • Mail merges
  • References or table of contents
  • Show hide button
  • Format Painter

Why should I register?

Microsoft Word is a powerful word processing application, but what does that mean for average Joes like us? In this webinar we will take a look at some of the most useful word processing tools available to us. We will start from some basic features that are being under-used, explore tabs and alignment, understand how to properly user themes and finally go into tables and a table of contents. This is a very practical webinar for using Microsoft Word to its fullest potential.

April 22nd, 2020, 12pm to 1pm EST

Using OneDrive To Collaborate in Real Time…

No, Seriously, Real Time!

Presented By Jesse O'Neil

What is covered in this webinar?

  • What is covered in this webinar?
  • "Excel
  • Creating tracking spreadsheets
  • Collaborating on data
  •   PowerPoint
  • Presenting online
  • Sharing presentations
  • Proofing presentations
  • Word
  • Creating shared essay or report based collaboration. Tips and tricks."

Why should I register?

We all know OneDrive as a basic, online storage container for files and content. But what most people don't know, is that OneDrive is the starting place to leverage MS Office collaboration features. Explore the topic of collaboration from the viewpoint of Microsoft Excel, PowerPoint and Word in this practical demonstration.

May 21st 2020, 12pm to 1pm EST

Removing the Confusion of Office 365

What Tools to Use, When

Presented By Jesse O'Neil

What is covered in this webinar?

  • Communication tools
  • Teams Vs. Skype for Business
  • Collaboration tools
    •    Yammer
    •  Delve Vs. OneDrive
  • Presentation tools
    •    PowerPoint vs. Sway
  • Project Management Tools
    •    Planner Vs. Outlook Tasks

Why should I register?

Office 365 is more than just a subscription to the flagship MS Office Products, it is also a jumping off point for collaboration and teamwork. With all of the attention it is getting lately, one question is persistent across the board: which tools are available, and when do we use them?

Learn about Microsoft applications you may not have heard of, and when to use them in this practical webinar.