Site Actions

Workforce Development

JCCC’s Microsoft Office Conference

JCCC's Microsoft Office Conference, featuring Office 2013 and Windows 8, will include a keynote speaker, a variety of breakout sessions and hands-on learning and networking opportunities.

Saturday, November 8, 2014
9 a.m.-4 p.m.
Regnier Center, Johnson County Community College (Map)

Register online!

Conference Schedule

8:30-9 a.m.
Registration/Networking

9-10 a.m.
Keynote Presentation
Bradley Davis, Microsoft Store Manager, Microsoft Corporation
Biography

10-10:10 a.m.
Coffee Break

10:10-11 a.m.
Breakout Session I

Access – Database Design & Performance: How to Keep a Database Healthy?
Jim Watkins, vice president, Heritage Computer Consulting & Services, Inc.
Biography
Description: Have you ever had a slow database drag you down? Learn how to design a relational database. Explore how to tune your database for better performance.
Level: Beginner, Intermediate, Advanced
Ideal for: Professionals, Educators

Excel – Using Excel Surveys to Automate Gathering Feedback
Bob King, chief technical officer, Thought Spray Solutions
Biography
Description: This workshop will introduce participants to creating, sharing and analyzing useful surveys using Office 365’s Excel Surveys feature. The survey created can be shared and filled out by recipients with no registration required. The inputs are recorded in an Excel spreadsheet to facilitate analysis and reporting.
Level: Beginner, Intermediate
Ideal for: Professionals, Educators, Home Users

PowerPoint – Working Outside the Box – Strategies for Moving Away From Square Images
Hattie Wiley, distance learning developer, National Weather Service
Biography
Description: Do boxy images dominate your instructional materials? It’s time to image outside the box. In this session, Hattie will demonstrate and coach you on a number of techniques for making cut out images and other image enhancements. The tools explored will depend on the needs of the participants. Techniques will include using the remove background tool, magic wand, cut outs, crop to’s, and other picture tools. By the end of this session, you will be able to make clearer and stronger visuals.
Level: Beginner, Intermediate
Ideal for: Professionals, Educators, Home Users

SharePoint – Finding a Needle in a Haystack: Using SharePoint to De-Clutter Your Inbox
Sharon Weaver, knowledge management expert, JCCC Continuing Education instructor
Biography
Description: Searching through multiple email accounts for a specific document can become very overwhelming. This session will show users an alternative approach to managing email attachments in SharePoint that will get them out of their email inbox and into a place where they can easily and quickly find them anytime, anywhere.
Level: Beginner
Ideal for: Professionals, Educators, Home Users

11:10 a.m.-noon.
Breakout Session II

Access – Creating Reports
Jim Watkins
Description: The information is in the database you created, but how do you show it to your boss? This session will take you through the steps of using the wizard to create reports by sorting and grouping data effectively. Learn how to adjust your report parameters, include group totals, grand totals and even running subtotals from your MS Access database.
Level: Beginner, Intermediate, Advanced
Ideal for: Professionals, Educators

Excel – Top 5 Things Every Sales Professional Should Know
Robyn Lehmann, technology training and data specialist, United Real Estate
Biography
Description: Excel is a powerful, flexible tool and in today’s market it’s essential for any sales professional to be in a position to provide their clients and customers with timely information. In this session you’ll find out how to create a time-line of events specific to a clients’ closing schedule, how to automate your commission letters, summarize closing information, work with data from other sources to create email and mailing lists and develop a dynamic commission comparison chart to help with sales staff recruiting.
Level: Beginner, Intermediate
Ideal for: Professionals

Microsoft Office – Mastering Office
Hattie Wiley
Description: Localized edits (highlighting and changing fonts, colors, and other elements) can be time consuming and a nightmare if changes are required. It’s time to work smarter instead of harder! MS Office has built in controls for changing templates, styles, fonts, colors and more. Learn where to find these and how to use them.
Level: Beginner, Intermediate
Ideal for: Professionals, Educators, Home Users

OneNote – What is OneNote and Why Should I use it?
Christy Rogers, owner and lead instructor, Training Umbrella
Biography
Description: Never lose another important note again! Using OneNote will solve the problem of keeping multiple paper notebooks for multiple topics. As a business professional it is imperative you keep your ideas and notes accurate and available. You will learn how to create pages and sections, best practices for organizing, create a Template Page to use during meetings, adding tags and symbols, searching your notes, and sharing your notes with someone else.
Ideal for: Professionals

