Excel 2013 - Using Formulas – use Excel to calculate and analyze data. We will cover: entering formulas in a variety of ways, using the insert function and formula bar, using the formula tab, absolute and relative cell references in copying formulas, using the fill handle to quickly copy formulas or patterns.
Excel 2013 - Charting/Graphing - use Excel to analyze and view data graphically via Excel's charting/graphing commands. We will cover the basics of creating a chart/graph and the ribbons (toolbars) used to modify them.
Excel 2013 - Advanced - Explore advanced Excel options such as Pivot Table and VLookup function. Prior experience with Excel needed.
Using Lynda - Free On-line Video Tutorials - this workshop will guide you through the process of using the training videos available from the Lynda website. PSU provides free access to Lynda for faculty, staff and students.
Mail Merge - using MS Word 2013& MS Excel 2013 - see how to use Mail Merge to create mailing labels and customized letters. Basic prior experience with Word & Excel needed.
PowerPoint 2013 Basics – use PowerPoint to make effective presentations. Learn the basics of creating a PowerPoint presentation including: adding slides, using text boxes, sorting slides, showing your presentation, alternate delivery methods, color schemes, design schemes, inserting clip art & photographs, printing and slide transitions. Download workshop handout (PDF)
Publisher 2013 Basics – use templates and included options to quickly create desktop publishing documents. We will illustrate Publisher capabilities by creating a flyer. Features such as: template selection; selecting color schemes; selecting font schemes; using text boxes; using clip art & photographs; grouping & ungrouping objects; inserting graphics & customer addresses; inserting tear-offs for contact information, coupons, order forms, response forms and sign-up forms will be covered. Download workshop handout (PDF)
Using Box.psu.edu – Free cloud storage - Box is a secure, cloud-based, commercial file storage, sharing, and collaboration service. Go to box.psu.edu and click on the “Login” button. The website will then walk you through the easy account creation process. There is no cost to the end user or department. Funding for Box at Penn State is provided by Information Technology Services. Each user will have unlimited storage space.
- AV Equipment & Services