Necessary Practice Files & Resources for Hands-on Virtual Workshop on Microsoft Excel 2019 Basic to Advance by NBICT LAB for Students, Teachers, Professionals, & Researchers

Training Session: July-December 2021 (Batch – 1)

Day – 1 – Necessary Resources – Download

Day – 2 – Necessary Resources – Download

Day – 3 – Necessary Resources – N/A

Day – 4 – Necessary Resources – Download

Day – 5 – Necessary Resources – Download

Day – 6 – Necessary Resources – Download

Day – 7 – Necessary Resources – Download

Day – 8 – Necessary Resources – Download

Day – 9 – Necessary Resources – N/A

Day – 10 – Necessary Resources – Download

Day – 11 – Necessary Resources – NA

Day – 12 – Necessary Resources – Download

Day – 13 – Necessary Resources – Download

Day – 14 – Necessary Resources – Download

Day – 15 – Necessary Resources – Download

Resources of YouTube Video Lectures

👉 Working with the Excel Environment – 

👉 The Compatibility Mode – 

👉 Exporting Excel Documents – 

👉 Cell Basics – 

👉 Modifying Columns, Rows, and Cells – 

👉 Absolute Cell References, VLOOKUP, & IF – 

👉 Using Function from the Functions Library – 

👉 Nested Functions Library – 

👉 Freezing, Splitting, Sorting, Filtering – 

👉 VLOOKUP Exact Match with IFERROR – 

👉 VLOOKUP Relative Match – 

👉 Data Validation – 

👉 HLOOKUP – 

👉 SUMIF – 

👉 Basics of Building a Pivot Table and Chart – 

Please, write a review for NBICT LAB