Microsoft Excel Advanced
April 9, 2018 @ 9:00 am
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) Conditional formatting to automatically flag trends, (2) Joining multiple-sheet workbooks with 3-D cell linking, (3) Expanded levels of commonly used formulas, such as IF logic, PMT, and Concatenate, for deeper data analysis, (4) Customize your own templates to save development time. Prerequisites? Proficiency using any level of Microsoft Excel is required..