COVID-19 Lockdown
Leading Training is online and available during the Covid-19 Shutdown.
Our staff are working from home and can do the following:
- Webinar training and e-learning
- Consulting
- Development work
- Support
We can provide remote assistance to anyone who needs it, however as an IT support company we are willing to provide emergency support to companies that are essential service providers.
If you require any help from us please make use of the live chat below.
Details
This course will build on your current Excel skills by teaching to use Excel's powerful tools to format statistics. The course will also guide you in best practice presentation of those statistics and how to analyse them.
Delivery Methods
| Delivery Method | Duration | Price (excl. VAT) | |
|---|---|---|---|
| Fulltime | 2 day | $936.00 | |
| Webinar | 2 day | $346.00 |
Discounts Available
Save up to $50.00 if you bring your own PC on a fulltime course.
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Audience
Any person currently using Excel at an advanced level and needs to use Excel tools to draw statistical analyses on data.
Pre-Requisites
Proficiency in Excel with evidence of experience in tools from Basic to Advanced. Complete our Basic to Advanced Excel Course if not.
Course Outline / Curriculum
- Introducing Excel Tables
- Simple statistics
- Sorting
- AutoFilter
- Custom AutoFilter
- Advanced Filtering
- Cleaning Data
- Importing into Workbook
- Move, copy, resize and delete columns and/or rows and/or sheets
- Format cell contents
- Clear formatting and cell contents
- Find and Replace data
- Cleaning Data with Text Functions
- Conditional Formatting
- Working with PivotTables
- Running the PivotTable Wizard
- Pivot Table Field Options (right click)
- Pivot Table Design and Options
- Building PivotTable Formulas
- Adding Another Standard Calculation
- Creating Custom Calculations
- Using Calculated Fields and Items
- Reviewing and changing solve order (new sheet)
- Retrieving Data from a Pivot Table (new sheet)
- Arguments of the GETPIVOTDATA function
- Working with PivotCharts
- Running the PivotChart Wizard
- Filter data
- Refresh data
- Group data
- Customizing Charts
- Selecting a Chart Type
- Working with Chart Styles
- Changing Chart Layout
- Changing a Chart’s Location
- Formatting 3-D Charts
- Ten Things You Ought to Know about Statistics
- Descriptive Statistics Are Straightforward
- Averages Aren’t So Simple Sometimes
- Standard Deviations Describe Dispersion
- An Observation Is an Observation
- A Sample Is a Subset of Values
- Inferential Statistics Are Cool but Complicated
- Probability Distribution Functions Aren’t Always Confusing
- Parameters Aren’t So Complicated
- Skewness and Kurtosis Describe a Probability Distribution’s Shape
- Confidence Intervals Seem Complicated at First, but Are Useful
- Ten Tips for Presenting Table Results & Analyzing Data
- Work Hard to Import Data
- Design Information Systems to Produce Rich Data
- Don’t Forget about Third-Party Sources
- Just Add It
- Always Explore Descriptive Statistics
- Watch for Trends
- Slicing and Dicing: Cross-Tabulation
- Chart It, Baby
- Be Aware of Inferential Statistics
- Using the Statistics Functions
- Counting Items in a Data Set
- Means, Modes, and Medians
- Finding Values, Ranks, and Percentiles
- Standard Deviations and Variances
- Normal Distributions
- Using the Statistics Functions cont.
- z-standard deviations
- t-distributions
- f-distributions
- Binomial Distributions
- Chi-Square Distributions
- Regression Analysis
- Correlation
- Some Really Esoteric Probability Distributions
- Descriptive Statistics
- Using the Descriptive Statistics Tool
- Creating a Histogram
- Ranking by Percentile
- Calculating Moving Averages
- Exponential Smoothing
- Inferential Statistics
- Using the t-test Data Analysis Tool
- Performing z-test Calculations
- Creating a Scatter Plot
- Using the Regression Data Analysis Tool
- Using the Correlation Analysis Tool
- Using the Covariance Analysis Tool
- Using the ANOVA Data Analysis Tools
- Creating an f-test Analysis
- Using Fourier Analysis
- Box and Whiskers Chart
- Pareto Chart
- Ten Tips for Visually Analyzing and Presenting Data
- Using the Right Chart Type
- Using Your Chart Message as the Chart Title
- Beware of Pie Charts
- Consider Using Pivot Charts for Small Data Sets
- Avoiding 3-D Charts
- Never Use 3-D Pie Charts
- Be Aware of the Phantom Data Markers
- Use Logarithmic Scaling
- Don’t Forget to Experiment
- Get Tufte
Schedule Dates and Booking
To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.
| Start Date | Branch | Status | |
|---|---|---|---|
| Thu 4 Jun 2020 | Woodmead | Scheduled | |
| Thu 6 Aug 2020 | Woodmead | Scheduled | |
| Thu 3 Sep 2020 | Woodmead | Provisional | |
| Thu 8 Oct 2020 | Woodmead | Scheduled |