Courses
  • Date(s)

  • Offered
    • Face-to-face
    • Online
    • On-site

Overview

Overview

Microsoft Excel is the most commonly used spreadsheet application, but working with data in spreadsheets can be both difficult and time-consuming. This course is designed for users of Microsoft Excel data management features and functionality. The four course modules offer tools and tips on building Microsoft Excel skills and organizing data and will explore list management, excel tables, pivot tables and pivot charts.

This self-paced, online course launches on Monday, January 6, 2020. Participants will have two weeks to complete the four course modules. The webinar concludes with a one-hour live Q&A webinar on Thursday, January 23rd to answer questions participants have after completing the course.

Learning Objectives

By completing this course, attendees will:

  • Understand List Management
  • Learn and explore excel tables
  • Create and modify PivotTables
  • Design compelling charts and PivotCharts to visually display summarized data


Key Topics
  • Module 1: List Management
    • Sort & Filter lengthy lists of data
    • Control data input using Data Validation
    • Highlight specific content using Conditional Formatting)
  • Module 2: Excel Tables
    • Create & Format data in an Excel Table
    • Modify the table range
    • Highlight content using Conditional Formatting
    • Quickly summarize and aggregate date using Table Totals Row
  • Module 3: PivotTables
    • Create & modify PivotTables to summarize data
    • Format the PivotTable to display important data
    • Apply filters to the data using new Slicer tool
    • Drill down into data details with a quick export
  • Module 4: Excel Charts and PivotCharts
    • Create basic Excel charts and PivotCharts
Yes

Curriculum

Instructors

No
 
No

Please enter a value

Hotel & Travel

Hotel Reservations

Make Hotel Reservation

About
Please enter a value
Airport(s)
Please enter a value
Please enter a value
mi
from event
 
 
mi
from event
 
 
mi
from event

Fees

$150

Competencies

CORE COMPETENCIES

Employee Competencies

  • Technical Credibility
Learn More
ROLE-SPECIFIC
Learn More
SUPERVISORY, MANAGEMENT AND LEADERSHIP
Learn More

FAQs

See Also

View Your Course Record