Certified Business & Industry Analyst

Advanced Data Manipulation

• Rounding Numbers
• Rounding to significant figures
• Rounding to nearest multiple
• Rounding dollar values
• Extracting integer values
• Rounding to even or odd integer
• Manipulating Text
• Matching cell contents
• Joining cells
• Changing case
• Extracting character
• Text length
• Working with Dates & Times
• Calculate number of days. months or years between dates
• Offsetting a date
• Calculate time difference
• Rounding time values
• Counting, Summing & Averaging Techniques
• Conditional counting & multiple criteria
• Counting frequent entries
• Conditional summing & multiple criteria
• Conditional averaging & multiple

Financial Functions

• Loan Calculations
• Investment Calculations
• Depreciations

 Advanced Data Analysis

• Analysis Tool Pak
• Regression
• Sampling
• Working with Trend Lines

Auditing Worksheets

• Tracking Errors in Excel
• Understanding Precedents and Dependencies
• Viewing and Hiding Tracer Arrows
• Resolving Circular References
• Using the Watch Window
• Evaluate Formulas

Data Analysis & Time Series & Forecasting

• Historical information
• Trend analysis
• Gap identification
• Develop forecasting models and analysis
• Variance and Standard Deviation
• Probability Distributions
• Normal Distribution
• Central Limit Theorem
• Estimation and Confidence Level
• Hypothesis Testing

Chart development & analysis

• Introduction to Charts in Excel
• Building Basic Charts
• Chart Editing and Formatting
• Setting Data Source and Plot Direction
• Changing Chart Layout and Styles
• Manipulating Labels, Axes and Background
• Formatting 3D Rotations
• Working with Quick Analysis
• Inserting Sparkline’s

Quality & Decision Support Systems

• Understanding Data & Forecasting Statistically
• How to Forecast Based on Historical Information
• Data Analysis using Statistical Analysis Techniques
• Introduction to Correlation & Regression
• Discussions & Lab Exercises

Tables & Charts in Data Analysis

• Types of Charts, Tables
• Building Simple Models
• Pivot Tables and Advanced Excel Techniques

Troubleshooting

• Problem Simulation
• Application to Business / Management
• Lab exercise

Continuous Improvement

• Total Quality Management
• Kaizen & Moving to Six Sigma
• Holistic Approach to Continuous Improvement.