Excel Intermediate (Live Online)

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more!Class Outline:Lesson 1: Working with FunctionsTopic A: Work with RangesTopic B: Use Specialized FunctionsTopic C: Work with Logical FunctionsTopic D: Work with Date & Time FunctionsTopic E: Work with Text FunctionsLesson 2: Working with ListsTopic A: Sort DataTopic B: Filter DataTopic C: Query Data with Database FunctionsTopic D: Outline and Subtotal DataLesson 3: Analyzing DataTopic A: Create and Modify TablesTopic B: Apply Intermediate Conditional FormattingTopic C: Apply Advanced Conditional FormattingLesson 4: Visualizing Data with ChartsTopic A: Create ChartsTopic B: Modify and Format ChartsTopic C: Use Advanced Chart FeaturesLesson 5: Using PivotTables and PivotChartsTopic A: Create a PivotTableTopic B: Analyze PivotTable DataTopic C: Present Data with PivotChartsTopic D: Filter Data by Using Timelines and Slicers