Lunch & Learn Webinar Series

    12:00 pm - 1:00 pm

     

    September 19, 2017 - Excel Intermediate Session I

     

    This first of two intermediate Excel sessions will focus on next level functions and their applications to business office and non-instructional office operations. Topics will include: the practical use of: minimum, maximum, countif, countifs, sumif and sumif functions, advanced data validation, and table sorting.

     


    November 29, 2017 - Excel Intermediate Session II
     
    In this second session, we will explore use of logical operators such as if and nested if statements. We will also look at the vlookup function as an alternative to nested statement and the use of ifblank and iferror for esthetics before entries are made. Business office and non-instructional department applications will be provided.
     

     

    January 16, 2018- Creating Highly Effective Presentations
     

    This session will explore strategies for creating effective presentations. While we will be using the platform of PowerPoint, the focus will be on design and in particular how to present complex financial data in a way that communicate key points.

     

     

    March 20, 2018- Practical Application of Google Forms
     

    This session will provide you with the tools that you will need to create surveys, internal requests inspection checklists and other operational applications. We will also look at how to summarize and port the data into google sheets and even excel for analysis.

     

     

      

    How Do I Participate? 

     Welcome to our webinar series. You get the best audio by phone using any of the numbers and access code. Do that first and I can help you with the log in. Also, check with your tech department to make sure join.me is not a blocked site. A headset is recommended if you want to do audio over the computer. Can't join us live - no worries the sessions will be recorded and links made available a few days afterwards. 

     Join the meeting: https://join.me/staffdevelopmentassociates 

    On a computer, use any browser. Nothing to download. 
    On a phone or tablet, launch the https://join.me/app and enter meeting code: staffdevelopmentassociates 

    Join the audio conference: 
    Dial a phone number and enter access code, or connect via internet. 

    By phone: 
    United States - Los Angeles, CA +1.213.226.1066 
    United States - New York, NY +1.646.307.1990 
    United States - Hartford, CT +1.860.970.0010 
    United States - Camden, DE +1.302.202.5900 
    United States - Tampa, FL +1.813.769.0500 
    United States - Washington, DC +1.202.602.1295 
    United States - San Francisco, CA +1.415.594.5500 
    United States - Atlanta, GA +1.404.400.8750 
    Access Code 438-042-744# 

     By computer via internet: 
    Join the meeting, click the phone icon and select 'Call via internet'. A small download might be required.