Who Should Attend
Managers and Executives, who have to manage, analyze and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.
Upon completion of the course, participants will be able to:
Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
Apply the function learnt to consolidate records.
Acquire skills to analyze the records for operations and reporting purposes.
Employ new ways of tabulating and managing data.
Manage the Usage of Dates & Data’s
MONTH, YEAR, DAY, DATE, COUNTIF, SUBTOTAL, DATEDIF formula, Advanced Auto-Filter Function, Absolute and relative reference
Quick and Accurate Way to Select Records
Building Complex formulas
MID, SEARCH, FIND, SUBSTITUTE, LARGE, SMALL
Merging 2 Lists into One
VLOOKUP, HLOOKUP, SUBTOTAL, REPLACE, MATCH, INDEX, INDIRECT, CHOOSE and more…
Unleashing the Power of Formulas
SUMIF Formula, SUMIFS, SUNPRODUCT, ARRAY, TEXT TO COLUMN Function
Analyzing Business Data in Double Quick Time
PIVOT TABLE function
Tapping the Power of Pivot Chart
Recording Macros to Speed Up Repetitive Tasks
Use Relative References
Duration: 12 Hours ~ Course Fees or Investment : Rs.2500
We have extensive experience in working with clients to gather requirements and in building the exact report necessary for your organization.
Consultants abound for almost any business situation in any industry -- whether manufacturing, education, healthcare, telecommunications, entertainment, or virtually any other slice of the economy -- bringing expertise in finance, accounting, IT, marketing, operations, strategy, or nearly any other functional discipline.
We take Microsoft Excel Classes on Excel 2003 / Excel 2007 / Excel 2010 and Mac too...
Send your Excel questions in advance via e-mail rajesh.xls @ gmail.com or bring them to the class.
Batch Details Timing:
Week Days: Morning - 06:00 IST - 07:30 IST (1:30 Hours) 2 days Per Week
(Mon-Sat) Evening - 20:00 IST - 21:30 IST (1:30 Hours) 2 days Per Week
21:45 IST - 23:15 IST (1:30 Hours) 2 days Per Week
(Online Classes one to one @ Internet)
We take online classes 30 Hours per week 3 Hours
Who can attend this Excel Hours?
This program is only for the Working professional only not for students or fresher.
…I will not teach you just a formula, because there is no point in me teaching you that, if any want to learn a formula, please use the Excel help or Excel Dictionaries. I will teach only the concept of the formula; mainly why this formula, what is the purpose, if this formula is the best option or some other way is available. When you understand the concept of the formula, you can innovate in your own style with your own views. For that I will help you in person, like a personal instructor to you.
For more details and Demo contact Rajesh - 98865 17585, only limited seats available
Email: rajesh.xls [at] gmail.com; Website: www.excelhours.yolasite.com