Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day) UK Classes & Lessons (Microsoft)

Talk to a Training Advisor

Tel. 0800 652 0202

Availability (sort by: location | date)

Request availability by clicking a date.

Europe / International

Edinburgh

TBA (EH1) 04/10/10 £ 1,150

TBA (NW1) 27/09/10 £ 1,150

TBA (NW1) 13/12/10 £ 1,150

Prices exc. VAT. Courses are vendor approved.

Need help? Contact us now.

About this class

In today's fast-paced business climate, it is vital that decisions are made quickly and accurately. The power of Microsoft Excel can be used to analyse business problems, identify solutions and make sound decisions to achieve a competitive advantage.

In this course, you use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform "what-if" analysis, apply functions, manipulate PivotTables, and present your results to make better decisions for planning, budgeting and more.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

Business and technical professionals making decisions based on data analysis, or anyone who wants to increase their knowledge of intermediate to advanced features in Excel. Experience with Excel at an introductory level is assumed.

What delegates will learn

Leverage advanced features of Microsoft Excel to facilitate business decisions
Perform "what-if" analysis for developing budget and project plans
Predict potential business developments using trend analysis
Consolidate and process multidimensional worksheets
Summarise and analyse large amounts of data using PivotTables and Excel features
Automate Excel processes and enhance worksheet models

Contents of this class

Business Solutions and Excel

Developing workbook models

Planning effective worksheets and workbooks to improve workbook maintenance
Highlighting KPIs and data anomalies with conditional formatting

Optimising solutions with "what-if" analysis

Managing variables in worksheets with Scenarios
Comparing and contrasting different datasets with scenario reports
Determining the magnitude of a variable with Goal Seek to achieve an end value
Calculating the optimum variable values in a worksheet model with Solver

Analysing and Deciphering Data

Evaluating data with Excel functions

Discovering and implementing functions with the F? tool
Interpreting calculations with the Formula Auditing tools
Identifying the correct statistical function to aid analysis
Applying basic financial functions
Differentiating serial dates and date presentations
Calculating the number of working days using the Analysis Toolpak

Controlling calculations and nested formulas

Troubleshooting calculations with the Function Arguments tool
Interpreting data variations with the IF function
Developing nested functions to cope with multiple conditions

Extracting values with data-centred calculations

Capturing information with lookup functions
Handling missing information
Checking data for uniqueness

Summarising Business Information

Organising workbooks and links

Arranging multiple workbooks with Workspaces
Managing external links

Consolidating ranges

Building 3-D formulas to analyse worksheet data
Summarising multiple sources of Excel information into one worksheet

Formulating Decisions from Database Information

Distilling lists for data analysis

Managing multiple datasets on a single worksheet with the Table feature
Defining an Excel list to ensure appropriate use of built-in list features
Extracting unique lists of records from an Excel list
Analysing lists with filters and aggregation
Calculating subtotals and grand totals

Condensing and refining data with PivotTables and PivotCharts

Creating interactive PivotTables and PivotCharts for real-time data analysis
Comparing related totals dynamically
Extracting and filtering records
Defining data summaries interactively
Presenting PivotTable reports effectively

Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)