Open Excel – Open the Powers of Excel

June 5, 2009

An important and indispensable ADD-IN for every excel user

Open Excel fills the gaps one may encounter in Excel 2007 and it also automates many of the frequently used tasks. It saves a lot of time and speed up the work. Whether you’re a beginner or advanced user, you know functions or macros or neither, you’re gonna use it, since it reduces manual inputs, increase accuracy, add efficiency and makes your work a quality work.

You must have encountered Gaps in Excel :

1.  If you’ve encountered copy error, while copying discontinuous range of data.

2.  If you want to run a charts slide show.

3.  If you want to detect and delete blank rows or columns in selection.

4.  If you want to calculate number of business days between two columns of date data.

5.  If you want to invert the selection.

6.  If you want to delete the pivot tables.

7.  If you want to sort all worksheets by their name.

8.  If you want to find or select all cells with same color as active cell color in the worksheet.

9.  If you want to spell numbers like 4006831 in words like Four million six thousand eight hundred thirty one.

10.If you want to remove all blank worksheets present in active workbook.

11.If you want to merge 2 or more worksheets with same columns heading.

12.If you want to select entire row or column of selection.

There are such more than 100 utilities embedded in this free and essential add-in. Some of them fills the gaps in excel and else automates the frequently used tasks.


Meaning of Open Excel

It means power of Open source for excel users. Those users who want to know the source code for their other personal uses can visit source code page here. This add-in is absolutely free considering the need of today’s real world where boss don’t want to spend an extra penny and its users are looking for an angel as in this conversation.

Boss: I’m mailing you a report, you’ve to format it in least possible time.
You: Ok, what is to be done.
Boss: Add ’0′ to first column, convert all formulas to values, remove hyperlinks, trim all the data, remove empty rows and calculate number of business days(excluding saturdays and sundays) between project start and end dates. and yes all of this in 30 minutes. It’s urgent and important.
You: Ok sir.

and when you look at the data, it’s around 10000 rows and all you can think of is an angel.


Why should I choose Open Excel and not anyone else?

Single Reason to choose: It is distributed free, which means you don’t need to purchase either the add-in or its license to use it. You can use it the way you want, where you want (Office or Home) or when you want from the moment you download it which can save your lots of time by adding accuracy and efficiency to your excel work.


Multiple reasons to avoid:
1. If you love to do your daily excel work manually.
2. If you love this statement atleast twice a day: “To err is human.”
3. If you don’t want to have free time for you and your loved ones.
4. If you’re against technological enhancements.
5. If you’re against free softwares.
6. If you dislike me (the developer of OpenXL)
7. If you don’t use excel.
8. If you dislike your organization and want to waste its most powerful resource, TIME.
9. If you already work faster and more accurately than computer.


Difference between Open Excel and Open Excel Plus:Open Excel is for Excel 2003 and Open Excel Plus is for Excel 2007.

Screenshots of Open Excel

June 4, 2009
Main Menu

Text Utilities Menu

Insert Text Dialog Box

Number Utilities Menu

Row/Column Utilities Menu

Select Utilities Menu

Date Utilities Menu

Sheet Utilities Menu

Information Utilities Menu

System Utilities Menu

Pivot Utilities Menu

Chart Utilities Menu

Launch Utilities Menu

Speak Utilities Menu

Web Utilities Menu

Videos: Watch Open Excel Features in Motion

June 3, 2009

Demo of Open XL Features

Features of Open Excel

June 2, 2009
Main Menu

1. Copy Multiple Selection: By default, Excel don’t allow copy-paste of discontinuous range of data, use this Open XL utility to copy and paste the discontinuous set of data.

Text Utilities Menu

2. Insert Text:
3. Reverse Text:
4. Extract Digits
5. Extract Alphabets
6. Change Case
>>  7. Upper Case:
>>  8. Lower Case
>>  9. Proper Case
>>  10. Sentence Case
>>  11. Toggle Case
12. Trim Spaces
>>  13. Left
>>  14. Right
>>  15. Both
>>  16. Excessive
17. Delete Text
>>  18. Left
>>  19. Right
>>  20. Custom Delete
21. Apply Rainbow Color
>>  22. Dark
>>  23. Light
24. Super/Sub Script
>>  25. SuperScript First Character:
>>  26. SubScript First Character
>>  27. SuperScript Last Character
>>  28. SubScript Last Character

Insert Text Dialog Box

Number Utilities Menu

29. Convert Formula to Values
30. Convert Text to Values
31. Convert Numbers to Text
32. Change Sign
33. Spell Numbers

Row/Column Utilities Menu

34. Remove Empty Rows
35. Remove Empty Columns
36. Insert Empty Rows
37. Select Odd Rows
38. Select Even Rows
39. Select Odd Columns
40. Select Even Columns

Select Utilities Menu

