Microsoft Excel Introduction

Duration 1 Day

Who should attend?

This course is suitable for you if you need to create a brand new spreadsheet to perform budgets, cash projections and sales analysis. Creating formulae to add columns of information and work out simple statistics such as finding an average. Equally if you have to report financial information to people in the form of numerical or graphical reports

Learning Outcomes

  • Enter and edit data within a worksheet
  • Manipulate data using formulas and functions
  • Professionally format the worksheet
  • Copy and Move data
  • Automatically fill cells
  • Print worksheets
  • Name ranges for use in formulas
  • Create relative and absolute cell references
  • Manage links between sheets and workbooks
  • Create charts

Course Content

  • Using Help
  • Editing Techniques
  • Saving Your Work
  • Formulas
  • Writing Formula
  • Using Functions
  • Copying Data
  • Auto Fill
  • Formatting
  • Spell Checker
  • Find And Replace
  • Printing
  • Absolute Cell References
  • Named Ranges
  • Naming A Formula
  • Linking Workbooks
  • Creating Charts
  • Chart Options
  • Changing The Size Of Embedded Charts