Professional >> Business

« back to courses page
Develop successful, relevant skills that will translate to all aspects of the business world.
Please click on the course title to see the full course description.
 

 

 
Learn the basic skills and concepts needed to use Microsoft Access 2013 productively and efficiently. After an introduction to the Access 2013 environment, learn how to plan databases and create tables. Learn to organize fields and records, and to work with data entry rules. Create basic queries and work with forms and reports.   Prerequisite: Experience with Windows. Learning Objectives: Identify components of the Microsoft Office Access 2013 environment Identify the components of a database Organize data in tables Show data in a table Demonstrate how to Query a database Design forms Produce reports Note: No refunds on bundled prices.

182FMOF1603A

Start date: 11/10/17

End date: 11/10/17

Fee: $219.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  Not Assigned



View Details »
Learn additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. Learn to normalize data, join tables while observing referential integrity, and query multiple tables. Insert background images and charts and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.   Prerequisite: Access 2013 - Beginning. Learning Objectives: Demonstrate how to streamline data entry and maintain data integrity Show how to join tables to retrieve data from unrelated tables Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries Prepare customized reports to organize the displayed information Note: No refunds on bundled prices.

182FMOF1604A

Start date: 11/17/17

End date: 11/17/17

Fee: $219.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  Not Assigned



View Details »
Designed for those currently on a career track leading toward administrative office management, this course teaches current principles and concepts including information management, technology, communications office systems and administrative procedures.              The class will be broken down into four parts: Part I will introduce students to the basic management practices, opportunities and challenges in administrative office management. Part II will focus on the managing of human resources in an office. Part III will stress leadership, decision-making, and motivation skills in the business environment Part IV will cover managing essential administrative services that include office design, space, and health and safety issues.   Internet research projects, case studies and chapter quizzes will help develop skills in strategic planning, organization, and time management.     PREREQUISITE- Prerequisites:  High School Diploma or equivalency. Complete Skills Assessment and submit Program Application. Working knowledge of computers and access to computer and Internet is required.   Completion of the Administrative Professional Certificate program or 2 years of experience as an Administrative Professional is recommended. This course can help prepare you for IAAP’s Certification in Organizational Management.     

182PMLD4142A

Start date: 10/30/17

End date: 12/06/17

Fee: $1,249.00

10 sessions.

Location : KSU Center Location : 
  KSU Center.

Room :  Not Assigned



View Details »
This hands on course is designed to provide individuals with the necessary skills to enter a professional office as an effective and productive team member. This class will provide solid, practical, and up-to-date coverage of office topics, beginning with information regarding the changing and challenging office and goes on to introduce key topics, such as interpersonal skills; job search; communications; time management; telecommunications; mail; records management; Financial procedures; appointments; visitors; travel; meetings and conferences; presentations; and professionalism in the office environment. Students will leave with an overview of how they fit into the realm of an office environment in their role as an administrative professional. Classes will include lecture, hands on exercises, critical thinking skills and portfolio applications with an example of their work. Textbooks and a flash drive are required and are available at the KSU Center Bookstore. This course will help to prepare you for the Certified Administrative Professional (CAP) exam. Prerequisite: High School Diploma or equivalency. Complete Skills Assessment and Program Application. Computer and Internet access required. Working knowledge of computers is also required.   Application To apply for the Administrative Professional Certificate program, please complete the following steps online: Skills Assessment & Program Application are located online. Click for instructions. You will be directed to the program application after finishing the skills assessment.

181PMLD4140B

Start date: 08/12/17

End date: 09/23/17

Fee: $849.00

6 sessions.

Location : KSU Center Location : 
  KSU Center.

Room :  208



View Details »
Being an administrative assistant isn’t what it used to be. Over the years it has evolved into a more integral role encompassing all aspects of office operations. And it’s growing, too. By 2022, the Bureau of Labor Statistics projects employment for administrative assistants will increase by 15.7 percent. That’s an additional 308,000 positions. “Administrative assistants often find themselves wearing many hats and juggling tasks,” said Pam Moss, program manager for the Administrative Professional Certificate. “They’re often tasked with keeping track of budgets and ensuring all departments adhere to the funds they’ve been allocated. At times, they’re enlisted as project managers, a role which requires advanced organization and planning skills.” These are just some of the skills addressed in our Administrative Professional course. The certificate program covers professional writing, meeting and event planning, web conferencing, changing technology and business ethics. It also serves as a stepping stone for those who desire to take the Certified Administrative Professional exam.

181PMLD0110A

Start date: 08/03/17

End date: 08/03/17

Fee: $0.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  236



View Details »

Corporate Financial Planning & Analysis Professional arrow

Click to choose from multiple offerings

Corporate Financial Planning and Analysis Information Session arrow

Click to choose from multiple offerings

Build on skills acquired in Excel 2013 Intermediate by working with advanced functions and formulas, as well as lookup functions. Learn about data validation and advanced data filtering. Apply advanced chart formatting and create complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. Explore Excel’s analytical features, run and record macros, and discover VBA code.   Prerequisite: Excel 2013 - Intermediate Learning Objectives: Recognize advanced functions and formulas Set up lookups and data tables Use advanced data management and charting Create and work with PivotTables and PivotCharts Show how to Export and import data Use analytical tools Apply Macros and Visual Basic Recognize accessibility and language features

181FMOF1507A

Start date: 09/15/17

End date: 09/15/17

Fee: $219.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  208



View Details »
Learn the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets, and downloading templates. Learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. Move and copy data and formulas, work with ranges, rows, and columns. Learn how to use simple functions and formatting. Create charts and graphics.   Prerequisite: Experience with Windows Learning Objectives: Create an Excel workbook and navigate worksheets. Identify order of operations. Demonstrate how to move and copy data and formulas. Use SUM function; perform calculations. Apply formatting to a worksheet Create inserted charts and graphics Prepare workbook contents for printing. Note: No refunds on bundled prices.

181FMOF1503A

Start date: 08/25/17

End date: 08/25/17

Fee: $219.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  208



View Details »
Learn how to work with large and multiple worksheets in Microsoft Excel 2013. Learn advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. Create outlines and subtotals and apply cell names. Sort and filter data and create tables. Learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Audit and protect worksheets, then share and merge workbooks, and track changes.   Prerequisite: Excel 2013 - Beginning. Learning Objectives: Create and manage links between workbooks Use advanced formulas and formatting Organize worksheet and table data using various techniques Create and modify styles and themes; merge and split cells Demonstrate how to sort and filter data Apply sharing and auditing features Note: No refunds on bundled prices.

181FMOF1504A

Start date: 09/08/17

End date: 09/08/17

Fee: $219.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  208



View Details »