|
Provided by: NobleProg - IT training courses Six Sigma Introduction Training CourseExcel |
 |
The course is designed for anyone who is interested in Six Sigma and the quality management.
|
|
||||||||||||||||||
Training
Provided by NobleProg - IT training courses
- A asked: Can your organisation arrange a weeks ( work days) training in line with the arrangement given below, for person in your site in UK from oth to st July ? Advanced Excel, VBA and Statistical Modeling day "Excel Commando" Course Week - FOUNDATION Day - Advanced Excel features Introduction and demonstrations of where we're heading Review of Excel fundamentals including absolute and relative cell-addressing Using Named Ranges Advanced formula construction Data and List manipulation Automatic Subtotals Pivot tables Charting Linking multiple files Protect and display options Using the VBA Macro Recorder Day - Introducing VBA Using the VBA Macro Recorder - continued Ways to Assign and Run Your Macros Examples of Useful Macros Using the "Immediate Window" Moving from Recording to Editing and Writing Code Understanding and fully utilizing the VBA environment Day - Focus on the VBA Language Understanding and fully utilizing the VBA environment - continued The Object Model In depth exposition of the VBA Language Language Structures Writing Custom Functions Variables Day - Programming for Integration Best practices in VBA application development Getting Data In and Pumping Data Out Interacting with External data sources Interfacing with Microsoft Access, and Microsoft Word Using the best tool for the job The power of SQL for data manipulation Creating Reusable Routines Creating your own "objects" Creating VBA Excel Add-ins Writing code that writes code Day - Review Review material from first days Detailed review of VBA language - fitting all the pieces together Complete any incomplete practical examples Workshop day to review material brought by course delegates Week - APPLICATION Day - Statistical Methods in Excel Built-in statistical functions Probability density functions and confidence intervals Other mathematical and statistical functions Creating your own statistical functions Built-in analysis tools and add-ins Analysis toolpak Scenario manager Goal seek Solver - constrained linear optimization Descriptive statistics Statistical significance Rank and percentile Array formulas and functions Day - Using Excel to make Decisions Built-in financial functions Creating your own financial functions Estimating straight line relationships Correlation analysis Hypothesis testing Analysis of variance Sensitivity analysis Building decisions trees Day - Building Models in Excel Setting up a model in Excel Predicting the future based on passed data Generating random Numbers that fit standard statistical distributions Regression modeling Sampling analysis Monte Carlo simulations Creating your own analysis tools Day - Case Studies Optimization models for finance decisions Forecasting with seasonally adjusted moving averages Forecasting in the face of unusual circumstances Modeling machine life and duration of projects Economic order quantity inventory model Determining the reorder point Day - Review Review the material from the last days and previous week Complete any incomplete practical examples Workshop day to review material brought by course delegates The knowledge I like to gain from this training should also cover the following areas: a Use Visual Basic for Applications to create macros that will execute scores of commands with a single click. a Analyze millions of cell values and distill that data into meaningful information you can use. a Let VBA walk you through setting up simple macros that can create reports, generate statistics, and develop new data files. a Build macros that not only create monthly reports but automatically reset each team membera ™s worksheets with new YTD and quarterly totals. a Use the Visual Basic Editor to enhance the power and flexibility of your existing macros. a Create interactive macros that will prompt users for required data and check entries for accuracy. a Quickly develop dialog sheets with text boxes, radio buttons, check boxes, and pull down lists for more accurate data entry. a Set macros to utilize logical constructs such as If a Then statements to perform data evaluation and correction for your users. a Automatically generate reports, graphs, statistics, and totals from data entered by multiple users in a shared workbook. a Quickly publish your Excel workbook with graphs, charts, and reports as a Web page a complete with interactive options. a Quickly, cleanly draw out crucial records with the AutoFill and Advanced Filter options. a Let Excela ™s PivotTable and PivotChart features manage millions of cell values to create useful statistics in just seconds. a Use statistical, financial, database, and other functions to provide unmatched accuracy and reliability to your department and corporate reports. a Easily create sophisticated graphs that shine with professional polish with the tips and tricks youa ™ll learn. a Download extensive Internet data onto an Excel spreadsheet and quickly organize it into useful reports and statistical analysis.
Six Sigma Introduction Training Course
Find out from case studies how Six Sigma uses a data driven approach to process improvement.
Learn how to deploy Six Sigma and how to select and manage Six Sigma improvement projects through the define, measure, analyse, improve, control phases.
Learn how to deploy Six Sigma and how to select and manage Six Sigma improvement projects through the define, measure, analyse, improve, control phases.
About The Training Provider: NobleProg - IT training courses
NobleProg - IT training courses - NobleProg specializes in bespoke computer and management training courses.
NobleProg provides computer training courses in the following areas:
* Drupal
* Java
* Linux
* MySQL
* OpenOffice
* Oracle
* PHP
* Project Management
* SVN and CVS
* UML
* Web Application Testing
* CSS
* VBA
* BPM
* SOA
* LPI (We are...
