Microsoft Excel Training @ Federal Ministry of Petroleum Resources, Abuja, Nigeria (4th Session)

Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (4th Session)

Date: August 24th, 2019

Time: 1 am – 6:00 pm

Topics Covered

  • How to create Table and working with Table
  • Understanding how to use named ranges
  • Using List Data Validation
  • How to use Text-to-column
  • How to use Trace Precedents and Dependents
  • Identifying and Fixing Circular References
  • 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
  • Introduction to Power BI

Posted in Blog.

Leave a Reply

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