Data Analysis with Excel هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

• Benefits of Performing Data Analysis
• Stages of Data Analysis

• Analyzing Performance against Target
• Using Powerful New Features
  • Flash Fill
  • Quick Analysis
• Advanced Data Sorting techniques
• Advanced Filtering Techniques
• Applying Validation Checks on Data

• Highlighting Data Based on Specified Criteria
• Create your own Formatting Rules
• Using Non Charting Visualization
  • Data Bars
  • Icon Sets
  • Color Scales

• What are Sparklines?
• Inserting & Modifying Sparklines
• Analyzing Data with Sparklines
• Performing Tweaks with Sparklines
• Handling Missing Data
• Making the Sparklines Dynamic (Auto-Update)

• Going through different types of Charts
• Modifying Charts and Working with Chart Options
• Advanced Charts Formatting
  • Inserting Text and Pictures inside Charts
  • Modifying Chart Axis
• Creating Specialized Charts for Measuring Performance
  • Combo Chart
  • Dynamic Chart
  • Thermometer Chart
  • Bullet Chart

• Analyzing Data with Pivot Tables: A very Powerful Reporting Tool
• Creating & Modifying Pivot Tables
• Performing Calculations within Pivot Tables
• Working with Pivot Charts
• Analyzing Data with Excellent New Features in Pivot Tables
  • Slicers
  • Timelines

• Using the brilliant Goal-Seek Feature
• Performing Sensitivity Analysis with Data Tables
• Using Scenario Manager to Summarize Results

• Creating Drop Down List
• Regulating & Managing the Entry of Data
• Custom Input Message and Error Alert

• Adding Interactive Advanced Controls
  • Buttons Control
  • Check Box
  • Spin Buttons
  • Option Buttons

• Using Macros to Automate Reports
• Recording a Macro
• Running a Macro
  • Assigning Macros to Objects & Buttons