Professional >> Business
« back to courses page

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.

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.

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.

Individuals who are able to transform data into actionable knowledge are in demand.  In fact, the FP&A position is one of the hardest to fill.  Kennesaw State University’s College of Continuing and Professional Education’s instructor-led FP&A program helps individuals learn the best practices for analyzing trends, building forecasts and creating financial models. Today corporate finance professionals are increasingly being called upon to play a critical role in their organization’s decision-making process and long-term growth. As the amount of data available keeps growing, the ability to connect meaningful financial data to business growth and present it to all stakeholders becomes even more important. This course is offered in partnership with AFP and is taught by experienced instructors.  Our course is designed for individuals seeking credentials that will focus on mastering the core functions of the FP&A role.  Earning your Certified Corporate Financial Planning & Analysis Professional (FP&A) credential will establish you as a recognized expert in the FP&A field. The curriculum for this course will cover five learning modules that include Part I: Financial Acumen – Gathering, Interpreting, Understanding, and Communicating Business and Financial Information, and Part II: Financial Analysis – Analyzing Information, Building and Interpreting Financial Projections, and Using Technology/Software. Learning Outcomes: Gather qualitative and quantitative information on factors affecting the financial performance of an organization Analyze data and relevant facts, then consolidate and convey insight to support decision makers and other stakeholders Assess and adapt an organizations processes to changes in the business environment Develop financial projections and forecasts to provide actionable intelligence for decision makers within the organization Use technology and software to perform key financial planning and analysis functions Recognize and abide by professional conduct standards Identify the entire decision support process Perform functions accurately and in an efficient manner Who should attend: • FP&A managers and directors • Accounting, treasury and financial analysts • Finance and treasury directors • Chief financial officers • Vice presidents of finance and treasury • Consultants •Technical and administrative staff supporting corporate finance •Students with interest in finance and business related fields Note: Fee includes the cost of the AFP FP&A Learning System™.  Participants must register separately for the FP&A exam (exam fee not included in cost of the course).

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.

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

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.

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.