Excel III
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 […]
PowerPoint I
Learn how to use the program to create slides, adding text, images, sounds, animation and slide transitions. PowerPoint 2016.
Excel
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
PowerPoint II
Must have taken PowerPoint I. Learn effective presenting skills and create your own presentation; volunteers can present their presentation. PowerPoint 2016.