MVP logo
    Your browser: , Version
Monday, 15.10.2018, 8:58 PM
Hello! Guest | Group Guest | RSS
Home | XLRibbon Products | Profile  | Login
Saytın menyusu

Sorğu
Saytın hansı bölməsini daha çox maraqlı hesab edirsiniz?
Səsvermə sayı: 129

Statistika

Total online: 1
Guests: 1
Users: 0

Müsabiqələr

Optimize Your Business with - "XLRibbon" Products:

"MyExcelWorld" - Time-Saving & Multi-Language Excel Add-in.

This Powerful Microsoft Excel Add-in for 2007-2016 will save your time when working with Cells, Formulas, Texts, Sheets and Workbooks.

It supports Big Ranges and over 10 languages. It contains over 20 the most wanted UDF's and Web-based functions such as GoogleTranslate() and also many upcoming new features.

Unconditional 30 Day Guarantee:
After you purchase the MyExcelWorld Add-in, you may return it for any reason, within 30 days. Your purchase amount will be fully refunded.

One Perpetual License Only for $33

These percentage discounts are applied automatically to your order.
The following discounts are available for multiple Items:

  • For 2 items -> 10% discount
  • For 3 items -> 15% discount
  • For 4 items -> 20% discount
  • For 5 items -> 25% discount
  • For 6 - 20 items -> 35% discount
  • For 21 - 50 items -> 40% discount
  • For 51 or more items -> 50% discount

"Customer support center" is available 24/7

 

For MyExcelWorld Excel-Add-in Video Tutorials Click here

The Most of Powerful Features of "MyExcelWorld" - Microsoft Excel Add-in general working scope as following:
- Works instantly in Big Range(s) (for ex: over a million cells);
- Protected sheets;
- Filtered Ranges/Visible cells only;
- Merged cells;
- Non-continuous Ranges/Multi-Ranges;
- Undo instantly and etc.

 

List of UDFs'

Definitions

=CBAR_Rates()

This function desired to retrieve AZN currency rates from the official site of The Central Bank of Azerbaijan Republic according to the given date and currency name. For example: type USD to get United States dollar, type EUR to get Euro, type RUB to get Russian ruble and etc.
Note: If errors occurred during obtaining the data from the web simply press F9 (Calculation) to fix it.

=CellFormula()

Shows cell formula. Range supported

=Convert2Date()

Recognizes date formats according to the local settings of your system. Range supported

=CountByCellColor()

Count cells based on cell color

=CountByFontColor()

Count cells based on font color

=DistinctCount()

Unique list count

=DistinctList()

Get distinct array list of your selected range/ranges. ByColumns: type - True or 1 to get the result by columns or left blank or type 0 (or type False) to get the result by rows. Multi-range supported. Apply more ranges with brackets like this: (A1:A10,C1:C10,F5:F15)

=ExtractX()

Extract desired Nth word from the text string. Nth value is optional. Default value is 0 and it'll find the last word.

=GetCellComment()

Shows cell comment text

=GoogleTranslate()

Translate text from any language to any. For example: if you want to translate the text from English to Russian then you should type for TranslateFrom "en"  and for TranslateTo "ru" and etc. By default it'll detect the text language automatically and translate into English.

=HasFormula()

If the cell contains any formula. Returns True or False. Range supported

=ISBLANK2()

This function desired to consider cell value as blank - after converting the cell formula (which result is blank) to its actual value. Standard ISBLANK() formula will consider this result as non blank cell. Range supported

=IsCellVisible()

Check if cell is visible. Returns True or False. Range supported

=JoinCells()

Combines the text from multiple ranges and includes a delimiter you specify between each text value that will be combined. By default Separator is ",". By default IgnoreEmpty is True to ignore blanks cells.

=NumberToWord()

Convert numbers to words untill quadrillion. For ex: 15.25 - fifteen dollars and twenty five cents or fifteen dollars and 25 cents

=ReverseText()

Reverse the text. (for ex: excel -> lecxe)

=SentenceCase()

Convert text to Sentence case. Range supported

=SheetNames()

Get array list of the sheets in active workbook. ByColumns: type - True or 1 to get the result by columns or left blank or type 0 (or type False) to get the result by rows

=SQRT2()

Finding the nth root of a number. Just specify number and root

=SumByCellColor()

Sum cells based on cell color

=SumByFontColor()

Sum cells based on font color

=VlookupX()

As you know Vlookup() function allows us to find the first one from the list. But VlookupX() function will allow to find N-th ones. By default Nth_criteria equals to zero and by default the function will find you the last criteria. Type 1 to find the first, type 2 to find the second, type 3 to find third and so on... Also it works even when your desired result is on the left side (for Result_Col_Num: type 0 to get the result from the first leftmost column, type -1 to get the result from the second leftmost column and so on...). For the rightmost column result type from 2 and so on (because the 1 is your criteria column)


For now it supports: English, Azerbaijani, Turkish, Russian, Arabic, Spanish, Portuguese, Chinese, French and 
German (Deutsche) languages.
Switch instantly any of them whenever you want without restarting Excel.

Upcoming supported languages are: Italian, Polish, Dutch and Japanese.

NOTE: System requirements - Windows, Microsoft Excel 2007 or later.

Buy Once, Use Forever.
Free Upgrade and Support for the next 1 Year.
Free 24x7 Web Email Support Service

Last updated: Oct 10, 2018 5:01 PM

Login

Search

Calendar
«  October 2018  »
SuMoTuWeThFrSa
 123456
78910111213
14151617181920
21222324252627
28293031

Useful Sites
  • www.planetaexcel.ru
  • www.programmersforum.ru
  • www.mrexcel.com
  • www.excelworld.ru
  • www.cyberforum.ru
  • www.excelvba.ru
  • www.muhasib.az

  • Visitors
    free counters


    MyExcelWorld © 2018
    Site managed by uCoz