Excel for Business Introduction

Create Spreadsheets

• Open spreadsheet application and create/open spreadsheet file and enter numbers, text and symbols into cells according to information requirements
• Enter simple formulas using cell referencing where required
• Correct formulas when error messages occur
• Use a range of common tools during spreadsheet development
• Edit columns and rows within the spreadsheet
• Use the autofill function to increment data where required
• Save spreadsheet to correct directory or folder Customise basic settings
• Adjust page layout to meet user requirements or special needs
• Open and view different toolbars
• Change font settings so they are appropriate for the purpose of the document
• Change alignment options and line spacing according to spreadsheet formatting features
• Format cell to display different styles as required
• Modify margin sizes to suit the purpose of the spreadsheets
• View multiple spreadsheets concurrently

Format Spreadsheet

• Use formatting features as required
• Copy selected formatting features from another cell in the spreadsheet or from another active spreadsheet
• Use formatting tools as required within the spreadsheet
• Align information in a selected cell as required
• Insert headers and footers using formatting features
• Save spreadsheet in another format
• Save and close spreadsheet to disk
• Incorporate object and chart in spreadsheet
• Import an object into an active spreadsheet
• Manipulate imported object by using formatting features
• Create a chart using selected data in the spreadsheet
• Display selected data in a different chart
• Modify chart using formatting features
• Print spreadsheet
• Preview spreadsheet in print preview mode