--- title: Using Basic Arrays in Excel - Webinar - U.S. Computer Connection description: An array is a type of formula that can perform multiple calculations on one or more items in an array . You can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single […] image: https://blog.uscomputer.com/hubfs/Imported_Blog_Media/WebinarReplay-Oct-17-2022-03-59-11-76-PM.jpg --- [Skip to content](https://blog.uscomputer.com/using-basic-arrays-excel-webinar#main-content) [![USCC_2C_Logo](https://blog.uscomputer.com/hs-fs/hubfs/USCC_2C_Logo.png?width=1078&height=250&name=USCC_2C_Logo.png "USCC_2C_Logo")](http://U.S.%20Computer%20Connection) Search - [Home](https://uscomputer.com) - About Show submenu for About - [Our Team](https://uscomputer.com/our-team) - [Careers](https://uscomputer.com/careers) - [Solutions](https://uscomputer.com/solutions) Show submenu for Solutions - [Cybersecurity](https://uscomputer.com/cybersecurity) - [Data Backup & Disaster Recovery](https://uscomputer.com/data-backup-disaster-recovery) - [Managed IT Services](https://uscomputer.com/managed-it-services) - [IT Projects](https://uscomputer.com/it-projects) - [Cloud Computing](https://uscomputer.com/cloud-computing) - [Blog](https://blog.uscomputer.com) - [Contact Us](https://uscomputer.com/contact) - [Home](https://uscomputer.com) - About Show submenu for About - [Our Team](https://uscomputer.com/our-team) - [Careers](https://uscomputer.com/careers) - [Solutions](https://uscomputer.com/solutions) Show submenu for Solutions - [Cybersecurity](https://uscomputer.com/cybersecurity) - [Data Backup & Disaster Recovery](https://uscomputer.com/data-backup-disaster-recovery) - [Managed IT Services](https://uscomputer.com/managed-it-services) - [IT Projects](https://uscomputer.com/it-projects) - [Cloud Computing](https://uscomputer.com/cloud-computing) - [Blog](https://blog.uscomputer.com) - [Contact Us](https://uscomputer.com/contact) [Client Remote Support](https://uscomputer.com/support/) [Free Strategy Session](https://uscomputer.com/contact/) Call Today! 203.356.0444 # Using Basic Arrays in Excel – Webinar [Garry Feldman](https://blog.uscomputer.com/author/garry-feldman) Oct 24, 2017 8:27:39 AM [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.uscomputer.com%2Fusing-basic-arrays-excel-webinar%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](https://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.uscomputer.com%2Fusing-basic-arrays-excel-webinar%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.uscomputer.com%2Fusing-basic-arrays-excel-webinar%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.uscomputer.com%2Fusing-basic-arrays-excel-webinar%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check+out+https%3A%2F%2Fblog.uscomputer.com%2Fusing-basic-arrays-excel-webinar%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.uscomputer.com%2Fusing-basic-arrays-excel-webinar%3Futm_medium%3Dsocial%26utm_source%3Demail) [![Click here button for youtube](https://blog.uscomputer.com/hs-fs/hubfs/Imported_Blog_Media/watch-now-button-for-youtube-channels-Oct-17-2022-03-59-12-19-PM.png?width=235&height=94&name=watch-now-button-for-youtube-channels-Oct-17-2022-03-59-12-19-PM.png)](https://youtu.be/aVWPDMFACro) An array is a type of formula that can perform multiple calculations on one or more items in an array . You can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. Advantages of arrays are: Consistency & Accuracy: If you click in any of the cells with an array formula, you see the same formula. Safety: You cannot overwrite a component of a multi-cell array formula, since it applies to all the cells in the array. Smaller file sizes: You can often use a single array formula instead of several intermediate formulas, saving storage space. [Training](https://blog.uscomputer.com/tag/training), [Employee training](https://blog.uscomputer.com/tag/employee-training), [employee education](https://blog.uscomputer.com/tag/employee-education), [education](https://blog.uscomputer.com/tag/education), [Webinar](https://blog.uscomputer.com/tag/webinar), [Excel](https://blog.uscomputer.com/tag/excel) ## Read On [![](https://blog.uscomputer.com/hs-fs/hubfs/August%202025/Social%20800%20x%20800/PSPro-Cyber%20Insurance%20%26%20IT-Ad-15-800x800.jpg?width=352&name=PSPro-Cyber%20Insurance%20%26%20IT-Ad-15-800x800.jpg)](https://blog.uscomputer.com/it-and-cyber-insurance-why-you-cant-afford-to-ignore-either) ### [IT and Cyber Insurance: Why You Can't Afford to Ignore Either](https://blog.uscomputer.com/it-and-cyber-insurance-why-you-cant-afford-to-ignore-either) Cyberthreats are evolving fast, especially with the rise of AI-powered attacks. That's why a solid... [![](https://blog.uscomputer.com/hs-fs/hubfs/August%202025/Social%20800%20x%20800/PSPro-Cyber%20Insurance%20%26%20IT-Ad-14-800x800.jpg?width=352&name=PSPro-Cyber%20Insurance%20%26%20IT-Ad-14-800x800.jpg)](https://blog.uscomputer.com/cyber-insurance-basics-what-every-business-needs-to-know) ### [Cyber Insurance Basics: What Every Business Needs to Know](https://blog.uscomputer.com/cyber-insurance-basics-what-every-business-needs-to-know) Cyberattacks rarely come with a warning, and when they hit, the damage can be fast and costly. From... [![](https://blog.uscomputer.com/hs-fs/hubfs/July%202025/Social%20800%20x%20800/PSPro-Risky%20vs%20Reliable-Ad-15-800x800.jpg?width=352&name=PSPro-Risky%20vs%20Reliable-Ad-15-800x800.jpg)](https://blog.uscomputer.com/the-role-of-it-service-providers-in-mitigating-it-risks) ### [The Role of IT Service Providers in Mitigating IT Risks](https://blog.uscomputer.com/the-role-of-it-service-providers-in-mitigating-it-risks) In today’s fast-moving business landscape, change is constant and often unpredictable. Markets can... #### Connect with USCC 933 Hope Street Stamford, CT 06907 [Follow us on Facebook](https://www.facebook.com/USComputerConnection) [Follow us on LinkedIn](https://www.linkedin.com/company/us-computer-connection) [Follow us on Facebook](https://www.youtube.com/channel/UCVJhg6c3_PpsUkKyY31areg) [Follow us on Twitter](https://twitter.com/UScomputerConncom) #### Solutions [Managed IT Services for Businesses](https://uscomputer.com/managed-it-services) [Cybersecurity](https://uscomputer.com/cyber-security) [Data Backup & Disaster Recovery](https://uscomputer.com/data-backup-disaster-recovery) [IT Projects](https://uscomputer.com/it-projects) [Cloud Computing](https://uscomputer.com/cloud-computing) Copyright © 2022 USCC. All rights reserved | [Privacy Policy](https://uscomputer.com/wp-content/uploads/2021/09/Online-Privacy-Policy.pdf) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Garry Feldman", "url" : "https://blog.uscomputer.com/author/garry-feldman" }, "dateModified" : "2022-10-17T16:00:14.066Z", "datePublished" : "2017-10-24T12:27:39.000Z", "headline" : "Using Basic Arrays in Excel - Webinar - U.S. Computer Connection", "image" : [ "https://blog.uscomputer.com/hubfs/Imported_Blog_Media/WebinarReplay-Oct-17-2022-03-59-11-76-PM.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.uscomputer.com/using-basic-arrays-excel-webinar", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.uscomputer.com/hubfs/USCC_2C_Logo.png" }, "name" : "U.S. Computer Connection" } } ```