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
November

December 2017

January
MO
TU
WE
TH
FR
SA
SU
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
6
7
Events for December

1

No Events
Events for December

2

No Events
Events for December

3

No Events
Events for December

4

No Events
Events for December

5

No Events
Events for December

6

No Events
Events for December

7

No Events
Events for December

8

No Events
Events for December

9

No Events
Events for December

10

No Events
Events for December

11

No Events
Events for December

12

No Events
Events for December

13

No Events
Events for December

14

No Events
Events for December

15

No Events
Events for December

16

No Events
Events for December

17

No Events
Events for December

18

No Events
Events for December

19

No Events
Events for December

20

No Events
Events for December

21

No Events
Events for December

22

No Events
Events for December

23

No Events
Events for December

24

No Events
Events for December

25

No Events
Events for December

26

No Events
Events for December

27

No Events
Events for December

28

No Events
Events for December

29

No Events
Events for December

30

No Events
Events for December

31

No Events
No event found!