{"id":15250,"date":"2021-05-03T14:35:00","date_gmt":"2021-05-03T12:35:00","guid":{"rendered":"https:\/\/blogs.sun.ac.za\/it\/?p=15250"},"modified":"2021-05-05T12:07:07","modified_gmt":"2021-05-05T10:07:07","slug":"3-day-online-excel-course-available","status":"publish","type":"post","link":"https:\/\/blogs.sun.ac.za\/it\/2021\/05\/3-day-online-excel-course-available\/","title":{"rendered":"[:en]3 day online Excel course[:af]3-dag aanlyn Excel-opleiding[:]"},"content":{"rendered":"

[:en]<\/p>\n

Due to Covid restrictions training will still be hosted online through our training partner Stellietech.<\/p>\n

The following course dates are available on Sun-e-hr for staff members to enrol.<\/p>\n\n\n\n\n\n\n\n
10-12<\/td>\nMay 2021<\/td>\n<\/tr>\n
17-19<\/td>\nMay 2021<\/td>\n<\/tr>\n
5-7<\/td>\nJune 2021<\/td>\n<\/tr>\n
7-9<\/td>\nJune 2021<\/td>\n<\/tr>\n
2-4<\/td>\nAugust 2021<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Should you be interested in attending you must please apply via the Sun-HR System by following the steps below:<\/p>\n

\n

>employee self-service
\n\u00a0 \u00a0 \u00a0>>training and development
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0>>>learner home
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0>>>>Information Technology
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 >>>>>Online Excel course<\/p>\n<\/blockquote>\n

COURSE OUTLINE:<\/strong><\/p>\n

Import Data and Navigate workbooks<\/strong><\/p>\n

    \n
  • Import Data from Text Files<\/li>\n
  • Import Data from CSV Files<\/li>\n
  • Search for Data<\/li>\n
  • Navigate to workbook Elements<\/li>\n<\/ul>\n

    Format worksheets and workbooks<\/strong><\/p>\n

      \n
    • Modify Page Setup<\/li>\n
    • Adjust Row Height and Column Width.<\/li>\n
    • Customise Headers and Footers<\/li>\n<\/ul>\n

      Customise<\/b>\u00a0Options and Views<\/strong><\/p>\n

        \n
      • Customise the Quick Access Toolbar<\/li>\n
      • Explore Workbook Views<\/li>\n
      • Freeze Rows and Columns<\/li>\n
      • Change Window View<\/li>\n
      • Modify Basic Workbook Properties<\/li>\n
      • Display Formulas<\/li>\n<\/ul>\n

        Configure Content for Collaboration.<\/strong><\/p>\n

          \n
        • Set a Print Area<\/li>\n
        • Save in Alternative File Formats<\/li>\n
        • Configure Print Settings<\/li>\n
        • Inspect Workbook for Issues.<\/li>\n<\/ul>\n

          Manipulate Data in Worksheets<\/strong><\/p>\n

            \n
          • Use Special Paste Options<\/li>\n
          • Use Autofill to Fill Cells<\/li>\n
          • Insert and Delete Rows and Columns<\/li>\n
          • Insert and Delete Cells<\/li>\n<\/ul>\n

            Format Cells and Ranges<\/strong><\/p>\n

              \n
            • Merge and Unmerge Cells<\/li>\n
            • Alignment, Orientation, and Indentation<\/li>\n
            • Use the Format Painter<\/li>\n
            • Wrap Text Within Cells<\/li>\n
            • Apply Number Formats<\/li>\n<\/ul>\n

               <\/p>\n

               <\/p>\n

              [:af]<\/p>\n

              Weens COVID-regulasies word opleiding steeds aanlyn aangebied met behulp van ons opleidingsvennoot Stellietech.<\/p>\n

              The following course dates are available on Sun-e-hr for staff members to enrol.<\/p>\n\n\n\n\n\n\n\n
              10-12<\/td>\nMei 2021<\/td>\n<\/tr>\n
              17-19<\/td>\nMei 2021<\/td>\n<\/tr>\n
              5-7<\/td>\nJunie 2021<\/td>\n<\/tr>\n
              7-9<\/td>\nJunie 2021<\/td>\n<\/tr>\n
              2-4<\/td>\nAugustus 2021<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

              As jy dit graag wil bywoon, doen asseblief aansoek op die Sun-HR stelsel deur die stappe onder te volg:<\/p>\n

              >employee self-service
              \n\u00a0 \u00a0 \u00a0>>training and development
              \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0>>>learner home
              \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0>>>>Information Technology
              \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 >>>>>Online Excel course<\/p>\n

              KURSUSRAAMWERK:<\/strong><\/p>\n

              Import Data and Navigate workbooks<\/strong><\/p>\n

                \n
              • Import Data from Text Files<\/li>\n
              • Import Data from CSV Files<\/li>\n
              • Search for Data<\/li>\n
              • Navigate to workbook Elements<\/li>\n<\/ul>\n

                Format worksheets and workbooks<\/strong><\/p>\n

                  \n
                • Modify Page Setup<\/li>\n
                • Adjust Row Height and Column Width.<\/li>\n
                • Customise Headers and Footers<\/li>\n<\/ul>\n

                  Customise<\/b>\u00a0Options and Views<\/strong><\/p>\n

                    \n
                  • Customise the Quick Access Toolbar<\/li>\n
                  • Explore Workbook Views<\/li>\n
                  • Freeze Rows and Columns<\/li>\n
                  • Change Window View<\/li>\n
                  • Modify Basic Workbook Properties<\/li>\n
                  • Display Formulas<\/li>\n<\/ul>\n

                    Configure Content for Collaboration.<\/strong><\/p>\n

                      \n
                    • Set a Print Area<\/li>\n
                    • Save in Alternative File Formats<\/li>\n
                    • Configure Print Settings<\/li>\n
                    • Inspect Workbook for Issues.<\/li>\n<\/ul>\n

                      Manipulate Data in Worksheets<\/strong><\/p>\n

                        \n
                      • Use Special Paste Options<\/li>\n
                      • Use Autofill to Fill Cells<\/li>\n
                      • Insert and Delete Rows and Columns<\/li>\n
                      • Insert and Delete Cells<\/li>\n<\/ul>\n

                        Format Cells and Ranges<\/strong><\/p>\n

                          \n
                        • Merge and Unmerge Cells<\/li>\n
                        • Alignment, Orientation, and Indentation<\/li>\n
                        • Use the Format Painter<\/li>\n
                        • Wrap Text Within Cells<\/li>\n
                        • Apply Number Formats<\/li>\n<\/ul>\n

                          [:]<\/p>\n","protected":false},"excerpt":{"rendered":"

                          [:en] Due to Covid restrictions training will still be hosted online through our training partner Stellietech. The following course dates are available on Sun-e-hr for staff members to enrol. 10-12 May 2021 17-19 May 2021 5-7 June 2021 7-9 June 2021 2-4 August 2021 Should you be interested in attending you must please apply via […]<\/p>\n","protected":false},"author":259,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3256,48738,44],"tags":[],"class_list":["post-15250","post","type-post","status-publish","format-standard","hentry","category-news","category-notices-2","category-training"],"publishpress_future_action":{"enabled":false,"date":"2026-05-09 16:38:07","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/posts\/15250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/users\/259"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/comments?post=15250"}],"version-history":[{"count":8,"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/posts\/15250\/revisions"}],"predecessor-version":[{"id":15279,"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/posts\/15250\/revisions\/15279"}],"wp:attachment":[{"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/media?parent=15250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/categories?post=15250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.sun.ac.za\/it\/wp-json\/wp\/v2\/tags?post=15250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}