Archive

September 2015

Browsing

Microsoft launched their Microsoft office 2016 worldwide on Tuesday,  They announced the availability of Office 2016 for Windows desktop platform. Used by more than 1 billion people worldwide. office is the one of the most popular product in the world. This product is biggest revenue for the company.

Microsoft update a new version of Microsoft Office every three years, They update more and more features, because of the competitive world. Office faces more competition than it has in the recent times.  A number of emerging players including Google’s Drive suite, and open source alternatives like OpenOffice and LibreOffice offer several of Office’s features for no cost at all. So they added more features in Microsoft office 2016, Here is the top 10 features

1) Co-Authoring

Co-authoring allows more than one user to work on a document simultaneously. Microsoft says that users can work on a document regardless of the device – read the operating system – they are using.

2) Office Sway

Microsoft have a office sway, a tool like bundle sway introduced earlier as a standalone service, right into the Office suite. Sway lets you make stylish media presentations that can be quickly made and embedded on websites.

3) Tell Me

Tell Me is a smart assistant that can understand your queries written in completely human-y words. It will assist you with whatever issues you’re having. There is also a feature called Delve, which as the company claims, uses algorithms to bring together the most relevant information or documents in one place

4) Smart Lookup

Smart lookup provide you with contextual information about words and phrases you need to know more about. When you select a word or a phrase – in Word, PowerPoint, or any other Office application – the sidebar opens at the right side with details about the selected text from various sources, including Wikipedia.

5) New themes

Users can now change the light, shiny interface to a rad-looking Dark Gray theme. The dark theme will also come in handy while working at night hours. There are a number of other themes as well.

6) Create forecasting

Create a forecast charts based on historical data. Just select the cells, and Excel now offers one-click option to predict the future trends. You can find the one-click forecasting option called Forecast Sheet under the Data tab.

7) Mail Triage

Mail Triage feature in Outlook analyses your email pattern and also observes the people you interact with the most, and using these metrics, it prioritises your emails.

8)Planner

Planner that allows a team to make projects and quickly make tasks and documents. It utilises Office Graph, a feature that keeps a record of every document, email-related actions, and other activity log of a user. Planner is arguably more efficient and useful.

9)integration with oneDrive and Skype

OneDrive integration enables you to open an Office document from anywhere and from any supported device. Skype, as you can imagine, allows you to talk to your colleagues, initiate and join online meetings and share your screen with your colleagues.

10) Windows 10 support 

There are several Windows 10 features that work great with Office 2016.

Enjoy the Features.

We have faced some problem that we mysql table pulling entire table but we need a particular nth row order. Suppose we have lot of row in the table like 1000 rows but we need nth order row only, In this case, here is the code how to select every n-th row,  you can get particular n order

Demo                            Download

n_th order like

Step 1:  Consider the same table in previous post

nth_order show in mysql

Step 2 : very simple method

Here showing the nth order in even and odd id, that’s it very simple

nth_order show in mysql in even

or Another method for sorting nth order is

Set @row as 1 and add with rownum the div with your nth order

Enjoy code

Many of us struggle with how to display mysql rows as columns. For example, having student details and subject and mark in a table. we need to show student, and is each subject in a column. here we going to discuss how to Display rows as columns in table using php and mysql

Demo                                                Download

Step 1:

We have a table with details like the image bellow.

how to display row as column

or here is the code for table

Step 2 :

Here is the mysql code for select row as column

So above code is simply set ‘Subject’ column as each subject like ‘english,maths..’ compare with ‘mark’ using “MAX” keyword and print maximum to minimum values as each column.

Output look like bellow image

so above code is simply

That’s it. enjoy code

The Recent Q&A Section held in Facebook HQ, CEO Mark Zuckerberg says Facebook is working with Dislike button and planning to publicly test in testing version. Finally launch the real.

AS Mark Zuckerberg said his older discussions with Audience . Facebook was considering something opposite to like button and finally plan to use dislike button so this is the first time he has definitively indicated it will ship a Dislike button to users. By the sound of it, we may not even have to wait too long.

He was also clear the button won’t be about fostering negativity the way YouTube and Reddit’s downvotes often can. Instead, it’s about “expressing empathy.”

So he cleared that the Facebook launch Dislike button is not for negative thing or agaist the certain post, it just symbol for their thoughts only. Proponents of the dislike button have long argued that the Like button is not appropriate for certain topics.

Facebook has apparently been working on it for quite some time – is that he wants to keep interactions simple.

The CEO expects the new feature to begin public testing soon, and it will roll it out to everyone if embraced.

Are you looking for popup Notification like Facebook, This Post will explain the functions and css. Here you are going to learn html css and jquery functions for popup notification. The popup Notification is one of the needed for all social sites projects and database back ends.  So here we go with basic code and live demo functions.

Demo Here                                              Download Here

Step 1: Create Html file for menu bar named as index.php

Step 2: Create css File for design style.css

Step 3: create jquery function for popup.

Add javascript into the index page. This javascript is basic hide and show script.  If you know the Basic javascript you can easily do this with your own idea. onlcik ‘show’  function show the Notification div, and the ‘hide’ function  hide the notification div.

step 4: Add library function for javascript

That’s It, enjoy the coding.