Tpoics Covered:- Excel Advanced Formula, Excel Macro and Excel VBA
Our most popular course.You’ll learn how to create templates for commonly used worksheets. Learn how to apply filters and sort data into key elements. Getting Excel to make decisions using the ‘If’ function, Pivot Table and conditional formatting,. Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.
Our Advanced Excel Training will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information.
Excel VBA course is suitable for advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to automate routine activities in Excel based on their requirements.
Advanced Features of Ms-Excel. Advanced Excel course also enables the student to utilize, the advance features taught in this course in an office environment with maximum efficiency.
In this course you will learn to write macros in Excel using programming languageVisual Basic Application (VBA). Recorded macro can be edited to customize it & one can directly go for coding to accomplish the required tasks.
Good proficiency in Microsoft Excel is required
Adv. Excel Training Duration
Regular classroom based training: 12 Weeks, 60 minutes of theory & practical session per day.