Main Menu
Microsoft Office

Microsoft Office Certificates

Microsoft Office is essential in today's workplace. Take our Beginning, Intermediate and Advanced classes to gain the skills you need in your workplace or home office. Our instructors offer the practical tips and tricks that make our lives easier. Maybe you have specific questions after you finish any level of Microsoft Training. Following any course completion you may sign up for two hours of personalized learning with your instructor.

Download Microsoft Office Certificates Flyer


4 courses required to earn this certificate

Prerequisite Courses (As Needed)

Choose 1:

Class Name

Learn the basic functions of the latest Windows operating system and how to customize its setup. Work with files and folders, shortcuts and properties. Resize windows, use the taskbar, start menu and recycle bin, and get an introduction to shortcuts. In addition, explore popular software and get started with launching programs. Note: See Course Skills Assessment. Prerequisite: 51010 or basic computer experience.

Note: This class uses Windows 10. UNM Tuition Remission eligible under Professional Development.

51101 | $249

Windows: Beginning - FAA-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Get hands-on training with the Mac's latest user-friendly operating system. Learn the basics of file management, navigating the Finder, setting up the Dock, customizing preferences, creating and saving files and backing up your computer. Become familiar with the concepts of peripherals, utility applications and cloud computing with iCloud. Note: http://ce.unm.edu/assets/pdf/digital-arts/digital-arts-course-skills-assessment.pdf?utm_source=lumens and utm_medium=course-description and utm_campaign=da-skills-assessment. Prerequisite: 54010 or equivalent experience.

Note: UNM Tuition Remission eligible under Professional Development.

54101 | $249

Mac OS X: Beginning - FAA-PD

10/23/17 - 10/30/17
Mon, Wed 8:00 AM - 11:00 AM (3 Session Total)
Joshua Martinez
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

or basic computer familiarity

Required Courses (4)
Class Name

Learn to create, edit, and save documents as well as format text, paragraphs, and documents using Microsoft Word. Learn effective navigation and selection techniques and work with tabs, indents, paragraph formatting and line spacing. Manage headers, footers, and margins. Use proofing and correcting features including find and replace text, AutoCorrect, and Spelling and Grammar Checker. Add graphics and clip art. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52141 | $249

Word: Beginning - FAA-PD

9/26/17 - 10/3/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Use Word for more complex tasks. Learn to format text in multiple columns and work with the intricacies of tables and charts. Explore customized formatting options with styles and themes for a more professional look. Manage lists, customize your Word environment and insert content using Quick Parts. Prerequisite: Word: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52142 | $249

Word: Intermediate - FAA-PD

10/17/17 - 10/24/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Make the most out of Word! Learn how to better utilize images in a document, customize graphic elements, and better control text flow. Make Word do the work for you with mail merge, advanced use of templates and macros. Prerequisite: Intermediate Word.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52143 | $249

Word: Advanced - FAA-PD

10/30/17 - 11/6/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Certificate Total: $996 for 36 hours

4 courses required to earn this certificate

Prerequisite Courses (As Needed)

Choose 1:

Class Name

Learn the basic functions of the latest Windows operating system and how to customize its setup. Work with files and folders, shortcuts and properties. Resize windows, use the taskbar, start menu and recycle bin, and get an introduction to shortcuts. In addition, explore popular software and get started with launching programs. Note: See Course Skills Assessment. Prerequisite: 51010 or basic computer experience.

Note: This class uses Windows 10. UNM Tuition Remission eligible under Professional Development.

51101 | $249

Windows: Beginning - FAA-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Get hands-on training with the Mac's latest user-friendly operating system. Learn the basics of file management, navigating the Finder, setting up the Dock, customizing preferences, creating and saving files and backing up your computer. Become familiar with the concepts of peripherals, utility applications and cloud computing with iCloud. Note: http://ce.unm.edu/assets/pdf/digital-arts/digital-arts-course-skills-assessment.pdf?utm_source=lumens and utm_medium=course-description and utm_campaign=da-skills-assessment. Prerequisite: 54010 or equivalent experience.

Note: UNM Tuition Remission eligible under Professional Development.

54101 | $249

Mac OS X: Beginning - FAA-PD

10/23/17 - 10/30/17
Mon, Wed 8:00 AM - 11:00 AM (3 Session Total)
Joshua Martinez
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

or basic computer familiarity

Required Courses (4)
Class Name

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52162 | $249

Excel: Intermediate - SUA-PD

8/2/17 - 8/9/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Sonja Dewing
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52163 | $249

Excel: Advanced - SUA-PD

8/8/17 - 8/15/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52161 | $249

Excel: Beginning - FAA-PD

9/5/17 - 9/12/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class

Excel: Beginning - FAB-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Sonja Dewing
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52162 | $249

Excel: Intermediate - FAA-PD

10/10/17 - 10/17/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52163 | $249

Excel: Advanced - FAA-PD

11/28/17 - 12/5/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Continue to build your expertise in Excel. Work with advanced formatting features, use lookup functions and explore array formulas to make your work more efficient. Create 1- and 2-variable tables. Import and export data as text files, use Goal Seek and Scenarios to analyze data, and run macros. In addition, start working with database functions and VBA code. Prerequisite: Excel: Advanced.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52164 | $249

Excel: Expert - FAA-PD

12/12/17 - 12/19/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Certificate Total: $996 for 36 hours

4 courses required to earn this certificate

Prerequisite Courses (As Needed)

Choose 1:

Class Name

Learn the basic functions of the latest Windows operating system and how to customize its setup. Work with files and folders, shortcuts and properties. Resize windows, use the taskbar, start menu and recycle bin, and get an introduction to shortcuts. In addition, explore popular software and get started with launching programs. Note: See Course Skills Assessment. Prerequisite: 51010 or basic computer experience.

Note: This class uses Windows 10. UNM Tuition Remission eligible under Professional Development.

51101 | $249

Windows: Beginning - FAA-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Get hands-on training with the Mac's latest user-friendly operating system. Learn the basics of file management, navigating the Finder, setting up the Dock, customizing preferences, creating and saving files and backing up your computer. Become familiar with the concepts of peripherals, utility applications and cloud computing with iCloud. Note: http://ce.unm.edu/assets/pdf/digital-arts/digital-arts-course-skills-assessment.pdf?utm_source=lumens and utm_medium=course-description and utm_campaign=da-skills-assessment. Prerequisite: 54010 or equivalent experience.

Note: UNM Tuition Remission eligible under Professional Development.

54101 | $249

Mac OS X: Beginning - FAA-PD

10/23/17 - 10/30/17
Mon, Wed 8:00 AM - 11:00 AM (3 Session Total)
Joshua Martinez
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

or basic computer familiarity

Required Courses (4)
Class Name

Understand the basic concepts of database use and how to most effectively design your database using Microsoft Access. Design basic tables and add, edit, locate, sort, filter and delete data. Set field properties, work with input masks and set validation rules. Learn to design and apply queries and reports to make it easier to accomplish everyday database tasks. In addition, get an introduction to basic forms. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52181 | $249

Access: Beginning - FAA-PD

9/25/17 - 9/29/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Go beyond the basics using queries to answer specific questions and develop summaries with Access. Create and enhance custom forms, a main form with sub-forms, and custom reports. In addition, learn how to identify and create relationships. Prerequisite: Access: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52182 | $249

Access: Intermediate - FAA-PD

10/9/17 - 10/13/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Make Access do more for you through advanced queries, including crosstabs and parameters. Learn to write SQL statements and attach SQL queries to controls. Create, run, and modify macros, attach macros to events, and create macros that will provide user interaction or data transfer. Import, export and link objects, and work with hyperlinked fields. Prerequisite: Access: Intermediate.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52183 | $249

Access: Advanced - FAA-PD

11/13/17 - 11/17/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Use your expertise in Access to plan and develop a database. Apply your knowledge of table design and table relationships, incorporating lookup fields to ensure consistency in data entry. Create user-friendly data input forms, design advanced queries and reports to extract data, and develop database navigation screens that include macro-supported controls. Prerequisite: Access: Advanced.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52184 | $249

Access: Expert - FAA-PD

12/11/17 - 12/15/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Certificate Total: $996 for 36 hours

4 courses required to earn this certificate

Prerequisite Courses (As Needed)

Choose 1:

Class Name

Learn the basic functions of the latest Windows operating system and how to customize its setup. Work with files and folders, shortcuts and properties. Resize windows, use the taskbar, start menu and recycle bin, and get an introduction to shortcuts. In addition, explore popular software and get started with launching programs. Note: See Course Skills Assessment. Prerequisite: 51010 or basic computer experience.

Note: This class uses Windows 10. UNM Tuition Remission eligible under Professional Development.

51101 | $249

Windows: Beginning - FAA-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Get hands-on training with the Mac's latest user-friendly operating system. Learn the basics of file management, navigating the Finder, setting up the Dock, customizing preferences, creating and saving files and backing up your computer. Become familiar with the concepts of peripherals, utility applications and cloud computing with iCloud. Note: http://ce.unm.edu/assets/pdf/digital-arts/digital-arts-course-skills-assessment.pdf?utm_source=lumens and utm_medium=course-description and utm_campaign=da-skills-assessment. Prerequisite: 54010 or equivalent experience.

Note: UNM Tuition Remission eligible under Professional Development.

54101 | $249

Mac OS X: Beginning - FAA-PD

10/23/17 - 10/30/17
Mon, Wed 8:00 AM - 11:00 AM (3 Session Total)
Joshua Martinez
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

or basic computer familiarity

Required Courses (4)
Class Name

Become a PowerPoint power user. Create slides that include graphs, tables and organizational charts for easy communication. Develop multimedia content and customized slide shows that set your presentations apart. Save presentations in various formats. Students develop and deliver a PowerPoint presentation in class. Prerequisite: PowerPoint: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52242 | $249

PowerPoint: Intermediate - SUA-PD

8/22/17 - 8/29/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Learn to create an effective layout for any graphic design project. Discover the principles of design for clear and attractive visual communication. Topics include an introduction to advertising, publication, and web design;; logos and letterhead packages;; layout;; typography;; and color theory. Note: Equipment and materials cost about $25;; a materials list will be available the first day of class. Prerequisite: None. Suggested: 55201.

Note: UNM Tuition Remission eligible under Professional Development.

55101 | $249

Graphic Design I - FAA-PD

9/28/17 - 10/5/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Zac Van Note
CE South Building

Register Online for this Class

Graphic Design I - FAB-PD

10/2/17 - 10/9/17
Mon, Wed 1:00 PM - 4:00 PM (3 Session Total)
Alexis Estrada
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Create presentation materials using Microsoft PowerPoint. Learn to edit, format, proof and print presentations. Build and run slide shows with transition and multimedia elements. Use templates and themes to make your presentations visually interesting. Draw objects and use ClipArt and WordArt for dramatic effects. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52241 | $249

PowerPoint: Beginning - FAA-PD

11/9/17 - 11/16/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Become a PowerPoint power user. Create slides that include graphs, tables and organizational charts for easy communication. Develop multimedia content and customized slide shows that set your presentations apart. Save presentations in various formats. Students develop and deliver a PowerPoint presentation in class. Prerequisite: PowerPoint: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52242 | $249

PowerPoint: Intermediate - FAA-PD

11/28/17 - 12/5/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Continue to improve your PowerPoint skills with new resources, advanced multimedia use and innovative design ideas. Learn how to make your presentations more visually effective with branded images and styles by recoloring images to match, finding images that you can use within the copyright laws, or using your own. Also, create a workflow map that will allow you to put together your presentations faster. Additional topics include adding tables and documents to your presentation. Prerequisite: 52242.

Note: This class uses version 2013. UNM Tuition Remission eligible under Professional Development.

52243 | $249

PowerPoint: Advanced - FAA-PD

12/12/17 - 12/19/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Certificate Total: $996 for 36 hours

Prerequisite Courses (As Needed)

Choose 1:

Class Name

Learn the basic functions of the latest Windows operating system and how to customize its setup. Work with files and folders, shortcuts and properties. Resize windows, use the taskbar, start menu and recycle bin, and get an introduction to shortcuts. In addition, explore popular software and get started with launching programs. Note: See Course Skills Assessment. Prerequisite: 51010 or basic computer experience.

Note: This class uses Windows 10. UNM Tuition Remission eligible under Professional Development.

51101 | $249

Windows: Beginning - FAA-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Get hands-on training with the Mac's latest user-friendly operating system. Learn the basics of file management, navigating the Finder, setting up the Dock, customizing preferences, creating and saving files and backing up your computer. Become familiar with the concepts of peripherals, utility applications and cloud computing with iCloud. Note: http://ce.unm.edu/assets/pdf/digital-arts/digital-arts-course-skills-assessment.pdf?utm_source=lumens and utm_medium=course-description and utm_campaign=da-skills-assessment. Prerequisite: 54010 or equivalent experience.

Note: UNM Tuition Remission eligible under Professional Development.

54101 | $249

Mac OS X: Beginning - FAA-PD

10/23/17 - 10/30/17
Mon, Wed 8:00 AM - 11:00 AM (3 Session Total)
Joshua Martinez
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

or basic computer familiarity

Required Courses (4)
Class Name

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. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52161 | $249

Excel: Beginning - FAA-PD

9/5/17 - 9/12/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class

Excel: Beginning - FAB-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Sonja Dewing
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Learn to create, edit, and save documents as well as format text, paragraphs, and documents using Microsoft Word. Learn effective navigation and selection techniques and work with tabs, indents, paragraph formatting and line spacing. Manage headers, footers, and margins. Use proofing and correcting features including find and replace text, AutoCorrect, and Spelling and Grammar Checker. Add graphics and clip art. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52141 | $249

Word: Beginning - FAA-PD

9/26/17 - 10/3/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Choose 2:

Class Name

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52162 | $249

Excel: Intermediate - SUA-PD

8/2/17 - 8/9/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Sonja Dewing
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Understand the basic concepts of database use and how to most effectively design your database using Microsoft Access. Design basic tables and add, edit, locate, sort, filter and delete data. Set field properties, work with input masks and set validation rules. Learn to design and apply queries and reports to make it easier to accomplish everyday database tasks. In addition, get an introduction to basic forms. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52181 | $249

Access: Beginning - FAA-PD

9/25/17 - 9/29/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52162 | $249

Excel: Intermediate - FAA-PD

10/10/17 - 10/17/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Use Word for more complex tasks. Learn to format text in multiple columns and work with the intricacies of tables and charts. Explore customized formatting options with styles and themes for a more professional look. Manage lists, customize your Word environment and insert content using Quick Parts. Prerequisite: Word: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52142 | $249

Word: Intermediate - FAA-PD

10/17/17 - 10/24/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Create presentation materials using Microsoft PowerPoint. Learn to edit, format, proof and print presentations. Build and run slide shows with transition and multimedia elements. Use templates and themes to make your presentations visually interesting. Draw objects and use ClipArt and WordArt for dramatic effects. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52241 | $249

PowerPoint: Beginning - FAA-PD

11/9/17 - 11/16/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Certificate Total: $996 for 36 hours

10 courses required to earn this certificate

Prerequisite Courses (As Needed)

Choose 1:

Class Name

Learn the basic functions of the latest Windows operating system and how to customize its setup. Work with files and folders, shortcuts and properties. Resize windows, use the taskbar, start menu and recycle bin, and get an introduction to shortcuts. In addition, explore popular software and get started with launching programs. Note: See Course Skills Assessment. Prerequisite: 51010 or basic computer experience.

Note: This class uses Windows 10. UNM Tuition Remission eligible under Professional Development.

51101 | $249

Windows: Beginning - FAA-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Get hands-on training with the Mac's latest user-friendly operating system. Learn the basics of file management, navigating the Finder, setting up the Dock, customizing preferences, creating and saving files and backing up your computer. Become familiar with the concepts of peripherals, utility applications and cloud computing with iCloud. Note: http://ce.unm.edu/assets/pdf/digital-arts/digital-arts-course-skills-assessment.pdf?utm_source=lumens and utm_medium=course-description and utm_campaign=da-skills-assessment. Prerequisite: 54010 or equivalent experience.

Note: UNM Tuition Remission eligible under Professional Development.

54101 | $249

Mac OS X: Beginning - FAA-PD

10/23/17 - 10/30/17
Mon, Wed 8:00 AM - 11:00 AM (3 Session Total)
Joshua Martinez
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

or basic computer familiarity

Required Courses (10)
Class Name

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52162 | $249

Excel: Intermediate - SUA-PD

8/2/17 - 8/9/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Sonja Dewing
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52163 | $249

Excel: Advanced - SUA-PD

8/8/17 - 8/15/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Become a PowerPoint power user. Create slides that include graphs, tables and organizational charts for easy communication. Develop multimedia content and customized slide shows that set your presentations apart. Save presentations in various formats. Students develop and deliver a PowerPoint presentation in class. Prerequisite: PowerPoint: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52242 | $249

PowerPoint: Intermediate - SUA-PD

8/22/17 - 8/29/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52161 | $249

Excel: Beginning - FAA-PD

9/5/17 - 9/12/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class

Excel: Beginning - FAB-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Sonja Dewing
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Understand the basic concepts of database use and how to most effectively design your database using Microsoft Access. Design basic tables and add, edit, locate, sort, filter and delete data. Set field properties, work with input masks and set validation rules. Learn to design and apply queries and reports to make it easier to accomplish everyday database tasks. In addition, get an introduction to basic forms. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52181 | $249

Access: Beginning - FAA-PD

9/25/17 - 9/29/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Learn to create, edit, and save documents as well as format text, paragraphs, and documents using Microsoft Word. Learn effective navigation and selection techniques and work with tabs, indents, paragraph formatting and line spacing. Manage headers, footers, and margins. Use proofing and correcting features including find and replace text, AutoCorrect, and Spelling and Grammar Checker. Add graphics and clip art. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52141 | $249

Word: Beginning - FAA-PD

9/26/17 - 10/3/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Go beyond the basics using queries to answer specific questions and develop summaries with Access. Create and enhance custom forms, a main form with sub-forms, and custom reports. In addition, learn how to identify and create relationships. Prerequisite: Access: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52182 | $249

Access: Intermediate - FAA-PD

10/9/17 - 10/13/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52162 | $249

Excel: Intermediate - FAA-PD

10/10/17 - 10/17/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Use Word for more complex tasks. Learn to format text in multiple columns and work with the intricacies of tables and charts. Explore customized formatting options with styles and themes for a more professional look. Manage lists, customize your Word environment and insert content using Quick Parts. Prerequisite: Word: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52142 | $249

Word: Intermediate - FAA-PD

10/17/17 - 10/24/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Make the most out of Word! Learn how to better utilize images in a document, customize graphic elements, and better control text flow. Make Word do the work for you with mail merge, advanced use of templates and macros. Prerequisite: Intermediate Word.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52143 | $249

Word: Advanced - FAA-PD

10/30/17 - 11/6/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Create presentation materials using Microsoft PowerPoint. Learn to edit, format, proof and print presentations. Build and run slide shows with transition and multimedia elements. Use templates and themes to make your presentations visually interesting. Draw objects and use ClipArt and WordArt for dramatic effects. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52241 | $249

PowerPoint: Beginning - FAA-PD

11/9/17 - 11/16/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Make Access do more for you through advanced queries, including crosstabs and parameters. Learn to write SQL statements and attach SQL queries to controls. Create, run, and modify macros, attach macros to events, and create macros that will provide user interaction or data transfer. Import, export and link objects, and work with hyperlinked fields. Prerequisite: Access: Intermediate.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52183 | $249

Access: Advanced - FAA-PD

11/13/17 - 11/17/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52163 | $249

Excel: Advanced - FAA-PD

11/28/17 - 12/5/17
Tue, Thu 1:00 PM - 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Become a PowerPoint power user. Create slides that include graphs, tables and organizational charts for easy communication. Develop multimedia content and customized slide shows that set your presentations apart. Save presentations in various formats. Students develop and deliver a PowerPoint presentation in class. Prerequisite: PowerPoint: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52242 | $249

PowerPoint: Intermediate - FAA-PD

11/28/17 - 12/5/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Continue to improve your PowerPoint skills with new resources, advanced multimedia use and innovative design ideas. Learn how to make your presentations more visually effective with branded images and styles by recoloring images to match, finding images that you can use within the copyright laws, or using your own. Also, create a workflow map that will allow you to put together your presentations faster. Additional topics include adding tables and documents to your presentation. Prerequisite: 52242.

Note: This class uses version 2013. UNM Tuition Remission eligible under Professional Development.

52243 | $249

PowerPoint: Advanced - FAA-PD

12/12/17 - 12/19/17
Tue, Thu 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Certificate Total: $2,490 for 90 hours

4 courses required to earn this certificate

Prerequisite Courses (As Needed)

Choose 1:

Class Name

Learn the basic functions of the latest Windows operating system and how to customize its setup. Work with files and folders, shortcuts and properties. Resize windows, use the taskbar, start menu and recycle bin, and get an introduction to shortcuts. In addition, explore popular software and get started with launching programs. Note: See Course Skills Assessment. Prerequisite: 51010 or basic computer experience.

Note: This class uses Windows 10. UNM Tuition Remission eligible under Professional Development.

51101 | $249

Windows: Beginning - FAA-PD

9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Get hands-on training with the Mac's latest user-friendly operating system. Learn the basics of file management, navigating the Finder, setting up the Dock, customizing preferences, creating and saving files and backing up your computer. Become familiar with the concepts of peripherals, utility applications and cloud computing with iCloud. Note: http://ce.unm.edu/assets/pdf/digital-arts/digital-arts-course-skills-assessment.pdf?utm_source=lumens and utm_medium=course-description and utm_campaign=da-skills-assessment. Prerequisite: 54010 or equivalent experience.

Note: UNM Tuition Remission eligible under Professional Development.

54101 | $249

Mac OS X: Beginning - FAA-PD

10/23/17 - 10/30/17
Mon, Wed 8:00 AM - 11:00 AM (3 Session Total)
Joshua Martinez
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

or basic computer familiarity

Required Courses (4)
Class Name

Understand the basic concepts of database use and how to most effectively design your database using Microsoft Access. Design basic tables and add, edit, locate, sort, filter and delete data. Set field properties, work with input masks and set validation rules. Learn to design and apply queries and reports to make it easier to accomplish everyday database tasks. In addition, get an introduction to basic forms. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52181 | $249

Access: Beginning - FAA-PD

9/25/17 - 9/29/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Go beyond the basics using queries to answer specific questions and develop summaries with Access. Create and enhance custom forms, a main form with sub-forms, and custom reports. In addition, learn how to identify and create relationships. Prerequisite: Access: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52182 | $249

Access: Intermediate - FAA-PD

10/9/17 - 10/13/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Make Access do more for you through advanced queries, including crosstabs and parameters. Learn to write SQL statements and attach SQL queries to controls. Create, run, and modify macros, attach macros to events, and create macros that will provide user interaction or data transfer. Import, export and link objects, and work with hyperlinked fields. Prerequisite: Access: Intermediate.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

52183 | $249

Access: Advanced - FAA-PD

11/13/17 - 11/17/17
Mon, Wed, Fri 1:00 PM - 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Register Online for this Class
Register by Phone at (505) 277-0077 | M-F 8am-5pm Except UNM Holidays
More Ways to Register

Certificate Total: $996 for 36 hours

Microsoft Office - Upcoming Classes

Class Name

Harness the power of Microsoft OneNote's electronic note-taking capabilities. Learn how to create virtual notebooks from handwritten or typed notes, drawings, screen clippings, audio and more. Capture thoughts, ideas and notes as you work in other applications. Prerequisite: Beginning Windows or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section SUA-PD

52035
$95
7/27/17
Thu 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

Use Excel Pivot Tables to efficiently extract meaningful information from large tables of data. Understand pivot table requirements and capabilities to view data from different perspectives. Extract data subsets, perform summary calculations, create interactive pivot charts and format reports. Go beyond the ChartWizardTM to create custom charts to visually represent your data. Understand chart types, and work with chart series. Prerequisite: Intermediate Excel.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section SUA-PD

52166
$149
8/1/17 - 8/3/17
Tue, Thu 1:00 PM - 4:30 PM
Rav Nicholson
CE South Building

Register Online for this Class

Get acquainted with the newest Microsoft Office suite, including Word, Excel and PowerPoint. Explore the basic navigation and functions of the current version of Office. Topics include changes from the last version, how to make the most of your transition to the new version, and tips and tricks to work with Office more efficiently and effectively. Prerequisite: Working knowledge of any version of Office.

Note: UNM Tuition Remission eligible under Professional Development.

Section SUB-PD

52021
$95
8/2/17
Wed 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section SUA-PD

52162
$249
8/2/17 - 8/9/17
Mon, Wed 6:00 PM - 9:00 PM
Sonja Dewing
CE South Building

Register Online for this Class

Start using the three basic applications for Microsoft Office: Word, Excel and PowerPoint. Topics include creating/revising documents, assembling and presenting slideshows, and building spreadsheets. Lessons are presented in bite-sized modules so you can apply what you've learned right away. Prerequisite: Basic computer experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section SUA-PD

52030
$195
8/8/17 - 8/10/17
Tue, Thu 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section SUA-PD

