{"id":"https://openalex.org/W7204645104","doi":"https://doi.org/10.5281/zenodo.22133223","title":"Business Automation with Excel, VBA, and Microsoft Copilot","display_name":"Business Automation with Excel, VBA, and Microsoft Copilot","alternate_titles":[],"publication_year":2026,"publication_date":"2026-08-27","ids":{"openalex":"https://openalex.org/W7204645104","doi":"https://doi.org/10.5281/zenodo.22133223"},"language":"en","primary_location":{"id":"doi:10.5281/zenodo.22133223","doi":"https://doi.org/10.5281/zenodo.22133223","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.22133223","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Book"},"parent_works":[],"lineage":["https://openalex.org/W7204645104"],"child_works_count":0,"type":"book","is_traditional":true,"indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5281/zenodo.22133223","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Gomaa, Ahmed","orcid":"https://orcid.org/0000-0003-0869-7888","observed_orcids":["https://orcid.org/0000-0003-0869-7888"]},"institutions":[{"id":"https://openalex.org/I124113063","display_name":"University of Scranton","ror":"https://ror.org/05xwb6v37","country_code":"US","type":"education","lineage":["https://openalex.org/I124113063"]}],"countries":["US"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Gomaa, Ahmed","raw_affiliation_strings":["University of Scranton"],"raw_orcid":"https://orcid.org/0000-0003-0869-7888","affiliations":[{"raw_affiliation_string":"University of Scranton","institution_ids":["https://openalex.org/I124113063"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I124113063"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9628999829292297,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9628999829292297,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13287","display_name":"Robotic Process Automation Applications","score":0.0142000000923872,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.004999999888241291,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/business-process-automation","display_name":"business process automation","score":0.9089999794960022},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.9729999899864197},{"id":"https://openalex.org/keywords/vba","display_name":"VBA","score":0.7419999837875366},{"id":"https://openalex.org/keywords/microsoft-copilot","display_name":"Microsoft Copilot","score":0.9419999718666077},{"id":"https://openalex.org/keywords/visual-basic-editor","display_name":"Visual Basic Editor","score":0.6759999990463257},{"id":"https://openalex.org/keywords/macros","display_name":"macros","score":0.6549999713897705},{"id":"https://openalex.org/keywords/arrays","display_name":"arrays","score":0.7379999756813049},{"id":"https://openalex.org/keywords/power-query","display_name":"Power Query","score":0.9900000095367432},{"id":"https://openalex.org/keywords/data-validation","display_name":"data validation","score":0.5080000162124634},{"id":"https://openalex.org/keywords/error-handling","display_name":"error handling","score":0.5879999995231628},{"id":"https://openalex.org/keywords/quality-assurance","display_name":"quality assurance","score":0.4690000116825104},{"id":"https://openalex.org/keywords/audit-trail","display_name":"audit trail","score":0.5479999780654907},{"id":"https://openalex.org/keywords/business-modeling","display_name":"business modeling","score":0.3889999985694885}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6970000267028809},{"id":"https://openalex.org/C11066294","wikidata":"https://www.wikidata.org/wiki/Q1518244","display_name":"Business rule","level":4,"score":0.6270999908447266},{"id":"https://openalex.org/C115199736","wikidata":"https://www.wikidata.org/wiki/Q667566","display_name":"Visual Basic for Applications","level":2,"score":0.61080002784729},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5785999894142151},{"id":"https://openalex.org/C177688676","wikidata":"https://www.wikidata.org/wiki/Q7449106","display_name":"Semantics of Business Vocabulary and Business Rules","level":5,"score":0.5009999871253967},{"id":"https://openalex.org/C207505557","wikidata":"https://www.wikidata.org/wiki/Q4374012","display_name":"Business process modeling","level":4,"score":0.42739999294281006},{"id":"https://openalex.org/C512115632","wikidata":"https://www.wikidata.org/wiki/Q134067","display_name":"Microsoft Visual Studio","level":3,"score":0.40630000829696655},{"id":"https://openalex.org/C115901376","wikidata":"https://www.wikidata.org/wiki/Q184199","display_name":"Automation","level":2,"score":0.3995000123977661},{"id":"https://openalex.org/C146222976","wikidata":"https://www.wikidata.org/wiki/Q1204997","display_name":"Business logic","level":2,"score":0.39570000767707825},{"id":"https://openalex.org/C193669473","wikidata":"https://www.wikidata.org/wiki/Q5001867","display_name":"Business domain","level":5,"score":0.35190001130104065},{"id":"https://openalex.org/C162754035","wikidata":"https://www.wikidata.org/wiki/Q17006331","display_name":"Artifact-centric business process model","level":5,"score":0.3481000065803528},{"id":"https://openalex.org/C179299601","wikidata":"https://www.wikidata.org/wiki/Q1017605","display_name":"Business Process Model and Notation","level":5,"score":0.3479999899864197},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.34310001134872437},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.3124000132083893},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3084999918937683},{"id":"https://openalex.org/C20151700","wikidata":"https://www.wikidata.org/wiki/Q541759","display_name":"Business object","level":4,"score":0.3068000078201294},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.30149999260902405},{"id":"https://openalex.org/C2778202681","wikidata":"https://www.wikidata.org/wiki/Q8034663","display_name":"Workbook","level":2,"score":0.29980000853538513},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.298799991607666},{"id":"https://openalex.org/C189076506","wikidata":"https://www.wikidata.org/wiki/Q1518232","display_name":"Business analysis","level":3,"score":0.2791999876499176},{"id":"https://openalex.org/C195344581","wikidata":"https://www.wikidata.org/wiki/Q2555318","display_name":"Automated reasoning","level":2,"score":0.27230000495910645},{"id":"https://openalex.org/C124998573","wikidata":"https://www.wikidata.org/wiki/Q13743","display_name":"VBScript","level":4,"score":0.26109999418258667},{"id":"https://openalex.org/C546592022","wikidata":"https://www.wikidata.org/wiki/Q1932945","display_name":"Business software","level":5,"score":0.257999986410141},{"id":"https://openalex.org/C37952496","wikidata":"https://www.wikidata.org/wiki/Q5001829","display_name":"Business analytics","level":4,"score":0.25589999556541443}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5281/zenodo.22133223","doi":"https://doi.org/10.5281/zenodo.22133223","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.22133223","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Book"},{"id":"doi:10.5281/zenodo.22133224","doi":"https://doi.org/10.5281/zenodo.22133224","is_oa":false,"landing_page_url":"https://doi.org/10.5281/zenodo.22133224","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Book"}],"best_oa_location":{"id":"doi:10.5281/zenodo.22133223","doi":"https://doi.org/10.5281/zenodo.22133223","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.22133223","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Book"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2181834773","https://openalex.org/W3015004654","https://openalex.org/W2552738640","https://openalex.org/W4385675059","https://openalex.org/W4385673002","https://openalex.org/W7211931343","https://openalex.org/W2913158659","https://openalex.org/W3088342487","https://openalex.org/W4385678377","https://openalex.org/W7048426263"],"abstract_inverted_index":{"Business":[0,14],"Automation":[1],"with":[2,57],"Excel,":[3],"VBA":[4,36],"&":[5],"Microsoft":[6,30,175],"Copilot:":[7],"From":[8],"Data":[9],"Exports":[10],"to":[11,23,39,199],"Controlled,":[12],"AI-Assisted":[13],"Workflows":[15],"introduces":[16],"business":[17,53,61,118,140,167,190,213],"students,":[18],"professionals,":[19],"and":[20,26,49,64,74,79,84,92,98,102,108,148,160,177,189,205,219,230,246,251,256,269,293],"independent":[21],"learners":[22,137],"applied":[24],"programming":[25,172,237],"business-process":[27],"automation":[28,226,285],"in":[29],"Excel.":[31],"The":[32,222,275],"book":[33,223],"develops":[34],"the":[35,67,87,117,121,127,132,166,186],"knowledge":[37],"required":[38],"specify,":[40],"read,":[41],"trace,":[42],"write,":[43],"debug,":[44,202],"modify,":[45],"test,":[46],"validate,":[47],"document,":[48],"maintain":[50],"recurring":[51],"Excel-based":[52],"processes.":[54],"It":[55],"begins":[56],"Excel":[58,88,99],"as":[59,136,227,233,235],"a":[60,236,271],"modeling":[62],"environment":[63],"progresses":[65],"through":[66],"Visual":[68],"Basic":[69],"Editor,":[70],"recorded":[71],"macros,":[72],"variables":[73],"data":[75,152],"types,":[76],"Boolean":[77],"logic":[78,191],"decision":[80],"structures,":[81],"loops,":[82],"procedures":[83],"functions,":[85],"arrays,":[86],"object":[89],"model,":[90],"file":[91,149],"error":[93],"handling,":[94,150],"UserForms,":[95],"Power":[96],"Query":[97],"Tables,":[100],"dashboards":[101],"KPIs,":[103],"end-to-end":[104],"automation,":[105],"quality":[106],"assurance,":[107],"professional":[109],"handoff.":[110],"A":[111],"continuing":[112],"fictional":[113],"organization,":[114],"DoGood,":[115],"provides":[116],"context":[119],"for":[120,211],"book.":[122],"Rather":[123],"than":[124],"resetting":[125],"at":[126],"beginning":[128],"of":[129,169],"each":[130,170],"chapter,":[131],"DoGood":[133],"system":[134],"evolves":[135],"add":[138],"explicit":[139],"rules,":[141,214],"repeated":[142],"processing,":[143],"reusable":[144],"procedures,":[145],"controlled":[146],"workbook":[147],"structured":[151,262],"preparation,":[153],"management":[154],"reporting,":[155],"validation":[156],"controls,":[157],"audit":[158],"evidence,":[159],"AI-assisted":[161],"development.":[162],"This":[163],"continuity":[164],"makes":[165],"purpose":[168],"new":[171],"capability":[173],"visible.":[174],"Copilot":[176],"similar":[178],"generative":[179],"AI":[180,198],"tools":[181],"are":[182],"introduced":[183],"only":[184],"after":[185],"relevant":[187],"syntax":[188],"have":[192],"been":[193],"practiced":[194],"independently.":[195],"Learners":[196],"use":[197],"explain,":[200],"draft,":[201],"refactor,":[203],"compare,":[204],"document":[206],"code":[207,281],"while":[208],"remaining":[209],"responsible":[210,225],"specifications,":[212],"testing,":[215],"validation,":[216],"privacy":[217],"boundaries,":[218],"acceptance":[220],"decisions.":[221],"treats":[224],"an":[228],"assurance":[229],"decision-quality":[231],"problem":[232],"well":[234],"problem.":[238],"Students":[239],"test":[240],"normal,":[241],"boundary,":[242],"exception,":[243],"failure,":[244],"regression,":[245],"rerun":[247],"conditions;":[248],"reconcile":[249],"populations":[250],"values;":[252],"manage":[253],"report":[254],"states":[255],"exceptions;":[257],"distinguish":[258],"measured":[259],"evidence":[260],"from":[261],"judgment;":[263],"apply":[264],"hard":[265],"constraints":[266],"where":[267],"appropriate;":[268],"preserve":[270],"human":[272],"review":[273],"path.":[274],"final":[276],"objective":[277],"is":[278,287],"not":[279],"merely":[280],"that":[282,286],"runs,":[283],"but":[284],"explainable,":[288],"testable,":[289],"auditable,":[290],"maintainable,":[291],"transferable,":[292],"responsibly":[294],"governed.":[295]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7204645104","counts_by_year":[],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2026-08-30T00:00:00"}
