Microsoft Excel Advanced (Level 2)
November 7 @ 9:00 am - 3: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) Advanced Formatting – Themes, Cell Styles, Customizing Page Setup (2) Date and Time Functions, Conditional Formatting (3) Advanced Functions for Text and Analysis – IF Criteria, Troubleshooting Formulas (4) Introducing Lookup (VLOOKUP and HLOOKUP) Functions and the Outline Features. Prerequisite: Proficiency using any level of Microsoft Excel is required.