• Best Advanced Excel Training in Kolkata
    Advanced Excel Training Kolkata

****100% Job Assistance.****


(Online Tuition Available)

Course Structure

Working with Excel Files,Entering data,Working with numbers,Formatting data,Managing your data in excel worksheet,Working with text and date,Manipulating data,Working with charts,PMT & FV,IPMT & PPMT,MACROS, MIS Report: Types, Examples and How to Effectively Prepare it, Split Data from a Master Sheet into Several Worksheets in Excel,Forecast,And,OR,Correl,Ceiling,Frequency,Sparklines (Line,Column,Win/Loss),working with Pivot Table,Pivot Chart,Slicer,Timeline,Power View,Power Pivot,Solver,Formula Auditing,Sorting,Filter,Advanced Filter,Data Validation,Consolidate,Vlookup,Hlookup, Abs,Concatenate,Exp,Exact,Fact,GCD,Int,LCM,Left,Len,Lower,Max,Mid,Mod,Now,
Power,Proper,Replace,Rept,Right,Round,Search,Sqrt,Today,Trim,Upper,Conditional Formatting,Find,Round,Round Up,Round Down,working with Salary Sheet,Absolute & Relative Cell References,Multiple IF Function,What If Analysis(Goal Seek,Scenario Manager),Subtotal,Text To Columns,Remove Duplicates,Freeze Panes,Istext,Isnumber,N Formula,Istext With Vlookup,Isnumber With Vlookup,Vlookup In Same Sheet,Vlookup In Deferent Sheet,CountA,Count Blank,Count If,Sumif,Sumifs,Choose,Printing excel files,Managing Excel files,Grouping and outlining data,Shortcut keys and references,etc.

Learning Outcomes:

Understand the use of Excel Functions
Gain Insights from vast array of data with ease
Make powerful dashboards
Analyse data like a professional
Understand shortcut techniques for faster and efficient use of Excel

  • Course fees Rs.7500/

  • Duration:- 2-3  months.

Our Successful Student’s of Advanced Excel Training

  • Uday Banik

(Online Tuition Available)

E-mail: raja@nicscomputer.com
D/70 Baghajatin Station Road, P.O- Jadavpur
Near: Pranta pally Girls High School
Bus Stop & Rail Station : Baghajatin
9830760989 / 9062813257