Noon-1 p.m.
Networking Luncheon

1:10-2 p.m.
Breakout Session III

Access – Using Access to Manage Data: Importing and Linking to External Data Sources
Jim Watkins
Description: Have you ever wanted to analyze corporate data when the corporate database doesn’t have the tools to assist you? Explore how Access can be used to import and link data to help you with this analysis. Learn how to decide when to import or when to link to an external source with your Access Database.
Level: Beginner, Intermediate, Advanced
Ideal for: Professionals, Educators

OneNote – Introducing OneNote
Hattie Wiley
Description: MS OneNote is one of MS Office’s secret treasures. It is great tool for keeping track of multiple lists, versions, program information and more. Also, when stored in an accessible location, it allows multiple users to edit, tracking them with named labels automatically. It acts as a repository for many different types of files and tracks your cut and paste information, automatically adding lines such as what folder or website contains the original information. In this session, we will enter information in a Sample Notebook, create a New Notebook, paste information from other files and the web, and share a notebook.
Level: Beginner, Intermediate
Ideal for: Professionals, Educators, Home Users

Project – What’s New in Project 2013?
Christy Rogers
Description: Learn about the exciting new upgrades and integration with SharePoint. See live how to save and sync your Project file to a SharePoint task list using Office 365. Create a Burndown report, a new report available in the 2013 version. We’ll cover the “Start” Experience, create a SharePoint sub-site using Office 365: sync task and timeline, and view the new graphical reports window.
Level: Beginner, Intermediate, Advanced
Ideal for: Professionals

SharePoint – Roadmap for Building Your Very Own Office 365-SharePoint Online Site
Tone' Shelby, principal technologist - eQualityITsolutions LLC, US Midwest MCT Regional Lead
Biography
Description: Tone’ will show what an Office 365/SharePoint 365 Online Website looks, features included in the site, apps that can be included to power BI and how all this can be done strictly through the web browser by any end-user. Tone’ will also provide a roadmap takeaway for how users can get started on their own website. You’ll also learn how easy it is to maintain and add to this type of website.
Level: Beginner, Intermediate, Advanced
Ideal for: Professionals, Educators, Home Users

2-2:10 p.m.
Coffee Break

2:10-3 p.m.
Breakout Session IV

Access – How Access Replaces Mainframe and Legacy Solutions
John Krzysztow
Biography
Description: Learn about the many uses of Microsoft Office’s Access 2010, and how it replaces mainframe and legacy solutions.
Level: Advanced
Ideal for: Professionals, Educators

Microsoft Office – Smarter SmartArt and Picture Layouts
Hattie Wiley
Description: A SmartArt graphic is a visual representation of your information and ideas. You can create SmartArt graphics by choosing from among many different layouts to quickly, easily, and effectively communicate your message. You can create a SmartArt graphic in Excel, PowerPoint, Word, or in an e-mail message in Outlook. Just like any other tool, Smart Art can be misused or customized to its potential. It’s up to you.
Level: Beginner, Intermediate
Ideal for: Professionals, Educators, Home Users

Visio – Use Microsoft Visio 2013 for Database Planning, Development and Client Management
Caren Grandgenett, database development and training specialist, JCCC
Biography
Description: Explore the use of Microsoft Visio 2013 Database Model Diagram capability. Visio provides a format for mapping table design, relationships and object design prior to development allowing for better communication among clients, project managers, developers, end users and other participants in the database develo p.m.ent process. This demonstration incorporates Crow’s Foot Notation, also known as Structured Systems Analysis and Design Method (SSADM).
Level: Beginner, Intermediate, Advanced
Ideal for: Professionals, Educators

Yammer – Yammer Time! Introduction to Yammer Social for Business
Ryan Gutridge, Senior Technical Consultant, Cela Technologies
Biography
Description: Enjoy a high-level overview of Yammer including the importance of ESN, successfully navigating Yammer to find information, understanding how to get started on Yammer, best practices, how to effectively engage in conversations, collaborating on content in Yammer, using Yammer on your mobile device, and knowing what to share and where to share it.
Level: Beginner
Ideal for: Professionals

3:10-4 p.m.
Closing

More information coming soon. Please check back for updates to the schedule.

For questions, call 913-469-3891.