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

Best Computer Education Institute Lucknow

Best Software Institute Lucknow

NIELIT O Level Courses 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

Full stack development institute near me Gomti Nagar Lucknow

Full stack development institute near me for freshers

Full stack development institute near me for beginners

Best full stack development institute near me

Web development course fees in lucknow

Web development institute in lucknow

Full stack developer course

Digital marketing training in gomti nagar, lucknow

Digital marketing course in gomti nagar, lucknow fees

Java full stack developer course free with certificate

Java full stack developer course fee

Java full stack developer course online

Python full stack developer course near Gomti Nagar Lucknow

Best Computer Courses After 12th Pass

Software Engineer Courses Lucknow

Best Web Graphic Designing courses in Lucknow

Web Designing course Lucknow

Graphics Designer Courses Lucknow

Graphic Designer Courses Lucknow

C Programming Language course Lucknow

C Programming Language courses fees

C++ courses Lucknow

php summer training Lucknow

English typing Course Lucknow

Digital Marketing Training fees Lucknow

O level course fees in lucknow

O level course fees in gomti nagar

Doeacc o level course in lucknow

CCC in lucknow

CCC 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.ERP9 courses Lucknow

Advance Excel Course Lucknow

Tally academy in gomti nagar

Tally center in gomti nagar

ADCA Computer Courses Lucknow

Full stack developer course

Full stack course

Full stack developer classes

Courses for full stack developer

Full stack classes

Course for full stack developer

Best computer institute near me

Full stack web development course

Full stack development course

Java full stack developer course

Full stack java developer course

Python full stack developer course near me

Python full stack developer course fees

Best python full stack developer course near me

Python full stack developer course

full stack net developer course

net full stack developer course

dot net full stack developer course

Software Training Institute Lucknow

DCA Courses Fees Lucknow

Accounting and Finance Diploma Courses Lucknow

Office Training Courses Lucknow

Microsoft Office courses in Lucknow

Programming in C++

Fees of computer Courses Lucknow

php live project training

Java training Lucknow

Online typing course

SEO SMO Training Lucknow

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

Asp.net training in lucknow

ASP.NET Training Lucknow

ASP.NET Training Institute Lucknow

Summer Internship and Industrial Training lucknow

Summer Training Institute Uttar Pradesh

PHP Training Lucknow

Tally Fees

Tally Courses in Lucknow

Diploma in Computer Application

Java training in lucknow

Core java training in lucknow

PPH training in lucknow

Digital marketing course in gomti nagar, lucknow

Best digital marketing institute in gomti nagar, lucknow

Digital marketing institute in gomti nagar, lucknow

Best digital marketing institute in gomti nagar, lucknow

Digital marketing course in gomti nagar, lucknow

Best digital marketing course in gomti nagar, lucknow

Digital marketing training in gomti nagar, lucknow

Best digital marketing training institute in gomti nagar, lucknow

Digital marketing institute in gomti nagar, lucknow

Digital marketing training in gomti nagar, lucknow

Digital marketing course in gomti nagar, lucknow fees

python full stack developer course with placement

full stack web development course in lucknow

ASP.NET full stack developer course near Lucknow

ASP.NET full stack developer course near Gomti Nagar Lucknow

Training in PHP Technology

IT sector training Lucknow

Best IT sector courses Lucknow

Training in ASP.NET Technology

Hindi typing course Lucknow

Digital Marketing Training Institute Lucknow

Back to Top