Skip to main content
Toggle navigation
Indiana University of Pennsylvania
A–Z Index
Find People
Admissions
Admissions
Undergraduate Admissions
Graduate Admissions
Cook Honors College Admissions
International Admissions
Culinary Admissions
Summer Sessions
Winter Session
Apply Now
Virtual Campus Visits
Academics
Academics
Undergraduate Programs
Graduate Programs
Colleges and Departments
Cook Honors College
Interdisciplinary Education
Internships and International Education
Online Learning
Our Students
Our Faculty
Special Programs
Academic Support
IT Support Center
Registrar
Career and Professional Development Center
IUP Libraries
MyIUP
Research
Research
Research News
Research Events
Centers and Institutes
Expertise
Resources for Researchers
Research Institute
Undergraduate Research Office
Student Research
Student Life
Student Life
Events and Activities
Dining, Housing, and Campus Life
Financial Aid
Student Employment
Center for Health and Well-Being
Student Support
Hawks Q&A Center
Hawk’s Nest
Parents
Student Co-op
Oak Grove
Center for Multicultural Student Leadership and Engagement
Alumni
Alumni
Returning to Campus and the Alumni House
Alumni Association
Meet Our Alumni
Alumni and Friends News
About IUP
About IUP
IUP at a Glance
Campuses and Centers
Community Services
Diversity, Equity, and Inclusion at IUP
Map, Directions, and Parking
Employment at IUP
Administration
Support IUP
News and Events
News and Events
IUP News
Central Calendar
IUP Magazine
Homecoming
Family Weekend
IUP Mobile
Emergency Information
Academic Restructuring Plans
2020-21 Academic Year Plans and Coronavirus Information
A–Z Index
Find People
Toggle navigation
Office of Extended Studies
Noncredit Courses
Custom Training
Microsoft Basic Excel: Course Outline
Microsoft Intermediate Excel: Course Outline
Microsoft Advanced Excel: Course Outline
Microsoft Advanced Word: Course Outline
Microsoft Intermediate Word: Course Outline
Microsoft Basics Word: Course Outline
Microsoft Onenote 2016: Course Outline
Intermediate Microsoft Access: Course Outline
Beginning Microsoft Access: Course Outline
Intermediate Microsoft Project: Course Outline
Beginning Microsoft Project: Course Outline
Microsoft Basics Powerpoint: Course Outline
Microsoft Intermediate Powerpoint: Course Outline
Developing Successful Interpersonal Skills Outline
Communicating Across Your Organization
Expanding Your Emotional Intelligence
Evolving Into the Manager Role
Effective Leadership Through Coaching
Managing Remote and Virtual Teams
Critical Facilitation Skills for Leaders
Attend IUP
Help Students Now
Microsoft Intermediate Excel: Course Outline
1: Working With Functions
Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date and Time Functions
Topic E: Work with Text Functions
2: Working With Lists
Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data
3: Analyzing Data
Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting
4: Visualizing Data With Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features
5: Analyzing Data With PivotTables and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers