Course Detail

Advanced Excel

Advanced Excel

  •    Duration: 1 Month
  •    Eligibility: Graduate/ Professional

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our free Excel Crash Course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level. This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research and FP&A. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you've mastered them. The main formulas & functions covered in this training course include:

Syllabus:

  • Overview of the Basics of Excel
  • Working with Functions (AND, OR, NOT, VLOOKUP, HLOOKUP, MATCH, INDEX)
  • Data Validations
  • Working with Templates - standardization
  • Sorting and Filtering Data (AutoFilter)
  • Working with Reports - Pivot tables
  • More Functions- Date and time, Text, Database, CountIf, CountIFS, SumIF, SumIfS
  • Formatting
  • Relative & Absolute Macros
  • What If Analysis - Goal Seek, Data Tables, Scenario Manager
  • Charts
  • New Features Of Excel - Sparkline, Inline Charts, data Charts

Assignment:  Self-Assessment by Faculty

Exit Profile: Expert in Excel Application Software

Back

nielit courses in lucknow

nielit centers in lucknow

nielit center in gomti nagar

o level in gomti nagar

o level course in gomti nagar

best o level institute in lucknow

o level training institutes in lucknow

gst course in gomti nagar

computer course in lucknow

best computer institute in lucknow

best computer institute in gomti nagar

best computer center in gomti nagar

o level course fees in lucknow

o level course fees in gomti nagar

doeacc o level course in lucknow

ccc in lucknow

ccc course in lucknow

ccc course in gomti nagar

ccc course fees in lucknow

ccc course institute in lucknow

tally institute in lucknow gomti nagar

tally academy in gomti nagar

tally center in gomti nagar

ccc computer course in gomti nagar, lucknow

seo course in lucknow

project training in lucknow

project training in gomti nagar

industrial training in lucknow

summer training in lucknow

.net training institutes in lucknow

asp.net training in lucknow

java training in lucknow

core java training in lucknow

php training in lucknow

Back to Top