Excel Intermediate focuses on the intermediate concepts of Microsoft Office Excel spreadsheet software. Summarize and analyze data using subtotals, PivotTables, and PivotCharts. Use data tables, Goal Seek, Scenario Manager, and Solver to perform what-if analysis. Use Date, Logical, Lookup, Database, and Financial functions. Analyze statistics using statistical functions.