Archive for April, 2011

learning VBA for access

Saturday, April 16th, 2011

In my previous article about 5 easy ways to learn Excel I explained 5 methods that can help you learn the program and its interface quickly.

Read more..

Excel Settings and Options

Friday, April 15th, 2011

Workbook defaults
There are various options in Excel that you can modify to make setting up your workbooks quicker and easier according to your preferences.

Read more..

Excel workflow routing

Thursday, April 14th, 2011

Outlook provides many e-mail functions that make it a good choice for implementing a routing solution.

Read more..

Excel Toolbars Personalizing

Thursday, April 14th, 2011

It is useful therefore, to know how to effectively use toolbars e.g. how to access hidden buttons, move them, view them and customise them.

Read more..

Array Formula Sumif

Wednesday, April 13th, 2011

The SUMIF() and COUNTIF() functions can only evaluate a single criterion.

Read more..

Excel Sorting features

Wednesday, April 13th, 2011

Excel 2003 has a built-in feature that enables data in a worksheet to be sorted. Sorting data in Excel 2003 can bring important data together, organise its appearance within the document, and allow the user to spot data that are incorrectly formatted or incomplete.

Read more..

Using Customs Formats to Control Numbers

Wednesday, April 13th, 2011

The number formats provided by Excel don’t meet your needs you can easily create your own custom formats.

Read more..

Publish Pivot Table As Web Page

Tuesday, April 12th, 2011

This tutorial outlines how to convert a complex pivot table from Excel into an interactive web based application

Read more..

Zeros Accounting Format dash rather than a zero

Tuesday, April 12th, 2011

The accounting format has several advantages but one disadvantage is that it will yield a “–“ (dash) rather than a zero

Read more..

Inserting Symbols in Excel

Tuesday, April 12th, 2011

Microsoft Excel is a fantastic tool for analyzing scientific data. Microsoft Word is a fantastic tool for writing up scientific research. So surely Microsoft Office is the only software a scientist would ever require beyond that associated with specialist scientific apparatus?

Read more..

Excel Easter Eggs Is it real?

Tuesday, April 12th, 2011

In the past the developers of Excel (and most of the other Microsoft Office applications) built in little hidden programs that would run inside the application if you knew the secret sequence of keys. These secret routines were generally humorous and entertaining.

Read more..

how to publish a pivot table

Tuesday, April 12th, 2011

Creating a Pivot Table with Grouped Dates

Imagine that you have the output from an accounts system: a table of payments made by your company. For each row of the table in Excel you have:

Read more..

Sample Data for Subtotal in Excel 2007

Monday, April 11th, 2011

When you have a massive amount of data, you can let excel calculate the subtotals in your worksheets. All you need to do is group the data by the items to be subtotaled and then tell excel to outline.

Read more..

Excel shared workbook

Monday, April 11th, 2011

Shared workbooks is a great feature of Microsoft Excel. You need to set up ‘shared workbooks’ if input from many persons is required to complete a project. This feature allows you to collaborate with others in your team quickly and easily.

Read more..

Formatting Hidden Format

Monday, April 11th, 2011

You can format anything in Excel so it will not appear on the worksheet but still be present in the worksheet. This works for both screen and printing. The custom format characters are three semicolons or ;;;

Read more..

Auto Fill using the Fill Handle

Monday, April 11th, 2011

You can fill in several types of series by selecting cells and dragging the “fill handle” or by using the Series command (point to Fill on the Edit menu, and then click Series). By dragging the fill handle of a cell, you can copy the contents of a cell to other cells in the same row or column

Read more..

Excel VBA and Access VBA

Monday, April 11th, 2011

Similarities between Excel VBA and Access VBA

In theory it should be easy to switch from one MS Office VBA programming language to another, since all the underlying principles are the same

Read more..

Filling Entire Column in Excel

Monday, April 11th, 2011

MS Excel can be customized in a way that suits a user to achieve his goal. It is extensively used in financial organizations. The features of MS Excel are as follows:

Read more..

Publishing Pivot Table in Excel 2010

Monday, April 11th, 2011

<Question to Dr ExcelAdvsior>

I was trying to publish a pivot table on excel 2010 with powerpivot add on, but I do not know how to save with feature interactivity likes in excel 2003

Read more..

Choosing right accounting software

Monday, April 11th, 2011

Are you in the process of selecting accounting software for your small business? If the answer is yes then you have plenty of options open to you, these include, to name but a few, Sage, QuickBooks and Microsoft Solomon.

Read more..