loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Advanced Excel training in kolkata for Finance HR

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Take & Make training centre

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Advanced Excel training in kolkata  for Finance HR

Advanced Excel training in kolkata for Finance HR

Baguihati, Kolkata

FREE

No Reviews Yet
3 Interested

About the Course


TAKE & MAKE TRAINING CENTRE
PRESENT:
100% PRACTICAL TRAINING ON CORPORATE ADVANCED EXCEL – BEYOND THE BASIC TRAINING:
FOR DURATION AND FEES ..

- PRACTICAL SESSION: FREE
- eBOOKS – MS-EXCEL 2003 +MS-EXCEL 2007 + MS-EXCEL 2010 *
- IN BUILT EXCLUSIVE FORMATS
- Practical EXAMPLE.xls File


There could be millions reasons. But, you should do it, if you feel that you need to do it for your Professional Career. Believe us, it is require for everyone and you have no idea about the power of Excel until you know it in details.

This training will take you from the very beginning basics of Excel and then straight into a simple set of efficiency rules that will lead you towards Excel excellence.


30 IMPORTANT TEMPLETE FORMATS YOU WILL GET FREE WITH THE TRAINING:
? Most Important File In Excl -All In One
? Attendence Sheet With Salary
? Bill Of Lading Sample
? Debt_To_Income_Ratio_Calculator
? Diary-2012 ( Free Internet Edition)
? Esi Chellan
? Export Invoice
? COMANY MIS REPORT – ( Also HOTEL MIS SAMPLE Format)
? Form 3a (Return Contribution)
? Form 6a (Pf Return Contribution)
? Form-05 (Regulation No. 32)
? HR Monthly Report
? HR MIS Report Format
? Just Daily Attendance Sheet
? KRA & KRA1
? MIS REPORT - FINALCIAL FORMAT
? Outstanding Report
? Payroll In Excel Format
? Petty Cash Vouchers Format
? Rupee in word in Excel
? Salary Sheet Format With Formula
? Salary Slip Format
? Stock Management
? Weekly Planner, Yearly-Calendar
? EMPLOYEE – DATA, INFO, ONLINE, COMPITENCY MATRIX
? Departmental
? Igor's physics class scatter diagram
? Interest Calculators
? Invoices
? Probability.

Admission Procedure: You have to give one Govt. Id and any one Address Proof at the time of admission along with the Admission Fee.
NOTE: THIS PARTICULAR TRAINING YOU CAN DO ON INDIVIDUAL BASIS ALSO. YOU CAN ALSO DO PART OF THE TRAINING ON PER CLASS BASIS.

Topics Covered

