Advanced Skills

Advanced Skills – this course is designed for those who want to use excel in corporation or for those involved with finance or accounting. 

  • Smart Art 
  • Finding and selecting smart art. 

  • Adding in extra Boxes to Smart Art. 

  • Editing Smart Art, 

  • Inserting Images 

  • Taking Screenshot with excel 

  • Screenshot: Thumbnails 

  • Screenshot: Customized 

  • Adding in text box 

  • Checking formulas 

  • Precedents Tracing 

  • Dependent Tracing 

  • Displaying Formulas 

  • Comments in Excel 

  • Creating Charts 

  • Recommended Charts 

  • Resizing Excel Charts 

  • Chart Design 

  • Creating tables 

  • Pivot tables 
  • Pivot table – Inserting Slicer 

  • Creating graphs from pivot table 

  • PivotTable – Change Summary Function 

  • PivotTable – Calculated Field 

  • V-Lookups 
  • V-lookup Linking 

  • H-lookups 

  • What if Analysis 

  • what if analysis – Goal Seek 

  • What if Analysis – Data Tables 

  • What If Analysis – Scenario Manager 

  • Rows to columns 

  • Text to columns 

  • Remove Duplicates. 

  • Data Validation 

  • Consolidate Data 

  • Grouping