This course is for you if you have little or no experience of spreadsheets and you want to learn the basic features.
Overview
You will learn the following skills helping you to enter and edit data:
• Moving around cells, sheets, & workbooks
• Entering numbers, text & dates
• Correcting mistakes: inserting additional/replacing existing cell content
• Selecting cells, rows, columns and ranges
• Selecting the entire worksheet
• Deleting cell contents
• Using Formulas
• Use the AutoFill/Copy tool to copy (replicate) formulas/increment data entries
• Changing the Layout
• Insert/delete columns and rows
• Adjust column width/row height
• Changing the font type, size and colour
• Using formatting tools: bold, italic, underline
• Changing alignment of cell(s): left, centre, right, top and bottom, TEXT WRAP
• Formatting numbers: decimal places, commas to separate thousands, currency symbol, percentages
• Page Setup options: fitting worksheet content to one page/several pages, changing worksheet orientation/paper size, adding Header and Footer
• Printing: worksheet, number of copies, entire workbook
• Using freeze Panes- Freeze Top Raw, Freeze First column
• Sorting and filtering data using Sort & Filter
• Find and replace data
Please bring a USB with you to save your work.
This is a non- accredited course and you do not need an assessment before joining this course.
Prosp Content
After this course, you can join other Excel courses or any other Digital Skills courses.
Career And Progression
