Advanced Excel

Advanced Excel Course

Advanced Excel Mastery Training Course is very useful  for Business analysis , Corporate Data management and Data analysis. Any one can learn from basic to advance excel  in career companion institute from basic to advanced. This Professional course helps to make a great career  in  corporate, IT campus and as freelancer

Advanced Excel Course

Basic Excel 2016 

Getting started with MS Excel 2016

  • Understanding Excel Environment
  • (Row, Column, Workbook, Sheets)
  • Working with Clipboard
     (Paste, Special, Format Painter)
  • Font and Alignment
  • Performing Basic Calculations
  •  Excel Sorting and Filtering
  • Tables and Charts 
  • Basic Excel Formulas
  • Introduction to Pivot Table
  • Excel Short Cuts.

Help on : 

  • Data Analysis
  • Data Cleaning
  • Advanced Reporting
  • Dashboard Making 

Advanced Excel 2016

  Mathematical Functions: 

  • Sum, Sumif, Sumifs,Sumproduct
  • Count, Counta, Countblank,
  • Countif, Countifs
  • Average, Averagea, Averageif, Averageifs
  • Subtotal, Aggregate,
  • Rand, Randbetween, Roundup, Rounddown

Date & Time Function

  • Date, Day, Month, Year
  • Edate, Eomonth
  • Networkdays, Workday
  • Weeknum, Weekday
  • Hour, Minute, Second
  • Now, Today, Time

Text Functions & Data Validation

  • Char, Clean, Code, Concatenate
  • Find, Search, Substitute
  • Replace, Len, Right
  • Left, Mid, Lower, Upper, Proper
  • Text, Trim, Value, Large
  • Small Filters (Basic, Advanced, Conditional)
  • Sort (Ascending, Descending, Cell/ Font Color)
  • Conditional Formatting
  • Data Validation
  • Group & Ungroup
  • Data split.

Statistical Function & Other Functions:

    • Isna, Isblank, Iserr, Iseven,
    • Isodd, Islogical, Isytext
    • Max, Min, Len, Right, Left, Mid
    • Maxa, Maxifs, Median, Minifs
    • Mina, Vara, Correl, Geomen

 

Logical Functions:

    • And, Or, If,
    • Iferror, Not, Nested If
    • Lookup & Reference Functions:
    • VLookup, HLookup
    • Index, Match,
    • Offset, Indirect,
    • Address, Column
    • Columns, Row, Rows
    • Choose
    • Arrays Concept In Lookup Formula’s
    • Past Special, Past link
Advanced Excel Course

Take Demo Classes of Excel basic to advanced course