Tag Archives: Excel

Mobile Office

How to Edit an Existing Document in Excel for iOS (iPhone and iPad)

In this tutorial you will learn how to open and edit the information in Excel for iOS contained in an already created document.

read more »

Mobile Office

Excel for iOS (iPhone and iPad) overview

This tutorial serves as an introductory guide to Excel for iOS, with special focus in the available functions of the mobile version in contrast with the original software.

read more »

Office

How to Make a Quiz in Excel 2013

In this HowTech written tutorial, we’re going to show you how to make a quiz in Excel.
Creating a virtual test or quiz can allow for a great deal of freedom and ease-of-use. Or if you simply wanted to save paper, creating a virtual quiz is a good choice.

read more »

Office

How to Create Labels in Word 2013 Using an Excel Sheet

In this HowTech written tutorial, we’re going to show you how to create labels in Excel and print them out in Word.
If you wanted name tags, IDs, or anything of the sort that can be made into labels, it’s handy to print them out at home onto special office sticker paper designed specifically for labels.

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

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 »

Office PC

How to Open Excel File in C#

Microsoft Excel can be managed and operated through C# code with the help of several built in libraries, which include functions to operate Excel. In this tutorial, we will show you how to open an excel file in C# application.


read more »