Auxiliary menu for Microsoft Excel (15.11.2024)

Auxiliary menu for Microsoft Excel (15.11.2024)

Auxiliary menu for Microsoft Excel  (15.11.2024)  includes:
- conversion of tabular text file, CSV or TXT format, into Excel file, XLSX format;
- accessing and executing the "Conversion TXT, CSV -> XLSX" command also from the File-Backstage menu, without the need to open a new empty file beforehand;
- correcting the calendar date after importing data, in CSV/TXT/XLS(X) format, from programs that use the PostgreSQL database;
- importing and converting PDF, DOC, DOCX and DOCM documents into Excel — XLSX files;
- converting any number into text format in the selected cells/columns;
- change text from the selected cells to uppercase and/or lowercase letters;
- correction of measurement units from "MP" to "m²", "MC" to "m³", etc. in selected cells/columns;
- conversion of formulas into value / text / calendar date / percentage;- mathematical and accounting functions (CALCULPEN, CODECOLOR, CODEHEXCOLOR, CONVNRLETTERSEN, CONVNRLETTERSRO, COUNTCOLOR, EXTRACTDATE, EXTRACTWORD, SUMCOLOR, UNIQUECOLOR, UNIQUESORT, VALDISC, VALDISCP, VALDISCPTOVAL, VALDISCTOVAL, VALVAT, VALVATP, VALWITHDISC, VALWITHDISCP, VALWITHDISCPTOVAL, VALWITHDISCTOVAL, VALWITHOUTDISC, VALWITHOUTDISCP, VALWITHOUTDISCPTOVAL, VALWITHOUTDISCTOVAL, VALWITHOUTVAT, VALWITHOUTVATP, VALWITHVAT, VALWITHVATFROMVAT, VALWITHVATFROMVATP,  VALWITHVATP);
- guide for mathematical and accounting functions (CALCULPEN, CODECOLOR, CODEHEXCOLOR, CONVNRLETTERSEN, CONVNRLETTERSRO, COUNTCOLOR, EXTRACTDATE, EXTRACTWORD, SUMCOLOR, UNIQUECOLOR, UNIQUESORT, VALDISC, VALDISCP, VALDISCPTOVAL, VALDISCTOVAL, VALVAT, VALVATP, VALWITHDISC, VALWITHDISCP, VALWITHDISCPTOVAL, VALWITHDISCTOVAL, VALWITHOUTDISC, VALWITHOUTDISCP, VALWITHOUTDISCPTOVAL, VALWITHOUTDISCTOVAL, VALWITHOUTVAT, VALWITHOUTVATP, VALWITHVAT, VALWITHVATFROMVAT, VALWITHVATFROMVATP,  VALWITHVATP); 

The guide is accessed in the menu Tools > Formulas > Functions.

- positioning, moving or/and multiplying any object according to parameters and coordinates (shape , image);
- sending the files in the work, via e-mails, with the help of Microsoft Outlook (Classic), in PDF or original formats. 

After installing the  Auxiliary Menu kit for Microsoft Excel (15.11.2024).exe, in  Microsoft Excel 20xx a new group of commands named "Tools"  will appear in  the command ribbon, as shown in the image above down.

Auxiliary Menu for Microsoft Excel is compatible with Microsoft Excel 2010 / 2013 / 2016 / 2019 / 2021 / 365.

The kit is virus free and can be downloaded by clicking on the image below or here:

Archive password: 654321.

(The article continues below. ↓)

Examples

Figure 1 – Extracting benchmarks uniquely and sorting them

Figure 2 – Converting numerical value to monetary value in letters

Figure 3 – Value without VAT, Value with VAT and VAT

Figure 4 – Discount

Figure 5 - Summation of cells according to their color

Figure 6 - Counting cells according to their color

Figure 7 - Extracting one or more words from a text in the cell

Figure 8 - Extracting the calendar date from a cell text

Figure 9 - Volatile summation based on background color with conditional formatting

Figure 10 - Volatile summation based on background color with conditional formatting and based on a criterion

Figure 11 - Example of positioning and sizing the object according to the desired range of cells

Figure 12 - Descending numbering with RANKUNIQUE vs RANK.EQ

Figure 13 - Calculation of the penalty for late payment of an invoice based on the reference interest rate
for the respective period

All articles on this site can be distributed with acknowledgement of the source, including a link to the article or site.

Other topics on the same topic:
- Meniu auxiliar pentru Microsoft Excel.