CHANDIGARH NO.1 - Web Education Academy - Admissions on 1st come 1st basis - Lowest Fee, Learn Unlimited! - Book a Free Demo Class
for Course Inquiry?
Call Now!


Data Analysis & Data Mining Course in Chandigarh

WebtechLearning provide best Data Analysis & Data Mining Course in Chandigarh. its 100% practical training with certifications.

Call for syllabus: 09915337448,

 Module 1 
 General Introduction about Excel
 Difference between Workbook and Worksheet
 Workbook Sharing and other features of Workbook
 Advanced Features of Excel (Save, Save as, Save & Send, Comments, etc
 Overview of Cut, Copy, Paste
 Overview of Bold, Italtic, Underline, Color (font & Background)
 What is Text Alignment (left, right, canter, Top, Middle, Bottom)
 What is Text Indent
 Different types of Font Type, Font Size
 Overview of Merge & Center
Module 2
 Understanding Wrap Text feature and practical usage
 Various types of number formatting, text formatting, Date & Time formatting
 What is Filter and Advanced Filter
 What are freeze panes, types of freeze panes and their practical usage
 What is data sorting
 Type of Data Sorting
 Understanding the concept of Data Validation
 Various types of Data Validation
Module 3
 Data Validation (continue)
 Creating Data Validation using external reference and within dialogue box
 What is meaning of sub total
 Subtotal on various data fields and its practical applicability
 What is Group, How Grouping is created
 Practical exposure of Grouping & Ungrouping data set (Rows and Columns)

Module 4
 What is Conditional Formatting
 Various types of conditional formatting using practical examples
 Creating an assignment using Conditional Formatting and Data Validation
 Meaning and usage of Name Manager
Module 5
 What is Pivot Table
 What is Pivot Table and Pivot Chart
 Exploring the power of Pivot and discovering the advanced features of Pivot Table
 Looking at various formatting options available in a Pivot Table
 Setting the formatting of the data in the Pivot Table
Module 6
 Exploring Charts and Graphs
 General Introduction about various types of Charts
 Discovering the practical aspect of various chart types and way to create  them on data set
 Understanding Trend lines and concept of Dual Axis
 Looking the magic of Sparkline
Module 7
 General Introduction about formulae
 Various simple functions like  Sum, Count, CountA, Average, Mean, Median,Text, Value, max, min
 lookup functions like vlookup, hlookup, offset, row, column, address etc
 Working on other functions like DSUM, DCOUNT, DAVERAGE, SUMIF, COUNTIF
 Understanding error handling through formulae like If(iserror), If(istext), If(NA) etc
 Working on various conditions in the formule like If without else, if with else, the use of AND & OR operator within If formula
Module 8
 A small up and running project on Excel (covering each functionality and formula creation learnt in the overall training)


Contact us for more details:

Mobile: 09915337448,

Top Search: >

WebtechLearning - Web Education Academy

ISO 9001:2008 Certified Academy

Professional Training + with Live Projects + Certifications+ Job

Call for query:  +91 9878 375 376, +91 9915 337 448 , Skype: webtechlearning

Book My Free Demo Class Now!

Note: you can meet your trainer, get demo class before joining the Course.

Webtech LearningTM partner's companies