Category Archives: Office

Office

How to Turn On or Off Outlook Autocorrect

In this tutorial, we will teach you how to turn on or off Outlook autocorrect. We will also teach you how to disable the replace text feature. This feature replaces the typo with the correct text automatically. In this tutorial, we will disable autocorrect features in Outlook.


read more »

Office

How to Change Default Font in Outlook 2010

In this tutorial you will learn how to change the default font in Outlook 2010. This can be a useful trick for getting the precise look you want when reading your emails.


read more »

Office

How to Share a OneNote Note

Microsoft OneNote is a Microsoft Application that allows you to take notes and clip snippets from the web. In this tutorial you will learn how to share your OneNote notes with other users in your network.


read more »

Office

How to Change Caps to Lowercase in Excel

In this tutorial, we will teach you how to change caps to lowercase in Excel.
Many a times, a user might type in text without realizing that the entire text was written with the Caps lock turned on. The user can either re-type everything again in the lowercase or can convert the text written in caps to lowercase.


read more »

Office

How to Use the HLOOKUP Function in Excel

In this tutorial, you will learn how to use the HLOOKUP function in Excel.
There are times when you want to calculate a value which resides in a separate table, but don’t want to use IF commands for this. Lookups, vertical and horizontal, provide you with just the means to do it.
In our example, we have our Horizontal Table in the same spreadsheet, but it could easily be in a separate one, or even in a separate workbook. As you can see, the table is an index of tax rates according to the offered salary. If such rules change along the way, we will need only to modify the Horizontal Table.


read more »

Office

How to Hide and Unhide Worksheet in Excel

In this tutorial you are going to learn how to hide worksheet Excel. This tutorial has been made on Excel 2010 and applies to this versions, as well as 2007.


read more »

Office

How to Convert Powerpoint to Video

In this tutorial, you’ll learn how to record a PowerPoint presentation to video.


read more »

Office

How to Edit Powerpoint Footer

In this tutorial, you’ll learn how to edit a PowerPoint footer. This is a very simply process.


read more »

Office PC

How to Format Date in Excel via VBA

In this tutorial, we will teach you how in Excel, the format date feature can be applied using Visual Basic. Basically, there are many vba excel format date keywords that can be used in your code to display the date in the format you want.


read more »

Office PC

How to Search in Excel via VBA Code

In this tutorial, we will guide you on how to search in Excel using visual basic. Visual Basic is a simple programming language developed by Microsoft. It is also integrated into several Microsoft Office applications. By using Visual Basic, we can add advanced functions using VBA scripts called macros. Usually macros are used to perform that needs to be carry out repeatedly.
As we have a very limited functionality of Search function in Excel therefore we can use the VBA macros to enhance search results as per our requirements. VBA Excel find script can be written in many ways depending on your needs. Here we are guiding you on creating a simple search in Excel VBA code.


read more »