Introduction to MS-Excel (YPG)

Course description

 Key Topics

• Excel Familiarisation
• Understanding columns, rows and Excel navigation
• Entering Text and Numbers
• How to create formula (includes order of operation)
• How to use autofill
• Using relative and absolute addressing
• How to format information in a spreadsheet
• Using Auto Sum and aggregate functions
• How to create charts
• Chart editing and formatting
• How to save workbooks
• Create PDFs from Workbooks

This 1 day course is a fully funded through YPG and is aimed at those between 16 and 24 years old that are not currently in employment.The course aims to give the new Excel user all the basic skills that they need to be able to use Excel with confidence.Tips are included on using Excel quickly and efficiently, and you will learn how to layout spreadsheets and create charts.DATES: 22nd June, 0930 - 1630

Learning outcome

INTERMEDIATE MS-EXCEL | Dumfries & Galloway College (dumgal.ac.uk) ADVANCED MS-EXCEL | Dumfries & Galloway College (dumgal.ac.uk)