Microsoft is the standard in spreadsheet. It lays out your data so you can organize your numeric or text data in spreadsheets or workbooks. Viewing it in context helps you make more informed decisions. Our training program teaches you the most basic to the most advance functions of Excel. Students will learn about calculations and how to modify and format a worksheet. They will also learn how to customize the Excel environment and how to manage and print workbooks.This course builds on your exsisting skills.
Students will also learn about creating formulas, inserting graphics and enhancing workbooks. They will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In our Advance modules students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. They will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. In addition to all that, 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.
Microsoft Excel Course Curriculum
Our Excel program is designed to help you use Excel to analyze data on any level. Whether you're just learning how to create spreadsheets or need to perform advanced data analysis with functions, formulas, and charts, these courses will help you unlock the maximum potential of this popular data-analysis program.