Category Archives: Office

Basics Office PC Tweaks

How to Create a Font

In this tutorial, we will teach you how to create a font. For professional results, you need applications such as Adobe Illustrator and Inkscape. But there are other alternatives out there.
Let’s get started by exploring some of those options here.

read more »

Office

How to Create Table of Contents in Word 2013

Creating table of contents in Word 2013 is quite easy and, hooray, you don’t have to type it manually.

read more »

Office

How to Copy or Paste Data in Excel via VBA

In this tutorial we will guide you on how to copy and paste data in Excel using VBA. Copying data and pasting it into another cell or worksheet is a simple task in Microsoft Excel. However it can trouble you a lot if you have a large amount of data and multiple spreadsheets to work with. Visual Basic for applications i.e. VBA helps you to perform these kinds of tasks which you need to carry out repeatedly. So here we are creating a VBA copy and VBA paste scripts using Excel macros for copying and pasting of data from one Sheet to another.

read more »

Office

How to Add a Watermark to a Worksheet in Microsoft Excel 2013

In this tutorial you will learn how to add a watermark to a worksheet in Microsoft Excel 2013.
Adding a watermark to your Excel worksheet makes it look cool and it may come handy if you want to enhance your company documents, say, the lists of workshop participants that you want to print out and even your company invoices!
Adding a watermark to a worksheet in Microsoft Excel 2013 does not happen just in a couple of clicks, but is still quite easy to do. Before you proceed, make sure you have your image file prepared. A nice JPG or PNG image with your logo or any other watermark-suitable picture is okay.


read more »

Office

How to Create and Clear Array VBA (Excel)

In this tutorial we will guide you on how to create and clear arrays in VBA Excel.
Arrays are basically a group of variables which have similar properties. Instead of using multiple variables, it’s better to use a single array. By using arrays, we can use a single variable for several values. It can store from 1 to more than thousands of values depending on the size of program. Arrays use a loop function to work which helps to store, retrieve and modify values in it. It is also a good practice to clear arrays in VBA programs at the end to free up the memory used to store it. This is very helpful when working on large data or spreadsheets as it slows down the overall performance of the program. Here we are using arrays in VBA Excel to input more than one values in a single variable with the help of macros.


read more »

Office

How to Write Excel Macros via VBA

You can easily get started with writing the visual basic code by enabling the feature in Microsoft Excel. By writing VBA excel macro, you can automate a number of tasks which otherwise might take a lot of your time. For example, changing the formatting of a whole document in a specific way, etc.
Follow this step by step tutorial where we will guide you on how to write Microsoft excel macros using Visual Basic.


read more »

Office

Wrap Text Around Image Powerpoint

In this tutorial, we will teach you how to wrap text around an image in Powerpoint. We will teach you how to place text boxes around a regular image. Furthermore, we will teach you how to send a picture to the back and adjust the text accordingly in order to make sure there is no overlapping.


read more »

Office

How to Make Outlook Email Encrypted

We will teach you how to perform Email encryption in Outlook. We will teach you how to modify the security settings so that you will be able to encrypt your email message.


read more »

Office

How to Use Symbols and Special Characters in Excel

In this tutorial, you will learn how to use symbols and special characters in Excel.


read more »

Basics Mac Office

How to Update Office for Mac 2011

In this tutorial you will learn how to update Office for Mac 2011.


read more »