Go Back to All Webinars

Category Technical Skills

  • Cyber Security
  • This course is designed to provide useful and pertinent information related to information security in the utilities industry. It will cover basic practices and cost-effective tools that efficiently thwart information security breaches. It will also review high-level actions that need to occur in the event of an information security breach.

    Objectives:

    • Understand the risks involved with electronically stored data
    • Have a more structured and definitive understanding of information security
    • Have a high level knowledge of cost effective tools and practices to protect electronic information
    • Have a better understanding of how to react to information security breaches in a company environment
  • Digital Forensics, Protecting your IT Assesses from Outside Threats
  • This presentation outlines electronic data, how it is compromised and how to protect your business from both internal and external threats. It includes the concepts of intrusion, prevention, and reaction and how business should react in situations where data may be at risk.

  • Excel Series 1 – Excel Formulas & Functions
  • This course is designed to give participants a foundation for building better formulas and functions in Excel 2010.

    Objectives:

    • Understand the importance of relative, absolute, and mixed cell references
    • Review the fill handle and how it reacts to the different types of cell references
    • Building formulas
    • Understanding Excel functions
    • How to work with the Insert Function
  • Excel Series 2 – Using Pivot Tables to Extract the Information You Need
  • This course is designed to give participants the tools they need to take their Excel data and create PivotTables and PivotCharts in Excel 2010.
    Objectives:

    • What is the purpose of a pivot?
    • Understanding what type of Excel spreadsheets are good for pivoting.
    • Work with PivotTable Field List
    • Understanding Column and Row Labels
    • Using PivotTable report Filters
    • Using PivotTable Values and Modifying those Values
    • Working with PivotCharts
  • Excel Series 3 – The Key to Organizing and Summarizing Data
  • This course is designed to expose participants to the various tools and techniques available for organizing and summarizing data in Excel 2010.

    Objectives:

    • Review the types of data in Excel that can be organized and summarized
    • Using sort and custom sort effectively
    • Differences in sorting and filtering
    • Working with Outlines and its grouping and subtotaling features
    • Excel’s Consolidate feature
  • Excel Series 4 – Excel Charting and Graphics to Bring Out the Best In Your Information
  • This course is designed to teach participants the various methods of creating and manipulating charts and graphics in Excel 2010.
    Objectives:

    • Understanding the benefits of conditional formatting
    • How to use conditional formatting options of data bars, color scales, icon sets, highlighting, and top/bottom rules
    • Learn how to create your own conditional formatting rules.
    • Review of Sparklines and when are they best used
    • Review how data validation can assist you and your spreadsheet users
  • Excel Series 5 – Using Conditional Formulas and What-If Analysis
  • This course is designed to teach participants the various methods of creating and manipulating charts and graphics in Excel 2010.
    Objectives:

    • Understanding the benefits of conditional formatting
    • How to use conditional formatting options of data bars, color scales, icon sets, highlighting, and top/bottom rules
    • Learn how to create your own conditional formatting rules
    • Review of Sparklines and when are they best used
    • Review how data validation can assist you and your spreadsheet users
  • OneNote – What Can It Do For You?
  • If you know what OneNote is or if you’re not sure what it is, this session is for you. Come learn about OneNote and find out if you can utilize, or if you are utilizing, this piece of software to the fullest? OneNote has a lot of functionality that may be just the thing to help you organize and store those “what do I do with this?” bits of information.
    Objectives:

    • Increase the understanding of the power of Microsoft OneNote 2010 note taking and planning software
    • Learn how to capture text, image, video and audio notes
  • S.T.O.R.M. (Storm Tactical Operations Remediation Model) Part I
  • This two part webinar is forged from real world storms experienced over a 35 year career in the utility industry. This program will prepare you to respond to the worst case scenarios. S.T.O.R.M. is an ongoing process that keeps your organization ready at all times.
    Objectives:

  • Gain the tools and organization skills to prepare for the worst
  • Protect your people and assets
  • Discover what you have to deal with
  • Look at unique ways to approach and old problem
  • Learn to deal with lodging, feeding, and serving the forces that will restore your system
  • Get you prepared, surviving the storm, and assessing what you really have
  • S.T.O.R.M. (Storm Tactical Operations Remediation Model) Part II
  • This two part webinar is forged from real world storms experienced over a 35 year career in the utility industry. This program will prepare you to respond to the worst case scenarios. S.T.O.R.M. is an ongoing process that keeps your organization ready at all times.

    Objectives:

    • Gain the tools and organization skills to prepare for the worst
    • Learn to protect your people and assets, as well as know what you have to deal with
    • Look at unique ways to approach and old problem
    • Bring you to restoration, clean-up, and debriefing
  • Useful Excel 2007 Tips
  • This session is designed to help participants work more efficiently in Microsoft Excel 2007.

    Objectives:

  • Awareness of Microsoft Excel features participants may not be utilizing
  • Provide quick tips that are available for use in Microsoft Excel
  • Improve their abilities while utilizing features within Microsoft Excel 2007
  • Course Outline:

  • Make the Quick Access Toolbar work for you
  • Special features within comments
  • Quick formatting features
  • Viewing multiple areas
  • Tips for Autofill and Autocorrect
  • Let Conditional Formatting do the work
  • Warning and Value of Grouping
  • Using 3-Dimensional formulas
  • If you can press this key, you can create a chart