Sunday, December 29, 2013

Book Review: Microsoft Office 2013 Professional 2013 Step by Step

Before some time Microsoft Press and Oreilly sent me Microsoft Office Professional 2013 Step by step by to review. I was so busy at my professional commandment that I was not able to review. Now I get a time to review and here is review of book.

About this book:


MicrosoftBook
Anybody who knows computer Knows about Microsoft Office Suite there are tons of features available in this office suite like Microsoft Word, Microsoft Excel, Microsoft Power point etc.  We all know this software's a little bit but we were not aware tons of feature each software has and this book aim to reveal all this features this can make your life very easy.

This book is designed for beginning to intermediate users. This books contains all the examples that could benefit individual as well as Business organizations.

This book is divided in 8 Parts from getting started to advance features.

Part-1 Office Professional 2013 Fundamentals:


In this part its get started with making user comfortable with Microsoft Office 2013 Environment and then it also highlights some of shared office features. It also highlights how you can use cloud services with your office application and even how you can use office with windows 8 touch device.

Part-2 Word 2013:


This part contains 6 chapters related to word where it get started with getting comfortable in word 2013 and then it also tells about navigation and reading features of word to editing and composing documents. There are some special chapters for presenting information and finalizing documents also.

Part-3 PowerPoint 2013:


This part contains 6 chapters related Powerpoint from getting comfortable in PowerPoint 2013 to finalizing and presenting. If you are a computer geek and you need to present in front of audience this part is for you. You can become expert in Power point via reading this chapters. It also emphasis creating office graphics and adding animation and multimedia.

Part-4 Excel 2013:


If you are an business owner and uses Excel in your day to day activities then this part is for you. This part contains 7 chapters dedicated to excel. Here you learn everything from creating and editing worksheets to analysing data to creating chart and graphics based on your worksheet. 

Part-5 Outlook 2013:


Emails become one of the best communication channel between people this days and If you don’t know Microsoft Outlook email client then you will look like illiterate. This part is for Outlook 2013. Its start with making yourself comfortable with Outlook 2013  to sending emails. It also contains chapters related to Staying on schedule, Working with tasks, Managing contacts and people and last and important tips and tricks about Microsoft Outlook to save your time. Another excellent part!!

Part-6 One Note 2013:


This part contains 6 chapters related to One Note. If you are attending lots of meeting and you need to take notes then this part is for you. There are tons of features explained about One Note to using One note every where.

Part-7 Access 2013:


This part contains 7 chapters related to Access 2013. From creating table to designing forms and reports to querying tables. If you are running a small organization with Microsoft Access you can maintain your data very easily and this part will make you expert of Microsoft Access.

Part-8 Publisher 2013:


This part contains 3 chapters related to Publisher 2013 from making yourself comfortable to creating,saving and exporting publications.

Conclusion:


Microsoft Office Professional 2013 step by step is a great book for the beginners and for intermediate users it can work as reference book. It explains all the components of Office Professional 2013 in very detail, straight forward and easy to understandable way.  This book is very well written by experience authors like Beth Melton, Mark Dodge, Echo Swinford, Andrew Couch, Eric Legault, Ben M. Schorr and Ciprian Adrian Rusen.

If you want to learn in Office 2013 Professional and become expert then this book is must buy for you!! I highly recommend this book for no voice to intermediate users of Office.

On this occasion, I would also like to thank Microsoft Press and Oreilly team for choosing me to review this book. I learn a lot of things in office with the help of this book.
Share:
Saturday, December 14, 2013

Creating DJango application with Python in Visual Studio

In previous post I have written about creating a basic python application with visual studio. In this post we are going to learn how we can create a DJango application with Python in Visual Studio with the help of python tools for Visual Studio.

What is DJango?


As per wikipedia, DJango is a free open source web application framework written in python which follow ups model view controller architectural pattern.It is maintained by  DJango Software Foundation an independent non profit organization. Django’s primary goal is to ease the creation of complex, database driven websites. DJango emphasizes reusability and plugability   of component and principle of Don’t repeat your self.

Creating DJango application with Visual Studio :


Let’s create first DJango application with Visual Studio and Python tools for Visual Studio. So to create DJango application with we have to create a new project via File->New Project –> DJango project just like following.

first-django-application-with-python-visual-studio

