Posted: 1 month ago

Hidden Mysteries in Data Analysis with Excel

Shortlist Click to Shortlist
  • Courses: Software Training
  • Locality: HAL Layout
  • Posted by: Learner
+91 98865 17585

Send Email Response

Description for "Hidden Mysteries in Data Analysis with Excel"

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.
Learning Objectives
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.
Course Outline
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
GOTO function
Building Complex formulas
Merging 2 Lists into One
Unleashing the Power of Formulas
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
About Us:
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 @ 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]; Website:

See more ads by this user
Mark as Spam
Safety tips for buyers / sellers
Use      keys to browse Next/Prev ads
Looking for Software training course in HAL Layout :
Get similar ads More details
Courses - Software Training | Locality - Bangalore East
Posted: 7 days ago by Learner   |   Computer courses - Bangalore
Courses - Software Training | Locality - HAL Layout
Posted: 1 month ago by Learner   |   Computer courses - Bangalore
Promote your business on
(Premium packages / Banners / Leads)
Mail us at