Title : Excel Advanced


Duration - 1 day

Fees :    £300 for 1 to 6 delegates        £350 for 7 to 10 delegates

(Fees are inclusive of all expenses)
 

 

Content
 

  • File Management
    • Converting from previous versions
    • Encrypting
    • Digital signatures
  • Advanced formulas and functions
    • Using absolute cell references
    • If and nested If statements
    • Sumif
    • Averageif
    • Countif
    • Array formulas
  • Named ranges
  • Database tools
    • Vlookup
    • Index/Match
    • Intersect
  • Text operators & functions
    • Concatenate
    • Find
    • Mid
  • Doing more with Pivot Tables & charts
    • Trend lines
    • Secondary axes
  • User Controls