University of Pittsburgh at Bradford
|
Excel 3 2013 – Advanced Workshop
Increase your mastery of Excel with more complex functions such as nested IF statements, conditional IFs, IIF statement, transposing data, Lookups (VLookup, HLookup), data conversion to/from Access tables, financial functions, text operations, data validation, range names, and error checking. Friday, May 3; 1:00pm - 5:00pm at the St. Marys Center $75.00 (14 days prior to class start) Cyber Security, Tips for staying secure on the web and social media Have you ever had that annoying popup you weren’t sure was safe to click on or wondered if that deal of the day on your homepage was legitimate? Should you open that email? Is it safe to shop or bank online? With the ever-changing world of cyber security, do you know how secure you actually are? Wednesday, May 14; 5:30 pm - 8:30 pm at the St. Mary's Center $55.00 Computers? I Don’t Even Know How to Turn Mine on Computers are everywhere -- whether it’s a tablet, smartphone, laptop, desktop, or food ordering terminal at your local convenient store. It would be difficult to go one day without seeing or using one of these devices. Come learn basic skills that will create a solid foundation. This course is for persons who are very new to the digital world and have little to no knowledge about computers. You will learn basic terms, web browsing, email set up, basic navigation of the Windows operating system, how to create a backup, and much more. Later in the course, you will learn some security tips and tricks on how to stay safe and secure while using your computer. In this course, you will be presented information via a Power Point and you will have the option for open discussion on any computer topics you would like to discuss. Tuesday, May 21; 5:30pm - 9:30pm at the St. Mary's Center $39.00 (14 days prior to class start) Microsoft Excel 1 This course will cover basic Excel screen overview, understanding and developing formulas, basic functions (sum, average, max, min), absolute and relative cell referencing, basic formatting and working with worksheets (inserting, renaming, deleting) and worksheet layout. This will be a fun filled fast paced course. Wednesday, May 22, 6:00pm - 9:00pm at the St. Marys Center $59.00 (14 days prior to class start) Microsoft Excel 2 In this course you will learn more advanced functions (IF, COUNTIF, SUMIF, VLookup, HLookup, etc.), more complicated formulas such as 3D formulas, how to do list processing, pivot tables and charting. You should have previous Excel experience or have taken the Basic Excel course. Monday, June 3; 5:00pm - 9:00pm at the ST. Mary Center $75.00 (14 days prior to class start) Microsoft Word: Give me the Basics New to Microsoft Word, or does your new job description require you to have Microsoft word knowledge? Come learn the basics so you can become more familiar with the most popular word processing software. In this course you can expect to learn how to navigate through the software, perform basic functions like saving, opening, searching, formatting, copying, pasting, and much more. Wednesday, June 5, 5:30pm – 8:30pm $59 per participant (14 days prior to start) iPhone: Beyond the calls - Using an iPhone Effectively - $25 per participant; (14 days prior to class start) Wednesday, June 12; 12:00pm - 3:00 pm at the St. Mary's Center Past classes, if you see something you would like please call us at 781-3437 and we will work with the provider on getting it here in St. Mary's Basic Computer Knowledge 101 Ever wish you had someone to sit with you while using your computer in case you needed assistance navigating the system? This course will go over basic computer skills to get you comfortable with using your computer, such as browsing the web, setting up and using email, using files, keeping your computer clean from malware and viruses, making sure you back up your data, and much more. This course will start with the basics and end with open discussions as to what you want to learn about your computer. TBA 6:00 pm - 9:00 pm $55.00 Microsoft 2013 Word 1 This course will cover basic Word. The course will provide an overview of the program. TBA; 12:00 pm - 4:00 pm at the St. Mary's Center $69.00 (14 days prior to class start) Intro and Basics of the Apple iPad Apple’s iPad and iPad mini are popular tablets that have changed the way we use computers. This class will teach you the basics of using the iPad along with finding popular apps that meet your needs. You will need to bring your own iPad/iPad mini to this class. TBA $34.00 iPhone: Beyond the calls - Using an iPhone Effectively - $25 per participant; (14 days prior to class start) TBA; 6:00 pm - 9:00 pm at the St. Mary's Center Google Suite 101 - $25 per participant; (14 days prior to class start) TBA 6:00 pm - 9:00 pm at the St. Mary's Center Introduction to Computers - $45 per participant; (14 days prior to class start) TBA; 5:30 pm - 8:30 pm at the St. Mary's Center Cyber Seniors- $45 per participant; (14 days prior to class start) TBA; 5:30 pm - 8:30 pm at the St. Mary's Center Formatting a Professional Resume using Word Learn how to format a professional resume in Microsoft Word to help you look your best and stand out from the rest. Please be prepared to include your own notes as we build your resume. A flash drive would be helpful to save your work. $20.00 (14 days prior to class start) TBA; 9:30 am - 11:00 am at the St. Mary's Center Microsoft Word Tools and Charts Inserting Tools and Charts into your documents is just the beginning. We will discover the ways to format the tables and charts and make your documents more aesthetically pleasing. $20.00 (14 days prior to class start) TBA; 6:00pm - 7:30pm at the St. Mary's Center The Basics of Social Media Social media blends technology and social interactions and is an essential 21st century skill. This class will give overviews of Facebook, Twitter, Pinterest, Skype, E-mail, and Instagram. No materials/technology required to bring to this class. TBA; 6:00pm - 9:00pm at the St. Mary's Center $39.00 (14 days prior to class start) PowerPoint – Adding Style to Your PowerPoint Presentations This creative course will teach you how to add that “something special” to your next PowerPoint presentation. Instead of using the basic functions of this Microsoft application, add creativity by adding hyperlinks, pictures, music, video and much more. You will learn how to create engaging presentations to capture and keep the attention of your audience. TBA; 6:00pm - 9:00pm at the St. Marys Center $55.00 (14 days prior to class start) |
