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

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?

Announcements

Student Art Association Meetings
Aloha mai kākou! This is a friendly invitation from your Student Art Association to join us every Tuesday, at 12:30pm – 1pm for our weekly meeting. ...
Happy Holidays from Campus Center
Aloha Vulcan 'Ohana! The holiday season is near! Campus Center is all decked out and wants to show you our spectacular holiday spirit. We invite you to come and enjoy our festive holiday decorations. ...
Hohonu General Editor Applications Open
**Hohonu Academic Journal** is recruiting for General Editors who get to be part of the editing process by working one-on-one with students. ...
Kanilehua Layout Designer Position Open!
Kanilehua, UH Hiloʻs Art and Literary Magazine is seeking a motivated student with some experience in Adobe creative suites or other digital design programs to be a member of the Kanilehua team and produce a quality magazine. ...
Kanilehua Submission Deadline Extended!
Kanilehua is the UH Hilo Art & Literary Magazine, and we work to publish the best creative pieces our UH Hilo students have to offer. ...
Kanilehua Submission Raffle
Great news! If your work is accepted into Kanilehua Art and Literary Magazine, your name will be entered into a raffle and you could win a fabulous prize! Prizes will be different for writers and artists. ...
Student Art Association Meetings and Design Contest
Aloha mai kākou! This is a friendly invitation from your Student Art Association to join us every Tuesday from 12:30pm – 1pm for our weekly meeting. ...
APIA Scholarship
UH Hilo undergraduate students of Native Hawaiian, Pacific Islander, and Asian American backgrounds who are U.S. ...
2021-2022 Ka Lama Ku Student Recognition Awards - NOW OPEN!
The 2021 - 2022 Ka Lama Ku Student Leadership Award nominations are now open. Please submit your nominations no later than February 20, 2022, at 11:59 pm (This is a hard deadline, there will be no exceptions). ...
2022-23 UH Common Scholarship Application Available Oct 1st
Starting October 1, 2021, students can complete the 2022-23 UH System Common Scholarship Application online at www.hawaii.edu/tuition/scholarships/how-to-apply/. ...
RISO Registration for 2021-2022 is now open
The 2021-2022 academic year UH Hilo Registered Independent Student Organization (RISO) registration period is now open. The final day to register is March 25, 2022, at 4:30 pm. ...
2022-23 FAFSA Available October 1st
Starting October 1, 2021, students can complete their 2022-23 Free Application for Federal Student Aid (FAFSA) online at Studentaid.gov/fafsa To receive priority consideration at UH Hilo, complete your FAFSA by February 1, 2022. ...
Cultivating Pilina: Empowering Connection to End DV
Aloha! Please join us every Friday for the month of October to engage in courageous conversations around Domestic Violence, as we work collectively to keep our communities safe. ...

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.