Catalog

This course is designed to advance your Excel skills beyond the basics, enabling you to effectively analyze and present data for intelligent decision-making within your organization. You will learn to work with a variety of functions, manage and analyze lists, and create dynamic visualizations using charts and PivotTables. By the end of this course, you\'ll be equipped to harness the power of Excel for deeper insights and more impactful presentations. The course also prepares you for the Excel Associate and Excel Expert certifications, covering the relevant Microsoft Office Specialist Program exam objectives.

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