Workforce Training >> Microsoft Excel's Power Features
« back to courses page

PREREQUISITE: The student should have an Intermediate to Advanced knowledge of Excel. You will need basic understanding of formulas such as a VLOOKUP and an IF statement. Please read the Course Description and Outline to see if this course is for you. EXCEL VERSIONS: EXCEL 2013, 2016 or Office 365 The curriculum will show you how to perform a task in Excel 2013, 2016 or Office 365. If you have Excel 2010, you will be limited in what you will be able to do after class. Who Should Attend? In this class, we will learn how to use the Excel features called Get and Transform also called Power Query. This class will teach you how to use data from multiple Excel spreadsheets, database tables, CSV files or other sources, transform it and then analyze the data. We will also review PivotTables and learn how to create more advanced PivotTables called Power Pivots. If you are an Intermediate to Advance Excel users would like to expand your knowledge of Excel this class is for you.