In this part of the website, we provide additional information about various Excel capabilities not described in Excel Environment.
Topics
- Miscellaneous built-in Excel functions
- Excel conditional functions
- Excel table lookup functions
- Built in Excel statistical functions
- Arrays as an argument in Excel formulas
- Data conversion and reformatting
- Table lookup
- Special charting capabilities
- Keyboard shortcuts
Reference
Microsoft Support (2026) Formulas and functions
https://support.microsoft.com/en-us/office/formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9
Hi,
I am trying to automate the binary logistic regression function from your add-in. I have several tables that I need it to be run on (over 10). Is there a way to use Excel VBA code to automate the binary logistic regression?
Thank you for your help and please let me know if you need any additional information.
Thanks,
Justin
I should mention that the data in the tables will be changing, hence the reason for needing it automated. I am trying to avoid running the binary logistic regression manually every single time the data changes. Thanks.
Justin,
See the following webpage
https://real-statistics.com/real-statistics-environment/calling-real-statistics-functions-in-vba/
Charles
HELLO
I Aslam one enquiry abt excel i had cretaed one workbook having more than 500 sheet and in one sheet 100 to 1200 columns are using to save data is there any limited capability for excel workbook if so how much thus did i lose my date
Hello Aslam,
Sorry, but I don’t know the limits on the number of sheets in an Excel workbook. I would think this this is largely governed by the amount of memory available.
Charles