Skip to main content

Computers & Technology >> Office Productivity
« back to courses page

Maximize your office productivity and performance by learning the latest software. Instructors offer hands-on learning and you'll gain experience with many popular office software programs.

Hawkeye Business and Community Education provides professional skill development for individuals and businesses. Cutting-edge, rigorous and relevant career and technical education (CTE) prepares youth and adults for a wide range of high-wage, high-skill, high-demand careers . Browse a complete list of our courses or course series and if you do not see the type of course you are looking for suggest a course or contact us to learn more about designing customized training for your workforce.

 
Save $50 by registering for the series! Demonstrate that you have advanced skills in Microsoft Excel 2016 by completing a Microsoft Excel Series including Excel Level 1, Level 2 and Level 3! Learn how to enter data, work with numbers, edit worksheets, and change the appearance of worksheets. Acquire the ability to work with formulas and functions, format cell contents, create and edit charts, manage multi-sheet workbooks, and apply advanced functions and data analysis. You will also learn to create tables and outlines, utilize graphics and templates, use lookup functions, pivot tables, macros, advanced formatting and analysis tools, and how to collaborate and share workbooks in Excel. Three textbooks are included.

Start date: 09/18/2018

Tuition: $397.00

View Details »
Google offers a strong line-up of free tools that will help you collaborate with others and be more efficient. This course provides an overview of the Google Suite of tools and their capabilities so you can incorporate them into your day-to-day life. Learn how to use Gmail, calendar, Google Drive, Google Docs, Google Sheets, and Google Slides and discover how they integrate with Microsoft Office. Gain tips and techniques to streamline your Gmail inbox and settings. Learn how to share and organize documents and folders in Google Drive and much more.  

Start date: 10/23/18

End date: 10/25/18

Tuition $99.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114-Computer Lab



View Details »
Improve data accuracy and consistency through the use of spreadsheets. Learn how to create, edit, and format spreadsheets with Excel. Discover basic formulas including relative and absolute references, how to search for and replace data, modify columns and rows, and become more efficient with AutoFill and AutoComplete. Textbook is included along with lifetime access to a virtual lab.  

Start date: 09/18/18

End date: 09/27/18

Tuition $149.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114-Computer Lab



View Details »
Take your Excel skills to the next level and improve your spreadsheets with conditional formatting. Learn to work with functions, sort and filter data, analyze data, create tables, charts and pivot tables.  Save time and learn more options with easy tips and tricks you will receive from our experienced instructor! Textbook is included along with lifetime access to a virtual lab.  

Start date: 10/09/18

End date: 10/18/18

Tuition $149.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114-Computer Lab



View Details »
Set yourself apart by learning advanced features of Microsoft Excel. In this course you will create tables and filters, generate pivot tables and pivot charts, use financial functions and data analysis, apply advanced functions, work with formatting and analysis tools, and much more. Textbook is included.  

Start date: 06/18/18

End date: 06/20/18

Tuition $149.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114-Computer Lab



View Details »
Set yourself apart by learning the advanced features of Microsoft Excel. Learn to work with multiple worksheets and workbooks, use lookup functions and formula auditing, automate workbook functionality, and create sparklines and map data. Receive an Excel Specialist Certificate by completing all three levels. Textbook is included along with lifetime access to a virtual lab.  

Start date: 10/30/18

End date: 11/08/18

Tuition $149.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114-Computer Lab



View Details »
Advance your everyday proficiency of Microsoft Office 2016 Suite, the most common software tool in the world, and earn the credential that proves it!  This 57-hour certificate program is for those with basic computer skills to prepare you to become a certified Microsoft Office Specialist (MOS). This industry recognized credential will demonstrate to employers that you have the computer skills and competencies required to be successful as an administrative professional. This course will enable you to increase your skills and competencies in each of the Microsoft Office Suite software: Word, Access, Excel, PowerPoint and Outlook.  Hands-on tasks are built in to each class to practice what you learn. Final class projects are designed to help you prepare for MOS Core certification. Tuition includes four texbooks, one practice test, and one MOS Exam retake voucher for the software of your choice. You will leave this class with a set of skills that are in high demand.

Start date: 09/17/18

End date: 11/26/18

Tuition $1,099.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114-Computer Lab



View Details »
Learn the fundamentals of QuickBooks to manage your accounting needs. You will learn how to set up a company, how to record income and expenses, manage accounts receivable and accounts payable, reconcile bank transactions, create reports and graphs, and much more. This class is taught on PC's, not Mac computers, and is not QuickBooks Online. Textbook is included.  

Start date: 10/17/18

End date: 10/29/18

Tuition $199.00

Location : Main Campus - Buchanan Hall Location : 
  Main Campus - Buchanan Hall.

Room :  114 Computer



View Details »
Expand your knowledge of QuickBooks. In this class you will learn how to set up inventory, track and pay sales tax, handle payroll, create estimates and sales orders, budget, make adjustments, complete year-end procedures and utilize the audit trail. This class is taught on PC's, not Mac computers and is not QuickBooks Online. Textbook is included.  

Start date: 07/09/18

End date: 07/18/18

Tuition $199.00

Location : Main Campus - Buchanan Hall Location : 
  Main Campus - Buchanan Hall.

Room :  114 Computer



View Details »
Expand your knowledge of QuickBooks. In this class you will learn how to set up inventory, track and pay sales tax, handle payroll, create estimates and sales orders, budget, make adjustments, complete year-end procedures and utilize the audit trail. This class is taught on PC's, not Mac computers and is not QuickBooks Online. Textbook is included.  

Start date: 11/12/18

End date: 11/19/18

Tuition $199.00

Location : Main Campus - Buchanan Hall Location : 
  Main Campus - Buchanan Hall.

Room :  114 Computer



View Details »
We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence. Agenda Unit 1 - Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2 - Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3 - Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4 - Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data

Start date: 08/06/18

End date: 08/31/18

Tuition $195.00

Location : Online



View Details »
We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence. Agenda Unit 1 - Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2 - Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3 - Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4 - Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data

Start date: 11/05/18

End date: 11/30/18

Tuition $195.00

Location : Online



View Details »