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

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.

Section Spring 1

52181
$259
02/03/2020 - 02/07/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM
Rick Berg
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.

Section Spring 1

52161
$259
02/04/2020 - 02/11/2020
Tue, Thu 1:00 PM ‐ 4:00 PM
Rav Nicholson
CE South Building

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

Section Spring 1

52182
$259
02/10/2020 - 02/14/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM
Rick Berg
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.

Section Spring 2

52161
$259
02/17/2020 - 02/24/2020
Mon, Wed 6:00 PM ‐ 9:00 PM
Sonja Dewing
CE South Building

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

Section Spring 1

52183
$259
02/17/2020 - 02/21/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM
Rick Berg
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.

Section Spring 1

52162
$259
03/05/2020 - 03/12/2020
Tue, Thu 1:00 PM ‐ 4:00 PM
Rav Nicholson
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.

Section Spring 2

52162
$259
03/16/2020 - 03/23/2020
Mon, Wed 6:00 PM ‐ 9:00 PM
Sonja Dewing
CE South Building

Learn More and Register

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.

Section Spring 1

52030
$195
03/17/2020 - 03/19/2020
Tue, Thu 1:00 PM ‐ 4:00 PM
Rav Nicholson
CE South Building

Learn More and Register

Explore advanced features of Excel to work more efficiently. Use logical, conditional, financial, text, and date/time functions. Create data validation rules, apply advanced filters, and explore database functions. Work with advanced formatting features, array formulas, and lookup functions. Learn how to create one‐ and two‐variable data tables, import and export data, and use analytical tools. In addition, learn the basics of creating macros and VBA code. Prerequisite: Intermediate Excel.

Section Spring 1

52163
$345
03/24/2020 - 04/02/2020
Tue, Thu 1:00 PM ‐ 4:00 PM
Rav Nicholson
CE South Building

Learn More and Register

Use Excel Pivot Tables to efficiently extract meaningful information from large data sets. 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. Explore a wide range of chart types, and learn chart modification techniques. Prerequisite: Excel Intermediate.

Section Spring 1

52166
$195
04/28/2020 - 04/30/2020
Tue, Thu 1:00 PM ‐ 4:00 PM
Rav Nicholson
CE South Building

Learn More and Register

4 courses required to earn this certificate

Prerequisite Courses (As Needed)

Choose 1:

Class Name

GGet 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&utm_medium=course‐description&utm_campaign=da‐skills‐assessment. Prerequisite: 54010 or equivalent experience.

54101 | $269

Mac OS X: Beginning - Spring 1

04/08/2020 - 04/22/2020
Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Daniel Norton
CE South Building

Learn More and Register

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 | $269

Windows: Beginning - Spring 1

04/23/2020 - 04/30/2020
Tue, Thu 6:00 PM ‐ 9:00 PM (3 Session Total)
Bryan O'Neill
CE South Building

Learn More and Register

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

GGet 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&utm_medium=course‐description&utm_campaign=da‐skills‐assessment. Prerequisite: 54010 or equivalent experience.

54101 | $269

Mac OS X: Beginning - Spring 1

04/08/2020 - 04/22/2020
Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Daniel Norton
CE South Building

Learn More and Register

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 | $269

Windows: Beginning - Spring 1

04/23/2020 - 04/30/2020
Tue, Thu 6:00 PM ‐ 9:00 PM (3 Session Total)
Bryan O'Neill
CE South Building

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

52161 | $259

Excel: Beginning - Spring 1

02/04/2020 - 02/11/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Learn More and Register

Excel: Beginning - Spring 2

02/17/2020 - 02/24/2020
Mon, Wed 6:00 PM ‐ 9:00 PM(3 Session Total)
Sonja Dewing
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 | $259

Excel: Intermediate - Spring 1

03/05/2020 - 03/12/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Learn More and Register

Excel: Intermediate - Spring 2

03/16/2020 - 03/23/2020
Mon, Wed 6:00 PM ‐ 9:00 PM(3 Session Total)
Sonja Dewing
CE South Building

Learn More and Register

Explore advanced features of Excel to work more efficiently. Use logical, conditional, financial, text, and date/time functions. Create data validation rules, apply advanced filters, and explore database functions. Work with advanced formatting features, array formulas, and lookup functions. Learn how to create one‐ and two‐variable data tables, import and export data, and use analytical tools. In addition, learn the basics of creating macros and VBA code. Prerequisite: Intermediate Excel.

52163 | $345

Excel: Advanced - Spring 1

03/24/2020 - 04/02/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (4 Session Total)
Rav Nicholson
CE South Building

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

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

GGet 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&utm_medium=course‐description&utm_campaign=da‐skills‐assessment. Prerequisite: 54010 or equivalent experience.

54101 | $269

Mac OS X: Beginning - Spring 1

04/08/2020 - 04/22/2020
Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Daniel Norton
CE South Building

Learn More and Register

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 | $269

Windows: Beginning - Spring 1

04/23/2020 - 04/30/2020
Tue, Thu 6:00 PM ‐ 9:00 PM (3 Session Total)
Bryan O'Neill
CE South Building

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

52181 | $259

Access: Beginning - Spring 1

02/03/2020 - 02/07/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
CE South Building

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

52182 | $259

Access: Intermediate - Spring 1

02/10/2020 - 02/14/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
CE South Building

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

52183 | $259

Access: Advanced - Spring 1

02/17/2020 - 02/21/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
CE South Building

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

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

GGet 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&utm_medium=course‐description&utm_campaign=da‐skills‐assessment. Prerequisite: 54010 or equivalent experience.

54101 | $269

Mac OS X: Beginning - Spring 1

