top of page

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

bottom of page