courses

Data Analysis using Excel

Ability to analyze data - ENROLL NOW

Rs. 499

PROGRAMME FEATURES

WHAT YOU WILL LEARN?                                             

  1. 9+ hours demandable topic videos in hindi
  2. To the point learning
  3. Anyone wants to explore the essential excel skills in detail
  4. Detail understanding for each function
  5. Learn instantly any topic as per requirement
  6. Doubt Clearing Sessions
  7. Certificate of Training provided


THIS COURSE WILL MAKE YOU

  1.  Smart work with the Functions and formulas
  2.  Increase working efficiency
  3.  Standout from the crowd
  4.  Increase productivity and time saving
  5.  Data analysis faster

  1. Basic & advanced number/date formatting
  2. Absolute, relative and mixed references ($ symbol use in formula)
  3. Analysis with number formulas 
  4. Logical test with data
  5. Lookup data with reference formulas
  6. Working with text data
  7. Adding date & time
  8. Adding names for cells references
  9. Automated color adding within data
  10. Working smartly to data tools
  11. Adding outline/group of data
  12. Pivot table & graph Basic understanding
  13. Smart tips

Download detailed course book

courses

Data analysis using Pivot Table

Analyze and visualize data with Pivot Table

Rs. 199


PROGRAMME FEATURES

WHAT YOU WILL LEARN?

  1. 3+ Hours demandable topic videos in hindi
  2. To the point learning
  3. For all who want to learn advance features of pivot table
  4. Learn instantly any topic as per requirement
  5. Life time access
  6. Doubt Clearing Session
  7. Certificate of Training provided


THIS COURSE WILL MAKE YOU

  1. Faster to analyze large data
  2. Increase working efficiency and Time saving
  3. Stand out from the crowd
  4. Quick report creation and decision making
  5. Easy to use and summarize huge data sets

  1. Pivot table basics understanding
  2. Slicer and Timeline
  3. Value as, Value by and showing value as percentage
  4. Data grouping (Date, Text and Numbers)
  5. Advance options
  6. Layout and Design for reporting
  7. Pivot chart and dashboard
  8. Automatically pivot table update by data table adding
  9. Sales Data analysis
  10. many more




courses

MS Excel - Data Visualization using Charts

Offline live training available

Rs.

WHAT WILL YOU LEARN?

  1. BASIC AND ADVANCE CHART FETURES
  2. WORKING WITH ADVANCE CHART TYPES
  3. COLUMN AND BAR CHART
  4. HISTOGRAM AND PARETO CHART
  5. LINE CHART
  6. AREA CHART
  7. PIE CHART
  8. DOUGHNUT CHART
  9. TREE MAPS
  10. SUNBURST CHART
  11. WATERFALL CHART
  12. FUNNEL CHART
  13. RADAR CHART
  14. HEAT MAP
  15. SPARKLINKS
  16. COMBO CHART
  17. FORM CONTROL - AUTOMATE CHART USING FORM CONTROL BUTTON
  18. MAKING CHART AS TEMPLATE
  19. CERTIFICATE OF TRAINING PROVIDED