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.

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