How to create a similar resume in MS Excel ???Hello All,
I came across this interesting resume which has been prepared as a
graph and charts sheet / dashboard. Although some may question its
relevance / consistency in color usage / display of information , it
is doing what it means to do... It captures attention and would surely
give the candidate a boost.
http://theportfolio.ofmichaelanderson.com/wp-content/uploads/2008/05/resume-infographic.jpg
I was wondering how this can be created using MS Excel... can someone
help me on this ???
Regards,
Anand Kumar
On Wed, 14 Jul 2010 22:13:21 -0700 (PDT), anandydr <anandydr@gmail.com>
w...
Help: Formula put into entire row creates large file sizeHi,
I have a spreadsheet where I would like one column to be the
concatenation of two other columns.
For example, in column C I would have =A1&B1.
This excel file will be given to people and they will fill in values
into columns A and B. The trick is, I don't know how many rows there
will be, so I don't know how many rows in column C should have this
formula.
If I paste this formula into the entire column C, the excel file blows
up to 3 megabytes. (It's only 15KB without this column).
Are there ways for me to accomplish this more efficiently?
Thanks for any help
Are y...
Excel query from Access databasesHi,
I have two separate databases in Access that have a common field of CustNo.
I'll like
to run a query in Excel using Get External Data... whereby I could create a
report that brings in data from both the databases.
Having tried this in Excel, it seems that I can only use one table at a
time, is there a way to overcome the issue.
Thanks, Rob
Hi Rob-
"I have two separate databases in Access that have a common field of
CustNo."
Is that accurate or do you mean 2 separate Tables in 1 Access DB file which
use CustNo as the common field?
AFAIK you can only query one Access...
Formulas in ExcelHi I am not sure how to word this but here goes, I would like to be able to
enter a w-4 withholding exemption (single and 1 or married and 2, etc.) and
have excel calculate this change automatically. Would this be an IF formula?
Thanks for any help you can offer.
--
Life, Love and Happiness
Give us some figures or a bit for information as anything can be an IF
statement, a simple =A1+B1 can be If=(A1<>"",A1+B1,"") or an if and
If=(And(A1<>"",B1<>""),A1+B1,"") etc. so as you can see we need a
little more info!
--
The...
Excel Charts with attached comments optionIt would be good if you could add a comment to a cell and have an option when
charting that cell to either show the comment or not. The comment should then
be linked to that specific data point.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com...
How do I separate address information from within an Excel cell?I have a Christmas Card list that was created using a single cell for the
whole address. Street, City, Zip/Postal etc. I need to split those
components out into separate cells in order to do a proper mail merge. Is
there any way to do this. I am not completely unfamiliar with macros but I
if that is the solution I would require a fair bit of hand holding.
Thanks
S.
If you actually used commas to separate the fields (and none of the fields
contain commas), you could select the column and do:
Data|text to columns
delimited
comma
Remember to keep enough open columns to the right s...
Can I move down 12 rows in excel for every new entryI am entering records of numbers which have formulas for calculation. I want
to place these records every 12 rows and be able to automate the worksheet
for our office personnel. How? HELP!! There can be anywhere from 50 to 150
records depending on how many batches are produced in manufacturing plant.
right click sheet tab>view code>copy\paste this. If not column A (1) then
change.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Target.Offset(12).Select
End Sub
--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Mickey&...
removing macros in Excel 97I have a few spreadsheets that upon opening ask if I want
to enable or disable the macros. When I open the file
there are no macros and unhiding the sheets shows no
macros as well. I have removed the modules that were
present on the file but to no avail, every time I open the
file it asks the same question. Does anyone know how to
find these hidden macro's. I tried the knowledge database
(article attached) but it didn't work as there are no
ranges or hidden ranges as well. Can someone help, this
is getting frustrating.
http://support.microsoft.com/default.aspx?scid=kb;...
create address listI want to create an address list that I can print, add too and edit. I also
want to be able to pick multiple addresses’s and print labels.
Contacts in Outlook supports that.
claudia wrote:
> I want to create an address list that I can print, add too and edit. I=
also=20
> want to be able to pick multiple addresses=E2=80=99s and print labels. =
=20
I tried outlook and this doesn’t meet my needs. The address and phone list
is for my personal use. I previously used Works Word and created a list I
printed to look up my family and friends phone numbers and addresse...
Frx NP rows and Excel exportIn versions of Frx6.7 SP9 and lower when a column is made NP in Frx, when the
report genrated is exported to Excel the NP column is not transferred to
Excel.
In Frx6.7 SP10 I have now found that NP columns now export to Excel and are
displayed as hidden columns in Frx.
As far as I can tell is is supposed to be function enhancement rather than a
bug.
Can someone confirm this for me?
Also - is there a way somehow to ensure it works in the way it did
previosuly (I ask this I my client has multiple complex Excel sheets that
link to the columns in this exported sheet - now due to this '...
How to add right-click menu in excel.
I have a user who cannot right click on cells.
When she right clicks on a cell nothing happens.
I have check in MS-Word (thinking that it has something to do wit
office) but it works fine.
What is the easiest way to get the right-click menu working again.
She had this problem once before but cant remember how it was fixed.
Thanks for the help
--
oioio
-----------------------------------------------------------------------
oioioi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2719
View this thread: http://www.excelforum.com/showthread.php?threadid=4670...
Need inserted lines to print in correct position on Excel graphsThe aim lines and trend lines that I inserted into the Excel graph appear in
the correct position on my monitor screen, but when I print the graph they
appear higher than when seen on the screen. How can I get the printed lines
to appear in the correct position?
Hi,
Did you use shapes to draw the lines? You could try changing the Move and
cell property.
But the best solution would be to create the lines using dummy series.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Lavonne" <Lavonne@discussions.microsoft.com> wrote in message
news:D4CD...
I enter in a 16 digit number and Excel turns the last digit to "O"Hello,
I have credit card numbers that I have entered into and
Excel spreadsheet (ex. 4444444444444444). When I entere
this in excel changes the last digit to "0" (ex.
4444444444444440). I am thinking that some sort
of "Masking" is going on? How can I convert this back to
the original true cc #?
Thank you,
G. Adamson
Format the cell for Text prior to entering the value, or include an
apostrophe (') at the beginning of the number.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com chip@cpearson.com
"G.Adamson" <gadamson@mars...
PST not created in Outlook 2003 after importprfHi all,
I would like to create a Exchange Server Outlook profile with a Unicode or
ANSI PST file.
When I launch outlook 2003 with the -importprf option, the creation of the
profile work fine (exchange server settings) but none PST is add (if the
file exist) or create and add (if the file not exist).
When I try my outlook.prf file with the -importprf option on an outlook
2007, all work fine, in the same environment (domain, policy settings,
etc...)
I use the Outlook ADM file to force the cached offline mode as default.
I try to use the settings "Exchange Unicode Mode - Ignore Arc...
Close Button In Excel Grayed Out From time to time, when I open Excel the close button in the top right
to close the program is grayed out, and I have to go to File -> Exit to
close the program. I think I remeber a knowledgebase article concerning
this topic about 6 months ago when someone else in the office was having
the problem, but I can't seem to find it. Anyone know the
cause/workaround for this bug?
Any help is appreciated.
cheers,
Ben Moore
Hi
http://support.microsoft.com/default.aspx?scid=kb;en-us;260199&Product=
xlw
XL: Close Button Is Dimmed After Groupwise Is Installed
--
Regards
Frank Kabel
F...
Links in Excel 2000...need helpHi,
Would you happen to know how to switch the setting in
excel so that when I doubleclick on a cell with a link to
another tab (worksheet), it will take me to that tab and
specifically the cell referenced?
Thx,
Maybe you can use a worksheet formula.
David McRitchie has posted these formulas that he uses.
=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
===
but you meant like what hap...
Dynamic ListsIt should be possible for the user to specify whether a list is dynamic or
static, so that they don't need to recreate the list prior to using it.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrow...
Folder List #5Is there a way to increase the FONT for the Folder List / All Folders? I know
we
can change font size for compose, reply... emails/ columns and so forth, but
I could not find an option to adjust the folder list column
Unfortunately it is not possible to change the font size of the Folder List
in Outlook. It can be modified by changing the DPI setting for Windows XP
but that will change the way all font in Windows is displayed. Here are the
steps to adjust the Windows DPI setting:
1)Right click on the desktop.
2)Select Properties.
3)Click the Settings tab in the Display Properties dialog....
How do I create custom postcards in Word 2007?I want to create my own postcards using the right size and type of paper for
mailing.
This depends entirely on your printer. Can it handle the heavy weight
of card used in postcards, and can it handle the unusual size of a
postcard?
On Apr 18, 2:54=A0pm, Create Custom Postcards <Create Custom
Postca...@discussions.microsoft.com> wrote:
> I want to create my own postcards using the right size and type of paper =
for
> mailing.
Perhaps the easiest way to start is to get some Avery (or similar) postcard
stock, which will have two postcards per sheet. Then find the a...
Match Text with ListHi, I would like to check a cell to see if the name in it matches one of the
names in a list. If so, I would like to print the name in the cell
containing the formula. If not, I would like to print something else, like
"False". Is this possible?
Thanks,
Tom
With name list in ColA and query name in cell B1 try the below formual in
cell C1.
=IF(ISNA(MATCH(B1,A:A,0)),"False",B1)
--
Jacob
"tommcbrny" wrote:
> Hi, I would like to check a cell to see if the name in it matches one of the
> names in a list. If so, I would like to pr...
getting events from ExcelHello,
How to I send events from Excel to my VB6 application?
I am unfamiliar with ActiveX . I think I see it as some sort of server
logically sitting between my app and Excel. That is to say, I think
that I would raise events in Excel VBA, the server catches them and
raises events in my vb6 app.
My need for this is that my app installs a toolbar in Excel. When the
user selects an action from the toolbar, I need to send to my app
the action code and a string of coded information.
I would also like to have Bidirectional communication but I dont see
how that could be done.
I n...
Global address list #24I created a few contact in active directory, and then deleted them. they are
still listed in the Global address list.
I have created another contact and it is not listed in the Global address
list, only in the "all addresses lists >all contacts"
how would i clean this up?
Hi,
try to recreate the GAL with ESM and download the Adress Book via Outlook
Send/Receive. In my cases i often had success.
best regards
Oliver Kieselbach (MCSE)
"John" wrote:
> I created a few contact in active directory, and then deleted them. they are
> still listed in the Global add...
Importing marketing list as campaign responsesHi there guys and thanks in advance for any light you might shed on this
matter.
I created a .csv file from an excel sheet and I want to import this into CRM
as campaign responses. When I try to do so, and after mapping all fields from
the file to correspondent fields in CRM, it just doesn't import anything.
It seems like it is going to import, but then, just doesn't do nothing. And
of course, nothing shows as campaign responses.
If I import the .csv file as leads, it works, so I guess the import file is
not corrupted or has any bad data.
Anyone knows what the problem might be?
...
Creating and manging Address ListsHi !
My platform is as follows:
Windows 2003 Server SP1
Exchange Server 2003 SP2
Outlook 2003 clients
My domain is (for example) @mycompany.com.
I have 100 users set up in ADUC with their mailbox.
I want to create some sort of Distribution lists each with some specific
users (let's say 3 differents lists with different users). I want to be able
to send mails to these list just by sending an e-mail to
mylist1@mycompany.com, and everyone belonging to the list will get a copy of
the mail.
The Filter trick in the creating process the list is not very convenient (my
users are all the same ...
Urgent: Creating a gaprh from two existing polynomial garphsHi All,
Please some one let me know the procedure how to draw a graph from two
existing graphs(which are polynomials). Please provide me a URL which
explains the process in detail, if possible.
This is really urgent for me, Thanks in adance
You have two charts, each with a series and a polynomial trendline? Copy one
chart, select the other, and from the Edit menu, use Paste Special and
select the All option. This adds the series from the copied chart to the
other chart, plus any trendline and non-default formatting.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom ...