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