{"id":1282,"date":"2023-05-24T13:30:17","date_gmt":"2023-05-24T12:30:17","guid":{"rendered":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/?p=1282"},"modified":"2025-01-07T11:20:31","modified_gmt":"2025-01-07T11:20:31","slug":"microsoft-excel-tips-and-tricks-part-2%f0%9f%92%a1","status":"publish","type":"post","link":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/2023\/05\/24\/microsoft-excel-tips-and-tricks-part-2%f0%9f%92%a1\/","title":{"rendered":"Microsoft Excel Tips and Tricks (Part 2)\ud83d\udca1"},"content":{"rendered":"\n

Blogpost by Laurie Stevenson (Student Digital Champion)<\/em><\/strong><\/p>\n\n\n\n

\"Banner<\/figure>\n\n\n\n

I published Part 1 of this blogpost<\/a><\/strong> earlier this week, where I introduced you to 5 tips and tricks to help you make the most of Excel, and this blogpost contains 5 further tips! If you want to learn more about Excel, please visit my new Excel LinkedIn Learning collection<\/a><\/strong>.<\/p>\n\n\n\n

Tip 6: Adding in multiple rows or columns at once<\/h1>\n\n\n\n

If you want to add more than one row or column in one go, this tip will save you the time of having to do this one row at a time.<\/p>\n\n\n\n

    \n
  • Highlight the number of rows or columns you want<\/li>\n\n\n\n
  • Right-click on the highlighted rows or columns<\/li>\n\n\n\n
  • Choose Insert<\/strong> from the drop-down menu that appears<\/li>\n<\/ul>\n\n\n\n

    Tip 7: Adding bullet points<\/h1>\n\n\n\n

    Finding the button to add these is not as easy as on Microsoft Word but luckily there are a couple of different ways to do this.<\/p>\n\n\n\n\n\n\n\n

    Option 1 – <\/strong>If you have a numerical keyboard:<\/p>\n\n\n\n

      \n
    • Select the cell where you want to add your bullet point<\/li>\n\n\n\n
    • Input ALT+7 <\/strong>into the cell<\/li>\n\n\n\n
    • Your bullet point should appear (if it doesn\u2019t, try option 2 below)<\/li>\n<\/ul>\n\n\n
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      Option 2 – <\/strong>Another option is to:<\/p>\n\n\n\n

        \n
      • Select the cell where you want to add your bullet point<\/li>\n\n\n\n
      • Input =CHAR(149) <\/strong>into the cell (this will add just the bullet point<\/em>)<\/li>\n\n\n\n
      • If you want to add text after the bullet point, input =CHAR(149)&\u201dInsert Text Here\u201d<\/strong><\/li>\n<\/ul>\n\n\n\n

        Tip 8: Hyperlinking to a webpage within your spreadsheet<\/h1>\n\n\n\n

        To link to a webpage within your spreadsheet:<\/p>\n\n\n\n

          \n
        • Click on your chosen cell and under the Insert<\/strong> tab select Link <\/strong>(or you can also right-click on the chosen cell and select Link <\/strong>from there)<\/li>\n\n\n\n
        • Type or paste in the website URL allowing you to be taken directly to that website when you select the chosen cell<\/li>\n<\/ul>\n\n\n\n

          This tip can also be used to take you to a YouTube video by copying the URL of your video on YouTube and pasting in the same way.<\/p>\n\n\n\n

          Tip 9: Adding tick or check boxes<\/h1>\n\n\n
          \n
          \"\"<\/figure>\n<\/div>\n\n\n

          This tip can be really useful if you are using Excel for project management, organisational purposes or to visually illustrate a positive result in a data set or in response to a question. To add a tick or check box:<\/p>\n\n\n\n

            \n
          • Go to the Developer<\/strong> tab<\/li>\n\n\n\n
          • Select Insert<\/strong> and choose your desired check or tick icon<\/li>\n<\/ul>\n\n\n\n

            Tip 10: COUNTIF function<\/h1>\n\n\n\n

            This function allows you to count the number of cells that meet particular criteria set by you, for example the number of times a particular job appears in a list of people.<\/p>\n\n\n\n

              \n
            • In an empty cell type =COUNTIF(<\/strong> followed by either typing the cell range you want to look in or by selecting and dragging over the desired cells<\/li>\n\n\n\n
            • Then type in the key phrase, number or character you are searching for in speech marks (don\u2019t worry, this function isn\u2019t case-sensitive so you don\u2019t need to worry about using capital letters or not for word searches<\/em>) – e.g. =COUNTIF(A3:A25, \u201cDoctor\u201d)<\/strong><\/li>\n\n\n\n
            • Close the brackets<\/li>\n\n\n\n
            • Then press the Enter<\/strong> key<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

              Blogpost by Laurie Stevenson (Student Digital Champion) I published Part 1 of this blogpost earlier this week, where I introduced you to 5 tips and tricks to help you make the most of Excel, and this blogpost contains 5 further tips! If you want to learn more about Excel, please visit my new Excel LinkedIn […]<\/p>\n","protected":false},"author":92954,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[56,136,13,394,402,105,28],"tags":[],"class_list":["post-1282","post","type-post","status-publish","format-standard","hentry","category-ict-proficiency-en","category-information-data-media-literacy-en","category-linkedin-learning","category-microsoft-excel-en","category-microsoft-support","category-student-digital-champions","category-students"],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/1282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/users\/92954"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/comments?post=1282"}],"version-history":[{"count":7,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/1282\/revisions"}],"predecessor-version":[{"id":1303,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/1282\/revisions\/1303"}],"wp:attachment":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/media?parent=1282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/categories?post=1282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/tags?post=1282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}