Excel 2: Advanced Functions

Enhance the functionality of your excel spreadsheets with nested functions, If statements, VLookup, Pivot tables, and charts. Increase efficiency by linking cells, worksheets, and workbooks. Analyze data using subtotal functions and advanced filters. Enrich data analysis visually using conditional formatting. Incorporate workbook security features and more.Prerequisites: Excel 1 or equivalent. Note: Optional textbook available at the Langara Bookstore.