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