Microsoft® Office Excel® 2019: Part 2 Training

The course is second in the series and covers the Office Specialist program necessary for Excel associate and Expert certification. During the course we teach students to execute basic calculations, modifying worksheets, analyzing data and using different functions. Those who take part 1 of the course are ideal candidates and can learn the intermediate to advanced skills.

• Working with functions.
• Working with lists.
• Analyzing data.
• Visualizing data with charts.
• Using PivotTables and Pivot Charts.

The course is for learners who already gained foundational knowledge through course 1 in Excel 2019 and are now wanting to proceed into a more intermediate and advanced environment of Excel for data analysis and other advanced functions and present data.

• 1. Working with Functions
• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date and Time Functions
• Work with Text Functions
View Less    View More   
2. Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
utline and Subtotal Data
3. Analyzing Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
4. Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features
5. Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers