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


Microsoft Office - Upcoming Classes

Class Name

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.

Section FAA‐PD

52241
$259
11/18/2019 - 11/25/2019
Mon, Wed 6:00 PM ‐ 9:00 PM
Joseph Sandoval
CE South Building

Learn More and Register

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.

Section FAA‐PD

52035
$129
11/19/2019 - 11/21/2019
Tue, Thu 1:00 PM ‐ 3:00 PM
Rav Nicholson
CE South Building

Learn More and 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.

Section FAB‐PD

52242
$259
11/27/2019 - 12/04/2019
Mon, Wed 6:00 PM ‐ 9:00 PM
Joseph Sandoval
CE South Building

Learn More and 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.

Section FAA‐PD

52243
$259
12/09/2019 - 12/16/2019
Mon, Wed 6:00 PM ‐ 9:00 PM
Joseph Sandoval
CE South Building

Learn More and Register

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.

51101 | TBA

Windows: Beginning

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

54101 | TBA

Mac OS X: Beginning

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

or basic computer familiarity

Required Courses (4)
Class Name

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.

52142 | TBA

Word: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52141 | TBA

Word: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52143 | TBA

Word: Advanced

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

51101 | TBA

Windows: Beginning

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

54101 | TBA

Mac OS X: Beginning

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

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.

52161 | TBA

Excel: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52162 | TBA

Excel: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52163 | TBA

Excel: Advanced

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52164 | TBA

Excel: Expert

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

51101 | TBA

Windows: Beginning

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

54101 | TBA

Mac OS X: Beginning

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

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.

52181 | TBA

Access: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52182 | TBA

Access: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52183 | TBA

Access: Advanced

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52184 | TBA

Access: Expert

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

51101 | TBA

Windows: Beginning

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

54101 | TBA

Mac OS X: Beginning

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

or basic computer familiarity

Required Courses (4)
Class Name

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.

52241 | $259

PowerPoint: Beginning - FAA‐PD

11/18/2019 - 11/25/2019
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Learn More and 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.

52242 | $259

PowerPoint: Intermediate - FAB‐PD

11/27/2019 - 12/04/2019
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Learn More and 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.

52243 | $259

PowerPoint: Advanced - FAA‐PD

12/09/2019 - 12/16/2019
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Learn More and 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.

55101 | TBA

Graphic Design I

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

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.

51101 | TBA

Windows: Beginning

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

54101 | TBA

Mac OS X: Beginning

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

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.

52161 | TBA

Excel: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52141 | TBA

Word: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

Choose 2:

Class Name

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.

52241 | $259

PowerPoint: Beginning - FAA‐PD

11/18/2019 - 11/25/2019
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Learn More and 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.

52162 | TBA

Excel: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52181 | TBA

Access: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52142 | TBA

Word: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

51101 | TBA

Windows: Beginning

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

54101 | TBA

Mac OS X: Beginning

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

or basic computer familiarity

Required Courses (10)
Class Name

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.

52241 | $259

PowerPoint: Beginning - FAA‐PD

11/18/2019 - 11/25/2019
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Learn More and 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.

52242 | $259

PowerPoint: Intermediate - FAB‐PD

11/27/2019 - 12/04/2019
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Learn More and 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.

52243 | $259

PowerPoint: Advanced - FAA‐PD

12/09/2019 - 12/16/2019
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Joseph Sandoval
CE South Building

Learn More and 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.

52161 | TBA

Excel: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52162 | TBA

Excel: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52181 | TBA

Access: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52182 | TBA

Access: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52163 | TBA

Excel: Advanced

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52142 | TBA

Word: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52141 | TBA

Word: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52183 | TBA

Access: Advanced

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52143 | TBA

Word: Advanced

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

51101 | TBA

Windows: Beginning

TBA

This class will be scheduled on a future date. Please check with the Computers/ IT Program Supervisor for more information.

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.

54101 | TBA

Mac OS X: Beginning

TBA

This class will be scheduled on a future date. Please check with the Digital Arts Program Supervisor for more information.

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.

52181 | TBA

Access: Beginning

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52182 | TBA

Access: Intermediate

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

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.

52183 | TBA

Access: Advanced

TBA

This class will be scheduled on a future date. Please check with the Business Skills Program Supervisor for more information.

Certificate Total: $996 for 36 hours


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.


UNMUNM Tuition Remission

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

Learn more about UNM Tuition Remission