CONTENTS:
1. BASIC TOUCH:
• Workbook Vs. Worksheets
• Rows/ Col Feature (Ins/Del, Align, AutoComplete, Auto Calculate)
• Worksheet- Naming, Adding etc.
• Cell Formatting & Converting
• Merge, Wrap, S2F, Border, Fill Effect
• Fill Series ( advanced)
• Referencing (Absolute, Relative Referencing, Mixed Referencing)
• What – If – Analysis, Goal Seek, Data Table, Scenario creation.
2. BASIC TO ADVANCE:
• Chart Analysis & Create charts and graphs
• Table Formatting
• Important Short Cut Keys for Advance Excel
• Multi Level Sorting
• Hide (Both Row/ Column and Work Book)
• Freeze Panes & Un Freeze Panes, Split Window
• Protect Worksheets or Cells or Sheet, Password Protect Security
• Circular References
• Removing Duplicate Values
• Cell Range Naming
• Go To ( Special )
• Paste ( Special )
• Filter Data ( Auto filter, Advance Filter )
• Auditing (Tracing precedents and dependents , Tracing errors, Adding 7 Removing Arrows, Track Errors etc)
• Embedding Object to Excel
• LINKING (Linking between Sheets, Linking between Workbook)
• Macros ( over View)
3. REPORTING
• Conditional Formatting ( Basic to Advance)
• Page Setup & Print Formatting
• Grouping & Sub-total Criteria
4. DATA HANDLING
• Data Validation (List with IF Condition, Input or Warning Message)
• PIVOT TABLE ( Using data sources, Consolidation ranges, Customizing PivotTable layout, PivotTable advanced options, Pivot Charts )
5. F PREVIEW
• Function Vs. Formula
• Multi Array Function
• BASIC FUNCTIONS:
SUM(),MIN(),MAX(),LARGE(),SMALL(),AVERAGE(),AVERAGEIF(),COUNT(),
COUNTA(),COUNTIF(),RANK(),SQRT(),SIGN(),PRODUCT(),ABS(),MOD() etc
• All ROUND type Function
6. DATA LOOK UP FUNCTIONS
• VLOOKUP(), HLOOKUP()
• MATCH() VS VLOOKUP()
• INDEX(), INDEX() WITH MATCH()
• CHOOSE()
• VLOOKUP() WITH CHOOSE()
• INDEX() WITH MATCH()
• Text to Columns
• Find & Replace (also with Wild Card Characters like *,?,[],`)
7. LOGICAL FUNCTION –
• AND(), OR(), NOT(), MINA(), MAXA() ETC.
• IF(),NESTED IF(),IF MIXED WITH OTHER FUNCTIONS LIKE AND(),MAX() ETC.
8. DATE & TIME FUNCTIONS
• NOW(),TODAY(),DATE(),TIME(),DAY(), MONTH(),YEAR(),
• WEEKDAY() & DDDD FORMAT,,WORKDAYS(), NETWORKDAYS(),
• HOUR(), MINUTE(), SECOND(), WEEKNUM(),DATEDIF()
9. TEXT FUNCTIONS
• PROPER(), LOWER(),UPPER(),VALUE(), REPLACE(),LEFT(),
• RIGHT(), MID(),TRIM() , LEN(),CONCATENATE() VS. &
10. SPECIAL FUNCTIONS
• REPT(),CLEAN(),EXACT(),HYPERLINK(),TRANSPOSE(),PMT(),
• SUMIF(),SUMPRODUCT(), SUBTOTAL()

? EXTRA ORDINARY SPECIAL BONUS TIPS AND TRICKS:
Linking Between Word and Excel Through Mail Marge
Add Picture to the Comment Box
Autocorrect Option
Automatic Formula Calculation
Enter Key Direction in Excel
Disable Fill Handle or Drag n Drop
Install Excel Add Ins
Adding/ Removing / Moving Quick Access Toolbar
Minimizing / Maximising Ribbon & Changing the Colour
Quick Referencing ( R1C1 )
Quickly Add Headers in Excel
Removing Grid Lines from Excel
Installing CAMERA in Excel
Converting Excel file to PDF
LASTLY, KNOW HOW EXCEL CAN SPEAK TO YOU!!

Who should attend

WHO & Why ADVANCED excel training?

*Working Professionals: Efficiently use spreadsheets, get noted by seniors.
*Experienced Working Professionals: To get promoted.
*Job Seekers: To get a good Job based on Admin, Finance or HR.
*Any Finance or HR Professional: To know the real POWER of Excel.
*Any Administrative Professionals: To save Huge time.

Pre-requisites

nil

What you need to bring

Admission Procedure: You have to give one Govt. Id and any one Address Proof at the time of admission along with the Admission Fee.

Key Takeaways

The ability to do anything with Excel for Finance or HR
Gallery
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 10 of 16
U

Uttam 30/05/2016

want a training instiute at kolkata advanced excell

0 0

Answer

You can add upto 6 Images

S

Sumit 02/10/2014

Hi.
I want 2 know full address & class schedule.

0 0

Answer

You can add upto 6 Images

U

Depon Das 28/05/2014

Hi,
I am Depon Das , Please inform me about your training institute details address and contact number.
Tell me your institute time.

0 0

Answer

You can add upto 6 Images

U

sayantani neogi 02/04/2014

I want to do this advance excel course. Send me contact details and course fee.

1 0

Answer

You can add upto 6 Images

U

aninditadas 11/03/2014

I would likr to do a course on advanced msexcel.please send me the contact details of the institution.

0 0

Answer

You can add upto 6 Images

U

Santanu Dey 26/01/2014

Please let me know the contact no and address of the Institute asap.

1 0

Saurav | 11/12/2015

Please call me for details....I have not found your contact number

1 0

Answer

You can add upto 6 Images

U

23/01/2014

Please inform me about detail address of the training Institute at Kolkata, Baguihati and also contact number. Is there any weekend batch?

1 0

Answer

You can add upto 6 Images

U

12/12/2013

Please inform me about detail address of the training Institute at Kolkata, Baguihati. and also contact number.

0 0

Answer

You can add upto 6 Images

U

12/12/2013

Dear Candidate (s),
The total duration is two months. It will be total 12 hours training which we have divided into 8 classes.
We are starting a new batch soon. Please, enroll through http://www.UrbanPro.com

0 0

Answer

You can add upto 6 Images

U

11/12/2013

Please let me know the duration and course fee in details and also the
institute address through my email.
Santanu


0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer


http://www.ratulbanerjee.weebly.com
Seats Left-

Students Interested 3

Course Id: 4076