You are here:

Excel/Expert Profile

Anne Troy

U.S.

Available

Expertise

Virtually all common questions about Microsoft Excel, including all versions. Help with formulas, functions, optimum data layout, and application management. Please: No VBA or macro questions.

Experience in the area

I taught Advanced Microsoft Excel to the senior accountants at the Environmental Protection Agency. Let's hope they were listening.

Publications

Dreamboat on Word Office VBA: Macros You Can Use Today

Education/Credentials

Self-taught and worked with the best in Microsoft Office applications.

Awards and Honors

Microsoft Word MVP 2008

What do you like about this subject?

I am a VBA project manager and am happy to provide you with a quote for your larger projects; don't be afraid of macros!

What do you still hope to achieve/learn in this field?

There is a be-all, end-all book on Microsoft Excel in my head; I hope to get it into book form some day.

Something interesting about this subject that others may not know:

Troubleshooting Excel is simple! You'll find the steps to take right here: Excel Troubleshooting

Something controversial or provocative about this subject

Many people use really long formulas when it's not necessary! Many people use Excel when they should be using Access, or vice-versa.

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
A.	05/21/12	10	10	10
Jennifer	05/17/12	9	9	10	Thank you very much for the excellent .....
Jeff	05/16/12	10	10	10	Thank you so much, it works perfectly .....
Gordon	05/10/12	10	10	10	Thank you for your expert help. And .....
Mohd Firdaus	05/09/12	10	10	10

Recent Answers from Anne Troy

2012-05-22 Access 2007 counting records:

You simply use the Subtotals feature, then, right there with Grouping... Sort your list by name. Then Data-->Subtotals. Then choose to "group" by Field 1. Choose to Subtotal by Field 2. You can

2012-05-22 counting records:

Hi! Have you tried the Grouping feature under the Data ribbon? Otherwise, I need to know, what do you mean by count/group? We can certainly count how many of each, but we'll first need to know where

2012-05-21 cell addition limits....:

Assuming A is dropdown start time. Assuming B is dropdown end time. Max 10-hour cell (C1), which must be formatted as number: =IF((B1-A1)*24>10,10,(B1-A1)*24) For the overtime cell (D1), format

2012-05-16 Change Cell Color based on Y or N in another Cell:

Use the Conditional Format feature. Select J1. Conditional format using a formula. The formula will be: =I1="y" (this might need to be upper case) If white is your default fill, you don't

2012-05-16 excel formula:

=if(c5>c4,c5*.9,c5*1.1) Try that out. I'm not sure if the 1.1 should be 1.1 or .1. If you're ADDING that .1, then 1.1. If you're just calcing 10% of c5, then .1. You did not say what should be

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Encyclopedia

Browse Answers: