Microsoft Excel Training @ University of Benin, Edo, Nigeria (2nd Session)

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates and undergraduates at University of Benin, Edo Nigeria (1st Session)

Date: May 16th, 2019

Time: 1pm – 5:30pm

Topics Covered:

  • Create Pivot Table
  • Working with Pivot Tables Field List
  • Tabular Pivot Table Report
  • How to Report Pivot Table Filter Pages
  • Pivot Charts
  • Working with Pivot Charts
  • How to create Table and working with Table
  • Understanding how to use named ranges
  • How to use Data Validation
  • How to use Text-to-column
  • How to use SUMIFS & AVERAGEIFS Functions
  • Data analysis using IF, AND, OR, Nested IF Statement
  • Building dynamic Dashboard
  • Introduction to Get & Transform & Pivot Table
  • How to Record, Run, Assign Macro

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *