Workshop

Mastering in Lightroom

1 Day Workshop
Time 9am – 5pm | 3000 Rs
Venue :Shrijibapa Web consultancy
Creative Light Room Presets more than 3000, (On Pen Drive)
Digital Study Material books (On Pen Drive)
Office Lunch  + Hi tea

Power Excel Using for Office Automation

Microsoft Excel 2016  ( Maximum Seats 5 )
  • Explore MS office Excel program usages in many ways to get maximum utilization.
  • Power Excel Using for Office Automation
    Time 9am – 5pm | 2500 Rs
  • What You will Learn
  • Making Master Business Contacts / Clients Database – Maintenance – Filtering Sorting – Security
    Account Day book
    Formula for Daily office Uses :
    Dynamic Percentage Formula
  • Function :
  • Sum , Auto sum , Bifurcated Sum, Sum if , Sum ifs , Average , Average If, Average ifs, Maximum, Minimum , Large, Conditional Formula Calculation Use of IF , Look up , V Lookup , Hlookup , Search , Index , Forecast
  • Audit Tools for Formula
  • Database Management :
  • Sort , Filter , Sub total , Pivot Table , Chart , Duplicate data removing
    Manipulation of Data sheet , add , remove, Link data Value
    Cutting , Copy , Paste, Paste Special Data
    Insert / Delete Raw , Cell , Column
    Hide/ Unhide Raw/Column /Sheet
    Password Protection for Security
    Linking sheet – Linking Books with formula
    Time Saving Short Cuts
  • Rajesh Bhonkiya Mo 9979884499
    C-1, Shrijibapa Complex , Opp Swaminarayan Mandir Vasna ,
    Vasna , Ahmedabad

[MEC id=”734″]

[MEC id=”724″]