Duration 3 Months

Course Code: 1021

• Advanced Excel – Introduction of Advanced Excel, working with large datasets, advanced formulas like IFERROR, INDEX, MATCH, VLOOKUP, HLOOKUP, SUMIF, COUNTIF, AVERAGEIF, TRUE/FALSE, AND, IF, DB, NEPER, CONCAT/CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM, TEXT, TODAY(), NOW(), DATE, WORKDAY, PMT,IPMT, PPMT, FV. Learn Conditional Formatting, Sort & Filter, Pivot Tables & Pivot Charts, Data Validation, Scenario Manager, Goal Seek, Macros, Dashboard Creation, and Advanced Charting. Also practice Duplicate Data handling, Remove Duplicates, Cut, Copy, Paste, Paste Special, Auto Fill, Insert Cells/Rows/Columns, Hide/Unhide, Rename, Freeze Panes, Format as Table, and Cell Styles, and many more.
• Internet & Email – Browse the web, search information, create, send, and manage emails, attach files, manage contacts, and communicate professionally online.