Microsoft Excel Advanced (Level 2)
March 26, 2019 @ 5:00 pm - March 28, 2019 @ 8:00 pm
Class / Program / Event Navigation
DIVE DEEP INTO EXCEL! Begin a deep dive into automating spreadsheets. Learn how to create linking formulas that automatically connect data over many different worksheets, allowing for easy one-time data entry. Add to your portfolio a group of the most powerful formulas frequently used in Excel. And then splash your spreadsheet with useful graphics and templates to highlight and connect key informational points. What Will I Learn? (1) Working with Functions- rangs, date and time functions (2) Working with Lists- sorting and filtering data (3) Analyzing data- creating and modifying data, quesry data (4) Adding Charts (5) PivotTables and PivotCharts Prerequisites? Proficiency using any level of Microsoft Excel is required.