Skip links and go to content
Humboldt State University
Skip to main content

Courses in Microsoft Excel

Microsoft Excel Basics

With Joan Dvorak

Learn the basic tasks of Excel: worksheet layout and design; calculating with formulas and functions; creating charts that summarize and explain your information; and saving and printing worksheets and workbooks.

Create, name, and save workbooks; design worksheets that utilize relative and absolute formulas and insert functions such as Sum, Average, Max, Min and Count. Compare how chart types communicate different interpretations of data and use sorting, filtering and tables in Excel.

Come learn the basics or expand your knowledge with new tips and techniques.

date Tues., Sept. 12-Oct. 3 (4 sessions)

time 6-8 p.m.

fee $75

place Humboldt County Office of Education, Main Building, Madrone Room, 901 Myrtle Ave., Eureka

class # 46571: REGISTER ONLINE

 


Intermediate Excel

With Joan Dvorak

Go beyond the basic tasks in spreadsheet software and explore powerful tools available to an intermediate user of Microsoft Excel. Evaluate worksheet design; use features such as conditional formatting and file templates; practice options such as text to columns and remove duplicates to manipulate data; utilize Excel analysis tools such as Autofilter, PivotTables, and advanced formulas and functions.

Participants will analyze data lists by applying 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.

date Tues., Oct. 17-Nov. 7 (4 sessions)

time 6-8 p.m.

fee $75

place Humboldt County Office of Education, Main Building, Madrone Room, 901 Myrtle Ave., Eureka

class # 46572: REGISTER ONLINE

 

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 for more than 19 years.

Print Friendly Version of this pagePrint this webpageGet a PDF version of this webpageSave a PDF of this webpage