New: VBA References!

BOOST productivity
EXCEL & VBA

An add-in – library which provides extended functionality to Excel.


Copied!sub files_info()
   dim x: x = application.run("file.\au", "c:\users\admin\downloads")
   if isarray(x) then
     [cell].resize(ubound(x, 1), 8).value2 = x
   else
     [cell].value2 = x
   end if 
end sub
sub files_info()
   dim x: x = application.run("file.\au", "c:\users\admin\downloads")
   if isarray(x) then
     [cell].resize(ubound(x, 1), 8).value2 = x
   else
     [cell].value2 = x
   end if 
end sub

◢	A	B	C	D	E	F	G	H
1	File Name	Path	Extension	Created	Modified	Accessed	Image size	Size
2	2025 fonts.rar	C:\Users\admin\Downloads\	.rar	10/06/2024	10/06/2024	24/07/2024		(MB) 218.68
3	victor freitas	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	2796×1940	(MB)1.47
4	calendar–chart	C:\Users\admin\Downloads\	.xlsx	24/07/2024	24/07/2024	24/07/2024		(KB) 264.07
5	checklist-word-template	C:\Users\admin\Downloads\	.docx	16/07/2024	16/07/2024	24/07/2024		(MB) 100.49
6	daniel-zacatenco	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	6000×3376	(MB) 3.75
7	dario-veronesi	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	6000×4000	(MB) 3.5
8	negative space	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	4320×4320	(MB) 663.01
9	invoice-word-template	C:\Users\admin\Downloads\	.docx	16/07/2024	16/07/2024	24/07/2024		(MB) 36.07
10	james-padolsey	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	5184×3888	(MB) 2.87
11	john-fowler-03pv	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	6448×4559	(MB) 6.35
12	marco-xu-cgvii7f	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	5472×3648	(MB) 3.64
13	adam platonic	C:\Users\admin\Downloads\	.jpg	24/07/2024	24/07/2024	24/07/2024	2976×3968	(MB)3.58
14	noto-hinted.zip	C:\Users\admin\Downloads\	.zip	10/06/2024	10/06/2024	24/07/2024		(GB) 1.09

SUPPORTED TOPIC FUNCTIONS

Powerful Features

–

SIMPLIFY CONNECTION TO Databases

Easily to connect, create queries that use SQL statements to retrieve data from connected databases (SQL Server, Ms.Access, MySQL, Oracle, DB2, DuckDB,..)

TAKE complete ADVANCED REPORTING FUNCTIONS

GROUP

APPENDTABLE

PIVOT

GROUPBY

GROUP

APPENDTABLE

PIVOT

GROUPBY

GROUP

APPENDTABLE

PIVOT

GROUPBY

SQL

QUERY

FUZZYSEARCH

SQL

QUERY

FUZZYSEARCH

SQL

QUERY

FUZZYSEARCH

REGEX

SORT

EMAIL.SEND

REGEX

SORT

EMAIL.SEND

REGEX

SORT

EMAIL.SEND

EXPORT.XLS

EXPORT.CSV

EXPORT.JSON

EXPORT.XLS

EXPORT.CSV

EXPORT.JSON

EXPORT.XLS

EXPORT.CSV

EXPORT.JSON

SCREENSHOT

UNION

UNPIVOT

INTERSECT

SCREENSHOT

UNION

UNPIVOT

INTERSECT

SCREENSHOT

UNION

UNPIVOT

INTERSECT

THE BEST ENVIRONMENT TO PRACTICE ARRAY FORMULAS

{=SUM(1-(MMULT(--(ISNUMBER(SEARCH(TRANSPOSE(exclude),data))),ROW(exclude)^0)>0))}

