thumbnail
IT Skills

Microsoft 365 Excel: Part 2 (ITS06EO)

profile
Instructor

Savvy

Reviews 0 (0 Reviews)

Course Overview

Course Content

  • Academy Topics

    • About This Course

    • Course Prerequisites

    • Course Overview

    • Course Objectives

    • Creating Advanced Formulas

    • TOPIC A: Apply Range Names

    • TOPIC B: Use Specialized Functions

    • Summary

    • Analyzing Data with Logical and Lookup Functions

    • TOPIC A: Use Text Functions

    • TOPIC B: Use Logical Functions

    • TOPIC C: Use Lookup Functions

    • TOPIC D: Use Date Functions

    • TOPIC E: Use Financial Functions

    • Summary

    • Organizing Worksheet Data with Tables

    • TOPIC A: Create and Format Tables

    • TOPIC B: Modifying Tables

    • TOPIC C: Table References

    • Summary

    • Visualizing Data with Charts

    • TOPIC A: Create Charts

    • TOPIC B: Modify and Format Charts

    • TOPIC C: Create a Trendline

    • TOPIC D: Create Advanced Charts

    • Summary

    • Analyzing Data with PivotTables, Slicers, and PivotCharts

    • TOPIC A: Create a PivotTable

    • TOPIC B: Filter Data Using Slicers

    • TOPIC C: Analyze Data with PivotCharts

    • Summary

    • Working with Graphical Objects

    • TOPIC A: Insert and Modify Graphic Objects

    • TOPIC B: Layer and Group Graphical Objects

    • TOPIC C: Incorporate SmartArt

    • Summary

    • Enhancing Workbooks

    • TOPIC A: Customize Workbooks

    • TOPIC B: Manage Themes

    • TOPIC C: Protect Files

    • TOPIC D: Preparing a Workbook for Multiple Audiences

    • Summary

    • Course Summary

    • Post-Course Assessment

Paid
  • Lessons 43
  • Skill Beginner
  • Last Update 27/02/2025