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

GOOGLE CLASSES

Intro to Google Forms

Need an online form? Google Forms should be the solution that you consider. It's easy and fast for collecting input from colleagues. The responses are instantly collected in a Google Sheet, where data can be analyzed. In this class, you will learn how to set up a Google Form in minutes. If you bring a laptop or smart device, you will create your own Google Form in class.

*Please bring an optional laptop or smart device.

To register for the course:

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

04/26/2017

2:00pm-3:00pm

50B-4205

EXCEL
Excel Essentials & Intro to Formulas and Functions (Mod 1)

This class is designed to create a strong foundation for using the world's most popular business software as a place to organize and analyze information. Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of basic formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet.

  • Introduction to the Excel 2013 Interface (The Ribbon, The Backstage View & The Quick Access Toolbar)
  • Zooming in and out of a worksheet
  • Navigating and selecting cells
  • Keyboard Shortcuts
  • Entering and editing data
  • Deleting/replacing cell data
  • Performing simple calculations
  • Saving the workbook file
  • Checking compatibility with older versions of Excel
  • Overview of the Formulas Ribbon
  • Building basic Formulas
  • Using simple Functions
  • Copying formulas/functions with the AutoFill command
  • Using Relative and Absolute cell references in calculations

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.

 05/03/20179:00am-12:00pm 90-026 
Formatting Spreadsheet Design, Page Setup & Printing
(Mod 2) 

This class is designed to create a strong foundation for using the world's most popular business software as a place to organize and analyze information. Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of basic formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet.

  • Inserting rows & columns
  • Moving, copying, and pasting data
  • Using AutoFill to complete a series of values
  • Introduction to worksheet Themes
  • Formatting worksheet data/using Cell Styles
  • Using Excel templates/creating custom templates
  • Managing worksheets: inserting, deleting, renaming, move/copy
  • Grouping worksheets
  • Freezing or splitting panes
  • Grouping and Hiding Rows/Columns
  • Creating custom views
  • Spell checking your worksheets
  • Setting print options through Page Setup
  • Using the Page Layout view
  • Using the Full Screen view
  • Printing your worksheet

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.

 05/03/20171:00pm-4:00pm 90-026
List/Table Essentials & Charting
(Mod 3) 

This intermediate class focuses on how to import, organize, explore, and control the information you have in Excel. Participants will master data management tools like sorting & filtering, as well as powerful data exploration tools like charts & pivot tables. In addition, you will discover new ways to control your information and avoid error, including how to create dropdown menus or lock a cell for editing. This course is designed for everyone looking to work with large sets of data in the most efficient and impactful way possible.

  • Overview of List design
  • Formatting lists as Tables
  • Using the Flash Fill option
  • Single and Multi-level Sorting
  • Removing duplicates from a list or table
  • Filtering records in a list or table
  • Search by Filter
  • Inserting automatic subtotals in a list
  • Inserting data charts
  • Using the Quick Analysis Tools
  • Formatting and editing chart elements
  • Adding/removing data from a chart
  • Creating custom chart templates
  • Printing charts
  • Changing table and chart formatting through Themes --Inserting Sparkline

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.

05/24/20179:00am-12:00pm90-026
Importing Data, Pivot Tables, Protecting & Linking Data
(Mod 4) 

This intermediate class focuses on how to import, organize, explore, and control the information you have in Excel. Participants will master data management tools like sorting & filtering, as well as powerful data exploration tools like charts & pivot tables. In addition, you will discover new ways to control your information and avoid error, including how to create dropdown menus or lock a cell for editing. This course is designed for everyone looking to work with large sets of data in the most efficient and impactful way possible.

  • Importing data from other sources
  • Overview of exporting options
  • Creating a database query
  • Creating Pivot Tables from lists or tables
  • Filtering Pivot Tables
  • Using the Slicer tool within a Pivot TableWorking with Pivot charts
  • Applying Data Validation rules
  • Applying built in Conditional Formatting
  • Creating custom conditional formats
  • Inserting & Editing Comments
  • Linking Data
  • Cell, sheet, and file protection

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.

05/24/2017 1:00pm-4:00pm 90-026 
Creating Advanced Functions
(Mod 5) 

Many of the most powerful functions in Excel are not designed intuitively, and there are many hidden data analysis tools capable of discovering the key values that change bottom lines. Through this course, participants will master how and when to use all of them. The final module focuses on macros, or customized multi-step automation, a tool that regularly turns hour long tasks into a single click of the mouse.

  • Creating and applying names in a worksheet
  • Using the IF function
  • Introduction to nesting functions
  • Using the formula auditing tools
  • Using the LOOKUP functions
  • Using SUMIF(S), COUNTIF(S), AVERAGEIF(S) functions
  • Using the IFERROR function
  • Other useful functions (Database, Text and Date functions - time permitting)

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/07/20179:00am-11:00am 90-026 

Using the "What if" Analysis Tools & Recording Macros

(Mod 6)

Many of the most powerful functions in Excel are not designed intuitively, and there are many hidden data analysis tools capable of discovering the key values that change bottom lines. Through this course, participants will master how and when to use all of them. The final module focuses on macros, or customized multi-step automation, a tool that regularly turns hour long tasks into a single click of the mouse.

  • Using the Consolidate Data commands
  • Using the Goal Seek and Solver tools
  • Creating Data Tables
  • Using the Scenario Manager
  • Adding the Developer Tab to the Ribbon
  • Recording and runing macros
  • Editing macros with the Visual Basic Editor
  • Creating buttons to run macros (Quick Access Toolbar & worksheet buttons)
  • Microsoft SkyDrive Overview
  • Customizing the Ribbon

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/07/20171:00pm-4:00pm 90-026 
Excel for Science

This special class will cover Database Management, pivot tables, advanced formulas, an intro to Visual Basic, and other useful features.

Database Management & Pivot Tables

  • List design
  • Sorting and filtering
  • Subtotals
  • Pivot tables
  • Advanced functions in pivot tables
  • Data validation
  • LOOKUP functions
  • Database functions

Advanced Formulas & Intro to VBA

  • Relative vs absolute
  • Linking names
  • IF functions
  • Nesting functions
  • Formula auditing tools
  • Macros
  • User-defined functions

Agenda Scientists and Engineers

  • Freeze and split screens
  • Custom formatting
  • Count functions
  • Named ranges
  • Max/min functions
  • Standard deviation function
  • Variance, median, mode functions
  • CountIF functions
  • SumIf functions
  • Data validation
  • Conditional formatting
  • X-Y scatter charts
  • Array functions/trend function/growth function
  • Goal seek
  • Custom views
  • Solver
  • Linking workbooks/worksheets 

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.

06/21/20179:00am-4:00pm90-026
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

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.

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

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.

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