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
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 Word I. Learn how to: copy, cut, paste; use paste special and format painter; format paragraphs and pages; bullet lists and columns; insert headers and footers, page numbers, tabs, tab stops and symbols; find and replace and tables. Word 2016.