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 – ⏬