Excel Programs

In partnership with UNM Continuing Education, we are offering focused, professional skill development programs. Building and sharpening software skills, enhances your leadership and management aptitudes.  

ce-logo.png

Excel: Beginning

Learn the most effective methods to create, modify, format, and print Microsoft Excel worksheets. Enter and edit data and apply basic formulas and functions to summarize data. Explore custom formatting features, such as fonts and conditional formatting. Create and format charts, insert and modify graphics and set print options.

Program Information

Dates: Tuesdays and Thursdays, June 24 – July 1, 2021
Time: 1 – 4 p.m., MDT
Location: Live Online
Cost: $259


Course Number: 52161-027
Contact Hours: 9.0
CEUs: 0.9 CEUs
Instructor:Rav Nicholson

Excel: Intermediate

Move beyond the basics with Excel. Link multiple worksheets/workbooks, outline and consolidate data, and create and use cell names for greater understanding and ease. Learn to sort and filter data, convert data ranges to tables and work with table formulas. Use hyperlinks, explore auditing and workbook protection features, and apply and create templates. Use backstage tools to modify application settings. Prerequisite: Excel: Beginning or equivalent experience.

Program Information

Dates: Tuesdays and Thursdays, July 27 – August 3, 2021
Time: 1 – 4 p.m., MDT
Location: Live Online
Cost: $259


Course Number: 52162-026
Contact Hours: 9.0
CEUs: 0.9 CEUs
Instructor:Rav Nicholson

Excel: Advanced

Learn the advanced features of Excel to simplify your work. Use logical, conditional, financial, text and date/time functions. Work with PivotTables and PivotCharts to see patterns in your data. Explore calculation options, validate cell entries, use advanced filtering options, and work with advanced charting techniques. Prerequisite: Excel: Intermediate. 

Program Information

Dates: New dates coming soon
Time: TBD
Location: Live Online
Cost: $295


Course Number: 52163-012
Contact Hours: 12.0
CEUs: 1.2 CEUs
Instructor:Rav Nicholson

Excel: Pivot Tables and Charts

Use Excel Pivot Tables to efficiently extract meaningful information from large tables of data. Understand pivot table requirements and capabilities. Extract custom data subsets, perform summary calculations, create interactive pivot charts, and format reports. Enhance your knowledge of chart types to create custom charts, applying advanced chart design techniques. Prerequisite: Intermediate Excel.

Program Information

Dates: Tuesdays and Thursdays, April 27 - April 29, 2021
Time: 1 – 4 p.m., MDT
Location: Live Online
Cost: $195

 

Course Number: 52166-012
Contact Hours: 6.0
CEUs: 0.6 CEUs
Instructor:Rav Nicholson

Upcoming Programs

Practical Project Management

Tuesdays and Thursdays
June 8 - August 12, 2021

6 - 8 p.m.

Fundamentals of Human Resources

Mondays and Wednesdays
June 7-23, 2021

6-8 p.m.


Mediation Certification

Saturdays
June 5 - July 24, 2021
9 a.m. - 3:30 p.m.

Essentials for Managers

Mondays
Sep. 13 - Nov. 15, 2021
6-9 p.m.



SHRM Exam Prep

Thursdays
Sep. 2 - Nov. 18, 2021
6-9 p.m.


Women's Leadership Development

Wednesdays
Sep. 15 - Nov. 3, 2021
6-8 p.m.



Sales Strategies for the 21st Centry

Tuesdays
Sep. 21 - Nov. 9, 2021
6-9 p.m.



Upcoming Workshops

Leading through Uncertainty to Clarity

Tuesdays and Thursdays
June 8 - 17, 2021
6-8 p.m.