{"id":1717,"date":"2020-09-25T15:37:52","date_gmt":"2020-09-25T15:37:52","guid":{"rendered":"https:\/\/blogarchive.utc.edu\/center-professional-education\/?p=1717"},"modified":"2020-10-13T14:22:51","modified_gmt":"2020-10-13T14:22:51","slug":"5-time-saving-tips-you-didnt-know-about-excel","status":"publish","type":"post","link":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/","title":{"rendered":"5 Time-Saving Tips You Didn\u2019t Know About Excel"},"content":{"rendered":"

\"male<\/p>\n

I sat down with Stephanie Chastain, CPE\u2019s Excel Trainer, to learn more about Excel and its functionality. Stephanie brings a wealth of knowledge and expertise to CPE, having been an IT trainer for 25 years. Check out five helpful, time-saving Excel tips that Stephanie has found most students don\u2019t know before starting Excel training.<\/p>\n

\n

TIP #1: USE THE AUTOFILL HANDLE TO AUTOMATICALLY NUMBER EACH LINE.<\/strong><\/h4>\n

Excel is often used for numbering data. You can use the autofill handle to quickly populate cells with data without having to manually enter every piece of individual data. Let\u2019s say you have to type in Line 1, Line 2, Line 3, etc. You would:<\/p>\n

    \n
  1. Put in at least two numbers in the first two cells of data. There must be at least two numbers for the autofill handle to work.<\/li>\n
  2. Highlight your series (the numbers you have entered in the cells).<\/li>\n
  3. In the bottom right-hand corner of your series, hover your mouse over the square outline. A solid plus sign will pop up. Now, you can click and drag as far down as you want your data to be entered. Data in the same increments you have chosen (for example, the lines would continue in increments of 1) will be auto-filled into your cells.<\/li>\n<\/ol>\n

    Not only can the autofill handle be used for numbering, but it can be used for custom lists as well as with certain words using whatever nomenclature you use for abbreviations. It may not seem to be a giant time-saver at first, but using the handle for repetitive tasks will save you a ton of time in the long run.<\/p>\n

     <\/p>\n

    \"Excel-AH\"<\/p>\n

     <\/p>\n

    TIP #2: HIGHLIGHT NUMBERS TO COMPUTE DATA QUICKLY.<\/strong><\/h4>\n

    Not many people realize that you can quickly see the sum, average, and count of data at the bottom of your spreadsheet. These figures are located in what\u2019s called the \u201cstatus bar.\u201d Instead of inserting a formula or function to give you this information, you would:<\/p>\n

      \n
    1. Highlight the numbers you want to pull data for.<\/li>\n
    2. Look at the \u201cstatus bar\u201d (located at the bottom of the Excel spreadsheet).<\/li>\n
    3. See the sum, average, and count data you need.<\/li>\n<\/ol>\n

      Let\u2019s say your boss calls you and asks, \u201cCan you tell me how many entries we have this month in XYZ category?\u201d You can use this method to quickly pull data.<\/p>\n

       <\/p>\n

      \"highlight<\/p>\n

       <\/p>\n

      TIP #3: INSERT MULTIPLE ROWS AND COLUMNS QUICKLY. <\/strong><\/h4>\n

      Instead of entering rows individually, you can quickly add multiple rows and columns to your spreadsheet. You would:<\/p>\n

        \n
      1. Highlight the same number of columns (or rows) you would like to insert.<\/li>\n
      2. Right-click your selection.<\/li>\n
      3. Select Insert.<\/li>\n
      4. The number of columns (or rows) you highlighted will be added. This is a very simple, yet effective time-saver!<\/li>\n<\/ol>\n

         <\/p>\n

        \"inserting<\/p>\n

         <\/p>\n

        TIP #4: RESIZE COLUMNS TO ACCOMMODATE VARIOUS DATA SIZES.<\/strong><\/h4>\n

        Excel users often make spreadsheets and resize individual columns to have data fit perfectly in each one. If you\u2019re not worried about aesthetics, but just want to get as much data as possible on one page, there is a way to automatically resize\u00a0every column at one time to match the largest set of data in a particular column. To quickly resize columns, you would:<\/p>\n

          \n
        1. Click on the Select All button (in the top left corner, between sections A and 1, on your spreadsheet).<\/li>\n
        2. Double-click between 2 columns to resize the entire spreadsheet.<\/li>\n<\/ol>\n

          You can apply the same steps to rows by clicking between 2 rows in the fourth step.<\/p>\n

           <\/p>\n

          \"gif<\/p>\n

           <\/p>\n

          TIP #5: FREEZE HEADINGS USING THE FREEZE PANE FEATURE.<\/strong><\/h4>\n

          It\u2019s easy to start scrolling and realize that you don\u2019t even know what you\u2019re looking at anymore. The freeze pane feature keeps your column headings visible as you scroll through data. This helps you easily reference what the information you\u2019re looking at is! You would:<\/p>\n

            \n
          1. Click on the row BELOW the row you want to freeze. (Pro tip: You always insert above with Excel).<\/li>\n
          2. Click on the View tab (located to the right of the Review tab at the top of your workbook).<\/li>\n
          3. Select the Freeze Top Row option. (You also have the ability to freeze entire rows. And don\u2019t worry, Stephanie shows you how to unfreeze everything in her class as well!)<\/li>\n<\/ol>\n

             <\/p>\n

            \"freeze<\/p>\n

            <\/h4>\n

            BONUS TIP: <\/strong><\/h4>\n

            While pivot tables and 3d references sound intimidating to some, they are actually very simple. A pivot table is a table full of statistics that summarizes data from a larger, more extensive set of data. Excel pivot tables simply allow you to manipulate and pivot data so you can look at it in different ways! 3d references point you to the same cell or range on multiple worksheets in your workbook. Once you learn that they are simply pointing you to another place in your workbook, you discover they aren\u2019t so daunting after all.<\/p>\n

            Join Stephanie for one of our upcoming Excel courses<\/a> and learn how to implement even more time-saving strategies.<\/p>\n

            \n

            ABOUT THE AUTHOR:<\/h4>\n

            \"Marah<\/p>\n

            Hi! My name is Marah Whitaker (think Laura with an M). I am the Marketing Assistant for UTC Center for Professional Education. During the workday, I spend time writing blog posts, creating content for social media,\u00a0<\/span>developing<\/span>\u00a0email campaigns, and building relationships with our customer base.<\/span>\u00a0<\/span>During my free time, you can find me getting lost in a good book, having spontaneous dance parties, playing piano, and going to Buffalo Wild Wings on Wing Night.<\/span>\u00a0Professionally and personally, I\u00a0<\/span>aspire<\/span>\u00a0to live by the Mr.\u00a0<\/span>Feeny<\/span>\u00a0quote, \u201cDream. Believe. Try. Do Good.\u201d I strive to use my passions to\u00a0<\/span>serve<\/span>\u00a0others and contribute positively to the world around me.<\/span>\u00a0<\/span><\/p>\n

            Connect with m<\/span>e<\/span>\u00a0on\u00a0<\/span>LinkedIn.<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

            I sat down with Stephanie Chastain, CPE\u2019s Excel Trainer, to learn more about Excel and its functionality. Stephanie brings a wealth of knowledge and expertise to CPE, having been an IT trainer for 25 years. Check out five helpful, time-saving Excel tips that Stephanie has found most students don\u2019t know before starting Excel training. TIP… <\/p>\n

            Continue Reading <\/span><\/a><\/span><\/p>\n","protected":false},"author":1540,"featured_media":1720,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[83661,83651],"tags":[],"class_list":{"0":"post-1717","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-computer-training","8":"category-productivity","9":"entry"},"yoast_head":"\n5 Time-Saving Tips You Didn\u2019t Know About Excel - UTC Center for Professional Education Archive: Jul 2007 - Oct 2025<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Time-Saving Tips You Didn\u2019t Know About Excel - UTC Center for Professional Education Archive: Jul 2007 - Oct 2025\" \/>\n<meta property=\"og:description\" content=\"I sat down with Stephanie Chastain, CPE\u2019s Excel Trainer, to learn more about Excel and its functionality. Stephanie brings a wealth of knowledge and expertise to CPE, having been an IT trainer for 25 years. Check out five helpful, time-saving Excel tips that Stephanie has found most students don\u2019t know before starting Excel training. TIP… Continue Reading\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"UTC Center for Professional Education Archive: Jul 2007 - Oct 2025\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-25T15:37:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-13T14:22:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Marah Whitaker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marah Whitaker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/\",\"url\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/\",\"name\":\"5 Time-Saving Tips You Didn\u2019t Know About Excel - UTC Center for Professional Education Archive: Jul 2007 - Oct 2025\",\"isPartOf\":{\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png\",\"datePublished\":\"2020-09-25T15:37:52+00:00\",\"dateModified\":\"2020-10-13T14:22:51+00:00\",\"author\":{\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/#\/schema\/person\/444d8bb79c26170bd145c164b67af6d6\"},\"breadcrumb\":{\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#primaryimage\",\"url\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png\",\"contentUrl\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png\",\"width\":600,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Time-Saving Tips You Didn\u2019t Know About Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/#website\",\"url\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/\",\"name\":\"UTC Center for Professional Education Archive: Jul 2007 - Oct 2025\",\"description\":\"The Latest at CPE\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/#\/schema\/person\/444d8bb79c26170bd145c164b67af6d6\",\"name\":\"Marah Whitaker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/caeaf7d558bcf7e9e683671ba127c245a0cf404e94a9ab64ceddba0a9904f050?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/caeaf7d558bcf7e9e683671ba127c245a0cf404e94a9ab64ceddba0a9904f050?s=96&d=mm&r=g\",\"caption\":\"Marah Whitaker\"},\"url\":\"https:\/\/blogarchive.utc.edu\/center-professional-education\/author\/yhm836\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 Time-Saving Tips You Didn\u2019t Know About Excel - UTC Center for Professional Education Archive: Jul 2007 - Oct 2025","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"5 Time-Saving Tips You Didn\u2019t Know About Excel - UTC Center for Professional Education Archive: Jul 2007 - Oct 2025","og_description":"I sat down with Stephanie Chastain, CPE\u2019s Excel Trainer, to learn more about Excel and its functionality. Stephanie brings a wealth of knowledge and expertise to CPE, having been an IT trainer for 25 years. Check out five helpful, time-saving Excel tips that Stephanie has found most students don\u2019t know before starting Excel training. TIP… Continue Reading","og_url":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/","og_site_name":"UTC Center for Professional Education Archive: Jul 2007 - Oct 2025","article_published_time":"2020-09-25T15:37:52+00:00","article_modified_time":"2020-10-13T14:22:51+00:00","og_image":[{"width":600,"height":600,"url":"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png","type":"image\/png"}],"author":"Marah Whitaker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marah Whitaker","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/","url":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/","name":"5 Time-Saving Tips You Didn\u2019t Know About Excel - UTC Center for Professional Education Archive: Jul 2007 - Oct 2025","isPartOf":{"@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#primaryimage"},"image":{"@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png","datePublished":"2020-09-25T15:37:52+00:00","dateModified":"2020-10-13T14:22:51+00:00","author":{"@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/#\/schema\/person\/444d8bb79c26170bd145c164b67af6d6"},"breadcrumb":{"@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#primaryimage","url":"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png","contentUrl":"https:\/\/blogarchive.utc.edu\/center-professional-education\/files\/2020\/09\/male-looking-at-computer-screen-amazed-feat.png","width":600,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/2020\/09\/25\/5-time-saving-tips-you-didnt-know-about-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blogarchive.utc.edu\/center-professional-education\/"},{"@type":"ListItem","position":2,"name":"5 Time-Saving Tips You Didn\u2019t Know About Excel"}]},{"@type":"WebSite","@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/#website","url":"https:\/\/blogarchive.utc.edu\/center-professional-education\/","name":"UTC Center for Professional Education Archive: Jul 2007 - Oct 2025","description":"The Latest at CPE","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogarchive.utc.edu\/center-professional-education\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/#\/schema\/person\/444d8bb79c26170bd145c164b67af6d6","name":"Marah Whitaker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogarchive.utc.edu\/center-professional-education\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/caeaf7d558bcf7e9e683671ba127c245a0cf404e94a9ab64ceddba0a9904f050?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/caeaf7d558bcf7e9e683671ba127c245a0cf404e94a9ab64ceddba0a9904f050?s=96&d=mm&r=g","caption":"Marah Whitaker"},"url":"https:\/\/blogarchive.utc.edu\/center-professional-education\/author\/yhm836\/"}]}},"_links":{"self":[{"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/posts\/1717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/users\/1540"}],"replies":[{"embeddable":true,"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/comments?post=1717"}],"version-history":[{"count":22,"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/posts\/1717\/revisions"}],"predecessor-version":[{"id":1823,"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/posts\/1717\/revisions\/1823"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/media\/1720"}],"wp:attachment":[{"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/media?parent=1717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/categories?post=1717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogarchive.utc.edu\/center-professional-education\/wp-json\/wp\/v2\/tags?post=1717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}