Have you faced situations where you look at a formula that has been applied to certain cells and wondered what the numbers mean or represent? Adding Comments to cells would help the end user viewing an excel spreadsheet get a better understanding of the data.
This is how you would add comments in Excel
- Right click on a cell where you need to add a comment.
- And Select “Insert Comment“.
- You would then see something that looks like a Post-it note where you can add your comments.
- Once you add a comment you will notice a small red triangle in the cell where you added the comment.
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
- 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.
- 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.
- 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.
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-
- Open Google Maps
- Enter the Location of the place that you would like to show on the website.
- Click Share
- Activate the “Embed Map” Tab.
- Copy the iframe code. This code can be pasted on the body of the HTML File.
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-
- Open the Start Menu and click on “Windows Security” located on the 2nd column.
- Then click on “Change Password”.
- Then enter your Old Password and the new password twice and hit Enter
Now you have successfully reset your password and you can throw your worries of the password expiring out the window! 🙂
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
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.
Then if you want the output of the date to be as month/day/year
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.
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-
- Go to the Calendar View in your Outlook Client.
- On the Top Navigation, Click on View and then select “Add a Time Zone”.
- Then select the Timezone that you would like to add from your dropdown.
- And then click OK.
In my previous blog I talked about the new features in Outlook. One of the features is the ability to Insert a table Into an Outlook Email. Let’s see how we can do this?
- Click on “New Message”.
- Activate the Message tab.
- Click on Table
- Select the Rows/Columns that you need
- And then click on “Insert Table”