Microsoft Excel Fundamentals For Data Analysis – March 13 & 14, 2021

Coimbatore Institute of Technology – Teaching Learning Centre (Under PMMMNMTT, MHRD, GoI) is organizing an online workshop on Excel Fundamentals For Data Analysis on March 13 & 14, 2021.

COURSE CONTENTS:

Excel 101
Working with Excel
Moving your Data
Basic Excel Features
Absolute, Relative and Mixed Reference
Editing Tools- Alignments
Cell Formatting
BODMAS Rules in Excel
Analyzing and Validating Data
Validating Data
Understanding Data Validation
Creating a Number Range Validation
Testing a Validation and Drop Down List
Creating an Input Message, Error Message
Conditional Formatting
High Light the Cell Rules
Top/Bottom Rules
Data Bars & Icon Sets
VLOOKUP Functions
Using the VLOOKUP Function
Application of VLOOKUP in forms and IF functions
Working with Functions and Formulas
Formulas with Absolute References
Auto sum Functions (SUM & AVERAGE)
IF and Nested Functions
Array Functions (SUMIF & AVERAGEIF)
COUNTIFS & SUMIFS
Pivot Table and Charting Pivoted Data
Getting Started with PivotTables
Displaying Data in a PivotTable
Formatting a PivotTable
Using the Classic PivotTable Layout
Getting Started with Pivot Charts

 

Course Fee: Rs.250/

REGISTRATION PROCESS
Course fee can be paid through RTGS/NEFT to the following account:

Account Name CIT-TLC TP 2019
Account Number 6842996928
Name of the Bank & Branch name Indian Bank, Peelamedu (CIT Campus)
IFSC Code IDIB000S107

After payment, register through the following Google form link and upload scanned copy of Counter Foil / Screenshot of the RTGS / NEFT/Google Pay(Bank Transfer) details on or before 03:00 PM of 12th March, 2021


Google Form Link for Registration: https://forms.gle/NWPKgTumMQe4c8ZM8

For brochure/more details: click here

Advertisement

Subscribe to Get Jobs in: WhatsApp CJ WhatsApp SJ Email Telegram