Certificate in Advanced Excel TRENDING

Course Fee: ₹ 4500

Duration: 3 Months

Monthly: ₹ 1500

(Note: Certificate Charges:– ₹ 300 Extra)

TechPiller offers Advanced Excel training in delhi. If you’re an Excel beginner (or an intermediate) and want to learn Advanced Excel, this is the perfect place for you to start. Such detailed Excel and Advanced Excel course has helped our students secure job in various MNCs. Whether you're a fresher or working and wanting to improve your Excel skill and wish to make ease some office tasks so, with the help of advance excel it can be considered possible. Excel is fully job-oriented course in itself, one could get a good job easily by successfully completing Advance Excel course from Best Institute of Advance Excel Training. TechPiller has helped so many students to set up their career with best efforts and knowledge by providing placement help to them. On doing a professional course at TechPiller, get an opportunity of working at MNC. Through trust and quality of placement are making TechPiller the Best Advance Excel Training center in Delhi.

Course Content:

3 Months CAE
  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphsss
  • Analyzing data: Data Menu, Subtotal, Filtering Data
  • Working with functions & formulae Formatting worksheets
  • Securing & Protecting spreadsheets
  • Logical Test- IF & Nested
  • SUM IF & SUM IFS
  • Not and if Error
  • Auditing Tools
  • Text Functions
  • Date Function
  • Name Range & Name Range with Formulas
  • Macros
  • Count Function & Statistical Function
  • Maths & Trigonometry
  • V-Lookup
  • H-Lookup
  • Lookup Function & Lookup Full Record
  • Index function
  • Match Function
  • Protect Cell, Sheet, File, Workbook
  • Hyperlink to sheet, File, Webpage, Update
  • Data Sorting
  • Advance Filters
  • Filtering Data
  • Advance Table
  • SUM IF & SUM IFS
  • Column Chart
  • XY Scatter Chart
  • Spark Line Chart
  • Pivot Chart (Table)
  • Pie Bar, Column & Line Chart
  • Pivot Table (Grouping, Slicer, Timeline)
  • Consolidation
  • Consolidation Extended
  • Conditional Formatting & Advance Conditional Formatting
  • Data Validation Error Alert
  • Dependent Dropdown List
  • Import Live Data from Web
  • Insert, Create Object
  • NPV
  • PMT, PPMT, IPMT