How to Analyze Data by Using Slicer in Pivot Table in Your Excel Worksheet

Pivot table has provided many useful features for you to analyze data and information. In this article, we will talk about the usage of slicer feature in pivot table. In Excel, the pivot table is very efficient in analyzing data and information. You can also demonstrate data in the way that you need by this feature. The image below shows the sales volume in a worksheet. In order to analyze this range, we have created two pivot tables in another worksheet. In the first table, we will show...

Read more »

How to Effectively Import Data from an Excel Spreadsheet to an Access Database

In this article we look at learning the process of importing data from Ms Excel in Ms Access in an effective manner The Ms Excel application is invariably counted amongst the most popular desktop applications in use today and by far the most widely used spreadsheet tool in the history of computing. Thus it is not surprising to note that many users often use Excel spreadsheets when they should ideally be using Access databases. MS Access might be a little more complicated to use as compared...

Read more »

2 Methods to Sort Alphabetically by Last Names in Your Word Document

In today’s article, we will provide you with 2 methods to sort alphabetically by last names in your word document. Basically, we are not alien to the “Sort” feature in Word. It helps us a lot in setting numbers and paragraphs in a particular order. And today, we will bring the topic of sorting alphabetically by last names if they are in sequence of: first name, last name. Obviously, you will not succeed in trying in usual way. While if you take our 2 ways introduced in the following...

Read more »