In this video tutorial we will show you how to set print area in excel.
Open the excel document. Select the part of the text you want to print. Go to “File” tab. Choose “Print”. In appeared menu in “settings” select “Print Selection”.
read more
Tag Archives: Excel
BasicsHow to set Print Area in Excel
January 10, 2013 – 12:29 pm
read more
How to alphabetize in Excel
January 10, 2013 – 12:26 pm
In this video tutorial we will show you how to alphabetize in excel.
Open the excel document you want to edit. Select the part of the document you want to alphabetize.
read more
How to Work with Excel’s Basic Features
December 5, 2012 – 4:34 am
This tutorial is going to provide an overview of working with some of the excel basic features.
read more
How to Import Excel and Text Files in Microsoft Access
December 5, 2012 – 4:30 am
Ms Access allows you to import files from other programs to facilitate the user. You can import spreadsheet in Access. Apart from importing excel into Access, it also allows users to import text files as well. In this tutorial, we will show you how to work with different options relating to import in Access.
read more
How to Export File Into Excel from Microsoft Access
December 5, 2012 – 4:29 am
A database is a tool for collecting and organizing information. Databases can store information about people, products, orders, or anything else. Using MS Access, you can add new data to the database, edit existing records, delete unwanted records and organize it in the way that best suits your requirements. Furthermore, you can share it with people. You can export Access into Excel if you want to use the Access Database and make calculations in it in Excel. The transition from database format to excel spreadsheet will be smoothly done.
In this tutorial, we will teach you how to export Access to Excel.
read more
How to generate random numbers in Excel
December 5, 2012 – 4:14 am
Random numbers/entries in Microsoft Excel can be generated by using keyboard commands. Through random generation you can create samples in Excel that can then be used for further use like research.
This process is very useful and very easy. However, once you have taken out your sample your need to make sure that you freeze the data otherwise the entries in it will constantly keep on changing.
To learn how to generate random numbers in Excel follow the tutorial below.
read more
How to Count Unique Entries in Excel
December 5, 2012 – 4:14 am
Microsoft Excel, a commercial spreadsheet application allows calculations, provides graphing, tools, macro programming and pivot tables. You can use formulas for not only calculation but also to help you in other ways. In order to find the unique entries in Excel, a certain formula has to be used which helps in excluding counting of duplicate data entries.
Follow this step by step tutorial to learn how to count unique entries in Excel.
read more
How to Align Data and Display Unique Items from Large Lists in Excel
December 5, 2012 – 4:14 am
In this tutorial, we will show you how to align data in Excel. There are several ways in which you can align data in Excel. You change the orientation of the text, format cells and increase or decrease indent. Furthermore, you can change the alignment of the text as well. We will also show you how to find unique items from large lists in Excel. Managing large lists can be a hassle. We will show you how to use a pivot table and find a solution to your problem by customizing the pivot table as per your requirements.
read more
How to Handle Blank Cells in Excel
December 5, 2012 – 4:14 am
Blank cells in Excel have different implications in different scenarios. In this Excel tutorial, we will teach you how to select all the blank cells and place a value in all of them. Furthermore, we will show you how blank cells can have an impact on certain formulas and calculations.
In this Excel tutorial, we will show you how to handle blank cells in a spreadsheet.
read more
How to Create and Manipulate Shapes in Excel
December 5, 2012 – 4:14 am
In Microsoft Excel, there are several shapes you can work with. You can insert whichever shape you want; the one that best meets your requirements. We will guide you on how to work better with these shapes. We will reveal shortcuts to you with which you can duplicate these shapes, increase or decrease them proportionately and increase or decrease them while keeping the center the same.
In this tutorial, we will show you how to create and manipulate shapes in Excel.
read more
Home