casinos

Posts Tagged ‘Office’

Productivity Minutes: Compare two tables October 2nd, 2014

Vinod Kumar

I remember writing a three part series on how to compare two lists before in this blog. This can be read from Excel Tip: Compare two lists (Method 3). This video is not about that, here I am going to show you the 4th method that will is super cool in my opinion.

So you could see how easy it is to compare two tables inside of Excel and how one can become efficient learning from Excel. Let this journey continue and let me know your feedbacks.

Do feel free to subscribe to my Youtube channel to get updates in the future.

Continue reading...


 

Productivity Minutes: AutoSum Trick with Excel September 16th, 2014

Vinod Kumar

As the productivity series catches heat, I have got a number of you ask more tips around Excel and other tools. So here is next in series of using AutoSum capability with Excel and how you can quickly calculate the SUM across the range which has sub-total already calculated.

Though I showed you four different way to achieve the same, I am sure you will have many more innovative ways of doing it. Please feel free to share alternate options if I have missed them in the above video. Will be a great learning for me too.

Do feel free to subscribe to my Youtube channel to get updates in the future.

Continue reading...


 

Productivity Minutes: Moving rows in Excel September 8th, 2014

Vinod Kumar

This is in series to our Productivity Minutes videos. I have started to get a hang of these videos and I am loving doing these short videos for you. In this blog, I would like to share the tip around how to move data presented in Excel from one position to another.

Yes, I understand we all are very comfortable in using CTRL+C and CTRL+V. But this tip is NOT about this technique. It is about how we can efficiently use mouse and achieve the movement of a row from one location to another in a Excel Table.

I plan to do these short videos and your feedback and encouragement will do a world of good. So let me know and do feel free to subscribe to my Youtube channel to get updates in the future.

Continue reading...


 

Productivity Minutes: Sharing Outlook Calendar September 4th, 2014

Vinod Kumar

I have had the opportunity to write a number of blog posts around Excel and other productivity tools in the past. Since I started the video blog series, now I will try to bring some of these tips in a quick Video series.

In this short video, we will look at how we can quickly share our Outlook Calendar with our external contacts without sharing our actual meeting details? Wish you wanted to reduce and eliminate multiple rounds of email to lock on a date and time? Well, this video is just for you – trust me.

Hope you enjoyed this quick “productivity minutes” video. Send me your comments filled with feedback and we will have many more in the future too.

Continue reading...


 

Creating Excel Interactive View July 24th, 2014

Vinod Kumar

I have been wanting to write on this topic for ages but seem to have missed out for one reason or the other. How many times in your life seen a web page with a bunch of tables and it is so boring to read them? The numbers or tables sometimes might have sorting capability but lacks a striking visualization to say the least. So I am going to borrow a table from a Wikipedia page about Indian Population. There are a number of tables and the table of interest to be in Literacy rate. So the rough table looks like:

State/UT Code India/State/UT Literate Persons (%) Males (%) Females (%)
01 Jammu and Kashmir 86.61 87.26 85.23+-
02 Himachal Pradesh 83.78 90.83 76.60
03 Punjab 76.6 81.48 71.34
04 Chandigarh 86.43 90.54 81.38

Well, this is as boring as it can ever get even when pasted as-is on this blog. Now here is the trick we are going to do called as Excel Interactive View. As the name suggests, we are going to use the power of Excel to make this mundane table into some fancy charts for analysis. This includes a couple of scripts that needs to be added as part of the HTML Table and we are done. It is really as simple as that. So let me add the complete table with the script added. Just click on the button provided above to see the magic:

State/UT Code India/State/UT Literate Persons (%) Males (%) Females (%)
01 Jammu and Kashmir 86.61 87.26 85.23+-
02 Himachal Pradesh 83.78 90.83 76.60
03 Punjab 76.6 81.48 71.34
04 Chandigarh 86.43 90.54 81.38
05 Uttarakhand 79.63 88.33 70.70
06 Haryana 76.64 85.38 66.77
07 Delhi 86.34 91.03 80.93
08 Rajasthan 67.06 80.51 52.66
09 Uttar Pradesh 69.72 79.24 59.26
10 Bihar 63.82 73.39 53.33
11 Sikkim 82.20 87.29 76.43
12 Arunachal Pradesh 66.95 73.69 59.57
13 Nagaland 80.11 83.29 76.69
14 Manipur 79.85 86.49 73.17
15 Mizoram 91.58 93.72 89.40
16 Tripura 87.75 92.18 83.15
17 Meghalaya 75.48 77.17 73.78
18 Assam 73.18 78.81 67.27
19 West Bengal 77.08 82.67 71.16
20 Jharkhand 67.63 78.45 56.21
21 Odisha 72.9 82.40 64.36
22 Chhattisgarh 71.04 81.45 60.59
23 Madhya Pradesh 70.63 80.53 60.02
24 Gujarat 79.31 87.23 70.73
25 Daman and Diu 87.07 91.48 79.59
26 Dadra and Nagar Haveli 77.65 86.46 65.93
27 Maharashtra 83.2 89.82 75.48
28 Andhra Pradesh 67.66 75.56 59.74
29 Karnataka 75.60 82.85 68.13
30 Goa 87.40 92.81 81.84
31 Lakshadweep 92.28 96.11 88.25
32 Kerala 93.91 96.02 91.98
33 Tamil Nadu 80.33 86.81 73.86
34 Puducherry 86.55 92.12 81.22
35 Andaman and Nicobar Islands 86.27 90.11 81.84

So how cool is this Excel visualisation? I am sure you will want to build or use this capability in your webpages or internal sites in your organizations too. I hope you learnt something really interesting.

If you want to learn more about using this feature in your dataset and web pages, well read the documentation from Excel Interactive View.

PS: the data comes from Wikipedia and I have just used a snapshot to show the same. So please dont read too much into the data etc, look at the Excel view capabilities.

Continue reading...