Human Resources Organizational and Talent Development is pleased to offer three Microsoft Office courses – Excel 2, Excel Data Analysis with Pivot Tables and PowerPoint 1 & 2 – free of charge to University employees.

Register through My Learning Connection in My Missouri State.  Limited seating is available.

Questions?  HRLearning@MissouriState.edu – 417-836-7683

Excel 2016 Part 2

February 22, 2018 – 8am to noon – Cheek Hall 100

This course is designed to deepen your understanding of analyzing massive amounts of data and extract actionable information from it. To ensure your success in this course, you should complete Excel 2016 Part 1.

Objectives:

• Work with specialized functions
• Create and manage list.
• Analyze data with tables and conditional formatting
• Visualize data with charts
• Use PivotTables and PivotCharts

Excel 2016:  Data Analysis with Pivot Tables

March 1, 2018 – 8am to moon – Cheek Hall 100

 This course is designed to clarify the process of creating an Excel PivotTable and to harness the power of PivotTable features by summarizing large collections of data for meaningful analysis. To ensure your success in this course, you should already understand spreadsheet concepts.

Objectives:

• Prepare data for PivotTable reporting
• Create PivotTables from various data sources
• Analyze data summarized in a PivotTable
• Create PivotCharts from data summarized in a PivotTable

PowerPoint 2016:  Parts 1 & 2

March 15, 2018 – 8am to noon – Cheek Hall 100

 This course is designed to immerse you in the design, development, and delivery of engaging multimedia presentations through the utilization of text, graphics, and animation.

Objectives:

• Modify the PowerPoint environment
• Customize design templates
• Develop a PowerPoint presentation
• Perform advanced text editing operations
• Add graphical elements to a presentation
• Work with media and animations
• Modify objects in a presentation
• Add tables and charts to a presentation
• Prepare to deliver a presentation