Course at a Glance

Course:
Microsoft Office Intermediate Excel
Date:
February 26 to March 18
Location:
Humboldt County Office of Education, Main Building, Madrone Lab, Eureka
Cost:
$75

Microsoft Office Intermediate Excel

24594

With Joan Dvorak

Go beyond the basic tasks in spreadsheet software and explore powerful tools available to an intermediate user of Microsoft Excel, including conditional formatting, PivotTables, and advanced formulas and functions.

Participants will evaluate worksheet design; practice data manipulation options such as text to columns and remove duplicates; utilize Excel analysis tools such as Autofilter, sorting, filtering and subtotals.

As time permits, we will also discuss formulas and functions such as If, Countlf, SumIf, Vlookup, what-if analysis and data validation.

This Extended Education course has been suspended based on HSU guidelines regarding Novel Coronavirus (COVID-19).

The College of Extended Education & Global Engagement anticipates rescheduling the course to a later late.

Please e-mail Extended Education about your interest in the class to get notified of the rescheduling.

 

Joan Dvorak

Joan Dvorak has been teaching adult professional development classes in Excel for more than 14 years. Students from a wide variety of occupations such as education and training, health services, legal and protective services, construction, transportation, financial services, hospitality and tourism, wholesale or retail, arts and community service have benefited from learning Excel spreadsheet techniques. At Fortuna High School, Joan has helped teachers and students utilize Microsoft Office programs since 1998.