PC Training Class Schedule October - December, 2017
Questions? Email the DTS Student Services Registrar.
All classes are listed in HealthStream ~ Register online today
Microsoft 2010 Creating a Dashboard / Reporting with Excel & Word: Students learn to create a dashboard, or summary report of key trends and business performance metrics. The class trains students in Excel & Word best practices to organize and analyze data for use in presentations, cross-organizational teams and management distribution. Students learn to custom filter, custom sort and use conditional formatting to identify trends in Excel, and introduction to Pivot Tables and one step charts. Additional lab focuses on organizing summary trends into another application, including new Paste Option choices, linking and format options. A “must” for managers of those responsible for cross-org or matrixed positions.
Wednesday, October 18th, 9:00 to 12:00N – New Britain, R1 Classroom
Microsoft 2010 Outlook for Managers - This class teaches efficiency tips to manage, organize and distribute e-mail messages and Calendar appointments. Managers learn best practices to automate inbox messages, set-up follow-up tasks from email and etiquette best practices for mail responses. Discover shortcuts for addressing messages, how to create and use distribution lists, attach multiple files, and create auto-signatures and receipts. Managers learn to create time-saving calendars, Contact lists and automate Outlook.
Wednesday, October 18th, 1:00 to 4:00 pm – New Britain, R1 Classroom
Microsoft 2010 Excel Introduction to Formulas: Learn to create to your own formulas with Excel, as well as work with others’ calculations. Recommended for anyone who uses Excel on an introductory level, but needs help with creating formulas and using functions. Course begins with simple formulas and develops more complex ones using multiple operations and functions. Students gain lab practice also in auditing, showing and editing formulas.
Wednesday, October 25th, 9:00 to 12:00N – New Britain, R1 Classroom
Windows Training with SharePoint - Foundation:Harness one of the fastest growing applications in healthcare, Microsoft SharePoint! Learn to open and edit site page, add a document and upload files. Students practice creating folders and managing content in SharePoint file system. Labs train students to organize content with moving files to different folders, managing permissions and using alerts and tags.
Wednesday, October 25th, 1:00 to 4:00 pm – New Britain, R1 Classroom
Microsoft Excel – More on Formulas & Functions – Intermediate - This course is for those people who have mastered Excel on at least an introductory level and need to create larger, more complex worksheets. Learn about range names and how to use them in formulas. Discover how to link data from one sheet to other sheets using 3-D and array formulas. Learn to use the functions NOW, IF, PMT and VLOOKUP. Understand formula errors and how to fix them.
Tuesday, November 7th, 9:00 to 12:00N – New Britain, R1 Classroom
Word Formatting: Mastered the Basics? Then take the next step and gain control over your Word documents while improving their appearance. Learn to control indents as well as bulleted lists and numbered lists. Make corrections more easily by finding and replacing text, or copying and moving text. Page numbering, AutoCorrect, and AutoText are also covered.
Tuesday, November 7th, 1:00 to 4:00 pm – New Britain, R1 Classroom
Microsoft 2010: Excel Advanced & Pivot Tables: Gain efficiencies in merging sheets into a larger Excel database with this class. From sheet navigation shortcuts to formatting requirements, students learn best practices to clean-up data merges, including key formatting pitfalls and data entry clean-up. Additional labs focus on building Pivot Tables to analyze, chart and calculate data. Final labs teach students the top tricks to set-up the data sets for distribution, including repeating headers, advanced header and footer tips and print options.
Tuesday, November 14th, 9:00 to 12:00N – New Britain, R1 Classroom
Microsoft Outlook Intermediate / Advanced: This class covers the next level Outlook features to save time, automate messaging and increase your efficiency. Learn to automate mail handling using the Rules Wizard. Organize your folders with the Organize Tool. Manage junk e-mail efficiently. Discover how easy and important it is to archive your old mail items and not "run out of space". Students learn how to manage project management and tasks with calendar and email tips.
Tuesday, November 14th, 1:00 to 4:00 pm – New Britain, R1 Classroom
Microsoft 2010 Excel and Word Combo: Save time and get a ‘2 for 1’ deal with this Combo class. Learn or refresh your foundation skills for Word Basics and Excel Basics. Create and edit documents and spreadsheets, including formatting tricks! Practice setting up the document and sheet to print, save and send efficiently!
Wednesday, November 29th, 9:00 to 12:00N– New Britain, R1 Classroom
Microsoft 2010 Word Advanced and Merge: Whether building a form or creating a mail merge, this course takes word processing to the next level. For those creating documents such as manuals or reports, this is a ‘must have’ session. Learn time-saving skills to customize header and footer with page numbers, build a table of contents, and create an interactive user form for users and create newsletters and brochures. Students learn to create bookmarks, mark entries and create an index. Also students harness mail merge with Excel, Outlook or Word, and create letters, forms, or labels.
Wednesday, November 29th, 1:00 to 4:00 – New Britain, R1 Classroom
PowerPoint Basics: Harness one of the most powerful communication tools in your office! For anyone new to presentation software or for those who need a refresher on the basics of PowerPoint. Learn to create a presentation from beginning to end. Students work with preset slide layouts, edit text boxes and learn graphics to apply professional looking designs. Discover slide show tips and distribution tricks, with industry best practices in presentation too!
Tuesday, December 5, 9:00 to 12:00 N– New Britain, R1 Classroom
Microsoft Windows & File Management: If words like “Cloud” and “USB” are a mystery, this is the class for you! Uncover the newest terminology and gain confidence using the Microsoft Windows interface. Students learn about the key terms and tools to download, upload and manage files and folders, as well as saving best practices to multiple locations and devices. Students learn best practices in compliant and secure methods for data linking, data storage and distribution.
Tuesday, December 5, 1:00 to 4:00 pm – New Britain, R1 Classroom
Microsoft 2010 Access-Converting Excel Sheets into a Database - This is an ideal class for the non IT or non- Finance user who is responsible for managing large datasheets, or for the power Excel user needing larger data sources than Excel. This basic Access class focuses on creating an Access database in 2010. Students learn to import existing Excel spreadsheet through the Wizard, map field and identify a primary key. Navigate the Access window and learn the "Datasheet" vs. "Design" views. The course introduces database concepts and table design through the 2010 tabs. Participants learn to create basic queries and reports through the wizards. The class focuses on best practices to enter data and organize in Excel for Access use. This is a time saving class for any user!
Tuesday, December 12th, 9:00 to 12:00 – New Britain, R1 Classroo
NEW: Word Intermediate-Creating Forms & Desktop Publishing:
Give your documents a polished look! Learn to use styles and publish a consistent look. Need to include pictures to illustrate your text? This course takes the mystery out of manipulating graphics and design objects in your documents. Discover how to create a header and footer for a finished appearance; and how easy it is to create a table of contents. Participants must be proficient in Windows and Word on at least an introductory level. They must take Word Basics and Word Formatting Techniques or have comparable experience.
Tuesday, December 12th, 1:00 to 4:00 pm– New Britain, R1 Classroom
Microsoft Project Management: This course is a ‘must’ for employees leading or participating in a project or project management. Participants learn the phases and processes of a standard project management life cycle framework. Learn to create, manage and link tasks and project deliverables, translating work into concrete details. Understand the newest trends in LEAN, Waterfall and Agile project management methodologies, and how to apply best practices to your project. Learn to create and manage project resources, costs and timing deliverables, and build a Project report.
Wednesday, December 13th, 9:00 to 12:00N – New Britain, R1 Classroom
Microsoft 2010 PowerPoint Intermediate / Advanced - Anyone who knows the basics of PowerPoint but needs to enhance their presentations should take this class. Participants will learn to build SmartArt and multi-media objects, animations and transitions. They will use Graph to chart data and import a chart from Excel. Students will also work with templates, Master Slides and special effects.
Wednesday, December 13th, 1:00 to 4:00 pm – New Britain, R1 Classroom
How to register: Go to HealthStream online and search for courses with “Microsoft” in the course title, or email: firstname.lastname@example.org.