This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can edited to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins.
Program
Objectives
After completion of this program, the participants will be able to the following
Write macros to automate routine work Create functions and procedures Design and use forms for data entry Create add-ins to deploy at client machines Create simple reports
Audience
Program is scheduled for Advanced Microsoft Excel users. VBA is a programming language, requires aptitude for programming.
Customizing common options in Excel Absolute and relative cells Protecting and un-protecting worksheets and cells
Working with Functions
Writing conditional expressions (using IF) Using logical functions (AND, OR, NOT) Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
Data Validations
Specifying a valid range of values for a cell Specifying a list of valid values for a cell Specifying custom validations based on formula for a cell
Working with Templates
Designing the structure of a template Using templates for standardization of worksheets
Sorting and Filtering Data
Sorting tables Using multiple-level sorting Using custom sorting Filtering data for selected view (AutoFilter) Using advanced filter options
Working with Reports
Creating subtotals Multiple-level subtotals Creating Pivot tables Formatting and customizing Pivot tables Using advanced options of Pivot tables Pivot charts Consolidating data from multiple sheets and files using Pivot tables Using external data sources Using data consolidation feature to consolidate data
More Functions
Date and time functions Text functions Database functions
Formatting
Using auto formatting option for worksheets Using conditional formatting option for rows, columns and cells
Course Duration
Fees (Indian RS.)
Fees (US $)
30 sessions of 1 hr. each
7,500
215
Management has full right tochange courses, contents, tuition fees without prior notice.
Click here to Register for
COMPUFIELDoffers a unique style of learning -
One computer : One student : One Instructor
The timing can be fixed based on our mutual convenience,
between 9.00 a.m. to 7.00 p.m.
Maximum Instructor to Student Ratio 1:4
Course duration in working days = Total sessions divided by number of sessions (hours) per day.
Sessions : Each session will be of 1 hour
No extra charges/refund for more/less time taken to complete the course.
Fees is for one course and it includes instructions, practicals,practice, project, preparation for exam (if any)
Lodging, boarding and travelling not included in the fees.
Overseas / local Students take 5 to 10 hours per day to complete their courses earlier.
Write macros to automate routine work
