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