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.

 

Call 319-296-4290 for course questions or email Business and Community Education. Please be prepared to provide the class ID.

Hawkeye Business and Community Education provides professional skill development for individuals and businesses. Browse a complete list of our courses or course series and if you do not see the type of course you are looking for contact us to learn more about designing customized training for your workforce.

Exploring Classes

Click on the course title to view the entire class description and class details.

Use the grey arrows to below to explore additional classes in this area.

 
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: 10/17/2017

Tuition: $397.00

View Details »
Data accuracy and consistency improves through the use of spreadsheets. Learn how to create, edit, and format spreadsheets with Excel. Learn basic formulas including relative and absolute references, select cells and ranges, modify columns and rows, print and preview worksheets and become more efficient with AutoFill and AutoComplete. Learn tips and tricks for Excel. Textbook is included.  

Start date: 10/17/17

End date: 10/19/17

Tuition $149.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114



View Details »
This course will help you improve your spreadsheets with advanced formatting. Learn to manage multiple worksheets and workbooks, insert headers and footers, create macros, sort data, and create charts. Relative and absolute formulas will also be reviewed. Save time and learn more options by mastering Excel with the easy tips and tricks you will receive from our experienced instructor! Textbook is included.  

Start date: 10/24/17

End date: 10/26/17

Tuition $149.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114



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

Start date: 10/31/17

End date: 11/02/17

Tuition $149.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114



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 48-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 4 texbooks and one MOS Exam for the software of your choice. You will leave this class with a set of skills that are in high demand.

Start date: 09/11/17

End date: 11/08/17

Tuition $1,099.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114



View Details »
Learn the fundamentals of QuickBooks to track the finances of your business. Learn the sales process, how to track revenue, manage expenses, reconcile bank transactions, set up files, customize forms, create reports and graphs, and much more. This class is taught on PC's, not Mac computers. Textbook is included.

Start date: 10/03/17

End date: 10/05/17

Tuition $159.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114



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, and complete year-end procedures. This class is taught on PC's not Mac computers. Textbook is included.

Start date: 10/10/17

End date: 10/10/17

Tuition $99.00

Location : Cedar Falls Center Location : 
  Cedar Falls Center.

Room :  114



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/07/17

End date: 09/01/17

Tuition $195.00

Location : Online



View Details »
A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence.

Start date: 06/05/17

End date: 09/01/17

Tuition $495.00

Location : Online



View Details »
Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level! This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do. Agenda Unit 1 - Organizing Worksheet and Table Data Introduction to tables Formatting tables using styles Using formulas in tables Sorting and Filtering table data Unit 2 - Understanding Popular Excel Functions Understanding Name Manager Applying business functions Creating functions that handle text Performing basic lookup functions Creating functions that work with dates and times Unit 3 - Improving Worksheet Appearance Formatting cells in worksheets Correcting common function errors Creating and using worksheet outlines Customizing Excel user interface Unit 4 - Analyzing Data Using Data Validation and Pivot Tables Understanding how to convert text to columns Understanding how to analyze spreadsheet data Understanding the basic pivot table layout and key terms Creating and formatting simple pivot tables

Start date: 10/02/17

End date: 10/27/17

Tuition $195.00

Location : Online



View Details »
QuickBooks is one of the most powerful tools you will use in managing your business. In addition to being a robust bookkeeping program, QuickBooks is a management tool. When set up and used properly, QuickBooks allows you to track and manage income, expenses, bank accounts, receivables, inventory, job costs, fixed assets, payables, loans, payroll, billable time, and equity in your company. It also provides you with detailed reports that are essential to making good business decisions. Throughout this course, you will learn in detail about the features in QuickBooks. This course can help you prepare to take the QuickBooks User Certification Exam. After passing the exam, you become an Intuit QuickBooks Certified User, which validates your QuickBooks knowledge. Details

Start Date: upon registration

Tuition $1,499.00

Location : Online

More information online at:  http://protrainedu.org/Lumens/Intuit-QuickBooks-2015/1206



View Details »
With Windows 10 just being released, students that can obtain these certifications will have a considerable advantage in the marketplace as companies start to migrate over to Microsoft's new OS. Microsoft is expecting to put Windows 10 on over a billion devices. Windows 10 contains many new features that have revolutionized Microsoft's platform. The start button is back, more security has been added, a new browser has been integrated and Microsoft has even added their voice based personal assistant, Cortana. This course is the Microsoft 70-697: Configuring Windows Devices for Windows 10. This course will cover topics such as Windows 10 deployment, OS management and device management, and many others. Details

Start Date: upon registration

Tuition $899.00



View Details »