COURSE CONTENTS

  • Sum, MAX, MIN, Average, Count, Today, Now, Datedif, Error Handling
  • Countif, CountA, CountBlank, Round, RoundUp, RoundDown, ABS, Sign, Ceiling, Floor, Trim, Value, Clean, Countifs, Sumifs
  • Conditional Formats, Text to Columns
  • Using Custom Sort & Advanced Filters
  • IF, AND, OR
  • Vlookup, Hlookup
  • IFError, IFNA, Rank, Match, Index
  • Validations, Indirect Function
  • Networkdays, EDate, EoMonth, WorkDay
  • Consolidation
  • Using Goal Seek, Data Tables, PMT
  • Creating/Revising Pivot Tables Using Slicer on Pivot Tables, Presenting Histogram Trends, Grouping Etc
  • Importing Data (Introduction to Power Query)
  • Auditing Tools, Worksheet Protection, Hyper Links, Compare Side by Side, Freeze Panes
  • Sparklines, Charts(Pie, Exploded Pie, Pie on Pie, Stacked Column Bar, Pareto, Plotting Data on Two Axis, Trend Lines)
  • Macros – Using, Recording & Editing

REGISTRATION

To enroll for the program on 15th July 2020, please visit the following link and make your payment online.

To enroll for the program on 22nd July 2020, please visit the following link and make your payment online.

CONTACT US

Interested in learning excel? Leave your name, number and email address, we will get back to you as soon as we can.