LCT0087 - Excel Part 2 (Microsoft 365)
11101509
Delivery Options
LEL-Lecture-lab.
Loading...
Course Description
Ideal for enhancing your data analysis and presentation abilities in a professional setting, in this course you will expand your Excel skills and learn how to create advanced workbooks to organize data and extract insights to make them easier to interpret and present to others. You will be able to analyze large datasets and extract actionable information. Explore advanced Excel features like charts, graphic objects, and data sorting/filtering for comprehensive data management.Course Outline
- Lesson 1: Working with Functions
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date and Time Functions
- Work with Text Functions
- Lesson 2: Working with Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
- Lesson 3: Analyzing Data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
- Lesson 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Lesson 5: Using PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Learner Outcomes
This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps): Exam MO-210 and Microsoft Excel Expert (Microsoft 365 Apps): Exam MO-211 certification exams.Prerequisites
Excel Part 1 (Microsoft 365) LCT0086 or equivalent experienceApplies Towards the Following Digital Badges
- Excel Specialist (Microsoft 365) Digital Badge : Excel for Microsoft 365
- Microsoft 365 Office Essentials PLUS Digital Badge : Microsoft 365 Office Essentials PLUS
Loading...
Enroll Now - Select a section to enroll in
Required fields are indicated by .