Microsoft Excel Introduction

Course Dates:

Business Benefit :-

Being able to analyse numerical data statistically and in chart form is a widespread need within many businesses and Excel is the ideal tool to use to do this. This course provides underpinning knowledge towards the Microsoft Office Specialist Qualification.

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

IT Qualifications, IT Skills

Related Products