Best text books / manuals for MS Office (intermediate-Advanced use
What are the best (most highly reccomended) text books / instruction manuals
you can get for Access, Excel, PowerPoint, Publisher, & Word and also VBE?
I consider myself to be Quite proficient in Excel......Can produce a decent
document in Publisher.......Can "Get by" in Word....Not enough knowledge of
Access......Only used PowerPoint once.......
I started using BASIC (the programming language) back in the '80s, so I have
some knowledge of VBE (Formulas & syntax are quite simular from what I see
I have created several Excel projects with Macros bu...Why Doesn't This MATCH Work
I'm trying to do a match to find a number equal or larger than
an input value. Since the values in the table are ascending I
need to reverse them to use a -1 Match type.
I've got a half dozen tricks that work. What I would like to
find out is why one in particular doesn't work.
A simplified example:
A1:J1 contains the values 2, 4,...,20.
A2 is the look up value. (eg 15)
A3 is =MATCH(A2,OFFSET(J1,0,1-ROW(Count!1:10)),-1)
where count is a blank sheet to return the numbers from 1 to 10.
I can see that the offset returns the array in reverse order which
is what I want. The Match how...Journal stopped working #3
I'm running Office XP Pro in Windows XP Pro. I noticed that my journal
doesn't keep track any more. When I open the journal it is now empty. I've
made sure that the feature is enabled in the Journal Option under Tools and
I've checked off the boxes to track email, Word, Excel, Powerpoint, etc. But
it still doesn't do it. Is there another location to enable Journal?
...'Remember Password' does not work
I click the Remember Password box in MSM Premium 05 and it never works. This
is the buggiest pos I have ever seen!
Money 2004 has had the same problem since last year when Microsoft had a
problem with .Net passport.
"Yet he can see through a brick wall in time. (As they say in Bree)"
Time and change will surely show
How firm thy friendship O-hi-o
"Carlos" <CJrodriguez@msn.com> wrote in message
>I click the Remember Password box in MSM Premium 05 and it never works.
>This is the...The best photographer
He is the best famous photographer..
...Reports not working from client machines
Reports are not working for me from client machines - neither from web
client nor from outlook client.
I guess, the problem is that, while installing crm we have given
http://localhost/reportserver as the reporting server url. I need to give ip
of the report server machine then...
btw, reports are working perfectly fine, if I login to server machine and
access it from web client.
do anyone know, how this setting can be changed? I tried 'Repairing' the
installation, but there is no option to specify report server url.
In the registery settings you can chang...Help: Working with Lists
I would appreciate some help, I have a list of data that consists of text. 2
columns wide, x number of rows down.
I would like to copy this list to another sheet, but so the data is visible
across 1 A4 sheet High, by X number of A4 sheets in width. ( as many needed
to display the data )
I have tried copying this list to another sheet by setting up the print area
and pasting to the selected cells, but everytime the list stays in the
original format and continues down out of the print area, in the first 2
I have to ask and display my ignorance; what do you mean by &quo...Quotes in money 2007 stopped working
Anyone else having problems with Money 2007 downloading quotes? Mine
stopped about 10 am.
Same here JC.
"JC" <email@example.com> wrote in message
> Anyone else having problems with Money 2007 downloading quotes? Mine
> stopped about 10 am.
...Convert function not working
I tried this function =CONVERT(2.5, "ft", "sec") but it is not working. it
is giving #name?
I m using office 2003.
Rao Ratan Singh
From help file:
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
3.. If necessary, follow the instructions in the setup program.
"Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message...Where is the best place to put notes?
We are new to MSCRM and are not used to all of the possible places that you
can enter notes. Has anyone created a structure for their company as to what
notes should be entered where?
There are many ways to handle notes. You have accurately identified that
notes are kind of disjointed. What you might consider doing is creating a
central notes depository in Sharepoint and then adding a customization with
an inline frame that shows the Sharepoint notes repository in several
different parts of CRM.
In general, you have not provided enough information on what you are trying
to ac...Calendar work week
How can I customize my calendar options to show different start and finish
times for different days of the week?
"joyce" <firstname.lastname@example.org> wrote in message
> How can I customize my calendar options to show different start and finish
> times for different days of the week?
You can't. Outlook assumes each day is 24 hours long and starts at midnight.
Seems reasonable to me.
Brian Tillman [MVP-Outlook]
...what is the best way to resize test that "best fits" the text box
I just want to know how to resize text to fit the text box.
Select the text and reduce the font size until it suits your requirements.
There is no automatic function for this.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"utahjohn" <email@example.com...Outlook 2003 Read Pane stops working
I have used Outlook 2003 without serious problem for many years.
Yesterday it crashed and when it restarted, the Reading Pane
I checked the "Settings" and the "Reading Pane" was set to "Right" as
I tried setting it to "Bottom" and it did not reappear.
I set it to "None" and then restarted Outlook and then set it back to
"Right" and still it does not appear. I have rebooted Windows XP and
tried again, but the "Reading Pane" will not appear.
Any ideas on what to try next?
I suspect that I have encountered...Rerun a print test in Home Publishing
it ran the print test page but i put in the wrong direction of the printer ,
how can i get it to rerun the print test again ???
Not much detail to work from here and anyway-
HomePublishing is not MS Publisher so you will have to look elswhere and
then suplly a lot more detail about your problem.
"stacey" <firstname.lastname@example.org> wrote in message
> it ran the print test page but i put in the wrong direction of the printer
> how can i get it to rerun the print test again ???
We are using a database to keep track of an ever increasing numer of
documents. They are set as hyperlinks, is there a limit or any dangers in
doing this apart from the obvious one of documents being moved from their
original location. Is there a better way to do this, we dont want to buy into
document management software.
...Best way to forecast individual sales territories?
I have a spreadsheet with twelve months of sales data per territory (100
territories.) I need to forecast the next three months. The product being
sold is just moving from launch phase to high growth phase, so it's still
growing pretty quickly. What is the best method to forecast each individual
territories' sales over the next three months?
Sure would oblige a message box returning the full path of a file browsed.
Thanx & Best Regards,
Check your other post.
Faraz Ahmed Qureshi wrote:
> Sure would oblige a message box returning the full path of a file browsed.
> Thanx & Best Regards,
<No response from other forum>
Hello, I have a Exchange 2003/OWA frontend that is protected with RSA two
factor authentication inside a Checkpoint Firewall.
The RSA part works fine and everything is good. Now I buy a Motorola Droid
and need to set up the Exchange Sync and the RSA poses a problem. If I
remove the RSA protection the Droid connects to the OWA and syncs well.
Calls to RSA says it will not work with a Droid so I'd have to get rid of
the RSA authentication.
The question is: it looks like if I want to use a Android 2.0 based Droid
phone to sync with outlook...Multiple Owners of an Account 09-28-06
Is it possible to have multiple owners of an account? Have the names appear
Thank you in advance,
Unfortunately, the answer is no.
...FindRecord Macro Won't Work
I am trying to run a macro that takes information from 2 separate
fields in one form and then searches a table for the record and then
it populates another form.
The first form only has 2 fields in it. I have one command button
also. For the command button I set the "OnClick" to a macro that
opens up another form and also finds the record that was chosen from
the 1st form.
The FindRecord action is set up like this
Match: Whole Field
Match Case: No
Search as Formatted: No
Only Current Field: Yes
Find First: Yes
The search form has two combo boxes th...Working hours
Every month we make a list of our employees working hours.
monday 10.00 - 16.00 = 6h
tuesday 16.00 - 20.00 = 4h
how can i calculate the hours together, some employ can have only 30 hours
per week, now calculate by my fingers....sorry for my bad english
Day in Column A,
Start time in Column B,
End time in Column C,
Start in Row 2.
Make sure time entries are TRUE XL recognized times.
Daily total in Column D, using this formula:
Say weekly total is in D9.
Format D9 to Custom
And use this formula:...GL figures
what really is the best practice method for brining in monthly GL figures so
users can get comparative statements this year/lastyr.
do you bring in all the old detail journals? or do you load via a
maintenance or IM the historical balance for each month in some file.
You mean when you are starting up a new company?
If so, unless someone needs the detail imported into GP for other reasons, I
bring in a beginning balance and monthly net changes only. For example,
let's say you're starting to use GP with January 2009, your fiscal year ends
in December and y...OOO not working
I've encountered a strange problem with one client running Outlook
2000/WindowsXP (both fully patched) accessing an Exchange 2003 server.
The issue is ... for this one user, Out of Office messages do not get
sent when he sets the OOO Assistant to "not in the office".
Some facts to consider;
User had the issue previously when on Exchange 2000 (recently migrated
to new server).
No one else has the problem, OOO works.
Tried turning on OOO from within OWA and that doesn't work either.
Yes, connected to the Exchange Server.
Yes, Exchange extensions are installed.
I've seen s...Money 2003 Help not working
My "Help" in Money 2003 does not work at all! It keeps
saying unable to load to topic. Anyone know how to fix
In microsoft.public.money, alex wrote:
>My "Help" in Money 2003 does not work at all! It keeps
>saying unable to load to topic. Anyone know how to fix
In Internet Explorer delete your browser temporary files with
Then open Money with Start->Run and entering
"msmoney -s" without the quotes into the box.
If that does not do it, try
http://support.microsoft.com/default.aspx?sci...best tutorials for graphs ( line of best fit) for excel
What are the best tutorials for using excel for stastical analysis graphs
and other graphs such as Line of best fit?
Here's a link to my chart gallery of Excel statistical charts.
Here's a link to my page on trend analysis with Excel. This page shows
several regression techniques that you can use with Excel.
Post back if you have more specific questions.
koday at processtrends dot com
"Niccole D" <Niccole D@discussions.microsoft....