Loading Events

« All Events

Basics of Excel (Workshop 1 of 2) [D-Lab]

January 24 @ 1:00 pm - 3:00 pm

See organizers’ website for details and registration.

This class will cover the basics of Excel, from simple formulas (SUM, COUNTIF) to more complex Excel features like Macros and the Data Analysis ToolPak. By the end of both sections, students will be able to employ Excel skills to open source policy data sets. These skills are transferrable to any sector.

Topics Covered Will Include:

  • Basic Formulas
  • Absolute vs. Relative Referencing
  • Sort/Filter
  • Data Cleaning: concatenate, removing duplicates, text to columns, importing PDFs
  • Advanced formulas: countif, sumif,
  • Index
  • Pivot Tables
  • Pivot Charts
  • Macros
  • Analysis ToolPak
  • Goal Seek

Details

Date:
January 24
Time:
1:00 pm - 3:00 pm
Event Category:
Website:
http://dlab.berkeley.edu/training/basics-excel-part-1-13

Organizer

D-Lab

Venue

356 Barrows Hall
Barrows Hall
Berkeley, CA 94720 United States
+ Google Map
Website:
http://www.berkeley.edu/map?barrows