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
March

April 2018

May
MO
TU
WE
TH
FR
SA
SU
26
27
28
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
29
30
1
2
3
4
5
6
Events for April

1

No Events
Events for April

2

No Events
Events for April

3

No Events
Events for April

4

No Events
Events for April

5

No Events
Events for April

6

No Events
Events for April

7

No Events
Events for April

8

No Events
Events for April

9

No Events
Events for April

10

No Events
Events for April

11

No Events
Events for April

12

No Events
Events for April

13

No Events
Events for April

14

No Events
Events for April

15

No Events
Events for April

16

No Events
Events for April

17

No Events
Events for April

18

No Events
Events for April

19

No Events
Events for April

20

No Events
Events for April

21

No Events
Events for April

22

No Events
Events for April

23

No Events
Events for April

24

No Events
Events for April

25

No Events
Events for April

26

No Events
Events for April

27

No Events
Events for April

28

No Events
Events for April

29

No Events
Events for April

30

No Events
No event found!