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!

09878375376

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, info@webtechlearning.com

 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)

Certifications

Contact us for more details:

Mobile: 09915337448, info@webtechlearning.com

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