#2 MS-Office Gyan for the day… (PowerPoint 2013)

In my last post I wrote about the new feature eye dropper” in PowerPoint 2013, this time I am writing about another features of PowerPoint.

 

How many of you used a screenshot in your presentation?

 

So you have used the paintbrush or other such tool to make it more good looking and then copy it to the presentation in your PowerPoint. You might have saved it and inserted it as a picture as well.

How about using any open window’s screen shot on the fly while designing your presentation and without  any help of picture editing tools. Yes no need to take it to the paintbrush and giving it a final touch. Everything is ready for you in PowerPoint itself.

image

 

Open the Microsoft PowerPoint and you can start with a blank page or a template of your choice.

Now open the window from which you want to copy a screen shot to your PowerPoint presentation. Navigate to the page or the window and you are done. No copy, no screen capture, nothing. For example I opened my blog in IE i.e. web browser window.

image

 

Now lets get back to the PowerPoint presentation and click on Insert menu and take your mouse to the Screen Shot button of the Images area. Just keep it there and read the tooltip.

Take a screenshot!!!!!

image

Now click the Screenshot button with small camera and a plus image on it. It will display you a list of Available Windows, (the current opened one in your system). Now its time to pick up the one you want to insert as a screen shot. The dialogue box that appears is asking for a hyperlink to the page if it’s a browser window. Choice is yours…just go ahead Smile

image

Remember my choice !!

image

…and what you thought … easy right Smile Smile Smile . Just a few steps and we are ready with the screen shot.

image

Guess what… it opens with an option to edit the image , the picture tools is all set for you. Now edit your picture inside PowerPoint, instead of going to other picture editing tools.

Power point 2013 has more features and options like this and you can learn More From Here & Here.

Till next time “Happy Learning & Sharing” :)

SQL Bang UG…Completed A Quarter…Sharing is fun, sharing is learning