52163
$249
8/8/17 - 8/15/17
Tue, Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Solve difficult design issues with database design analysis. Using practical examples, identify database tasks, collect data needed to support tasks, and map the data to tables. Apply rules of table design, resulting in efficient tables that take full advantage of relational capabilities. Determine key fields and relationships, learn about normalization and solve complex ''many to many'' database relationships. Prerequisite: Access: Beginning or database experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section SUA-PD

52190
$295
8/21/17 - 8/25/17
Mon, Wed, Fri 1:00 PM - 4:00 PM
Rick Berg
CE South Building

Register Online for this Class

Become a PowerPoint power user. Create slides that include graphs, tables and organizational charts for easy communication. Develop multimedia content and customized slide shows that set your presentations apart. Save presentations in various formats. Students develop and deliver a PowerPoint presentation in class. Prerequisite: PowerPoint: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section SUA-PD

52242
$249
8/22/17 - 8/29/17
Tue, Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

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. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52161
$249
9/5/17 - 9/12/17
Tue, Thu 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

Get acquainted with the newest Microsoft Office suite, including Word, Excel and PowerPoint. Explore the basic navigation and functions of the current version of Office. Topics include changes from the last version, how to make the most of your transition to the new version, and tips and tricks to work with Office more efficiently and effectively. Prerequisite: Working knowledge of any version of Office.

Note: UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52021
$95
9/7/17
Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

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. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAB-PD

52161
$249
9/25/17 - 10/2/17
Mon, Wed 6:00 PM - 9:00 PM
Sonja Dewing
CE South Building

Register Online for this Class

Understand the basic concepts of database use and how to most effectively design your database using Microsoft Access. Design basic tables and add, edit, locate, sort, filter and delete data. Set field properties, work with input masks and set validation rules. Learn to design and apply queries and reports to make it easier to accomplish everyday database tasks. In addition, get an introduction to basic forms. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52181
$249
9/25/17 - 9/29/17
Mon, Wed, Fri 1:00 PM - 4:00 PM
Rick Berg
CE South Building

Register Online for this Class

Learn to create, edit, and save documents as well as format text, paragraphs, and documents using Microsoft Word. Learn effective navigation and selection techniques and work with tabs, indents, paragraph formatting and line spacing. Manage headers, footers, and margins. Use proofing and correcting features including find and replace text, AutoCorrect, and Spelling and Grammar Checker. Add graphics and clip art. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52141
$249
9/26/17 - 10/3/17
Tue, Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Get acquainted with the newest Microsoft Office suite, including Word, Excel and PowerPoint. Explore the basic navigation and functions of the current version of Office. Topics include changes from the last version, how to make the most of your transition to the new version, and tips and tricks to work with Office more efficiently and effectively. Prerequisite: Working knowledge of any version of Office.

Note: UNM Tuition Remission eligible under Professional Development.

Section FAB-PD

52021
$95
10/3/17
Tue 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

Go beyond the basics using queries to answer specific questions and develop summaries with Access. Create and enhance custom forms, a main form with sub-forms, and custom reports. In addition, learn how to identify and create relationships. Prerequisite: Access: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52182
$249
10/9/17 - 10/13/17
Mon, Wed, Fri 1:00 PM - 4:00 PM
Rick Berg
CE South Building

Register Online for this Class

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52162
$249
10/10/17 - 10/17/17
Tue, Thu 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

Use Word for more complex tasks. Learn to format text in multiple columns and work with the intricacies of tables and charts. Explore customized formatting options with styles and themes for a more professional look. Manage lists, customize your Word environment and insert content using Quick Parts. Prerequisite: Word: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52142
$249
10/17/17 - 10/24/17
Tue, Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Start using the three basic applications for Microsoft Office: Word, Excel and PowerPoint. Topics include creating/revising documents, assembling and presenting slideshows, and building spreadsheets. Lessons are presented in bite-sized modules so you can apply what you've learned right away. Prerequisite: Basic computer experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52030
$195
10/21/17
Sat 9:00 AM - 4:30 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Make the most out of Word! Learn how to better utilize images in a document, customize graphic elements, and better control text flow. Make Word do the work for you with mail merge, advanced use of templates and macros. Prerequisite: Intermediate Word.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52143
$249
10/30/17 - 11/6/17
Mon, Wed 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Use Excel Pivot Tables to efficiently extract meaningful information from large tables of data. Understand pivot table requirements and capabilities to view data from different perspectives. Extract data subsets, perform summary calculations, create interactive pivot charts and format reports. Go beyond the ChartWizardTM to create custom charts to visually represent your data. Understand chart types, and work with chart series. Prerequisite: Intermediate Excel.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52166
$149
11/7/17 - 11/9/17
Tue, Thu 1:00 PM - 4:30 PM
Rav Nicholson
CE South Building

