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.
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.
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.
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.
Microsoft Access allows you to create tables, forms, queries and reports that are essential for your database. You can use different features to easily create your own database even if you are new to the Access. In this tutorial, we will guide you how to create tables in Access. Tables in Access are the foundation for your database and your record entries.
Design view in Access is the best way to create tables, forms and reports. Design view lets you configure even the smallest option in your database. It provides you with various options for table construction. In addition to all the features on table tools field ribbon, it has many customizable field properties. Furthermore, we will teach you how to assign a primary key to your database. Primary key is the unique identifier of a specific table and it can be any field that is unique to that table only. Follow this step by step tutorial to learn how to assign a primary key in Access.
Access is considered a relational database in which data is split into tables that are interconnected. Database Relationship tells you how one table is connected to the other table and how data is integrated in between them. It is important to know how relationships in Access work in order to maintain referential integrity between tables.
In this tutorial, we will teach you how to create relationship in Access.
Ms Office Access is database application software that lets you create a database with ease. Access makes it easy to search your table and data. There are three main techniques in this software to do this which are; finding, sorting and filtering. If you have a large database it becomes impossible to look for a particular record so the use of these tools makes it convenient to look for data in a more effective manner. To sort in Access is very effective in finding data and records.
Access is database application software that lets you create database of various sorts with ease. You can even create forms in Access. To begin with, forms in access allow you to view one record at a time. Furthermore, forms make it easier to enter data into tables. Lastly, forms express the same data in the table but in a manner far more presentable.
Form wizard in Access lets you create forms with great ease. You can create forms in Ms Access with the help of the wizard with just a few clicks. In this tutorial, we will teach you how to use the wizard and other options relating to it. New record entry can be done to the database with the help of these forms.
Home