430589_10151249803289029_384269882_n       I joined SQL Bangalore User Group (#SQLBangUG) as one of the first 4 members and till date I am part of this “knowledge Hub”, where sharing is fun while learning.

It was Saturday, November 24, 2012 when the first SQLBangUG was hosted at Microsoft Signature Building, Bangalore, India. Vinod Kumar delivered the key note for the event with his unique style of welcoming all and introduced the speakers while explaining the core  purpose of SQLBangalore User Group.

 

"Sharing is fun, sharing is learning"

 

I was lucky enough by getting a chance to present a session on SQL Server 2012 and would like to thank Vinod and Pinal for giving  me an opportunity to deliver a a session at such a big event. Being a learner and a student this forum is going to help me a lot.

The First UG meet sessions were

1: T-SQL Pitfalls  Speaker: Vinod Kumar M, MTC – Technology Architect
2: Top 5 SQL Server 2012 functions Speaker: Manas Ranjan Dash
3: Contained databases Speaker: Sudeepta Ganguly, Sr. Systems Engineer – Atos
4: Column Store Index in SQL Server 2012 Speaker: Pinal Dave, Evangelist – Pluralsight

Also we had two surprise session by International Speaker Lynn Langit, BigData and BI consulting & Raj Chaudhuri from Microsoft, Mumbai on Index and Big Data.

 

66022_500051696693269_1000969640_n386525_500052030026569_538144332_n556795_500052376693201_541434094_n68306_500053216693117_15063029_n14157_500054453359660_704467154_n311241_500054380026334_746315131_n66092_500056346692804_1377774993_n543012_500056250026147_948877610_n63767_500057260026046_1298326439_n

Photo courtesy: Sandip Pani

Pinal Dave from Pluralsight gave away one year free subscription coupon of Pluralsight courses to one of the lucky audience and also he gave couple of his books and monthly coupons of Pluralsight to other attendees.

Sahal blogged about this event and  this was written prior to the event which shows the excitement level of the participants and the enthusiasm to learn something new.

http://www.get-exchange.info/2012/11/20/nosql-ug-meet-sqlbangalore-ug-meet-on-24-nov-2012/

By December 18 the group had added 300 members to its list Smile

 

The Second UG Meet was on Saturday, December 22, 2012

The sessions were as follows

1. Better together: Excel + SQL for Database Developers By Kamlesh Rao
2. Basics of Backups with SQL Server By Balmukund Lakhani, Microsoft
3. Intro to Indexing – Basics rediscovered By Sourabh Agarwal, PFE – Microsoft
4. Knowing sp_server_diagnostics output By Amit Banerjee, PFE, Microsoft
5. Tips and Tricks Session By Vinod Kumar, MTC – Architect

548847_10151382283862803_764516271_n398713_491457330906098_1042803860_n393140_491457207572777_853433763_n406697_491457440906087_1815952124_n66702_491457484239416_1348497391_n483196_492572390794592_826425171_n

Amit Banerjee wrote a blog about the event which is the fastest ever published blog on SQLBang UG http://troubleshootingsql.com/2012/12/22/sql-bangalore-ug-meet/

Also an excellent coverage by our Super Star Balmukund Lakhani in his blog http://sqlserver-help.com/2012/12/23/coverage-report-sql-server-bangalore-user-group-meeting-2-22-december-2012/

 

and we did it! Crossed 400 Mark on 1st Jan 2013 ~ Balmukund Lakhani

 

Also we wished our members on new year day with this unique poster

SQLBangUG_2013

 

The Third UG Meet was on Saturday, Jan 19, 2013 which focused on EXCEL based visualizations

1: Tour of PowerPivot with Excel by Vinod Kumar

2: Advanced Excel Visualizations by S Anand

3: Introduction to PowerView with Excel by Selvakumar

4: Surprise SharePoint Session by Pinal Dave

image814801_10200454388025068_553314515_n14871_498864596821477_2055710638_nimage_thumb18image_thumb13274938_497847073589896_1324110356_n

SQL Bangalore se Balmukund Lakhani without Cameraman

http://sqlserver-help.com/2013/01/22/coverage-report-sql-server-bangalore-user-group-meeting-3-19-january-2013/

We were forced to postpone the SQL user group meeting (scheduled for 23 Feb 2013) by a week due to some issues with the availability of speakers.

Great Discussion and Knowledge Sharing in FB page

 

In between all these sessions the FB page of SQLBang was fully occupied by members where they discussed some live issues and shared great knowledge about SQL Server and the trend is going on with a lot of enthusiasm.

 

Next UG meet on 2nd March 2013

So What are you waiting for… join the SQL Bangalore User Group and experience the power of sharing through learning and be a part of the next UG meet on 2nd March 2013

This UG meeting is about multi-dimensional concepts. This is completely different from the relational engine we are aware off. Register at here

1: Start your journey with Multidimensional using SSAS -by Sudhir Rawat (Microsoft)
2: Introduction to Cubes -by Deepthi Anantharam (Technology Evangelist)
3: SQL Server 2012 Analysis Services – Tabular Mode by Karan Gulati (Microsoft)

Smile Smile Smile Today the group has welcomed its 791th member Smile Smile Smile

 

What & where

 

Facebook: https://www.facebook.com/groups/SQLBangalore/

Events Page: https://www.facebook.com/groups/SQLBangalore/events/

Twitter: @SQLBangalore

Twitter Hash Tag: #SQLBangUG

Download PPT from the Past sessions

https://www.facebook.com/groups/SQLBangalore/files/

 

SQL Bangalore UG se Manas Ranjan Dash

Till next “Keep Smiling”

Gift from SQL Server (Microsoft Corporation, Redmond)

 

Last year in December I participated in a unique contest by Microsoft SQL Server (FB page).

The contest page says…sqlserver_logo

Enter the New Year Cover Photo Challenge and help us ring in 2013 with a ‘Happy New Year’ themed message to the SQL Server community! Submit an image or photo of your own design that we can use as our SQL Server Facebook page cover photo in January, and if your entry is selected as one of our four winners, you will also receive a SQL Server Swag Set worth over $150!

 

On 29th of December 2012 I got  a mail from the Microsoft SQL Server team saying…

Hi there Manas,

Congratulations! You’ve been selected as a winner our New Year’s photo challenge!

 

They published the photo in their FB page and here is the link for the same SQL Server Cover Photo Challenge

ManasDash

 

On 18th February I received a parcel from USA where I found the following gift.

 

DSC_0082DSC_0084

DSC_0086DSC_0088DSC_0085

*** Sports Bottle, T shirt, SweatShirt, USB Flash Drive, USB Hub, Speaker

Thank you SQL Server and the team and special thanks to Katrina Munsell  Smile Smile Smile

 

Till next time “Keep Learning and Sharing”

#1 MS-Office Gyan for the day (PowerPoint 2013)

This is the first blog post on tips or tricks for MS-Office by me and am excited to start this series, but it may not be a series of post that you get everyday. When ever I come across a new features or some interesting things to share I will just summarize my learning here. I consider all my blog post as my personal database of my learning and for future use. It may or may not help you and all the blog post are just my learning , there may be better idea and process or option which you can go for. Feel free to read and think before you implement if its useful.

 

So here we go with one of the feature of Power Point 2013 …

Most of the time we get confused (am for sure) during color selection for a logo or a picture we saw somewhere say in a website and we need the same color for our logo.

So today we will take the help of Power Point and one of its new feature “eye dropper” which can be found form the format menu.

So Lets try to mimic the design (its a copy)  of the new logo of Microsoft here. Check the below screen shot taken from Microsoft Power Point 2013 Preview and I will take you through designing this logo from Microsoft.com website logo-lg-1x[1]

 

image

So start Power point 2013 and then take those four square (from Insert menu and select shape). Now when you copy and paste the first square and create other three you can see those are not in proper order and alignment with each other as required).

