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

Subscribe our Telegram Channel to get all updates: Join Now!

Alert : Dear Visitors, Faculty Plus Employees will not call any candidates towards Job Offer or Job assistance or asking certificates. Faculty Plus will never charge any candidates for Jobs. Please be aware of fraudulent calls or emails.

Previous articleSavitribai College of Art, Maharashtra wanted Assistant Professor for various Department(Walk-In)
Next articleBathinda College of Law, Punjab wanted Assistant Professor