Skip to main content

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.

192FMOF1603A

Start date: 10/19/18

End date: 10/19/18

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.

192FMOF1604A

Start date: 10/26/18

End date: 10/26/18

Fee: $219.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  Not Assigned



View Details »
With the need for financial planning services at an all-time high, individuals are looking to secure their financial future and they need a professional, competent advisor to get there. This Certified Financial Planner™ course provides existing and future financial professionals with the skills and training needed to deliver comprehensive and accurate personal financial planning services to their clients. Through this curriculum you will learn to analyze and advise in all core areas of personal financial planning. This 14-month course is taught by industry professionals who are part of the financial services community within the Atlanta-Metro area.  KSU is an established institution with the CFP Board of Standards, Inc. Upon successful completion of the Certified Financial Planner™ Program, students are then eligible to apply for the CFP® certification examination. This course will cover: Fundamentals of Financial Planning Insurance Planning Income Tax Planning Investment Planning Retirement Planning Estate Planning Financial Plan Development (Capstone) The financial planning field is one of the fastest growing professions in America. In fact, the U.S. Bureau of Labor Statistics predicts financial planner jobs will grow faster than average due to the wealthier and longer-living population requiring more financial guidance. As demand for qualified planners grows, intense competition will continue for these well-paying jobs. Professionals who have extensive educational training and national certification will have the best opportunities.

191TFIN2008A

Start date: 08/14/18

End date: 10/01/19

Fee: $5,999.00

89 sessions.

Location : KSU Center Location : 
  KSU Center.

Room :  244



View Details »

Corporate Financial Planning & Analysis Professional arrow

Click to choose from multiple offerings

Join us for an Information Session about Corporate Financial Planning & Analysis. Along with learning the latest best practices for analyzing trends, building forecasts and creating financial models, this course will prepare you for AFP’s new Certified Corporate FP&A Professional™ credential exam. During this session you will have the opportunity to speak with our instructor, review course materials, and participate in a Q and A session at the end of the presentation.

191TFIN2000A

Start date: 08/02/18

End date: 08/02/18

Fee: $0.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  244



View Details »
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

191FMOF1507A

Start date: 09/14/18

End date: 09/14/18

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.

191FMOF1503A

Start date: 08/24/18

End date: 08/24/18

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.

191FMOF1504A

Start date: 09/07/18

End date: 09/07/18

Fee: $219.00

1 session

Location : KSU Center Location : 
  KSU Center.

Room :  208



View Details »