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.

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 computer software and application software. 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.     

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.

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. 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.