Query, Share and Manage Excel workbooks on LAN, Internet

How to share Excel Workbooks, Worksheets, Ranges on the LAN and Internet

Part 1

Part 2

• How to register Add-in A-Tools Pro
• How to start server with Add-in A-Tools in Microsoft Excel
• Server set up and client permissions in Excel and Add-in A-Tools
• Client connect to the server in Excel and Add-in A-Tools
• How to restore lost in Add-In A-tools toolbar in Microsoft Excel
• Advanced Input, Dropdown List - Select list with multi columns, filter, date
• List of extension functions in Add-In A-Tools in Microsoft Excel
• Download and set up Add-in A-Tools
• Setup Add-in A-Tools
• Advanced Input - Drop down list find and filter
• Execute SQL in Excel and create dynamic report
• Share Excel online with restrict rights users
• Function return Dynamic array
• Database functions
• Color functions
• Accounting functions
• Extended functions
• Excel connect to external database
• Create formula array of Excel by click Formula Builder - Mouse click only
• Settings in A-Tools Options
• Add-in A-Tools Function Programming
• Add-in A-Tools Network Programming
• Sync data from Excel to Google Sheets by Add-in A-Tools
• Sync data from Excel to Excel online by Add-in A-Tools