EXCEL – LEVEL I-ONE DAY SESSION
This workshop covers introductory material geared towards those with little or no knowledge of Excel. It covers the basics of navigating around Excel; entering and editing a worksheet, moving/copying, AutoFill, formatting, creating formulas, basic functions, printing and previewing, and charts.
EXCEL-LEVEL II-ONE DAY SESSION
This workshop covers some more advanced functions (such as VLOOKUP, IF, PMT). It also touches on working with multiple workbooks/worksheets, consolidation features, and working with tables (Excel database features). Sorting and filtering are also covered.
EXCEL-LEVEL III-ONE DAY SESSION
Trainees will review formulas and functions from Level II and add more advanced functions to their skills, including: Functions: Date & Time, Look up, MATCH, Text, Information, SUMIF and COUNTIF, TRUE & FALSE Logical functions, AND, OR, NOT IFERROR functions. Trainees will explore using Templates and Macros, Form Controls, Error Checking and Data Analysis features in this 7 hour session.
POWERPOINT – LEVEL I
In this one day workshop geared for those either new to PowerPoint, or those wishing to learn what is new in PowerPoint 2016. Trainees will explore The Microsoft Office Backstage View, using help, creating a presentation and adding text, closing and opening, naming presentations; inserting, deleting, and editing slides. Other topics covered include: applying bold, italic and underline to text; Format painter, changing a slide’s layout, using pictures, creating shapes, arrows, formatting the borders, adding effects to shapes, rotating & adjusting shapes, the format pane, working with multiple shapes and objects; text boxes and WordArt, running a slideshow, setting up a slide show, adding animations, and setting up rehearsed timings.
POWERPOINT – LEVEL II
This course will introduce the learners to importing slide content form another source; reusing slides from another presentation, importing slides from an outline, working with slide backgrounds, setting aside background, setting a picture as a slide background, slide masters, Handout master & Notes Master. Advanced animation is introduced, Adding sound and video, creating a smart art graphic and additional advanced features.