Power Excel: Analysing Data to Make Business Decisions

Focus on Training

Course

Online

£ 995 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

This course is about harnessing the power of Microsoft Excel to analyse business problems and identify solutions, allowing you to turn data into information to make sound decisions that, in today's fast-paced climate, can lead to a competitive business advantage. You gain the knowledge and hands-on skills required to exploit Excel's intermediate and advanced features, such as PivotTables and PivotCharts. In this course, you gain experience with the following: Financial and statistical functionsScenario Manager, Solver and Goal Seek3-D worksheetsData consolidationSubtotalingPivotTables and PivotChartsCreating and examining macros This course is applicable to all versions of Excel from Excel 97 to Excel 2013. Furthermore, you can complete the Hands-On exercises in either Excel 2013, 2010, 2007 or 2003, allowing you to choose the version that better suits your needs. Learning Objectives You Will Learn How To:Leverage features of Microsoft Excel to facilitate business decisionsDevelop intelligent worksheets to quickly identify KPIsPerform "what-if" analyses for developing budget and project plansSummarise and analyse large amounts of data using PivotTables and Excel featuresAutomate Excel processesHands-On Experience:Automating lookup calculationsReducing speculation with "what-if" analysesConsolidating and summarising data contained in multiple worksheets and workbooksDefining the best combination of values to solve problemsCreating interactive reports with PivotTables

About this course

Experience with Excel fundamentals is assumed. You should be able to: Open, save and close workbooksReference cells through absolute and relative addressingCreate simple formulasAccess worksheets in a workbookInsert and delete worksheetsCut, copy and paste information from one cell to another Use AutoFillFormat numbers in a worksheetResize columns and rows

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Microsoft excel training
  • Financial Training
  • Financial
  • Microsoft Excel
  • Excel

Course programme

Troubleshooting and Enhancing Professional Workbooks

  • Deciphering and correcting functions for data integrity
  • Accurately interpreting calculations
  • Implementing Names to enhance your workbook model
  • Monitoring KPIs using conditional formatting
Analysing Data with FunctionsSummarising business data with functions
  • Identifying the correct statistical function to aid analysis
  • Applying basic financial functions
  • Differentiating serial dates and date presentations
  • Calculating the number of working days
Controlling calculations and nested formulas
  • Interpreting data variations with the IF function
  • Streamlining calculations with referencing
  • Developing nested functions for multiple conditions
  • Capturing information with lookup functions
  • Applying techniques to implement and troubleshoot nested calculations
Optimising Workbook Models with "What-If" AnalysisPlanning for contingencies
  • Managing variables in worksheets with Scenarios
  • Comparing and contrasting different data sets with scenario reports
Quantifying variables in a workbook model
  • 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
Summarising Business InformationOrganising workbooks and links
  • Arranging multiple workbooks with Workspaces
  • Managing external links
Consolidating ranges
  • Building 3D formulas to analyse worksheet data
  • Summarising multiple sources of Excel information into one worksheet
Formulating Decisions from Database InformationDistilling data sets for data analysis
  • Managing multiple data sets on a single worksheet with the Table feature
  • Defining an Excel data set to ensure appropriate use of built-in features
  • Extracting unique lists of records from an Excel data set with the Advanced Filter
  • Analysing data sets with filters and aggregation
Interpreting and refining data with PivotTables
  • Defining data summaries interactively
  • Summarising data sets with grouping and aggregation
  • Comparing related totals dynamically
  • Filtering details with Report Filters and Slicers
Visualising and exploring PivotTable reports
  • Presenting PivotTable reports effectively with PivotCharts
  • Examining data patterns with Sparklines
  • Analysing multiple tables of data with Power Pivots
  • Discovering and presenting information with Power View
Enhancing Excel Usage with MacrosAutomating repetitive tasks
  • Simplifying complex tasks and reducing errors
  • Bulletproofing routine editing and formatting
  • Invoking macros with Form controls

See related categories

Power Excel: Analysing Data to Make Business Decisions

£ 995 + VAT

The best Excel courses

See all

See all