![Profile of Trainer S. Sharma
More than 6 years of Training Industry experience
Trained more than 1000 Professionals
Trained at esteemed oraganizations like TATA Power, JP Morgan, Axis Bank, Asian Paints,
Birla Sunlife, ITC Ltd., K. Raheja Group and many more
Excellent Communication skills
Result oriented training approach
Academics:
M.Tech in Computer Science NMIMS, 2011
Computer Engineering Mumbai University, 2006
Diploma in Computer Tech Mumbai University, 2003
Technical Skills:
RDBMS: SQL-2003,MS-Acess-[2003,2007]
Ms-Project, Word, Excel, PowerPoint ,outlook [2003, 2007,2010],Open Office 3.0 (Cal, Impression)
HTML, DHTML
C, Visual Basic, VBA, Excel-VBA
(c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com 6](https://image.slidesharecdn.com/aarkexprofile-121226235459-phpapp01/85/Advanced-Excel-Basic-Excel-Training-6-320.jpg)
Advanced Excel &Basic Excel Training
- 1. BASIC ADVANCED MS Excel Training MS Excel Training
- 2. Clientle served by our Trainer since 2007 Mahindra & Morgan Stanley JP Morgan Axis Bank Asian Paints Mahindra Advantage Times Global TATA Motors TATA Power HDFC ERGO HSBC Bank Broadcasting IDFC Ltd ITC Ltd Kotak Securities Citibank eClerx Ltd ICIC Prudential Gujarat Ambuja Ultra Tech Life Insurance Loreal India Mastek Cements Cement Volkswagen and many Ebay India Zycus Infotech Ratnakar Bank India more (c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com 2
- 3. Excel Basic Course Content 8 hrs (1 Day) Module-1 | Introduction of Spreadsheet Explore, Ribbon, Toolbar, Labelling, Saving, Updating Module-2 | Formatting a Worksheet Formatting Numbers, Text, Wrap, Find, Replace, Shading, Borders, Table, Paste Special Module-3 | Understanding Cell References and Range Name References, Relative References, Absolute Ref, Mixed Ref, Range Name, Series Module-4 | Working with Simple Formulas and Functions Basic Func: Sum, Avg, Max, Min, Count, Countif, SumIf, Vlookup, Hlookup Module-5 | Sorting, Filtering Data and Charting Simple Sort, Auto Filter, Custom Auto Filter, Simple Charts & Stats Module-6 | Printing Options Page orientation, Paper Size, Headers, Footers, Margins, Column & Row Settings Requirements: - Basic Computer Skills Module-7 | Text and Date Functions - Separate Computer per Date /Text Func, Text to Column, Remove Duplicates, Freeze Panes, Split Trainee - Projector for more Module-8 | Pivot Table and Subtotal than 5 Trainees Pivot Table Wizard, Cross Tab Report, Report Filter, Display Subtotal (c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com 3
- 4. Excel Advanced Course Content 16 hrs (2 Days) Module-1 | Introduction to Excel Excel Overview, Ribbon Interface, Changing Default settings, Quick Access Toolbar, Personalization Options Module-2 | Understanding Cell References and Range Name References, Relative References, Absolute Ref, Mixed Ref, Range Name, Series Module-3 | Working with Formulas and Functions Conditional Func, Logical Func, Nested If, Database Func, DSUM, DCOUNT, DMAX, DMIN, DGET Module-4 | Lookup and References Functions Vlookup, Hlookup with IFERROR & Match Func, Nested V Lookup, Index-Match Func Module-5 | Data Validation and Protection Validating Cell Entries, Protecting Worksheet, Creating & Managing Templates Module-6 | Sorting and Filtering Data Simple & Advanced Sort, Auto Filter, Custom Filter, Advanced Filter Module-7 | What if-Analysis Tools Goal Seek Command, One & Two Variable Data Tables, Scenario Summary Report, Display Scenario Requirements: - Basic Excel Skills Module-8 | Formatting Features Table Format, Conditional Format, using formulae & vlookup - Separate Computer per Trainee Module-9 | Importing Data Importing Text files, Importing data from database - Projector for more than 5 Trainees Module-10 | Macro & Custom Functions Running & Recording a macro, Working with VBA, Creating user defined func, Assigning a Macro to a func. (c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com 4
- 5. Features 100 % Practical Training Weekend batches at your doorstep Projector-based training with one PC per participant Course Material available on request One of the most nominally charged across the sector No Advance payment required Client data privacy and security (c) www.AarkEx.com | 0091-86 8989 5577 | AarkExIndia@gmail.com 5
- 6. Profile of Trainer S. Sharma More than 6 years of Training Industry experience Trained more than 1000 Professionals Trained at esteemed oraganizations like TATA Power, JP Morgan, Axis Bank, Asian Paints, Birla Sunlife, ITC Ltd., K. Raheja Group and many more Excellent Communication skills Result oriented training approach Academics: M.Tech in Computer Science NMIMS, 2011 Computer Engineering Mumbai University, 2006 Diploma in Computer Tech Mumbai University, 2003 Technical Skills: RDBMS: SQL-2003,MS-Acess-[2003,2007] Ms-Project, Word, Excel, PowerPoint ,outlook [2003, 2007,2010],Open Office 3.0 (Cal, Impression) HTML, DHTML C, Visual Basic, VBA, Excel-VBA (c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com 6
- 7. Our Other Services MS Access Training Macros & VBA MS Power Solutions Point Training Excel Based Project Other Open Office Structure Services Training Design +91-86 8989 5577 AarkExIndia@gmail.com www.AarkEx.com (c) www.AarkEx.com | 0091-868989 5577 | AarkExIndia@gmail.com 7