41. Invert the selection
42. Select Entire Row
43. Select Entire Column
44. Select Active Cell Value
45. Based on Type

>>  46. Empty Cells
>>  47. Non-empty Cells
>>  48. Protected Cells
>>  49. Non-protected Cells
>>  50. Hidden Cells
>>  51. Formula Cells
>>  52. Non-numeric Cells
>>  53. Numeric Cells
>>  54. Errorneous Cells
55. Based on Value
>>  56. Odd Numbers
>>  57. Even Numbers
>>  58. Duplicate Values
>>  59. Unique Values
>>  60. Hyperlinked Cells
>>  61. Commented Cells
62. Based on Format
>>  63. Active Cell’s Font Color
>>  64. Active Cell’s Interior Color
>>  65. Bold Cells
>>  66. Italic Cells
>>  67. Underlined Cells
>>  68. Limited Length Cells

Date Utilities Menu

69. Calculate Business Days
70. Calculate Total Days
71. Calculate Week Differences
72. Calculate Total Months
73. Calculate Total Quarters
74. Select Current Year Dates
75. Select Current FY Dates

Sheet Utilities Menu

76. Insert Empty Sheets
77. Remove Empty Sheets
78. Color Sheet Tabs
79. Remove color from tabs
80. Unhide all sheets
81. SuperHide ActiveSheet
82. Sort Worksheets
83. Export Active Sheet as workbook
84. Export All sheets as Individual Workbooks
85. Merge Worksheets
86. Protect All Worksheets
87. Unprotect All worksheets
88. Save selected sheets

Information Utilities Menu

89. Count Duplicates
>>  90. in Selection
>>  91. of Active Cell
92. Count Selected Cells
93. Count Colored Cells

System Utilities Menu

94. Save Selection as Image
95. Remove Macros
96. Remove External Links
97. Remove Hyperlinks
98. Close Saved Files
99. Force Save
100. Copy all Worksheets to MSWord

Pivot Utilities Menu

101. Remove all Pivot Tables
102. Count Pivot Tables

Chart Utilities Menu

103. Count Charts
104. Run Charts Slideshow
105. Remove all charts

Launch Utilities Menu

106. Launch Camera
107. Launch Calculator
108. Launch Spell Checker

Speak Utilities Menu

109. Speak Cells
110. Stop Speaking
111. By Rows
112. By Columns
113. On Enter

Web Utilities Menu

114. Search on Microsoft Windows Live
115. Search on Google
116. Search on Yahoo
117. Search on ww.ExcelItems.com
118. Search on E-Bay
119. Excel Forum
120. VBA Codes
121. VSTO Codes
122. Excel Downloads
123. Contact a Trainer
124. Donate Us
125. About Us

Contact Us

June 1, 2009
Ultimate Destination for Best Work in Least Time

We showed our expertise in Excel, VBA and VSTO here. Take a look below and you’ll be having a fair idea of our domain of work where our compact and solid organization could help you.

Office Productivity: MS Office, Sharepoint Server, MS Project 2007
Business Objects: Xcelsius, Crystal Reports
Programming  Languages: VS2008, Perl, C, C++, VBA, VSTO
Web languages: Ajax, Flex, JSP, Joomla, CMS

Few Solutions: Corporate trainings, Wiki, Blogs or Blog Templates, Excel/Project Dashboards, Website Development, Desktop Solutions, Web Services
Simple Note: Contact us for any kind of IT work, this is just the Trailer.

Regards

Ayush Jain
ayushjain@openexcel.com
+91.9891377633

Download Open Excel

May 31, 2009

Note: It is essential to join our Google group when you click download link to proceed and use.


OPEN EXCEL (Open XL)

>>>Pre-requisites:
1. Microsoft Excel 2007
2. Microsoft .NET 3.5 Framework (Optional, if internet connection available)
3. VSTO 3.0 for Runtime (Optional, if internet connection available)

>>>Version History
v 1.0.0.0 – Download Link here.


INSTALLATION

1. Download the Zip file from the link provided above.
2. Run the Setup file.
3. Open Excel 2007 and check if the Open XL menu appears as shown below. If Yes, then Enjoy !!


Testimonials

April 25, 2009

Hello world!

April 21, 2009

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!

Donate Us

April 5, 2009

Please

If you feel grateful towards this add-in and would like to contribute some amount as a token of thanks, we would be highly obliged to you for this nice gesture.

Improvement is everywhere and so does with Open XL. Our endeavour is not for money but for millions of Excel users who uses this application and faces problem.

Your small contribute can spark up our efforts, it will definitely accelerate its development process.

It will help us against fighting those peoples who refuses to share knowledge and monetize everything that came across to them.

Your donation might seems small to you, but we consider every single penny as tons of thanks from you.


Please



Follow

Get every new post delivered to your Inbox.