Microsoft Excel

Microsoft Excel is a powerful spreadsheets program that helps you get the most out of your data. Its features enable you to capture, analyse and share information effectively.

Skill Level Required:Basic Computer Skills.

Course Outline

• Starting Microsoft Excel
• The Microsoft Excel Screen
• Moving around the cells in Excel
• Moving between worksheets
• Renaming worksheets
• Entering data
• Editing data
• Undoing and Redoing
• Autocorrect
• Autocomplete
• Pick lists
• Entering values and dates
• Highlighting cells, rows, and columns
• Highlighting the entire worksheet
• Saving a worksheet
• Closing Microsoft Excel
• Opening an existing workbook
• Inserting and deleting rows and columns
• Moving cells
• Copying cells
• Using drag and drop
• Adjusting column width and row height
• The Fill Handle
• The Fill Series
• Creating a formula
• Using the Paste Function to create a formula
• Using AutoSum
• Excel Functions
• Cell formatting
• Adding lines, patterns and colours
• Changing Page Layout
• Headers and Footers
• Freeze frames
• Hiding columns and rows
• Creating Charts
• Using comments
• Sorting records
• Filtering records
• Conditional Formatting
• Password protection for data and files

Cost: €125

<< Return to List of Courses >>