Once you click ok it will create a DJango project like following.

First-Django-application-solution-exploer-visual-studio

Now it’s time to create our first application. So right click FirstDjango folder and add new DJango App.

First-Django-app-solution-explorer-visual-studio

Now once you click on DJango app it will open a box like below.

Add-DJango-app-web-python-visual-studio

Now its time to install Python Environment to application via right click on python environment in solution explorer and select environment.

Select-Python-DJango-Environment-Visual-Studio

Now once you click OK it will add python environment to application.

python-environment-visual-studio

Now right click python 2.7 and right click it will open up a popup like below.

Install-Python-Package-Visual-Studio

Once you click on Install Python Package it will open up a dialog like following.

Install-DJango-VisualStudio
Once you click OK It will install DJango package in Visual Studio after installing lot of files it may take 5 to 10 minutes.

Installing-Django-Visual-Studio-Sucessfully

It’s done!! run your first application with DJango with f5 and following you see in browser.

Running-DJango-Application-Python-Visual-Studio

Woohoo!! your first python web application ready. Hope you like it. Stay tuned for more..
Share:

ASP.NET Web API vs WCF

With Microsoft.NET Stack there are lots of way to create service like ASP.NET Web Service, WCF(Windows Communication Foundation) service and now ASP.NET Web API. The developer often get confused mainly between WCF Service and Web API. So I thought it is a good idea to write a blog post to about differences between ASP.NET Web API and WCF Service.

Difference between ASP.NET Web API  and WCF Service:


  1. WCF services support multiple transport support like HTTP,TCP,UDP,MSMQ and allow switching between them while ASP.NET Web API is used only http based services best suited for http service and mobile based application back end service. It is an quick and easy way to create http service.
  2. WCF support multiple encodings like Text,MTOM while ASP.NET Web API support wide range of media types like XML,JSON etc.
  3. WCF Service support Request-Reply, One way and duplex exchange patterns while HTTP service only support Request/Return pattern.

When to choose? What? WCF or Web API


  • Choose WCF if you want to support any other transport protocol then HTTP.
  • Choose Web API when you want to create resource oriented services very quickly.
  • Choose Web API when you want to serve wide variety of clients like browsers, mobile etc.
  • Choose WCF when you want to support message queuing, one way messaging and duplicate message communication.
Share:
Wednesday, December 11, 2013

Creating first python application in Visual Studio

Before some time I have blogged about Python tools in Visual Studio and explained how we install python tools with visual studio and start developing python application with the one of greatest editor in class Visual Studio. In this post we are going to learn how we can create a python application in Visual Studio.

First check whether Python Interpreters are install on your machine or not?


First step for creating python application with Visual Studio is to check whether Python interpreters are installed or not not. To Check this after installing Python tools for Visual Studio go to Tools menu –> Python Environments and it will show a list of python environments available.

Python Enviroments for Visual Studio

If it is not installed, you need to download from http://www.python.org/. I have already installed Python 3.3 so its showing there.

Creating first python application:


Once you install Python tools for visual studio it will also have options to create python application in visual studio. So go to file menu –> new project options->templates-> Select python it will show all the python options available for visual studio just like below.

Visual Studio Python Project Templates

There you have few options like below.
  • From Existing Python Code
  • Python Application
  • Django Project
  • Python MPI Application
  • IronPython Application
  • IronPython WPF application
  • IronPython Silverlight Web page
  • IronPython Windows application
As we need to create a simple application for python we are going to our first application with Python application.Once create project it will create application like following.

Python application in visual studio solution explorer

Now open that PythonApplication1.Py and write following code.

Python Hello World application with Visual Studio

And now run application via pressing f5.

PythonApplicationfromvisualStudioOutput

That’s it we are able to run our first application in Visual Studio. Woohoo!! Hope you like it. Stay tuned for more..
Share:
Sunday, December 8, 2013

Python tools for Visual Studio

Lots of people complaining that Microsoft does not support open source that is a myth about Microsoft it does support there are lots of open source initiative done by Microsoft and Python tools for Visual Studio is one of them.

With the help of this plugin you are able to do work on python on Visual Studio one of best editor in class.

Here is the link from you can download the Python tools for Visual Studio. Python tools are available for Visual Studio 2010,2012 and 2013. You can download the tools according your version.