04/08/2020 - 04/22/2020
Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Daniel Norton
CE South Building

Learn More and Register

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 | $269

Windows: Beginning - Spring 1

04/23/2020 - 04/30/2020
Tue, Thu 6:00 PM ‐ 9:00 PM (3 Session Total)
Bryan O'Neill
CE South Building

Learn More and Register

or basic computer familiarity

Required Courses (4)
Class Name

Learn to create effective layouts 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; 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.

55101 | $269

Graphic Design I - Spring 2

03/19/2020 - 03/26/2020
Tue, Thu 6:00 PM ‐ 9:00 PM and Tue 6:00 PM ‐ 9:00 PM (3 Session Total)
Zac Van Note
CE South Building

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

52241 | TBA

PowerPoint: Beginning

TBA

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

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 | TBA

PowerPoint: Intermediate

TBA

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

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 | TBA

PowerPoint: 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

Prerequisite Courses (As Needed)

Choose 1:

Class Name

GGet 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&utm_medium=course‐description&utm_campaign=da‐skills‐assessment. Prerequisite: 54010 or equivalent experience.

54101 | $269

Mac OS X: Beginning - Spring 1

04/08/2020 - 04/22/2020
Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Daniel Norton
CE South Building

Learn More and Register

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 | $269

Windows: Beginning - Spring 1

04/23/2020 - 04/30/2020
Tue, Thu 6:00 PM ‐ 9:00 PM (3 Session Total)
Bryan O'Neill
CE South Building

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

52161 | $259

Excel: Beginning - Spring 1

02/04/2020 - 02/11/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Learn More and Register

Excel: Beginning - Spring 2

02/17/2020 - 02/24/2020
Mon, Wed 6:00 PM ‐ 9:00 PM(3 Session Total)
Sonja Dewing
CE South Building

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

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

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 | $259

Access: Beginning - Spring 1

02/03/2020 - 02/07/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
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 | $259

Excel: Intermediate - Spring 1

03/05/2020 - 03/12/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Learn More and Register

Excel: Intermediate - Spring 2

03/16/2020 - 03/23/2020
Mon, Wed 6:00 PM ‐ 9:00 PM(3 Session Total)
Sonja Dewing
CE South Building

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

52241 | TBA

PowerPoint: 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

GGet 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&utm_medium=course‐description&utm_campaign=da‐skills‐assessment. Prerequisite: 54010 or equivalent experience.

54101 | $269

Mac OS X: Beginning - Spring 1

04/08/2020 - 04/22/2020
Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Daniel Norton
CE South Building

Learn More and Register

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 | $269

Windows: Beginning - Spring 1

04/23/2020 - 04/30/2020
Tue, Thu 6:00 PM ‐ 9:00 PM (3 Session Total)
Bryan O'Neill
CE South Building

Learn More and Register

or basic computer familiarity

Required Courses (10)
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 | $259

Access: Beginning - Spring 1

02/03/2020 - 02/07/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
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 | $259

Excel: Beginning - Spring 1

02/04/2020 - 02/11/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

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

52182 | $259

Access: Intermediate - Spring 1

02/10/2020 - 02/14/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
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 | $259

Excel: Beginning - Spring 2

02/17/2020 - 02/24/2020
Mon, Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Sonja Dewing
CE South Building

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

52183 | $259

Access: Advanced - Spring 1

02/17/2020 - 02/21/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
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 | $259

Excel: Intermediate - Spring 1

03/05/2020 - 03/12/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (3 Session Total)
Rav Nicholson
CE South Building

Learn More and Register

Excel: Intermediate - Spring 2

03/16/2020 - 03/23/2020
Mon, Wed 6:00 PM ‐ 9:00 PM(3 Session Total)
Sonja Dewing
CE South Building

Learn More and Register

Explore advanced features of Excel to work more efficiently. Use logical, conditional, financial, text, and date/time functions. Create data validation rules, apply advanced filters, and explore database functions. Work with advanced formatting features, array formulas, and lookup functions. Learn how to create one‐ and two‐variable data tables, import and export data, and use analytical tools. In addition, learn the basics of creating macros and VBA code. Prerequisite: Intermediate Excel.

52163 | $345

Excel: Advanced - Spring 1

03/24/2020 - 04/02/2020
Tue, Thu 1:00 PM ‐ 4:00 PM (4 Session Total)
Rav Nicholson
CE South Building

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

52241 | TBA

PowerPoint: 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.

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 | TBA

PowerPoint: 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.

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 | TBA

PowerPoint: 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

GGet 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&utm_medium=course‐description&utm_campaign=da‐skills‐assessment. Prerequisite: 54010 or equivalent experience.

54101 | $269

Mac OS X: Beginning - Spring 1

04/08/2020 - 04/22/2020
Wed 6:00 PM ‐ 9:00 PM (3 Session Total)
Daniel Norton
CE South Building

Learn More and Register

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 | $269

Windows: Beginning - Spring 1

04/23/2020 - 04/30/2020
Tue, Thu 6:00 PM ‐ 9:00 PM (3 Session Total)
Bryan O'Neill
CE South Building

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

52181 | $259

Access: Beginning - Spring 1

02/03/2020 - 02/07/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
CE South Building

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

52182 | $259

Access: Intermediate - Spring 1

02/10/2020 - 02/14/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
CE South Building

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

52183 | $259

Access: Advanced - Spring 1

02/17/2020 - 02/21/2020
Mon, Wed, Fri 1:00 PM ‐ 4:00 PM (3 Session Total)
Rick Berg
CE South Building

Learn More and Register

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. UNM Staff, Faculty and Retirees: You may use your Tuition Remission for all Professional Development classes. Learn more about UNM Tuition Remission.