Improve your word processing skills and take advantage of all the great features the newest version of Microsoft Word has to offer. You will create, revise, and save documents for future use and also learn the interface, creating and using autocorrect entries, spell and grammar check, thesaurus, and find and replace features. In addition, you will insert and remove page breaks, adjust margins, change line spacing, set, modify and remove tabs, cut, copy, and paste text, and create a mail merge for letters, labels or envelopes. Price includes textbook.
Learn advanced word processing skills. You will work with tables creating, sorting, performing calculations, and adjusting properties, and also create and edit documents which include Word Art, clip art, drop caps, auto shapes, text boxes and other objects. Use your creative side as you format a newsletter trying out format changes using built-in and custom styles. Prerequisite: MS Word Part I. Price includes textbook.
Use Microsoft Excel to manage, display, and save numerical data. You will receive instruction on the newest Microsoft Excel interface, entering data into cells, viewing data, and printing out worksheets. We will also cover formatting numbers and text; using the format painter; inserting, deleting, and modifying rows and columns; creating and using formulas with fixed and relative referencing; creating and modifying charts. Price includes textbook.
Advance your skills even more! You will learn how to manage multipage worksheets; freezing headings and splitting worksheet windows; adding graphics to worksheets; creating, saving and using templates; locking and unlocking cells; applying worksheet protection by setting a password; attaching a digital signature; creating and managing multiple sheet workbooks; copying formatting between worksheets; using linked formulas; and so much more. Prerequisite: Working knowledge of Windows & MS Excel Part I. Price includes textbook.
Do you want to learn how to build more complicated formulas, use functions and combine them in powerful ways? Learn to troubleshoot formulas using the auditing tools, document the formulas that you create, and use named ranges and cells in your formulas to better understand the purpose of the formula. Prerequisite: Excel experience.
Our CPA instructors have been in the business of accounting for several years and feel QuickBooks will assist you into understanding the many different ways it can help your small business. This hands-on course will offer you background on accounting principles and financial statements so that you can make sure you are capturing the right data in QuickBooks. Some of the topics to be covered include: income statements, balance sheets, tracking sales, expenses, preparing bank reconciliations, managing accounts payable and accounts receivable. Price includes textbook. Please register one week prior to class start date to ensure book arrival.
Become a more confident user and discover everything that QuickBooks can do for you. Don't waste time through trial and error learning—master the fundamentals with our level II QuickBooks training course. If you want to reduce frustration and increase accuracy, then this class is for you! Discover the most accurate and efficient way to use QuickBooks, and if you've recently upgraded, learn the secrets to using the new features. Prerequisite: Quickbooks I. Price includes textbook. Please register one week prior to class start date.
Website, social media, email marketing, SEO...“oh my!” There is so much to learn and implement in marketing a business or organization globally. Do not fear! This course can teach you the ins and outs of what you should be doing right to attract customers to your website.
Take the entire series of the five following courses and save $16.
Create your own website in just four hours. Use WordPress software to build a customizable website for personal or business use. Bloggers, small business owners, and all types of companies use WordPress to manage and operate their website. WordPress makes it easy to customize and edit content quickly and easily without learning code.
Advance your creative skills with WordPress. Learn to set up plugins, configure widgets, set up custom menus, and customize your website template. You will also learn where to go for additional help. Must have taken Basic Website Design class or have experience with WordPress.
Cattaraugus County Campus - Olean
Let’s start selling online! Learn about ecommerce options such as Shopify, Big Commerce, and how to use a WordPress website as an online storefront. For many small businesses, there's no need to build an expensive online shop from the ground up. Learn ways to get your shop up quickly and easily with minimal upfront costs.
Have your website stand out from others by learning the techniques that will allow your it to gain a top spot within a search engine. You will learn SEO techniques such as: title tags, meta descriptions, keywords, quality content guidelines, user experience guidelines and analysis methods. SEO is a critical tool for businesses in the competitive online environment.
Explore how web analytics can help you gain a better understanding of your website and your visitors. Find out how many people visit your website, how they found it, pages they liked and didn't like. Web analytics can help you create a better user experience for your website's visitors and can help you track performance. Learn how to set up web analytics, use tracking codes, and analyze data.