ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

MS Excel Training Solutions

•Download as PPSX, PDF•
•
A
aarkex

This document provides information about MS Excel training courses offered by AarkEx. It outlines the features of basic and advanced Excel courses, including practical training, weekend batches, course materials, and no advance payment required. The basic course covers introductory formatting and formulas over 8 hours for Rs. 1500, while the advanced course covers more complex functions, data tools, and macros over 16 hours for Rs. 2800. Requirements include basic computer skills and a separate computer per trainee. The trainer has over 6 years of experience training over 1000 professionals at major companies. AarkEx also offers other training services like MS Access, PowerPoint, and OpenOffice.

1 of 7
Downloaded 34 times
BASIC ADVANCED MS Excel Training MS Excel Training
Features • 100 % Practical Training • Weekend batches at your doorstep • Inhouse case studies & assignments • 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 Graduate Students Financial Analysts Entrepreneurs Who Should Management Marketing Self Employed Attend? Students Professionals Job Seekers HR Professionals Investment Advisors (c) www.AarkEx.com | 0091-98 2296 3201 | AarkExIndia@gmail.com 2
Clientele 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-98 2296 3201 | AarkExIndia@gmail.com 3
Excel Basic Course Content – 8 hrs (Rs. 1500/-) 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-98 2296 3201 | AarkExIndia@gmail.com 4
Excel Advanced Course Content – 16 hrs (Rs. 2800/-) 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-98 2296 3201 | AarkExIndia@gmail.com 5
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-98 2296 3201 | AarkExIndia@gmail.com 6
Our Other Services MS Access Training Macros & MS Power VBA Point Solutions Training Excel Based Other Open Office Automation Services Training Projects +91-98 2296 3201 AarkExIndia@gmail.com www.AarkEx.com (c) www.AarkEx.com | 0091-98 2296 3201 | AarkExIndia@gmail.com 7

More Related Content

MS Excel Training Solutions

  • 1. BASIC ADVANCED MS Excel Training MS Excel Training
  • 2. Features • 100 % Practical Training • Weekend batches at your doorstep • Inhouse case studies & assignments • 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 Graduate Students Financial Analysts Entrepreneurs Who Should Management Marketing Self Employed Attend? Students Professionals Job Seekers HR Professionals Investment Advisors (c) www.AarkEx.com | 0091-98 2296 3201 | AarkExIndia@gmail.com 2
  • 3. Clientele 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-98 2296 3201 | AarkExIndia@gmail.com 3
  • 4. Excel Basic Course Content – 8 hrs (Rs. 1500/-) 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-98 2296 3201 | AarkExIndia@gmail.com 4
  • 5. Excel Advanced Course Content – 16 hrs (Rs. 2800/-) 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-98 2296 3201 | 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-98 2296 3201 | AarkExIndia@gmail.com 6
  • 7. Our Other Services MS Access Training Macros & MS Power VBA Point Solutions Training Excel Based Other Open Office Automation Services Training Projects +91-98 2296 3201 AarkExIndia@gmail.com www.AarkEx.com (c) www.AarkEx.com | 0091-98 2296 3201 | AarkExIndia@gmail.com 7