Excel Beginners Course Content:

Enter text, dates, and numbers
Edit cell content
Cut, copy, paste, paste special and move selected cells, use the Office Clipboard
Work with series (AutoFill)
Use Save and Save As
Apply font styles (typeface, size, colour and styles)
Apply number formats (currency, percent, dates, comma)
Modify size of rows and columns
Apply cell borders and shading
Preview and print worksheets & workbooks
Change page orientation and scaling
Set page margins and centering, headers and footers
Insert and delete rows and columns
Freeze and unfreeze rows and columns
Rename a worksheet
Insert and Delete worksheets
Move and copy worksheets
Enter formulas in a cell and using the formula bar
Use references (absolute and relative)
Use AutoSum and Basic

Excel Advanced Course Content

Functions (AVERAGE, SUM, COUNT, MIN, MAX)
Using charts and objects
Importing data and text
Exporting to other applications
Apply, editing and creating templates
Using multiple workbooks
Create custom number formats
Use conditional formatting
Use the Report Manager
Use Lookup Functions (Hlookup or Vlookup)
Recording, Running and Editing macros
Auditing a worksheet
Trace errors, precedents and dependents
Apply conditional formats
Use grouping and outlines
Use data forms
Use subtotaling
Applying Data Filters and Extracting data
Use data validation
Use PivotTable
Use Goal Seek
Work with Scenarios
Apply and remove worksheet and workbook protection
Track changes (highlight, accept, and reject)

Entry requirements

Commencement dates: Contact Ariston College Admissions Office for details

Fees: 190.00 per day (Individual tuition 240.00 per day)

Course Application Form