Continuation of the Microsoft Excel Beginning course. Focuses on the higher level concepts of Microsoft Excel spreadsheet software within the Microsoft Office Suite. Summarize and analyze data using subtotals, PivotTables, and PivotCharts. Automate business analysis with tools such as Goal Seek, data tables, and Solver and run scenarios using Scenario Manager. Use Date, Logical, Lookup, Database, and Financial functions such as VLOOKUP, HLOOKUP, OR, AND, nested IF, COUNTIF, SUMIF, AVERAGEIF, DSUM, and DCOUNT. Analyze statistics using statistical functions.