Advanced Microsoft Excel-Beyond the Basics *ETF - Event Details

UH Hilo Home > News & Events

This event has concluded and is no longer current.

This event has concluded and is no longer current.

Advanced Microsoft Excel-Beyond the Basics *ETF

Location: UCB 105 (PC Lab)

Don’t waste your time on basic Excel 2016 skills that you already know. By assuming that you are already able to use Excel's basic features, this workshop will focus on advanced features and functionality of the software which include but are not limited to: Master dynamic tables using automatic, manual, qualified and unqualified structured table references Use advanced filters to apply complex logical criteria Use Excel's Subtotal feature to create both regular and nested subtotals Implement a hyperlink-based navigation system to allow users to easily navigate large workbooks Create beautiful interactive forms using checkbox, combo box, command button, text box and option button controls Record macros with both absolute and relative references Use slicers to allow touch-screen users to quickly filter Pivot Tables by multiple criteria Understand primary and foreign keys and use them to create both one-to-many and many-to-many relationships Understand OLAP pivot tables and use them to analyze data residing in a data model Use Get & Transform queries to extract, clean and combine data from Web Pages, Databases and Worksheets Use Get & Transform to create a de-normalized data extract from a multi-table relational database Required: Ability to operate a computer & basic Microsoft Excel experience. Who is Claire Akau: With 20+ years of experience, Claire's 3 career passions include Teaching/Training, Software and Accounting. She is also a Accounting instructor for the University of Hawaii at Hilo's College of Business and Economics.

Dates: Jul 24-Jul 28, M/W/F 4:30pm-6:30pm
Instructor: Claire Akau
Instructor Bio: With 20+ years of experience, Claire's 3 career passions include Teaching/Training, Software and Accounting. She is also a Accounting instructor for the University of Hawaii at Hilo's College of Business and Economics

Special Restrictions: Tuition: $85
Required: Ability to operate a computer & basic Microsoft Excel experience.

For more information, contact: CCECS@hawaii.edu (808) 932-7830

Tags: CCECS Workshop Non-Credit Community Advanced Microsoft Excel-Beyond the Basics Tech

What's also happening?

Week of July 23, 2017 calendar with events listings
Week of July 23, 2017Next →
SunMonTueWedThuFriSat

Video Production Class

Advanced Microsoft Excel-Beyond the Basics *ETF

Announcements

Rotary Peace Fellowship
Each year, Rotary awards two types of fellowships that fund some of the world’s most dedicated and brightest professionals to study at one of Rotary’s Peace Centers around the world. ...
Mindfulness Meditation w/Michael
Practicing Mindfulness offers ways to calm our mind and reduce stress, enabling us to enjoy life more fully. Hosted by Michael Donenfeld who has practiced meditation with and received training from Vietnamese poet and Monk, Thich Nhat Hanh.
2020-21 FAFSA Available October 1st
Effective October 1, 2019, students can complete their 2020-21 Free Application for Federal Student Aid (FAFSA) online at www.fafsa.gov. To receive priority consideration, complete your FAFSA by February 1, 2020. ...
Walk-in Wednesdays
Counseling services will now be offering 30 minutes walk-in sessions, every Wednesday from 1-4 pm. We know things happen and you may need to talk with someone immediately. This service is open to all UH Hilo students. ...

Disclaimer: The University of Hawaii at Hilo is not responsible for the contents, links and/or materials presented in any web site listed above that is not of the “hilo.hawaii.edu” or “.uhh.hawaii.edu” domains. All comments, complaints and grievances should be filed with the author, host and/or owner of said site.