Students, Professionals, Freelancers, Executives and Managers who have already very good knowledge of Microsoft Excel, but now feel the need for learning super powerful features and options of Excel, to manage their worksheet-related tasks more efficiently using advance function in Excel and working with Excel VBA.
Pre-requisites: Participants attending this training should have a very good knowledge of Microsoft Excel, such as simple if , absolute and relative reference, sum-if and count-if function, conditional formatting , filter and simple pivot table.
Module 1 Efficient way of using Excel
Module 2 Lookup and Reference function
Module 3 Conditional Formatting using Formula and Function
Module 4 Advance Pivot
Module 5 What-If Analysis
Module 6 Data Forms
Module 7 Working with External Data
Module 8 Recording Macros
Module 9 The Visual Basic Editor
Module 10 Writing Procedures for Selection Techniques and Looping
Module 11 Writing Procedures for Worksheets and File related Objects
Payment can be made using Debit card/Credit Card/NEFT/Cheque.
*Students have to produce id card to avail Student’s discount price.
*Students have to carry their own laptop.
*Pragati Software reserves the right to postpone any program due to insufficient nomination