Data Analysis

Data analysis –Excel & VBA , Macros

1 ) Functions in Excel
• Mathematical Functions.
• Date & Time Functions.
• Text Functions & Data Validation.
• Statistical & Other Functions.
• Logical Functions.
• Lookup & Reference Functions.
2) Pivot
• Pivot Table and Charts.
• Import and Export data.
• Protect/Unprotect Sheets/Workbooks.
• Worksheet Formatting and Print Display.
3) Analysis in Excel
• Data Collection Method with Data Quality,Analysis Single/Multidimensional Analysis.
• Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table.
• Manual What-If Analysis, Threshold Values & Goal Seek.
• One-Variable Data Table, Two-Variable Data Table.
4) Dashboard &Reporting
• Advanced Dashboard, Report Development – (Real World Data)
5) Macros & VBA in Excel –
• Introduction to the VBE, Properties window & Project.
• Excel Macro Language Review (VBA) Including Variables.
• Data Types, Constants, Arrays, Operators & Expressions.
• If-Then-Else, Select-Case, And/or Nested Conditions
• Loops, Logic Decisions and Calling.
• Explorer, Password Protection of Code How to use the VBE – Features, Options, Intelligence Technology.