Filter by Category
Newport
in Location
Microsoft Excel - Level 2
with Donna Taylor

This course covers naming a range, specialprinting titles of rows & columns, paste between work-sheets, pasting values and links, viewing and workingwith multiple work-sheets, 3D formulas, protecting a workbook \ worksheet, & cells, checking for duplicates, Excel as a database, autofilters, slicers,and creating a graph with two axis.
Excel Level 2 is a continuation of Level 1, participants should have those skills before taking Excel Level 2. Course objectives are how to work with multiple files and worksheets, naming a range and benefits, sorting and filtering data using Excel as a database, tables and their benefits, data validation, sub-totals, Pivot Tables, conditional formatting, graphs with two axis and sparklines.
Microsoft Excel - Level 3
with Donna Taylor

This course provides advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.
Excel Level 3 is a continuation of Level 2, participants should have those skills before taking Excel Level 3. Course objectives are If Statements, Lookup Functions, Date and Text Functions, What-If Analysis, Exporting, Importing using Power Pivot, Simple Macros and Form Tools.