www.EXCELITEMS.com

May 31, 2009

Introduction

Filed under: Uncategorized — ashishjain @ 7:00 pm

Brief Description

Hi Friend, Welcome to ExcelItems –  You’ve been come to right place, if you’re an excel user and looking for some related material. From books to trainers, macros to free downloads, solutions on discussion forums, we’re fully equipped with Excel items here. Ok, have you heard about OpenXL yet? Yessss ! and then you should know it’s our product helping thousands of excel users from newbie to amateur to professionals one. If you’re still unaware of it, then use it today.


Discussion Board

Our discussion board is largest Google group with the name, MS Excel and VBA Macros, Here is the link: http://groups.google.com/group/excel-macros/.

This group is 2 years old and 100% resistant to spam, serving above 4000 worldwide members. Microsoft’s Most Valuable Professionals(MVP) like Rodney Powell is active member of this community.


Open Excel

It’s Power of Open Source in Microsoft Excel. Yes, It’s a free add-in with source code provided to you on this website from our developer, Ashish Jain. It solves many Excel 2007 problems and automates frequently used tasks for you.

For e.g. it provides Excel 2003 style menu in Excel 2007, super hide a worksheet, run charts slide show, calculate number of business days between two dates, remove all macros, can append 0 to any number of cells and much more. To explore – visit OpenXL here.


VBA Macros Collection

Have you ever visited a website with full collection of VBA macros, so that you need not to go on another website? We hope you find us of this type. We are in continuous endeavor to provide you with latest research of us on Macros, so that you don’t waste your precious time in developing what already has been developed. Click here to visit our VBA Macros collection.


Tutorials

Today, there are so many institutions, schools, colleges and teachers but where are the good ones? The Good one is you itself, yes we can learn and study better than ever and without anyone. But yes, we need a best guide for best results. Our tutorials are designed in step-by-step manner to help every kind of excel user from newbie to professional and from America to East-Asia. Moreover, they are online and Free.

Click here to access them.


Books

If you talk about our experience then we must say books are far better than any online material. If you’re really serious about learning VBA, VSTO or Excel/Access 2007 then we’ve searched and collected some books for our readers. They’ll help you a lot.

and yes the first link on this Books page is MS Office 2007 Home and Student edition in its cheapest price only through our website. Always use Genuine products, since purchasing a product provides you with support and keeps you away from hassles. Click here to access books.


Free Downloads

We keep on researching and developing the best excel products and add-ins for you. Moreover they’re free. Please explore our downloads section and you’ll find Stock Trackers for almost major world exchanges, Open XL, EMI Calculator, Budget Planner, CPI calculator and much more . . .

We do not warrant that downloads and examples will meet your requirements or that their operations will be error free but if you report us, we may help you out in removing errors, if any or will improve it to meet your requirements. Please report enhancements/bugs to our Forums. Click here to explore our downloads section.


Call a Trainer

If you’re looking to learn excel in step-by-step manner, we’re here to help you. Our professional tutors are Microsoft Certified developers and users and are in the field of training for 3 years (on average).

We deal in every level of training for your every need. i.e. from Beginner to advanced level of training for Excel, VBA and VSTO.

Click here to Call a Trainer.


About me

In India, there is saying “If we know us, we’ll get Nirvana (free from the cycle of birth and death)”. So, the one who is still searching about him, can tell you what about himself?

But if you still wanna know, who is the author of http://www.excelitems.com, please visit this link.


April 10, 2009

Tutorials to Learn MS Excel 2007

Filed under: Uncategorized — ashishjain @ 7:00 pm


Tutorials


Microsoft Excel 2007

—-Beginner
      1. Introduction to Microsoft Excel 2007 and its components
      2. 10 ways to move in a worksheet in MS Excel 2007
      3. View more data in a worksheet
      4. Move between worksheets and Open workbooks
      5. Go to Cells quickly in Excel 2007
      6. Select Cells Using Keyboard and Mouse
      7. How to enter and delete data in MS Excel 2007
      8. How to edit or modify a cell in Excel 2007

—-Intermediate

—-Advanced


Excel Functions

—-Beginner
—-Intermediate
—-Advanced


MS Excel Macros Programming

—-VBA

——-Beginner
——-Intermediate
——-Advanced

—-VSTO

——-Beginner
——-Intermediate
——-Advanced


April 2, 2009

VSTO Macro Codes Examples

Filed under: Uncategorized — ashishjain @ 7:00 pm


Visual Studio Tools for Office ( Macros Collection )


Workbook

Worksheets

  1. Sort all sheets
  2. Remove blank worksheets from Current workbook
  3. Color all Sheet Tabs
  4. Remove color from all sheet tabs
  5. Protect all worksheets
  6. Remove Password (Unprotect) all worksheets
  7. Insert ‘n’ number of Blank Worksheets


Range

  1. Color a range based on its percentage value

Select

  1. Invert the Selection

Number


Rows/Columns

  1. Delete Blank Rows
  2. Remove Empty Columns

Text

  1. Change Case (Upper, Lower, Proper, Sentence and Toggle)
  2. Remove Extra Spaces (Left, Right, Both sides and from Inside)

Format

  1. Partly Background Color a Cell (Coloring only a portion of Cell)

Form

  1. Resize Form during Run-Time

Event Macro

  1. Example of Worksheet_Change Event Macro

Miscellaneous

  1. Access Internet Explorer (Search Engine Example)
  2. Change Image Location
  3. Copy Excel Worksheets to MS Word

April 1, 2009

About us

Filed under: Uncategorized — ashishjain @ 7:00 pm

Meet your Blog Author


Name :
Ashish Jain
Age : 25 years.
Interests: Writing Blogs, Solving Excel queries, River Rafting in Rishikesh, Freaking out with Friends


Job Profile : I’m working with CSC India Pvt. Ltd. as Demand Coordinator, helping the organization with my Excel Automation expertise. My total work experience tolls to 20+ months. I consider MS Excel as best analytical tool that is used by newbie to highly technical person all over the world. I particularly like Pivots, Charts and Macros in Excel.


Academic Qualification : Master of Computer Applications, M.Sc. (Mathematics)
Technical Qualification : Microsoft Certified Professional, Microsoft Certified Application (Excel) Specialist


Other Interests : Passionate about Success, Deliver lectures and seminars on Leadership, Positive Thinking and Relationship Handling (Behavioral) and on MS Excel, Scripting Languages like Perl, Shell Scripting and VB Script(Technical).


March 23, 2009

Call/Contact Trainer for Excel/VBA/VSTO

Filed under: Uncategorized — ashishjain @ 8:51 am

What makes us one of the best corporate excel trainer?

1. Our Course Content (as given below)
2. Microsoft Certified Persons
3. Training exposure to all industries. viz. Electronics to Finance.
4. Ready spreadsheets for hands on experience.
5. Step-wise example files.
6. Understanding of real needs.
7. Quality assessment
8. Relevant examples.

We’re flexible with training hours and course content. Please go through our standard course content given below and feel free to contact us anytime for your queries and confirmations.

Call us: 09999-40-48-43
Mail: jainashish@live.com
Course Content available here


Blog at WordPress.com.