institute, school for short term computer courses in financial appliction excel, advance excel & Tally, macros VBA

Our Courses

Creative


			Email ID:

Search for our courses

~	Diploma in Advance Microsoft Excel
~	Diploma in Microsoft Excel
~	Diploma course in Computerized Accounting + Financial Application
~	Diploma course in Computerized Financial Application (MIS)
~	Diploma In Relational DataBase Management System
~	Certificate course in Microsoft Excel
~	Certificate course in Macros VBA
~	Certificate in Microsoft Excel
~	Certificate in Computerized Accounting & Financial Application
~	Certificate course in Computerized Accounting & Financial Application

Advance Excel Topics Covered


Overview of the Basics

~ ~ ~	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

Management has full right to Change courses, contents, tuition fees without prior notice

COMPUFIELD offers 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.	Management has full right to change courses, contents, tuition fees without prior notice.