52163 - Excel: Advanced
Course Overview
Learn the advanced features of Excel to simplify your work. Use logical, conditional, financial, date/time formulas and functions. Explore data validation rules, criteria tables, custom number formatting, array formulas, lookup functions, data tables, exporting and importing data, analytical tools, macros and visual basic.
Prerequisites
Excel: Beginning and Excel: Intermediate or equivalent knowledge.
Hardware: Continuous internet access, PC (Windows 8 or later), and microphone are required to attend the Live Online session. Webcam is recommended. Latest version of Google Chrome, Mozilla Firefox, or Microsoft Edge browsers are also recommended.
Software: Excel application should be downloaded prior to start date of course.
UNM Tuition Remission
UNM Staff, Faculty, and Retirees: This course is Tuition Remission eligible under Professional Development. For more information, visit the UNM Tuition Remission information page click here.
Rick Berg graduated college in 1972, then spent the next 6 years traveling around the world. He was a diver and journalist in Costa Rica, climbed in the Himalayas and Andes, and hitchhiked across the Sahara. He was the sixth person to do a solo canoe descent of the Amazon. He then returned to the U. S. to get a Ph.D. in economics from UC-Berkeley, but mostly to climb rocks in Yosemite. After that he spent 5 years at UC-Santa Cruz, twice being nominated as its outstanding teacher. But once again adventure called, so he built a sailboat and spent 9 years sailing it around the Pacific and Indian Oceans, stopping to teach economics at universities in New Zealand and Macau, but mostly windsurfing, diving, and climbing coconut trees. In 1995 he sold the boat and moved to New Mexico, where he started a successful software development company, DataWizards, specializing in database design for both web and desktop, and the creation of custom Excel spreadsheets.