Microsoft Office

Learn how to create a PivotTable and a pivot chart, perform lookups, use data validation (control inputs from a list), link cells, IF and Countif functions, using text to columns function and arranging the view of various spreadsheets. Must have taken Excel I & Excel II and have a strong working knowledge of Excel. Excel […]

Must have taken Excel 1. Learn and perform: commonly used formulas; continue copy and fill series; inserting and modifying comments; filtering and sorting; database essentials; perform subtotals; create and modify charts. Excel 2016

Learn the best practices and the foundation for Excel including: cursor positions and editing cells; how to create spreadsheets; perform basic data entry; execute spreadsheet operations, copy and fill series, inserting, deleting and adjusting columns and rows; formatting, saving, basic formulas, creating borders, formatting dates and conditional formatting. Excel 2016