About the Course
Advance Excel Training for the people who want to work on Dual Role(Reporting as well as Automation) It is also useful for the people who work in HR dept, CA firm, Data analysis.
Topics CoveredOverview of SQL and
Advance Excel Training of All Formula like (VLOOKUP, HLOOKUP, SUMIF, COUNTIF, DCOUNT, DSUM, ARRAY FORMULA, OFFSET, INDIRECT, LEFT, RIGHT, MID etc)
Graphs (Static and Dynamic)
Data consolidation etc
Validation, Filters, Advance Filters, Conditional Formatting, Name Range, Dynamic Name Range,
Automation of Report using VBA Macros, Outlook mailer through Excel, Reading Text /Log File, Connection With Excel,Access, Mysql etc database, Different type of Looping and many more
and SQL (Query Writing)
Who should attendPeople who want to work as automation Engineer as well Reporting.
And Those who want to gain the complete knowledge without having Basic programming and Excel knowledge
Pre-requisitesDesired Knowledge --> Basic Excel
What you need to bringNA"
Key Takeawaysflawless Development and Reporting Techniques