Even when you organize them in order Power point will help you by providing exact line-up from all the possible ways (Line-up and space objects equally). You can see those horizontal and vertical lines while moving the object and placing them in line-up with other.

image

 image

Now you got the four square, its time to choose the color, look at the color at your target image. You have to decide the exact color, say for the first box whether its  Orange…no its a red.. I think its a  mix of orange and red. Oooopss!!!! Don’t worry lets ask Power point.

Select the First box, Go to Format – Shape Fill and select Eye Dropper. Now with out releasing the left mouse button go to the Internet explorer and click the first square in the Microsoft Logo(which you have opened already as www.microsoft.com).

 

image image image image

image

Immediately you will find that your box (part of the logo) in Power Point is filled with the color that you selected from the website.

image

       Now continue the same for all the four boxes and and the design is ready. You can select the borders to none from Shape Out line. Once you are done with all the finishing touch your logo is ready. If you want save the same as a png or a jpeg format and you have one image ready. Now choice is yours whether you want to design something with all the colors in the world :) .

 

 image

Power point 2013 has more features and options like this and you can learn More From Here & Here.

Till next time “Happy Learning & Sharing” :)

2012 in review

Thank you  WordPress.com stats helper monkeys who have prepared a 2012 annual report for my blog.

Here’s an excerpt:

600 people reached the top of Mt. Everest in 2012. This blog got about 3,600 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 6 years to get that many views.

Click here to see the complete report.

Happy Diwali

Happiness, brightness, joy and all those other flavours are there to add to our live on this special day Deepavali. People in India (most of them) celebrate 5 days of Diwali, they are as follows.

 

Day 1: Dhanteras

Day 2: Choti Diwali

Day 3: Lakshmi Puja

Day 4: Govardhan Puja

Day 5: Bhai Duj

 

diwali

To know more about Diwali and the way its being celebrated in different parts of India visit http://en.wikipedia.org/wiki/Diwali