PythonToolsForVisualStudioCodePlex

Go to download and here you can download Python as per your visual studio version 2010,2012 or 2013.

Pythontoolsfordiffrentvisualstudioversion

Installing Python Tools for Visual Studio :


Installation of Python tools is quite easy. Download the setup files and run exe of for that setup. You will get following screen.

PythonForVisualStudioInstallation1

Accept terms in License Agreement and click on install. There is also advance mode available where you can select different options.

PythonForVisualStudioInstallation2

Once you click install it will start installing python tools.

PythonForVisualStudioInstallation3

Once installation complete it will notify like below.

PythonForVisualStudioInstallation4

Click on finish and Yep you are ready to write code in python for Visual Studio.

Python and Visual Studio :


Now once you open Visual Studio and create a new project it will also Python as new language options.

VisualStudioPythonProject

Here you have various like From Existing Application, Python Application, DJango Project, Python MPI application. You can also see there is IronPython support is also there.

That’s it. You can see its very easy. Hope you like it. Stay tuned for more..
Share:

ASP.NET and Web Tools 2013.1 Tools for Visual Studio 2012

Recently Microsoft has released ASP.NET and Web Tools 2013.1 for visual studio 2012. There are tons of new feature and improvements are there. So Now it’s possible to have all the latest feature on ASP.NET stack on Visual Studio 2012 like ASP.NET MVC 5, ASP.NET Web API 2, Entity Framework 6.0 etc.
You can download this update from the following link.

http://www.asp.net/visual-studio/overview/2012/aspnet-and-web-tools-20131-for-visual-studio-2012

ASP.NET MVC 5:


Once you install this tools, ASP.NET MVC 5 templates are also installed.

ASPNETMVC5VisualStudio2012ProjectTemplate

So now you can use all the ASP.NET MVC 5 feature like One ASP.NET, ASP.NET Identity,Bootstrap MVC template, Authentication Filters,Filter overrides etc.

ASP.NET Web API 2:


ASP.NET Web API2 is also available here.

ASPNETWebAPI2VisualStudio2012ProjectTemplate 

So all ASP.NET Web API2 features like attribute routing, Cross Origin Resource Sharing, OWIN (Open Web Interface for .NET), IHttpActionResult, Web API Odata all are available Visual Studio 2012.

Twitter BootStrap Template:


Now ASP.NET MVC 5 application comes with Twitter Bootstrap, So all goodies of Twitter Bootstrap will be there with your ASP.NET MVC application.

Entity Framework 6.0:


It’s also comes with Entity framework 6.0. Where you have some new great features like Async Query and Save,Connection Resiliency, Code-Based Configuration, Dependency Resolution, Interception/SQL Logging, Improved transaction support etc will be available in Visual Studio 2012 itself.

Also there is a new version of Nuget is also available with this release. So now if one developer has Visual Studio 2012 and another one is having Visual Studio 2013 then also they can work on same project.

This post is a just an overview of all the new features that are available with this release. I will write in detail about all this new features. Stay tuned for more..
Share:
Saturday, December 7, 2013

New Milestone achieved–600,000 visits for my blog

Today, I got a good news from www.sitemeter.com that My blog has completed 600,000 visits for my blog. It’s a great achievement. I have never thought I will go so far.  It’s because of readers of my blog so thank you very much for your support and love without you guys this was not possible. On this occasion I would also like to thank my family for always being there and supporting me whatever I do and believing in me that I could do that. Thanks you very family!!.

Here are few statistics of my blog.

Statistics for my blog - A blog about asp.net mvc and other microsoft technologies

So till now 600,505 visits and 763,338 page views I got about 253 unique visits everyday.

Again thank you very much all readers of this blog without you it was not possible. I will keep writing blog whenever I get time from my professional commitments. I am loving all the communities are there and always been part of that.

Please also suggest me topics for writing blog post. Stay tuned for more..
Share:
Search This Blog
About Me
My Photo

Full Stack Developer,Blogger,Microsoft Mvp, Mentor, Life long learner, 10+ Years of Experience for JavaScript, web and Microsoft technologies. ASP.NET MVC,Web Forms,C#,AngularJs,Golang
Mvp profile
Subscribe to my blog

Enter your email address:

Follow us on facebook
Blog Archive
Total Pageviews