Register Online for this Class

Create presentation materials using Microsoft PowerPoint. Learn to edit, format, proof and print presentations. Build and run slide shows with transition and multimedia elements. Use templates and themes to make your presentations visually interesting. Draw objects and use ClipArt and WordArt for dramatic effects. Prerequisite: Windows: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52241
$249
11/9/17 - 11/16/17
Tue, Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Make Access do more for you through advanced queries, including crosstabs and parameters. Learn to write SQL statements and attach SQL queries to controls. Create, run, and modify macros, attach macros to events, and create macros that will provide user interaction or data transfer. Import, export and link objects, and work with hyperlinked fields. Prerequisite: Access: Intermediate.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52183
$249
11/13/17 - 11/17/17
Mon, Wed, Fri 1:00 PM - 4:00 PM
Rick Berg
CE South Building

Register Online for this Class

Harness the power of Microsoft OneNote's electronic note-taking capabilities. Learn how to create virtual notebooks from handwritten or typed notes, drawings, screen clippings, audio and more. Capture thoughts, ideas and notes as you work in other applications. Prerequisite: Beginning Windows or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52035
$95
11/16/17
Thu 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

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.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52163
$249
11/28/17 - 12/5/17
Tue, Thu 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

Become a PowerPoint power user. Create slides that include graphs, tables and organizational charts for easy communication. Develop multimedia content and customized slide shows that set your presentations apart. Save presentations in various formats. Students develop and deliver a PowerPoint presentation in class. Prerequisite: PowerPoint: Beginning or equivalent experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52242
$249
11/28/17 - 12/5/17
Tue, Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Solve difficult design issues with database design analysis. Using practical examples, identify database tasks, collect data needed to support tasks, and map the data to tables. Apply rules of table design, resulting in efficient tables that take full advantage of relational capabilities. Determine key fields and relationships, learn about normalization and solve complex ''many to many'' database relationships. Prerequisite: Access: Beginning or database experience.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52190
$295
12/4/17 - 12/8/17
Mon, Wed, Fri 1:00 PM - 4:00 PM
Rick Berg
CE South Building

Register Online for this Class

Use your expertise in Access to plan and develop a database. Apply your knowledge of table design and table relationships, incorporating lookup fields to ensure consistency in data entry. Create user-friendly data input forms, design advanced queries and reports to extract data, and develop database navigation screens that include macro-supported controls. Prerequisite: Access: Advanced.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52184
$249
12/11/17 - 12/15/17
Mon, Wed, Fri 1:00 PM - 4:00 PM
Rick Berg
CE South Building

Register Online for this Class

Continue to build your expertise in Excel. Work with advanced formatting features, use lookup functions and explore array formulas to make your work more efficient. Create 1- and 2-variable tables. Import and export data as text files, use Goal Seek and Scenarios to analyze data, and run macros. In addition, start working with database functions and VBA code. Prerequisite: Excel: Advanced.

Note: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52164
$249
12/12/17 - 12/19/17
Tue, Thu 1:00 PM - 4:00 PM
Rav Nicholson
CE South Building

Register Online for this Class

Continue to improve your PowerPoint skills with new resources, advanced multimedia use and innovative design ideas. Learn how to make your presentations more visually effective with branded images and styles by recoloring images to match, finding images that you can use within the copyright laws, or using your own. Also, create a workflow map that will allow you to put together your presentations faster. Additional topics include adding tables and documents to your presentation. Prerequisite: 52242.

Note: This class uses version 2013. UNM Tuition Remission eligible under Professional Development.

Section FAA-PD

52243
$249
12/12/17 - 12/19/17
Tue, Thu 6:00 PM - 9:00 PM
Joseph Sandoval
CE South Building

Register Online for this Class

Related Classes & Certificate Areas


Tuition Assistance

Tuition Assistance may be available if you are unemployed, a veteran or veteran’s spouse, or a person with a disability. Other options include education loans. For more funding options, and contact information, please visit our Loans and Financial Aid page.


UNM Tuition Remission

UNM Staff, Faculty and Retirees: You may use your Tuition Remission for all Professional Development classes.

Learn more about UNM Tuition Remission