PER
DELEGATE
FROM
£650 + VAT
Venues: At your own offices or our luxury training venues in Cardiff, Langstone (Nr Celtic Manor), Bristol or Swindon (Please state your choice of venue when booking)
This comprehensive introduction course in Excel teaches participants how to create and enhance spreadsheets, use charts, formulas and functions, and formatting a spreadsheet effectively. This 1-day Excel Introduction course will assist delegates to develop their skills in creating and formatting professional looking spreadsheets.
Who Should Attend
This course is designed for any delegates who would like to learn how to create, format a professional spreadsheet and learn how to use and create basic formulas and functions in a spreadsheet.
• Screen layout & features
• Using workbooks & worksheets
• Navigating a spreadsheet
• Highlighting cells and ranges of cells
• Entering text and numbers
• Entering days and months using AutoFill
• Resizing rows and columns
• Inserting new rows and columns
• Calculations using AutoSum
• Font type – Font size – Font colour
• Bold - Italics - Underline
• Align: Left – Centre – Right – Merge cells
• Currency – Percentage - Decimals
• Creating cell borders
• Formatting cells as a date or time
• Using print preview
• Set up landscape & portrait
• Scaling – adjust a print out size
• Applying headers and footers
• Creating a new folder or subfolder
• Average, Maximum, Minimum and Count formulae
• Using absolute cell referencing
• Sort alphabetically or numerically
• Sort in Ascending or Descending
• Creating a simple graph or chart
• Format appearance & colour
• Adding legends & data labels
• Adding/removing data
• Changing the chart type
Click below to the Booking Form | Click below to have an overview sent to your email address |
You are viewing the text version of this site.
To view the full version please install the Adobe Flash Player and ensure your web browser has JavaScript enabled.
Need help? check the requirements page.