Microsoft Excel Training @ University of Benin, Edo, Nigeria (1st 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: 9am – 12:30pm

Topics covered

  • General Excel Formatting
  • Freezing Panes and Splitting windows
  • Using Arithmetic Operators in formulas
  • Using SUM, AUTOSUM, AVERAGE, MAX, MIN Functions
  • Enabling Nigeria Naira Currency Symbol in Excel
  • Using find and replace
  • Data visualization with Pie, Column, Bar and Line Charts
  • 3D Reference in Excel
  • Using UPPER, LOWER & PROPER Functions
  • How to use Flash Fill for Extraction & Combining Text String
  • Data analysis using COUNT, COUNTA, COUNTBLANK & COUNTIFS Functions
  • Linking Workbooks calculations
  • Data consolidation by Position
  • Data consolidation by Reference

Posted in Blog.

Leave a Reply

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