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
January

February 2018

March
MO
TU
WE
TH
FR
SA
SU
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
1
2
3
4
Events for February

1

No Events
Events for February

2

No Events
Events for February

3

No Events
Events for February

4

No Events
Events for February

5

No Events
Events for February

6

No Events
Events for February

7

No Events
Events for February

8

No Events
Events for February

9

No Events
Events for February

10

No Events
Events for February

11

No Events
Events for February

12

No Events
Events for February

13

No Events
Events for February

14

No Events
Events for February

15

No Events
Events for February

16

No Events
Events for February

17

No Events
Events for February

18

No Events
Events for February

19

No Events
Events for February

20

No Events
Events for February

21

No Events
Events for February

22

No Events
Events for February

23

No Events
Events for February

24

No Events
Events for February

25

No Events
Events for February

26

No Events
Events for February

27

No Events
Events for February

28

No Events
No event found!