This advanced-level course is intended to help regular users of Excel become even more proficient by expanding their knowledge of Excel data analysis tools, consolidation tools, advanced functions, and PivotTables. This course will cover a variety of organizing tools and What-If analysis tools that will help Excel users get the most out of their data. In addition, two key advanced spreadsheet tools (PivotTables and PivotCharts) will be discussed at length. Following that, advanced concepts dealing with Excel functions, AutoFill lists, and consolidating and combining data will also be covered. The new Slicer features and PowerPivot add-on, two important tools for working with PivotTables and PivotCharts, are covered as well.

Go beyond the basics and learn how to write a formula, work with a built-in function, create a chart and organize data in a list.

Tap into the power of Excel by using more functions that are built-in and explore the needed techniques to build multiple sheet workbooks and to link and consolidate data among them.

This Introductory level class is intended to help all novice computer users get up to speed quickly creating impressive presentations for work, weddings, birthdays, and special occasions. This course will also be helpful to more experienced users of prior versions who have little to no experience with PowerPoint 2016 and the ribbon interface. The course will cover the different features of the interface, give a brief overview of all the tabs in the ribbon, show users how to print presentation handouts, cover simple presentation designs, and the basics of formatting. By the end of this course, users will be comfortable in creating presentations, customizing the PowerPoint Interface, making presentations look professional and presentable, saving them, and presenting a slide show.