search
search
» » » » » 100% PRACTICAL TRAINING ON CORPORATE ADVANCED EXCEL – BEYOND THE BASIC TRAINING

100% PRACTICAL TRAINING ON CORPORATE ADVANCED EXCEL – BEYOND THE BASIC TRAINING

- Kolkata
Posted on: 6th October, 2016 | 08:39:AM
Reply to: (Use contact form below)
Posted by: TNM TRAINING
Fee: INR5500.00
Ad Type: I am offering a class
I am:: A Professional/Business
Contact Name: +919831752505
Phone Number: +917044452505
Address1: AA-1/2 DESHBANDHU NAGAR,BAGUIATI, KOLKATA-700059
Address2: NEAR LOCATION DESHBANDHU NAGAR POST OFFICE.
TAKE & MAKE TRAINING CENTRE PRESENT:
100% PRACTICAL TRAINING ON CORPORATE ADVANCED EXCEL – BEYOND THE BASIC TRAINING:

- PRACTICAL SESSION
- eBOOKS – MS-EXCEL 2007- 2016 *
- 30 IN BUILT EXCLUSIVE FORMATS
- Practical EXAMPLE.xls File
WHO & Why ADVANCED excel training?
1. Working Professionals: Efficiently use spreadsheets, get noted by seniors.
2. Experienced Working Professionals: To get promoted.
3. Job Seekers: To get a good Job based on Admin, Finance or HR.
4. Any Finance or HR Professional: To know the real POWER of Excel.
5. Any Administrative Professionals: To save Huge time.
6. Any CA/ICWA/LLB/CS/M.COM/MBA Students : For better Future.

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.
FOR CONTENTS, PLEASE, VISIT OUR WEBSITE:
http://www.tnmtraining.com
PLUS:

30 IMPORTANT TEMPLETE FORMATS YOU WILL GET FREE WITH THE TRAINING:





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
KNOW HOW EXCEL CAN SPEAK TO YOU!!
And MANY MORE..

FREE...FREE..FREE.FREE..FREE.FREE.FREEE
SOFT COPY OF EXAMPLE.XLSX WHERE ALL EXAMPLES ARE STORED.
eBook – Excel 2007 ( 142 pages)
eBook – Excel 2010 ( 151 pages) WAIT..WE HAVE MORE.......................

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.


100% PRACTICAL TRAINING ON CORPORATE ADVANCED EXCEL – BEYOND THE BASIC TRAINING

It is ok to contact this poster with commercial interests.

30 hits | Post# A527710

Report Abuse | Email this Ad

Contact this User: 
 
Your email: *
Message: *
Security Code: *
Enter the code shown above into this textbox
 

related

Institute of Good Clinical Practice :- Institute of Good Clinical Practice provides internship for aspiring professionals willing to pursue
Training Clinical Data management on Electronic Data Capture Tool EDC

SQL School is one of the best training institutes for SQL Server DBA Training and MSBI Training. We have been providing Online and Classroom Trainings
PRACTICAL SQL Admin ONLINE TRAINING DURING WEEKENDS

AIG is Advanced Innovative Group that collaborates with forward looking individuals and organizations for providing structured and globally accepted p
Advanced Six Sigma Certification

SQL School provides Interactive & video training and Practical Online Trainings and Classroom Trainings. We are specialized in SQL Server Technolo
Excellent Real Time video Training on Business Intelligence Only @ SQL School

Excellent Training and live Exposure on All Aspects in Iphone/Ios Silver IT Solutions, we provide Software training and JOB Placement services for a
Excellent Training and live Exposure on All Aspects in Iphone/Ios

100% PRACTICAL TRAINING ON CORPORATE ADVANCED EXCEL – BEYOND THE BASIC TRAINING, India, Worldwide, Classes, Other Classes