ADV. EXCEL

Advanced Excel computer courses cover a variety of topics, including data analysis, formulas, and functions: 

• Data analysis: Learn how to organize and prioritize data, and use advanced filters to identify patterns 

• Formulas and functions: Master functions like VLOOKUP, XLOOKUP, MATCH, and INDEX to extract data from spreadsheets 

• Logical functions: Use logical functions like IF, AND, and OR to enhance decision-making 

• Pivot tables and charts: Become a data analysis expert with PivotTables 

• Protection: Secure spreadsheets with password protection and control access and editing permissions 

• Importing and consolidating data: Learn how to import and consolidate data 

• Dashboards: Learn how to create dashboards 

• Form controls: Learn how to use form controls 

• VBA and macros: Learn how to use VBA and macros