Microsoft PowerPoint 2021 Intermediate

Topic A: Working with Date and Time Function
• TODAY
• NOW
• Calculation between dates / time formula

Topic B: Working with Text by Changing Case
• UPPER
• LOWER
• PROPER

Topic C: Working with Lookup Function
• VLOOKUP
• HLOOKUP

Topic D: Conditional Data Summary
• COUNTIF / COUNTIFS
• AVERAGEIF / AVERAGEIFS
• SUMIF / SUMIFS

Topic E: Conditional Data Extraction
• IFERROR
• IF

• Using Text-to-Column
• Insert FlashFill to Combine and Split Data
• Insert Checkbox feature

Topic A: Create and Modify Tables
• Create table
• Table Styles and Options
• Removing Duplicate Values
• Total Row with SUBTOTAL Functions
• Rename table
• Convert table to range
Topic B: Sort and Filter Data
• Sorting Data by value
• Sorting data by color
• Filtering Data

Topic A: Conditional Formatting
• Highlight Cell Rules
• Data Bars
• Icon Sets

Topic B: Create Charts
• Chart Insertion Methods
• Resizing and Moving the Chart
• Adding Additional Data
• Switching Between Rows and Columns

Topic C: Modify and Format Charts
• Formatting the Chart with a Style
• Chart Elements
• Chart Filter