Skip to Content
Home └Master in Excel-(for Finance Exec.)
Master in Excel-(for Finance Exec.)

Master in Excel-(for Finance Exec.)

 

₹ 499.00
499.0 INR ₹ 499.00
₹ 499.00
Buy Now
Add to Cart
Responsible CA Saurabh Jog
Last Update 20/08/2024
Completion Time 19 hours 19 minutes
Members 6
Advanced
  • Course Introduction
    1Lessons · 5 mins
    • Download Related Files
  • Section-1 Basic Concepts, Formulas
    6Lessons · 2 hrs 15 mins
  • Section-2 Functions
    13Lessons · 6 hrs 21 mins
    • 2-1 Functions Intro
    • 2-2 Functions Sum
    • 2-3-1 Functions Sumif
    • 2-3-2 Functions sumif expl
    • 2-4 Functions Sumproduct
    • 2-5-1 Functions If
      Free Preview
    • 2-5-2 Functions If and
    • 2-6 Functions if or
    • 2-7 Functions if nested
    • 2-8-1 Functions Vlookup
    • 2-8-2 Functions Vlookup1
    • 2-9 Functions Vlookup Match
    • 2-10 Functions HLookup
  • Section-3 Data Manipulation
    6Lessons · 2 hrs 28 mins
    • 3-1 Import data to excel
    • 3-2 filter1
    • 3-3 filter2
    • 3-4 sort
    • 3-5 subtotal
    • 3-6 Conditional formating
  • Section-4 Pivot Tables
    5Lessons · 2 hrs 8 mins
    • 4-1 Pivot Table1
    • 4-2 Pivot Table 2
    • 4-3 Pivot tables3
    • 4-4 Pivot table fields
    • 4-5 Pivot Table 4
  • Section-5 Visualizations & Charts
    5Lessons · 1 hr 56 mins
    • 5-1 Charts 1
    • 5-2 Charts 2
    • 5-3 Charts 3
    • 5-4 Charts 4
    • 5-5 Charts 5
  • Projects
    10Lessons · 4 hrs 6 mins