Excel
Fundamentals

  • What is a spreadsheet
  • Creating a worksheet
  • Entering text and numbers
  • Changing cell attributes
  • Entering formulae
  • Saving and closing a worksheet
  • Opening an existing worksheet
  • Printing and print options
  • Inserting columns and rows
  • Moving and copying
  • Relative and absolute references
  • Creating graphs
  • How to use 'Help'
  • Your questions

Microsoft Excel 2010, 2013, 2016+

Duration

3-4 hours
FREE

Who for

Anyone who is new to Excel or just needs that little bit of extra help with the basics. This course is designed for those who need to know the fundamentals and will provide you with the practical knowledge of how to effectively use a spreadsheet.

Outcome

Be able to save amounts of time by creating spreadsheets that are correctly structured for their purpose. Know how to create calculations to take the leg work out of analysis and to produce professional looking charts that summarise information.

What Next

As you've mastered the fundamentals of Excel, you're now ready to start learning how to manipulate and interrogate data using advanced functions in excel. The intermediate course will provide you with the practical knowledge of how to use spreadsheets to gain information back from data entered.