What’s new in Excel 2016 or Excel for Office 365?

Excel has recently come out with some new features that were released to the end users of Office 365.

Some of the features are as follows

  1. Deselect Cells- How often have you selected some cells in Excel only to realize later that not all the cells that you selected are required? Then the only way to go about this is to start all over again. But this is a thing of the past since Excel now allows you to deselect cells after making a selection. So, In case you have accidentally selected some cells, you could deselect them rather than going back to square one.
  2. Insert 3D Models– Windows 10 users would have noticed a desktop application called Paint 3D. This is where you can create 3D Models. Excel now allows you to Import these models to your spreadsheet in order to better Interpret the Information at hand.
  3. Convert SVG Icons to Shapes-SVG also known as Scalable Vector Graphics is a format for Images where the resolution or the sharpness of an Image is maintained even when it is zoomed or blown up. SVG Images can now be transformed Into shapes for further manipulation.

Excel

Advertisements

How to Embed a Google Map on your Website?

In this day and age saying that a map would be a “good to have” on your website would be an understatement. Maps give Information and credibility to a company. So, it is very Important to have this on the website. Fortunately it is not an arduous task to Implement it. Here are the steps-

The Steps

  1. Open Google Maps
  2. Enter the Location of the place that you would like to show on the website.
  3. Click Share GMaps
  4. Activate the “Embed Map” Tab. GMaps-2
  5. Copy the iframe code. This code can be pasted on the body of the HTML File.

How to reset a Password in Windows 7 Enterprise?

Windows 7 is a fairly old O.S. when you look in terms of it’s release date. Microsoft has been encouraging customers to switch to Windows 10 since it is faster and better but some organizations still stick to their old systems.

Organizations for security purposes normally enforce a policy where a user have to reset their password after a certain period of time. Not doing this in a timely manner would lead to the expiration of the password. So, in case you have the misfortune of using Windows 7 and you have received a notification that your password is going to expire soon, this is what you need to do-

The Steps

  1. Open the Start Menu and click on “Windows Security” located on the 2nd column.Screenshot (106)
  2. Then click on “Change Password”.Screenshot (107)
  3. Then enter your Old Password and the new password twice and hit EnterScreenshot (108)

Now you have successfully reset your password and you can throw your worries of the password expiring out the window! 🙂

How to convert to a specific date format in PHP?

Date is something which could be represented or described in many different ways. For Instance the date today could be represented in the following ways-

20th March 2018

03/20/18

20/03/18

2018/03/20

And so on

So, it is Important to know how would one convert from one format to another.

The first thing to do is set a default date format.

date_default_timezone_set('EST');

 

Then if you want the output of the date to be as month/day/year

$date_formatted=date("m/d/Y",strtotime($date));

 

This statement can be modified to the format that you require.

You need to pay attention to the characters that are used to describe the dates, they are case sensitive.

This would give you a detailed explanation on the characters and their description.

 

How to add a new Timezone in Outlook?

In one of my recent blogs, I talked about the new features of Outlook. One of the new features is the ability to add a Timezone to your Outlook Calendar.

This is the way to add a Timezone to your Outlook Calendar-

  1. Go to the Calendar View in your Outlook Client.
  2. On the Top Navigation, Click on View and then select “Add a Time Zone”. Screen Shot 2018-03-17 at 9.10.46 PM
  3. Then select the Timezone that you would like to add from your dropdown. Screen Shot 2018-03-17 at 9.11.02 PM
  4. And then click OK.