MS Outlook 2016 allows you to create a list of the tasks to do; you can even set the reminder to let you remind about your tasks. You can even assign the task, set the task status report to someone. So let us start with the steps for How to create or assign a New task in MS Outlook 2016? Steps to create or assign a New task in MS Outlook 2016: Step 1: Open the Outlook 2016 application on your … [Read more...]
How to Schedule Appointments in MS Outlook 2016?
Appointments are the scheduled by the user for performing a specific work that does not require to invite other peoples or reserve resources. If you feel, you can hide your appointment details from other users in Outlook. You can also set the priority of the appointments. So let us proceed with the steps for How to Schedule Appointments in MS Outlook 2016? Steps to Schedule Appointment in MS … [Read more...]
How to Schedule a Meeting in MS Outlook 2016?
MS Outlook 2016 allows scheduling a meeting and sending the meeting invitation to more than one people at a time. It also tracks which attendee has accepted your meeting invitation and which not. Using scheduling assistance, you can reschedule the meeting in case any attendee seems to be busy during the meeting session. You can also set recurrences and reminders for the meeting. So let us proceed … [Read more...]
How to create and add Signatures to the messages in MS Outlook 2016?
Outlook allows you to create a personalized signature for the messages/emails that you send/forward/reply. In this personalised signature, you can add text, image, electronic business card, and logo. You can also set, to which messages/emails this personalised signature would be attached. So let us begin with the steps for, How to create and add Signatures to the messages in MS Outlook … [Read more...]
How to break Links in MS Excel 2016?
In the previous article, we learned to create a link in MS Excel 2016. Now if you do not need the links anymore, break the link between the source and referencing workbook. This article explains the steps to break links in MS Excel 2016. Remember once you break a link between source workbook and referencing workbook, the link/formula will convert to the current value of the cell. And most … [Read more...]
How to create Links in MS Excel 2016?
MS Excel allows you to create a link between two worksheets of the same workbook, or between two different workbooks. The beauty behind this linking is that if you modify the original data, you will also experience modification in your linked data as well. In this article, I have explained the steps to create links in MS Excel 2016. Steps to create Links in MS Excel 2016: Step 1: Select the … [Read more...]
How to use VLOOKUP in MS Excel 2016?
VLOOKUP is a function that helps you to find the thing from a table array, the data you stored on the spreadsheet. There are four parameters in the VLOOKUP function. Let us start with the steps of How to use Vlookup in MS Excel 2016? Steps to use Vlookup in MS Excel 2016: The data I have, contains the number of copies of an XYZ book sold in each month from the year 2011 to 2015. Step 1: … [Read more...]
How to Sort Data in Ms Excel 2016?
Sorting comes in a frame when we need to arrange data in a certain fashion i.e. smallest to largest or vice-versa. You can also create your own order for sorting data. So let us move on How to Sort Data in Ms Excel 2016 ? Steps to Sort Data in Ms Excel 2016: Step 1: Select the cell to which you want to apply sorting operation. Like, I selected the cell below Total. Inside Home tab, under … [Read more...]
How to Transpose in MS Excel 2016?
Transpose is an array function i.e. it is applicable to arrays. There are two methods to perform the transpose first is Paste Special method, second Transpose function. The drawback with Paste special method is that if we perform any change in the source data it does not reflect in the transposed data. But if you are using Transpose function and perform any change in the source data it will … [Read more...]
How to Delete Macro in MS Excel 2016?
Macro is an action or group of actions that is recorded, and it can be played back again as many times as required. The actions in macro can be a keystroke, mouse movements, typing text, or modifying text. In this article, we will discuss How to Delete Macro in MS Excel 2016? If you want to delete a macro that belongs to Personal Macro Workbook. Then you need to first unhide the workbook to delete … [Read more...]
- « Previous Page
- Next Page »