Skip to main content
Toggle navigation
Indiana University of Pennsylvania
Imagine Unlimited
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
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
Imagine Unlimited
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 Advanced Excel: Course Outline
1: Working With Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
2: Using Lookup Formulas and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas
3: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
4: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
5: Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data
6: Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecasting Data Trends