All classes are listed in HealthStream ~ Register online today!
NEW: Combo: Excel Charts & PowerPoint: “A picture is worth a thousand words” Master new Excel Charting tools to visualize data trends. Learn to easily create and edit charts, and then master importing into a presentation. Understand the new Clipboard paste options, and the compliance best practices to reuse and link data to the chart. Gain best practices in formatting data and charts from Excel to Powerpoint. From bar charts to bitmaps, take your analysis and data trending to the next level with this new class! This course is for those people who have mastered Excel on at least an introductory level.
Monday June 4, 9:00 to 12:00 N – New Britain, R1 Classroom
Microsoft 2010 PowerPoint Intermediate
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.
Monday, June 4, 1:00 to 4:00 p.m. – New Britain, R1 Classroom
Microsoft 2010: Excel Intermediate/ Advanced Formulas & Functions:
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, and custom lab practice with text clean-up, date, financial and other useful tools!
Tuesday, June 13, 9:00 to 12:00 – 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. Optional labs include Forms, Desktop publishing and References.
Wednesday, June 13, 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!
Wednesday, June 20, 9:00 to 12:00 – 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.
Wednesday, June 20, 1:00 to 4:00 pm – New Britain, R1 Classroom