December 5, 2012 – 4:14 am
Pivot table in Access is a good way to group and summarize huge amounts of information like sales records pulled from a database. Pivot tables allow you to analyze your data in a more graphical manner.
The best thing about pivot tables is that they are very customizable. For example, you can start with a sub grouped view that shows you all your sales grouped by customer’s country. Let’s say, you change your mind and want all the sales grouped according to the orders. This change can easily be brought about in the pivot table.
read more »
December 5, 2012 – 4:14 am
Creating graphs and charts will give your data a more presentable look. It will be easier for the end user to analyze data presented in graphical form. Sometimes merely looking at numbers is not enough. A graphical image conveys the message better.
In this tutorial, we will teach you how to create a pivot chart in Access.
read more »
December 5, 2012 – 4:14 am
Microsoft Access is database application software that lets you create database of various sorts with ease. The best part about Microsoft access database is that it helps one to quickly track and report information. It provides the user with rich user interface and interactive design capabilities. It can also be used for web applications. Data macros in Access enable you to add logic to events that occur in tables such as adding, updating, or deleting data.
read more »
December 5, 2012 – 4:09 am
In Microsoft Office Outlook you can easily save the views you are working on. There are three default views and others you can create yourself.
To learn how to save view in Outlook and then later reset them, follow the tutorial below.
read more »
December 5, 2012 – 4:09 am
Excel provides its user with excellent sorting options. You can filter your data in Excel as per your requirements. Sorting in Excel allows you to re-arrange data as per your needs. In the tutorial, we will show you how to filter data according to multiple criteria.
In this tutorial, we will teach you basic and multi-field sorting in Excel.
read more »
December 5, 2012 – 4:09 am
Sorting data at times can be a huge problem when you have so many rows and columns and so much of data in them. Excel allows you to sort data the way you want. You will have a lot of choices as to how you want to sort it. For example you can classify your data according to the departments. Sorting data in Excel can be done easily by inserting a table. Even more you can delete duplicate entries in Excel after you add them in a table.
Follow this step by step tutorial to learn how to use tables in Excel to sort and filter data.
read more »
December 5, 2012 – 4:09 am
Excel spreadsheets help users with their calculations and computations. The subtotal feature in Excel allows you to find totals department wise. In this manner, you can compare the individual figures with the grand totals and see each department’s contribution to the grand total. You can make subtotals either using the sum function or working with the average function.
In this tutorial, we will show you how to insert automatic subtotals in Excel.
read more »
December 5, 2012 – 4:09 am
Vlookup in Excel is considered kind of tricky by most users. We will teach you how to apply vlookup. In the formula, you have to provide the cell where the results would be displayed, the data range, the column you are referencing it to and whether the condition is true or false. It is a logical function and helps people in real life situations when they are trying to maintain a car database or parts database.
In this tutorial, we will show you how to create a lookup table in Excel.
read more »
December 5, 2012 – 4:09 am
In this tutorial, we will teach you how to explore the analysis toolpak in Excel. First of all, we will show you how to enable Analysis toolpak. Once the toolpak has been enabled, we will show you how to work with it. Under data analysis, you will find several options. We will show you how to work with two of them in this video; correlation and moving average. We will show you how to apply both of the functions.
read more »
December 5, 2012 – 4:09 am
Many people don’t know how to create a PivotTable in Excel. They consider it too complicated. In the preparation of the Pivot table, you have to select the data range the Pivot Table is going to use. Next you choose the fields that you want to use in the Pivot Table. Then you assign these fields roles; place some in rows while others in column headings. In this tutorial, we will teach you how to create a basic Pivot Table in Excel.
read more »
Home