Data Analysis for Businesses Office 2007

Data Analysis for Businesses (Office 2007)
Any business generates data about customers, suppliers, products, orders and more, and this can quickly become unmanageable. Learn how to manipulate and analyse it effectively with MS Excel.

What does the course involve?
You will learn through tutor demonstration, discussion and practical exercises using business-related examples.

What will I study?
Creating graphs and charts Data analysis in business need not be rocket science. By displaying data visually, even a straightforward pie chart or bar chart can bring your data to life. Starting from a simple level, we will gradually build more complex graphs and get to know some of the enhanced chart design features of Excel 2007. This will include editing existing charts and generating trend lines.

But what if... ? Will sales increase by 5% or 25% next year? Can we drive our production costs down by 5% or will they increase by 10%? Business decisions often need to be based on factors like these where we can only make an educated guess at the answer. We will look at ways of creating and viewing different scenarios in Excel with one or several variables.

Bringing it all together Learn how to consolidate data from different worksheets and workbooks in one place for easier analysis, then summarise it using the redesigned Pivot Table options in Excel 2007.

What are the entry requirements for Data Analysis for Businesses (Office 2007)?

• You need to have studied spreadsheets to an intermediate level.

How is the course assessed?

• There is no assessment for this course

Frequently Asked Questions
Who is this course for?
You will probably be familiar with the more straightforward formulas and functions in Excel. You may already be using Excel 2007 or thinking of making the move to it.

How will this course benefit my business?
Whether your focus is on customers, products, suppliers or elsewhere, chances are that you need to make sense of lots of accumulated data before you can make effective business decisions. This course is designed to give you the skills and increase your confidence in using Excel to support those decisions.

This information is believed to be correct. Cirencester College continually updates and reviews its provision to ensure that it meets the needs of the community. Therefore the right to amend, change or delete learning programmes, accreditation routes or terms and conditions relating to entitlement to study is reserved at all times. We aim to provide open access to a comprehensive range of high quality education and training for the whole community over the age of 16 regardless of race, class, belief, language, gender, sexual orientation, disability, previous educational attainment or particular circumstances.