A macro is a template of commands and functions which can be used to facilitate automation of tasks you repeatedly do in Microsoft Excel. You can specify if a macro is available only to a certain workbook or to all Microsoft Excel files. Set the Security Level to Medium or Low Open an Microsoft Excel workbook or create a new one. Prior to creating and recording a macro through Excel, set your computer’s security level to medium or low so you can run macros in Excel. To do this, click Read More

Microsoft Access Microsoft Access is a program that ships with Microsoft Office and allows users to retrieve, store, and organize information from a wide variety of sources. Microsoft Access is ideal for small businesses, entrepreneurs, and those who simply wish to keep track of their finances better. Microsoft Access can perform many different tasks and includes a vast number of prebuilt applications that can be used to organize information in different ways and easily share that information with other users. User Interface Microsoft Access features an advanced user interface system Read More

PPS, or PowerPoint, files are files that are created using either PowerPoint or a similar program. PowerPoint is a program that ships with Microsoft Office and allows users to create fully-functional presentations and slideshows for use in schools, meetings, and lectures. While PowerPoint itself is a great program, some users do not appreciate the Microsoft Office layout or the price tag that accompanies it. For these reasons, a large number of similar programs have been introduced to the market since the release of PowerPoint that provide either the same or Read More

Microsoft Word comes with a large collection of fonts that can be used for word processing. However, there are times when other fonts are wanted. To get these requires downloading different fonts from the Internet. Some of these are free, but there are premium fonts that can be quite expensive. Typically, a free font can handle most of the things an individual wants to do. Adding New Fonts The very first step is to find the font that you want to use. There are many different sites on the web Read More

Importing data to MS Excel is the process of transferring data from other database sources and converting it into .xls format. This process eliminates the need to manually enter every item into a new Excel worksheet. Importing data therefore saves the user a lot of time and reduces human error. The source data is called internal data source if it is located in files or folders in a personal computer. Importing Data through the Import Data Functionality On a new Microsoft Excel worksheet, click the Taskbar menu labeled Data then Read More

Portable Document Format (PDF) is a file format that the Adobe Corporation developed. It is used to easily transfer documents via the Internet. PDF files are protected from changes and retain a presentation’s exact elements, thereby avoiding problems like missing fonts or broken layouts. PDF files can be viewed with Adobe Acrobat Reader, an easily downloadable application for Windows and Mac OS X. A number of equivalents are available on Linux as well. Converting MS Word Documents to PDF Sending a uniform file to many recipients, transferring files from one Read More

To change a Microsoft Exchange password, follow these instructions: Press the [CTRL], [ALT], and [DELETE] keys at the same time. In the window that pops up, click the Change Password button Enter a User name Select the domain that the password is being changed for Enter the old password Enter the new password Enter the new password again Click the OK button A box that says “Your password has been changed” will pop up. Changing the Microsoft Exchange password will only change the password in the mail server. It will Read More

Unprotecting an Excel sheet is surprisingly easy. If your Excel sheet is password protected and you do not know the password, there is no way that you can unprotect the sheet in that particular workbook – but you can create a new workbook which will contain exactly the same formulas, formatting and values that will not be protected and will be editable. How to Unprotect a Non-Password Protected Excel Sheet Open up the Excel document. Click on the “Review” tab. Click “Unprotect Sheet” or “Unprotect Workbook.” How to Unprotect a Read More

What is Powerpoint? Powerpoint is a powerful program that comes with Microsoft Office. Powerpoint allows users to create animations, presentations, and slideshows for lectures, home movies, meetings, and other purposes. Powerpoint includes a wide variety of tools, features, and special effects that make powerful and entertaining presentations easy to create. With this software, users have the ability to modify virtually every aspect of their presentation, including text options, color schemes, and placement of objects such as videos and pictures. Users also have the ability to create an unlimited number of Read More

You can send a fax through Microsoft Outlook with a few simple, easy steps. Unfortunately, if you have Microsoft Outlook Express, you need special software to be able to send a fax. There are several software programs available online. Here are some of the top programs you can use. Mighty Fax Mighty Fax is one of the worlds most popular and user-friendly Windows fax software programs available today. Mighty Fax lets you send and receive faxes directly from Microsoft Word or any of your other Windows programs without the need Read More