Microsoft Excel Manipulating Data
Half Day

This module has been designed for delegates who are familiar with Excel and can already use the basic functions. The topics covered are particularly useful if large amounts of data need to be re organised for reporting and statical analysis.

Course format: Half day, max capacity 6

Wireless Computer Accessories
microsoft-excel-seeklogo.com.png

Session Topics

  • Absolute Cell Reference

  • Named Ranges

  • Using Named Ranges in Formula

  • Text Formula

  • LEFT/RIGHT/LEN

  • Round

  • Concat

  • Trim

  • Text Join

  • Text to columns

  • Remove Duplicates

  • Date Formula

  • Subtotals

  • Custom Lists

  • Remove Blanks

  • Hide Cells