University of Pittsburgh at Bradford
|
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. Tuesday, October 2; 6:00pm - 9:00pm at the St. Mary's Center $55.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 Excel I course. Monday, November 5; 5:00 pm - 9:00 pm at the St. Mary's Center $69 per participant; (14 days prior to class start) 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. Thursday, November 8; 5:30pm - 8:30pm at the St. Mary's Center $25.00 (14 days prior to class start) Cyber Security, Know Before it's Too Late Cybercrime is on the rise. Do you have the tools and knowledge to ensure you are being safe? Learn the tools and best defense to protect yourself against these attacks. Knowing just a few tips and tricks goes a long way to protect yourself and to feel safe in the digital world. The information presented in this course will benefit every single person who uses a computer, tablet, smartphone, or any other means to access the web. No one is 100% safe; however, there are tools and tips to learn to protect yourself in the ever-changing digital world. Thursday, November 15; 5:30pm - 8:30pm at the St. Mary's Center $29.00 (14 days prior to class start) Microsoft Word: Give me the BasicsNew 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. Tuesday, November 20, 5:30pm – 8:30pm $55 per participant (14 days prior to start) 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. Wednesday, January 30; 6:00pm - 9:00pm 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, February 27, 6:00pm - 9:00pm at the St. Marys Center $55.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. Wednesday, March 6; 6:00pm - 9:00pm at the St. Marys Center $55.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. Wednesday, March 13; 5:00pm - 9:00pm at the ST. Mary Center $75.00 (14 days prior to class start) 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, April 26; 1:00pm - 5:00pm at the St. Marys Center $75.00 (14 days prior to class start) Microsoft Word: Give me the BasicsNew 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. Tuesday, November 20, 5:30pm – 8:30pm $55 per participant (14 days prior to start) 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 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? TBA 6:00 pm - 9:00 pm at the St. Mary's Center $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) Microsoft 2013 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. TBA; 6:00 pm - 9:00 pm at the St. Mary's Center $55.00 (14 days prior to class start) Microsoft 2013 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 Excel I course. $69 per participant; (14 days prior to class start) TBA; 5:00 pm - 9:00 pm at the St. Mary's Center Microsoft 2013 Word 1 This course will cover basic Word. The course will provide an overview of the program. TBA; 6:00 pm - 9:00 pm at the St. Mary's Center $59.00 (14 days prior to class start) PowerPoint 2013 TBA $55 per participant (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 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. $69 per participant; (14 days prior to class start) TBA; 1:00 pm - 5: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 |
