Category Archives: Office

Office PC

Save in Excel. VBA Tutorial

December 3, 2013 – 12:24 pm

In this tutorial we will guide you on how to save files in Excel using VBA. Visual Basic for applications (VBA) is a powerful programming language designed and developed by Microsoft. It is integrated in many Microsoft Office applications like Excel, Access etc. to helps users to create their own functions to perform specific tasks. Here we are showing you how a “Save as” option works by using Excel VBA. Instead of using the “Save as” button, we will record a macro and use the double click option in VBA Excel for save as function.


read more »

Tags , , , | Permalink | Comments Off on Save in Excel. VBA Tutorial
Office PC

How to Open Excel File via VBA

December 3, 2013 – 4:12 am

In this tutorial we will guide you on how to open an Excel file via VBA. Visual Basic for applications or VBA is designed by Microsoft to be used along with handful of Microsoft applications such as Excel or Access. It comes up with Microsoft Excel 2007 and 2010 as built in tool. By using VBA, we can record our own macros and write scripts for performing specific tasks as per our requirements. If you are working with Excel and you need to open a particular file over and over again then you may take help from VBA and write up a simple code to let VBA open the Excel File for you in a single click.


read more »

Tags , , , | Permalink | Comments Off on How to Open Excel File via VBA
Office PC

How to Export Excel Data to Word via VBA

December 2, 2013 – 4:36 am

In this tutorial we will guide you on how to export Excel data to word using VBA.
For this tutorial, we will be working with this sheet over here. What we’re going to do is create a macro that allows the user to specify a separator and then export using VBA from Excel to Word file. In order to Export Excel Data, we will use some objects with multiple combinations and data range to export into a new Word Document. If Word document is already existed then the selected data will be added at the end of the existing document instead of creating a new one.


read more »

Tags , , , , | Permalink | Comments Off on How to Export Excel Data to Word via VBA
Office

How to Create Pivot Table in Excel 2013

October 11, 2013 – 4:38 am

Pivot tables are one of the most powerful features in Excel and they can make your data easy to use and manage with a minimum of effort. In this tutorial you are going to learn how to create a pivot table in Excel 2013.


read more »

Tags , , | Permalink | Comments Off on How to Create Pivot Table in Excel 2013
Office

Tricks for Using MS Office for Colorblind People

October 10, 2013 – 4:22 am

In this tutorial, you’ll learn a few easy tips that will allow you to ensure that your documents in MS Office will be equally understandable for people who are colorblind, and those who have full vision.


read more »

Tags , | Permalink | Comments Off on Tricks for Using MS Office for Colorblind People
Office

How to Change Default Font in Outlook 2007

October 9, 2013 – 4:14 am

In this tutorial you are going to learn how to change font in Outlook 2007 so that your emails are sent with a different font as standard.


read more »

Tags , , | Permalink | Comments Off on How to Change Default Font in Outlook 2007
Office

How to Edit MS Office Documents on iPad

September 30, 2013 – 5:02 am

In this tutorial you are going to learn how to edit Microsoft Office documents on the iPad.


read more »

Tags , , | Permalink | Comments Off on How to Edit MS Office Documents on iPad
Office

How to Insert Check Mark Symbol in Excel

September 24, 2013 – 4:47 am

In this tutorial you are going to learn how to insert a tick mark in Excel.


read more »

Tags , , , | Permalink | Comments Off on How to Insert Check Mark Symbol in Excel
Office

How to Hide and Unhide Worksheet in Excel

September 11, 2013 – 10:00 am

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


read more »

Tags | Permalink | Comments Off on How to Hide and Unhide Worksheet in Excel
Office

How to Print Info from OneNote

September 2, 2013 – 6:00 pm

OneNote is a note taking app that is part of the Microsoft Office suite. In this tutorial you will learn how to print your notes to keep a hard copy available.


read more »

Tags | Permalink | Comments Off on How to Print Info from OneNote

« Previous Page — Next Page »

« Previous Page — Next Page »