Course details

The aim of this course is to give candidates a comprehensive training in the specialised features of this powerful spreadsheet software, focusing on practical business applications such as:

  • sales figures, budgets, forecasts, etc.
  • databases
  • analysing statistical or numerical possibilities presenting statistical reports, etc.

Course Content

Creating spreadsheets

  • Inserting data
  • Inserting Formulas and Functions
  • Formatting and Editing Data
  • Formatting the layout of the spreadsheet

Relative and absolute cell address

Editing between worksheets and workbooks

Organising and analysing data

  • Sorting data
  • Filtering Data
  • Database Functions
  • Auditing a Worksheet
  • Creating Reports using Subtotals, Consolidation Scenarios, Goal Seek and Solver Utilities, etc.
  • Using advanced Functions e.g.; If Function, VLookup
  • Advanced Formatting. e.g. Styles, Templates, Conditional Formatting
  • Working with Pivot Tables
  • Linking between worksheets and workbooks
  • Sharing data between Microsoft Excel and Microsoft Word
  • Charts
  • Objects and Drawing
Updated on 08 November, 2015
Are you from Rossan College ? Claim your course!
Courses you can instantly connect with... Do an online course on Software Development starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or