Online Advanced Microsoft Excel Course in Pitampura Rohini

Microsoft Excel is one such application that does not require any preaching to be used. It is the choice of billions of corporate users due to its power, speed & simplicity of use. Most people have a basic understanding of Excel but a few really know where to find Excel’s most effective & efficient power features. This course contains everything you need to know & learn about Excel. It is designed to fill the void by providing comprehensive training on Excel’s most powerful features. The DICS Innovatives is conducting the Online Advanced Excel Course in Pitampura for all those looking to become Excel professionals. These online Excel classes in Pitampura are well-versed in delivering the right knowledge to its students that may help them glitter their resume and find a suitable job.

 

COURSE Modules

  • Essential Math/Stats Functions: SUM, AVERAGE, MIN, MAX, COUNT, LARGE, SMALL, FLOOR
  • Essential Text Functions: UPPER, LOWER, PROPER, FIND, TEXT, LEFT, RIGHT, MID
  • Date & Time Functions: NOW, DATEDIF, EDATE, NETWORKDAYS, WEEKDAYS, YEAR, MONTH, HOUR, MIN
  • Using Logical Functions: IF, IFS, AND, NOT, ISNA, IFERROR, ISBLANK, ISNUMBER
  • Using Excel Power Functions: SUMIFS, COUNTIFS, AVERAGEIFS
  • Using D-Functions: DSUM, AVERAGE, DMAX, DMIN, DGET
  • Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE
  • Working with Name Ranges & Name Manager
  • Working with Smart Tables
  • Working with Array & 3D Formulas
  • Using Flash Fill for Data Transformation & Separation
  • Creating & Customizing Charts – Column, Line, Bar, Pie, and Combo Charts
  • Analyzing & Summarizing Data with Pivot Table Reports, Pivot Charts & Slicers
  • Automating Recurring Tasks with Macros
  • Using Excel Business Modeling Tools: Goal Seek, Data Tables, Solver, Scenario Manager
  • Conditional Formatting
  • And loads of Excel Tips & Tricks
  • Data analysis
  • Protect workbook

DICS Innovatives is Best Computer Institute in Pitampura offers advanced excel course, learn with professional trainers, and become a Ms. Excel expert

Leave A Comment