The Basics of Excel, Parts 1 and 2

October 23, 2017, 12:00pm to October 25, 2017, 2:00pm

Open To: Faculty, graduate students, staff, undergraduates

Description:

Part 1: October 23, 12:00 p.m. – 2:00 p.m.

Part 2: October 25, 12:00 p.m. – 2:00 p.m.

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

Please register separately for Part 1 and Part 2:
http://dlab.berkeley.edu/training/basics-excel-part-1-2
http://dlab.berkeley.edu/training/basics-excel-part-2-2

Registration

See event details for participation information.

Host

Event type

Topics