Excel - Next Steps

This course is suitable for learners with a basic knowledge of the topics covered at Introductory level, such as using simple formulae for addition, subtraction, multiplication and division, calculating row and column totals using SUM and AUTOSUM functions, changing the format and appearance of data, inserting and deleting rows and columns and adjusting row heights and column widths.

Topics covered include:

• Using common Functions
• Moving and Copying Information
• Paste Options Button
• Copying Formulas
• Absolute Cell References
• Autofill
• AutoFill Options Button
• Sorting Information
• Hiding Columns and Rows
• Wrapping Text and Calculations
• Formatting Currencies and Dates
• Borders and Shading
• Working with Comments (inserting, viewing, editing and deleting)
• Freezing and Splitting the Screen
• Other useful features (if time allows), such as repeating rows or column headings on each page and fitting the worksheet to a page

Central Sussex College is committed to providing you with guidance and support to help you make the most of your potential and achieve your goals! We offer an exciting range of academic qualifications, vocational subjects and apprenticeships – based at excellent facilities in Crawley, Haywards Heath, East Grinstead and Horsham. We have something for everyone – so whether you are just leaving school and looking to study for a BTEC or A Levels, are looking to retrain and gain new skills or take your studies further with professional qualification or higher level training at our University Centre, Central Sussex College can cater for you.