Language:
SEARCH
  • Recent Posts

  • Categories

  • Archives

3 day online Excel course

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 the Sun-HR System by following the steps below:

>employee self-service
     >>training and development
             >>>learner home
                     >>>>Information Technology
                                >>>>>Online Excel course

COURSE OUTLINE:

Import Data and Navigate workbooks

  • Import Data from Text Files
  • Import Data from CSV Files
  • Search for Data
  • Navigate to workbook Elements

Format worksheets and workbooks

  • Modify Page Setup
  • Adjust Row Height and Column Width.
  • Customise Headers and Footers

Customise Options and Views

  • Customise the Quick Access Toolbar
  • Explore Workbook Views
  • Freeze Rows and Columns
  • Change Window View
  • Modify Basic Workbook Properties
  • Display Formulas

Configure Content for Collaboration.

  • Set a Print Area
  • Save in Alternative File Formats
  • Configure Print Settings
  • Inspect Workbook for Issues.

Manipulate Data in Worksheets

  • Use Special Paste Options
  • Use Autofill to Fill Cells
  • Insert and Delete Rows and Columns
  • Insert and Delete Cells

Format Cells and Ranges

  • Merge and Unmerge Cells
  • Alignment, Orientation, and Indentation
  • Use the Format Painter
  • Wrap Text Within Cells
  • Apply Number Formats

 

 

Comments are closed.

 

© 2013-2024 Disclaimer: The views and opinions expressed in this page are strictly those of the page author(s) and content contributor(s). The contents of this page have not been reviewed or approved by Stellenbosch University.