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
June

July 2018

August
MO
TU
WE
TH
FR
SA
SU
25
26
27
28
29
30
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
29
30
31
1
2
3
4
5
Events for July

1

No Events
Events for July

2

No Events
Events for July

3

No Events
Events for July

4

No Events
Events for July

5

No Events
Events for July

6

No Events
Events for July

7

No Events
Events for July

8

No Events
Events for July

9

No Events
Events for July

10

No Events
Events for July

11

No Events
Events for July

12

No Events
Events for July

13

No Events
Events for July

14

No Events
Events for July

15

No Events
Events for July

16

No Events
Events for July

17

No Events
Events for July

18

No Events
Events for July

19

No Events
Events for July

20

No Events
Events for July

21

No Events
Events for July

22

No Events
Events for July

23

No Events
Events for July

24

No Events
Events for July

25

No Events
Events for July

26

No Events
Events for July

27

No Events
Events for July

28

No Events
Events for July

29

No Events
Events for July

30

No Events
Events for July

31

No Events
No event found!