Excel - Level 2

Course Description

Excel - Level 2 is an intermediate, instructor-led Microsoft course designed for people who want to turn raw data into insights that help make smarter decisions. Ideal for learners pursuing accounting, administration, data analytics, finance, marketing, project management, and related careers. This hands-on course builds intermediate Microsoft Excel skills used in today’s workplace. This practical course covers:

• Creating Advanced Formulas
• Working with Functions and Lists
• Analyzing Data
• Visualizing Data with Charts
• Using PivotTables and PivotCharts
• Applying Conditional Formatting

Through live instruction and hands-on practice, participants gain intermediate spreadsheet skills that boost Microsoft Office proficiency and enhance career growth in a data-driven world.

Participant Outcomes

Upon successful completion of this course, you will be able to:

• Use Functions: Apply Excel’s built-in formulas to make calculations easier.
• Manage Lists: Organize and sort your data efficiently. A
• nalyze Data: Spot patterns, trends, and insights from your information.
• Create Charts: Turn your data into clear, visual representations.
• Use PivotTables & PivotCharts: Summarize and explore large amounts of data quickly.

Course Content

Lesson 1: Working with Functions

• Work with Ranges: Select and manage groups of cells efficiently.
• Use Specialized Functions: Apply formulas for finance, math, and more.
• Use Logical Functions: Make decisions in your spreadsheets with IF and other logic tools.
• Use Date & Time Functions: Handle dates and times easily.
• Use Text Functions: Manipulate and clean up text in your data.

Lesson 2: Working with Lists

• Sort Data: Arrange your data in the order you need.
• Filter Data: Focus on the information that matters most.
• Query Data: Extract specific info using database functions.
• Outline & Subtotal Data: Summarize and organize your lists quickly.

Lesson 3: Analyzing Data

• Create & Modify Tables: Organize your data effectively.
• Apply Intermediate Conditional Formatting: Highlight important trends and patterns.
• Apply Advanced Conditional Formatting: Make complex data insights pop visually.

Lesson 4: Visualizing Data with Charts

• Create Charts: Turn your numbers into easy-to-read visuals.
• Modify & Format Charts: Make charts look polished and professional.
• Use Advanced Chart Features: Customize charts to highlight key information.

Lesson 5: Using PivotTables and PivotCharts

• Create a PivotTable: Summarize large datasets quickly.
• Analyze PivotTable Data: Explore trends and patterns in your data.
• Present Data with PivotCharts: Visualize PivotTable insights effectively.
• Filter with Timelines & Slicers: Focus on specific data easily.