<code class="language-xls" style="word-spacing: -3px;">
    <span class="token brace">{</span><span class="token operator">=</span><a class="token function" href="https://autechniques.com/excel-sum-function">SUM</a><span class="token punctuation">(</span><span class="token number">1</span>
    <span class="token operator">-</span><span class="token punctuation">(</span><a class="token function" href="https://autechniques.com/excel-mmult-function">MMULT</a><span class="token punctuation">(</span>
    <span class="token operator">--</span><span class="token punctuation">(</span><a class="token logic function" href="https://autechniques.com/excel-isnumber-function">ISNUMBER</a><span class="token punctuation">(</span>
    <a class="token function" href="https://autechniques.com/excel-search-function">SEARCH</a><span class="token punctuation">(</span><a class="token function" href="https://autechniques.com/excel-transpose-function">TRANSPOSE</a>
    <span class="token punctuation">(</span><span class="token define name">exclude</span><span class="token punctuation">)</span><span class="token punctuation">,</span><span class="token define name">data</span>
    <span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
    <a class="token function" href="https://autechniques.com/excel-row-function">ROW</a><span class="token punctuation">(</span><span class="token define name">exclude</span><span class="token punctuation">)</span>
    <span class="token operator">^</span><span class="token number">0</span><span class="token punctuation">)</span><span class="token operator">></span><span class="token number">0</span><span class="token punctuation">)</span>
    <span class="token punctuation">)</span><span class="token brace">}</span>
</code>

Key Benefits

Flexible interaction

Streamline your workflow with our amazing platform and effortlessly write cleaner and better code

=LAMBDA(x,y,f,
         REDUCE.λ(
                  MAP(
                      BYROW.λ(x),
                      BYROW.λ(y),
                      LAMBDA(x,y,
                             INVOLKE.λ(
                                      x,
                                      y,
                                      f
                             )
                      )
                  ),
                  VSTACK.λ,
                  1
         )
  )

=LAMBDA(x,y,f,REDUCE.λ(MAP(BYROW.λ(x),BYROW.λ(y),LAMBDA(x,y,INVOLKE.λ(x,y,f))),VSTACK.λ,1))

UNLOCK THE TRUE POWER OF LAMBDA FUNCTIONS

MANAGER WORKBOOKS even better

Automate repetitive tasks in SECONDS

Process data, synthesize reports from simple to complex in just a few clicks!

Average

+ $900

33%

Expenses

$100,000

Income

$600,00

Profit

+ $500,000

Total:

$500,000

Average

+ $900

33%

Expenses

$100,000

Income

$600,00

Profit

+ $500,000

Total:

$500,000

FAQs

Frequently asked questions

Some of the most common questions. Can’t find the right answer? Click here to contact us

Contact Us

What are the system requirements to use?

Windows 7-11, Windows server 2008-2025. Microsoft Excel 2007-365.
To use – full features from the toolkit, make sure you are using Excel-64bit.
To take – full advantage from the toolkit, you should install Excel 2021 or Excel 365.
For the best experience, Windows11 and Excel365 is recommended.

How to install AUExpress for Excel?

First, you need to download the installer and run add-in under administrator to install.
Next, open Excel then click the login form button, just enter your account information (include username & password) to login.
Last, close and reopen Excel (no need to login from the second).

How to use, are there any resources included?

It will take some patience and time to learn how to use the Add-in.

Basically, we provide gifs-videos-documentation and .xlsx files for demos mainly with advanced features. That means, Simple features with almost no documentation, you can practice by yourself.

If you need additional instructions, just send a ticket.

How to ask for support?

For fix bugs: send us the problem you’re having. It’s best to include: minimalist demo file, gif or video of the action and what (message error) went wrong.

For licensing, new feature request, update or any other issue, please email us.

How to get the latest update?

After logging in to your account, you can click the update button to install the latest add-in version (this may include patches or new features).

To see related information, click the (What’s new) button and view add-in update history.

How to buy a licensing?

A product’s account will be delivered by e-mail immediatelly after the payment transaction.

If I purchase Add-in, how many computers can I use it on?

[annual renewal] 1 license/1 machine for the time being.

Who can use this Add-in?

For jobs that using Excel: administrative, HR, marketing, accountant, financial, sale, statistician, actuary, data architect..
For all subjects: students, engineers, accountants, auditors, etc. from individuals to businesses.
For all skills: from beginner to expert.
For best results, intermediate excel skills are recommended.

What is the biggest barrier?

Language differences can be a barrier, so we ask for your patience when dealing with any issues or problems. 🫠

Testimonials

Hear what people are saying about us

“Nice work on this product. You’ve saved our business! If you aren’t sure, always go for this product. Believe me, you won’t regret it.”

Jessica Lee

@jesslee

“This product is by far the most valuable business resource we have ever purchased. Thank you for your hard work!”

Courtney Francis

@courtneyfrancis

“This product is by far the most valuable business resource we have ever purchased. Thank you for your hard work and commitment to creating quality products with great attention to detail. Our business has achieved amazing results”

Mark Smith

@msmithdev

Solidify

“Nice work on this product. You’ve saved our business! If you aren’t sure, always go for this product. Believe me, you won’t regret it.”

Kate Hughes

@katehughes

“I don’t know what else to say. This is simply unbelievable! Nice work on this product. You’ve helped our business!”

Emily Johnson

@emjohnson

“Nice work on this product. You’ve saved our business! If you aren’t sure, always go for this product. Believe me, you won’t regret it.”

John Jones

@jjones

BOOST productivityEXCEL & VBA

–

SIMPLIFY CONNECTION TO Databases

TAKE complete ADVANCED REPORTING FUNCTIONS

THE BEST ENVIRONMENT TO PRACTICE ARRAY FORMULAS

Flexible interaction

DYNAMIC SEARCHBOX filter

UNLOCK THE TRUE POWER OF LAMBDA FUNCTIONS

MANAGER WORKBOOKS even better

Automate repetitive tasks in SECONDS

Frequently asked questions

Hear what people are saying about us

Take your excel skill to the next level

BOOST productivity
EXCEL & VBA