Microsoft Excel 2016 – Level 2

If you have had a taste of using formulas in Excel, you probably realize that you can use formulas and functions for a multitude of calculations. In this class, we will dig deeper into how to use the capabilities of Microsoft Excel 2016 to perform simple and complex tasks using formulas, functions, filtering, conditional formatting and if-functions. Then students will work on the enhanced analyzing tools in Excel 2016 – Charts, Sparklines, Slicers, Pivot Tables and more. The use of VLOOKUP to find values in Excel lists or tables will also be explored. Twyla Vogel, the instructor, serves as the Northwest Iowa Community College Continuing Education Business Coordinator and is certified as a Microsoft Office Specialist. She has a Business Administration Degree from Briar Cliff University and a Master of Business Administration degree from the University of Sioux Falls. Twyla has many years of experience working with financial businesses and in teaching both basic and customized computer training. 2 Sessions.