Office Software Courses
- MS Excel 2010 Intermediate
- MS Excel 2010 Advanced
- MS Access 2010 Basic
- MS Excel 2013: Data Analysis with Pivot Tables
MS Office 2010
If you are familiar and comfortable with the basics of Excel, then you are ready to learn the intermediate level features and functions of Excel 2010. In this 8-hour course, delivered in two 4-hour morning sessions, participants will learn how to use multiple worksheets and workbooks, advanced formatting options, create outlines, work with lists and tables. Participants will create and use name ranges, work with Absolute References, and insert and edit hyperlinks. This course also covers advanced charting techniques, file sharing, merging, pivot tables and workbook templates.
Date: Mon. & Wed., May 18 & 20, 2015 Newtown Campus
This 8-hour course, delivered in two 4-hour morning sessions, builds on the skills and concepts taught in Excel 2010: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.
Date: Tues. & Thurs., June 2 & 4, 2015, Newtown Campus
Learn the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. In addition, students will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports. This 8-hour course, is delivered in two 4-hour morning sessions.
Date: Tues. & Thurs., June 9 & 11, 2015 Newtown Campus
MS Office 2013
This 3-hour course examines how to prepare raw data in Excel for Pivot Table reporting. Originally, data is brought in from one Excel spreadsheet followed by using multiple spreadsheets. Additionally, Microsoft Access data is brought into a Pivot Table. The course analyzes the data using Pivot Table tools such as, filtering, sorting, grouping, collapsing and expanding, and creating calculations within a table. Formatting, Timelines, and Pivot Table Slicers are introduced to enhance the look and meet the needs of Pivot Tables used for presentations. Finally, Pivot Charts are explored to display data graphically. The graphical interface makes it easy to notice patterns and trends.
The targeted student has an Intermediate working knowledge of Excel. Experience with sorting and filtering is helpful.
Date: Tues., June 16, 2015, Newtown Campus