Analysing Statistics with Excel
This one-day course is very hands-on where you learn real-world techniques to make statistics easy to understand. We work with industry standard statistical models in Excel without the need for any programming, which you can take away for your own use. Increasingly both private and public sector organisations are turning to statistics to help drive performance, improve decision making and deliver better services. Within this growing dependency on statistics, there is an increasing need for more professionals to be able to think in a more statistical way. Delegates will gain skills in writing powerful formulas using a variety of unexplored statistical functions. Who is this for? Based on real-world statistical data produced by analysts and researchers, this course will benefit professionals from both the private and public sector who want to build confidence in making more effective business decisions, looking to understand how to interpret statistics and attain a greater skill set with Excel. Public and private sector Data analystsSpreadsheet authorsFinance managersDecision makersFinancial controllersJunior accountants What will you learn? How to formulate robust stat models in Excel for optimum performance outputIntro to statistical terms and how to read stat models used in the real worldTypes and examples of quantitative data: continuous, categorical, countReal world distributions e.g., normal, bimodal, uniform, skewedKey terms calculations: mean; mode; median; percentile; deviation; range; ratio; probability; and riskBenefits and best practice of statistical modelling in modern-day businessesLots of dynamic flexible spreadsheet models and examples for quick and easy outputStreamline data heavy processes with stat functions: NORMDIST, STDEV, VAR, KURT, SKEW, LARGE, PERCENTILE, RANK, CORREL... and moreDiscussion point: real world statistical data and how it can be used and improvedAssociations | Trends | RegressionFurther advanced Excel techniques to generate statistical outputsCorrelation vs Causation | Regression analysisIdentify different types of data trendsHypothesis testingThe role of chance and how to assess it& F-test | & T-test | Analysing cross-sectional dataInterpreting the results from the probability valueStatistical charts and associated toolsDesigning a & Histogram to visualise data flowComplexities in charting and data plottingCreate an & Ogive chart and extract the resultsBonus topics:Understanding population and sampling2 techniques for analysing business trends via a & Frequency Distribution Table How to read an & ANOVA Table A fully-automatic & Statistical Distribution Dashboard to take awayHomework topics for further study All exercises and project files used on the course will be available to take home.Please read the following guidance carefully, which applies only if you are attending this course Virtual Classroom (Online):In addition to the Virtual Classroom (Online) Classroom, you will need to have your own version of Excel open to complete the exercisesIt does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:Extend from a computer to a 2nd screen - please refer to this link for guidance on how to correctly setup a second monitor https://support.microsoft.com/en-us/help/4340331/windows-10-set-up-dual-monitors orUse 2 computers, orUse a tablet for the Virtual Classroom (Online) Classroom and a computer for the ExcelPlease note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course. How will this help your career? Build confidence in modern-day statistical tools all within Excel (with no programming)Write powerful Excel formulas and see the benefits and practicality of using stat modelsBe able to gain quick insight into business data for better decision making
Suitability - Who should attend?
The course material includes a variety of features in Excel and participants will gain the maximum benefit from this course if they are regular spreadsheet users and / or have already attended Data Analysis with Excel – Intermediate.
Training Course Content
This one-day course is very hands-on and delegates will be exposed to real-world statistical models which they can take away for their own analysis and processes. Increasingly both private and public sector organisations are turning to statistics to help drive performance, improve decision making and deliver better services. With this growing dependency on statistics, there is an increasing need for more professionals to be able to think in a more statistical way.The course includes fast tips and best practice for creating robust, dynamic, and flexible statistical models, and improving functionality and calculations. Delegates will discover how to enhance the visual appeal of complex spreadsheets, making them much easier to read and manage. Plus gain skills in writing powerful formulae using a variety of unexplored statistical functions.By the end of the course, delegates will: Understand the principles of modern-day statistical analysisBe confident in writing powerful Excel formulasSee the benefits and practicality of using statistical modelling techniquesGain insight into using business data for better decision making