One Day Workshop On MS Excel - Engineering College in Pune | I²IT International Institute of Information Technology

Event Details


10 AM to 04 PM

One Day Workshop On MS Excel

The department of Information Technology is organizing a One Day Workshop On MS Excel for teaching and non-teaching staff on Tuesday, 21th January 2020 (Second Half). Registration is free. The resource person is from Global Talent Track.
All the participants will be given an e-certificate by Microsoft.

Table of Content

Introduction to Keyboard Shortcuts Sorting data Filtering data Charts
Apply Conditional Logic in formula 1. Databases in Excel – introduction 1. Filter data – the filter icon 1. Using Quick Analysis
Text functions – an introduction 2. Sort data 2. Filter on text 2. Recommended Charts
1. Concatenate 3. Sort on font colour 3. Filter on more than one column 3. Understanding different types of chart
2. Trim 4. Sort on cell colour 4. Remove the filter IF Function (IF Statement)
3. Upper 5. Sort on cell icon 5. Filter data on colour Duplicate
4. Lower Conditional formatting 6. Text filters
5. Proper HLOOKUP 7. Number filters
6. Right VLOOKUP 8. Date filters
7. Left Pivot table
8. Delimit
The Interested teaching and non-teaching staff should fill the details in given below link :