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 June 2020, please visit the following link and make your payment online:

https://www.meraevents.com/event/online-basic-ms-excel-training

To enroll for the program on 10th June 2020, please visit the following link and make your payment online:

https://www.meraevents.com/event/online-advanced-excel-training

CONTACT US

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