IT offers technical training courses to Berkeley Lab employees in partnership with UC Berkeley. Click on the course titles below to learn more then register through the Berkeley Lab portal.
- Berkeley Lab staff may contact ittraining@lbl.gov for training feedback.
- For trouble registering for courses, Zoom links, etc. contact dlab-frontdesk@berkeley.edu.
- Visit it.lbl.gov/training for more IT learning and consulting opportunities.
Course Listing
Excel Data Analysis: Charts, Pivot Tables, and VLOOKUP
June 1, 2023, 9:30 a.m. – 12:30 p.m.
This three-hour workshop will cover charts in more detail, review pivot tables, and the widely-used VLOOKUP function. The introductory workshop Excel Data Analysis is recommended as a prerequisite. The full series runs again on June 21 and 22 (see below).
Python Fundamentals Pilot: Parts 1-3
June 13, 2023,15, 20, 11:00 a.m. – 1:00 p.m.
This three-part interactive workshop series is your complete introduction to programming Python for people with little or no previous programming experience. By the end of the series, you will be able to apply your knowledge of basic principles of programming and data manipulation to a real-world social science application.
Python Deep Learning: Parts 1-2
June 12, 14, 2023, 2:00 p.m. – 5:00 p.m.
The goal of this workshop is to build intuition for deep learning by building, training, and testing models in Python. Rather than a theory-centered approach, you will evaluate deep learning models through empirical results. You start with a review of what deep learning and neural networks are and how they work before jumping straight into Python, using the Keras library to build neural networks.
Python Data Wrangling and Manipulation with Pandas
June 21, 2023, 2:00 p.m. – 5:00 p.m.
Pandas is a Python package that provides fast, flexible, and expressive data structures designed to make working with ‘relational’ or ‘labeled’ data both easy and intuitive. It enables doing practical, real world data analysis in Python. In this workshop, you’ll work with example data and go through the various steps you might need to prepare data for analysis.
Python Text Analysis Fundamentals: Parts 1-2
June 20, 22, 2023, 9:00 a.m. – 12:00 p.m.
This two-part workshop series will prepare participants to move forward with research that uses text analysis, with a special focus on humanities and social science applications.
- Part 1: Preprocessing Text. In the first part of this workshop, you walk through possible steps to preprocess and tokenize data using tools from basic Python, NLTK, and spaCy in order.
- Part 2: Bag-of-words Representations. In this part of the workshop, you study one of the foundational numerical representation of text data: the bag-of-words model.
Python Web Scraping
June 26, 2023, 2:00 p.m. – 4:00 p.m.
In this workshop, you’ll learn how to scrape data from the web using Python. Web scraping involves downloading a webpage’s source code and sifting through the material to extract desired data. The course assumes a basic knowledge of Python.
Excel Data Analysis: Introduction
June 21, 2023, 9:30 a.m. – 12:30 p.m.
This is a three-hour introductory workshop that will provide an overview of Excel, with no prior experience assumed. Attendees will learn how to use functions for handling data and making calculations, how to build charts and pivot tables, and more.
Excel Data Analysis: Charts, Pivot Tables, and VLOOKUP
June 22, 2023, 9:30 a.m. – 12:30 p.m.
This three-hour workshop will cover charts in more detail, review pivot tables, and the widely-used VLOOKUP function. The introductory workshop Excel Data Analysis is recommended as a prerequisite.
in the bottom right or navigate to