Training and Awareness

Overview

Berkeley Lab provides a number of services to help you better understand and use our IT services, as well as improve your skills with computer applications.

Training

Calendar: Our IT calendar provides information on all scheduled training opportunities.

Offsite Computer Training: The Berkeley Lab Institute facilitates training with a number of local vendors.

Online Computer Training: BLI facilitates access to SkillSoft online learning courses.

Awareness

IT is happy to provide customized seminars or training sessions for your needs for virtually any sized group at LBL. Just drop us a line at it-communications@lbl.gov

Our flagship presentation is "IT Support for Science" a 45-minute overview of our service portfolio designed for research staff which includes interactive demos of the latest features in our collaboration apps.

We offer Google training to groups of any size, customized for various technical levels and interests (more administrative, more scientific collaboration oriented, etc).

Finally, we will customize training/awareness activities for virtually any purpose - just drop us a line at the email above.

Upcoming Training Schedule

The IT Division is offering a series of training opportunities over the next few months in computer programming and desktop training. There is no charge for these courses, which are supported as part of IT's commitment to help researchers and operations staff collaborate and compute more effectively.

The schedule and course descriptions are listed below:
 

Course Title

Course Description

Date

Time

Location

EXCEL
Intro to Data Analysis with Microsoft Excel

Microsoft Excel includes several tools that allow one to analyze large mounts of data...

Master the use of these tools and you change the way you do business. Making sense of you data is essential in making key decisions for your organization. This course will teach you how to use some of the tools built into Excel that enable you to mine the answers hidden in your data records and unlock the analysis power of Excel.

  • Converting lists of records into tables
  • Sorting and filtering records
  • Using Summary Based IFS functions
  • Building and working with Pivot Tables
  • Creating Pivot Charts
  • Inserting Sparklines
  • Applying Conditional Formatting

Sorry...this class is full. If you would like to be added to the waitlist, please contact:
Erin Scharfstein @ ecscharfstein@lbl.gov

*please note maximum capacity in the training room is 15 people. Any attendees over the limit will be waitlisted and contacted when and if a seat becomes available.

06/28/20179:00am-12:00pm90-026
Presenting Financials: Make Numbers and Statistics Standout with Excel and PPT 2013

This course is designed for individuals who want to combine the data analysis tools of Microsoft Excel with the presentation capabilities of Microsoft PowerPoint. You will learn how to uncover the key values for your business, turn those values into well designed, user friendly charts, and incorporate those charts into a professional PowerPoint Presentation.

Topics will include:

  • Getting to the right data with:
    • Automatic Subtotals
    • Pivot Tables
    • Creating Pivot Charts
  • What chart works best for your data?
  • Best Practices for creating Charts
  • Using Themes and Styles to format Charts effectively
  • Sparklines and Conditional Formatting for Presenting data from a table
  • Best Practices for Presentations
  • Imbedding and Linking charts n PowerPoint
  • Animating charts in PowerPoint

Sorry...this class is full. If you would like to be added to the waitlist, please contact:
Erin Scharfstein @ ecscharfstein@lbl.gov

 *please note maximum capacity in the training room is 15 people. Any attendees over the limit will be waitlisted and contacted when and if a seat becomes available.

06/28/2017 1:00pm-4:00pm 90-026 
SMARTSHEET
Project Management with Smartsheet

Effectively managing projects is important to every business. This course provides project management beginners with everything they need to know to plan and track projects. If you have never used project software or want to start using Smartsheet to manage projects, this course is for you.

  • Intro to Project Management
  • What Makes a Great Project Manager?
  • Project Vocabulary
  • Goals vs. Deliverables
  • Project Process Groups
  • PMI (Introduction)
  • Project Management Methodology
  • How to Create a Project Plan
  • Interface
  • Importing a File
  • Working in a Document
  • Attachments in a Sheet
  • Discussions
  • Reminders
  • Sharing
  • Update Requests
  • Notifications
  • Smartsheet Toolbar
  • Home Tab
  • Account Administration
  • Workspaces
  • Dashboards

https://sites.google.com/lbl.gov/ittrainingcs/ 

*please note maximum capacity in the training room is 15 people. Any attendees over the limit will be waitlisted and contacted when and if a seat becomes available.

 07/12/20179:00am-4:00pm  90-026
POWERPOINT
PowerPoint Psychology: The Do's and Don'ts of Content and Planning for Success
(Mod 1) 

Lots of people make PowerPoint presentations, and lots of people make really bad presentations. In this course, you will learn (and put into practice) psychology-based PowerPoint strategies and techniques, well beyond the normal ones you may have heard. This is the class that everyone needs. It's not just about using PowerPoint, it's about using it well! Armed with this information, your PowerPoint presentations will be the envy of the office.

  • Storytelling for PowerPoint
  • Reporting Effectively
  • Avoiding BORING PowerPoints
  • Common mistakes and why well intentioned people make them time and again
  • Avoiding Reading Slides Out Loud
  • Data Heavy Slides
  • Identifying and Presenting to Your Audience
  • Using the Presenter View
  • Humor and animation - when it helps (and when it hurts)
  • How to not overload your users
  • Using PowerPoint to increase retention
  • How Much is Too Much. Make Content Decisions

Sorry...this class is full. If you would like to be added to the waitlist, please contact:
Erin Scharfstein @ ecscharfstein@lbl.gov

*please note maximum capacity in the training room is 15 people. Any attendees over the limit will be waitlisted and contacted when and if a seat becomes available.

 08/02/20179:00am-12:00pm 90-026 
PowerPoint Psychology: The Creating Clean & Easy Slides
(Mod 2) 

 Lots of people make PowerPoint presentations, and lots of people make really bad presentations. In this course, you will learn (and put into practice) psychology-based PowerPoint strategies and techniques, well beyond the normal ones you may have heard. This is the class that everyone needs. It's not just about using PowerPoint, it's about using it well! Armed with this information, your PowerPoint presentations will be the envy of the office.

  • Using PowerPoint as written document
  • Font Choices: Size Matters
  • Create "Clean" Designs
  • 3 Useful Graphic Design Rules
  • How to Make Sure your Slides are not Overloaded
  • Creating CLEAN slides
  • Creating Slides our Brains Naturally Understand
  • Design tips and tricks for non-designers –easy things anyone can learn
  • Tips for Imagery
  • Build and share a real presentation

Sorry...this class is full. If you would like to be added to the waitlist, please contact:
Erin Scharfstein @ ecscharfstein@lbl.gov

*please note maximum capacity in the training room is 15 people. Any attendees over the limit will be waitlisted and contacted when and if a seat becomes available.

 08/02/20171:00pm-4:00pm 90-026 

 

Adaptavist ThemeBuilder EngineAtlassian Confluence