2017 Winter Catalog - Hastings Community Education Winter 2017 Catalog | Page 19

Technology Microsoft Excel: Getting Started Mike Reis Input data, add rows and columns, and do simple calcula ons in a spreadsheet. Excel can save you me! Learn how to: Enter informa on in to cells, Insert/delete rows and columns, Perform calcula ons, Automa cally sum a range of cells, Format a worksheet, Print a worksheet, Sort alphabe cally or numerically, Move and copy data, and Use online help. Prerequisite: Comfortable working with Windows 7. Bring your own laptop or use desktop unit with Office 2010 in the lab. MIKE REIS, is a Cer fied Microso Office Master and has been teaching for eight years. Min. 4/Max. 15 #51169B Mon Feb 13 6:30-8:30 pm Sr. High, #B211 $19-1 ses Microsoft Excel: Formatting Spreadsheets Mike Reis Learn how to: Format text using the Ribbon or Mini toolbar, Change the look of an en re workbook by applying a theme, Add borders & shading to cells, Change column width & row height, Adjust the posi on of contents within a cell, Make text display ver cally or at an angle, Format numbers with percent symbols, commas, and dollar signs, Add headers & footers to display when you print the worksheet. Prerequisite: Be comfortable with basic Excel. (Suggested: Excel 2010 Ge ng Started.) Bring your own laptop or use desktop unit with Office 2010 in the lab. Min. 4/Max. 15 #51169C Mon Feb 27 6:30-8:30 pm Sr. High, #B211 $19-1 ses Microsoft Excel: Functions & Formulas Mike Reis There are 300+ built-in Excel func ons to perform calcula ons in your spreadsheets! Learn how to: Create worksheets that update automa cally, Use cell references, Create and/or edit a formula, Use a built-in func on, Use the AutoSum bu on, Use ScreenTips to enter func on arguments, Copy formulas to other cells, Understand rela ve and absolute references, Create logical (if/then) statements, Use column headings in formulas. Prerequisite: Basic Excel. (Suggested: Excel 2010 Ge ng Started.) Bring your own laptop or use desktop unit. Min. 4/Max. 15 #51169D Mon Mar 6 6:30-8:30 pm Intro to QuickBooks 2017 Sr. High, #B211 $19-1 ses NEW online with ed2go Manage the financial aspects of your small business quickly and efficiently with this powerful accoun ng so ware designed especially for the small- to midsized-business owner who needs a fully func onal accoun ng system that’s also easy to use. Handson experience as you master the tools to set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create es mates; and generate reports. Classes begin: Jan 18, Feb 15, Mar 15 and more; $99 for online course. To register, go to: http://bit.ly/2gCiQui Computer Skills for the Workplace NEW online with ed2go Most jobs today require a working knowledge of certain computer skills. You will learn how to implement the powers of modern office so ware to work faster and more efficiently. We’ll focus on prac cal applica on for so ware most common to the workplace. When you finish this course, you will have learned why employers consider technological literacy so cri cal to the success of any organiza on. Classes begin: Jan 18, Feb 15, Mar 15 and more; $89 for online course. To register, go to: http://bit.ly/1JIUR9n 19