I would like to become fluent in excel and in microsoft access.Is there a free tutorial for that ?

OK here's the dilly. I don't know alot about the ins and outs of a computer, so I need your help. What I would like to know (step by step) is, if I ever had Excel on my comp, and somehow managed to accidently put it somewhere else or delete it, how can I find out? Remember lamins terms and step by step.

Excel calculations?? So , I have this spreadsheet that calcutes elasped time. The first column is START TIME (A); the second is (B) END TIME; the third is (C) ELASPED TIME. To get elasped time I used the following formula: =TEXT(B2-A2, "h:mm") to return the time in Hours and Minutes. However, I would like ELASPED HOURS to returned as a decimal representation: Instead of time being returned as 23:30ours elasped , I would like it to be returned as 23.5 hours. Does anyone know a FORMULA that will return it as I described above? The times are formatted like this: 12/12/2010 10:15:00 PM

I need to know microsoft excel for my new job. I intend on taking a course but don't know which one or what one. I have a basic understanding of computers and in fact used microsoft excel years ago in a warehouse I worked in which was no problem to me. But now I require a course to prove I can use and understand it.Can anybody recommend one? Its in Ireland by the way. Thnnkas in advance....

I have good knowledge of excel but want a course to make me a excel whizz- wheres the best place to go?

I am looking for a professional, paid, course in Excel that will be thorough and explain all of the functions needed for financial reporting. I do not need VBA-- but in depth training of sorting/pivot tables/etc are needed. A full one, or two day course is what I envision. I am looking for a professional, paid, course in Excel that will be thorough and explain all of the functions needed for financial reporting. I do not need VBA-- but in depth training of sorting/pivot tables/etc are needed. A full one, or two day course is what I envision. I live in San Francisco.

Are there websites where I can learn Excel to an advanced level? Ideally, interative lessons. Thanks.

I am looking for a professional, paid, course in Excel that will be thorough and explain all of the functions needed for financial reporting. I do not need VBA-- but in depth training of sorting/pivot tables/etc are needed. A full one, or two day course is what I envision. I am looking for a professional, paid, course in Excel that will be thorough and explain all of the functions needed for financial reporting. I do not need VBA-- but in depth training of sorting/pivot tables/etc are needed. A full one, or two day course is what I envision. I live in San Francisco.

I have been asked to deliver a basic Excel training seminar and I have never used my HP laptop to connect to an overhead projector before. I need my "students" to be able to see me go through the step by step process of setting up worksheets. How do I do this? What kind of snags can I expect? Thanks! Sue

Ok here is my question: Sometimes I have to hide some of my worksheets in Excel, and later on when I want to unhide all of them, I have to do them one at a time. It's a pain because sometimes I can have up to 30 worksheets hidden at a time. Does anyone know if there is a way to unhide multiple worksheets at once? Do I have to run a macro? I can't believe the masterminds behind Microsoft software didn't think to make something so simple a little easier to do. Lol, thanks! :)

We all are aware of the SPREADSHEET in Microsoft excel. If any person types a formula in the cells, then the values obtained from the cells will be as per the formula set by the person who typed them. Thus, in a way the formulas typed in represent the mind logic and will of the person who typed them. Thus any values entered in the cells would be giving the final answer adhering to the formulas representing the will and desire of the person who typed those formulas. But you cannot see the face of that person in the spreadsheet when you are using the computer. Using the same analogy, we can understand that this Universe is like a SPREADSHEET adhering to laws and commands of ALLAH (SUBHAANAHU WA TA’ALAA), yet we cannot see him but the entire universe works on the commands of ALLAH (SUBHAANAHU WA TA’ALAA) which represent him. We know these laws as SCIENCE. Is it not true? What are your views and opinions on this ?

how do you use microsoft excel? i have no idea how and i really want to learn... i have a 2003 or a 2004 version and the only help sites i can find are those for 2000 and 2007...

My boss told me that I need to take a class that teaches me how to use Microsoft Excel. Can anyone tell me where in Tempe Arizona I can do that at? Any near locations? Thanks!

I need to purchase a set of in-class textbooks for a high school class and for a middle school class. Any suggestions would be appreciated!

I would be paying $175 a month. The lease is for four years with an annual interest rate at 3% and the car will retain 40% of its value after four years. I need to find the maximum price of the car I can lease.

I have some knowledge of Microsoft Excel and I want to get certification. I know myself: I learn better from software than I do from reading a book. Does anyone have recommendations for software that would fit the bill? I would prefer something reasonably priced and quality, but that might be unrealistic! Thanks in advance!

I'm getting an A in my college advanced excel class and was thinking about taking the certification test after I was done with the class. So I was wondering how hard will the certification test test be?

I want to write MS Excel certification,where I get the exact material and sample question papers for practice...

I'm interested in enrolling into the Excel online high school program as a full time student over the summer so that I can start and finish my junior year of high school over the summer. Has anyone had trouble with their high school and or college accepting this diploma? Also approximately how long did it take you to complete a course?

Also looking for free online Excel and Word tests/quizes

I have a few projects that need to be done and I am not very good at excel spreadsheets at all is there and online service where I can send the info then someone makes the spreadsheets and I pay a fee ? So basically I am looking for a service to send my info a specifics and get spreadsheets made in excel to specific settings....

I have a Master list of conferences for different clients. I would like this data to filter into a different worksheet (same excel file) for each client seperately. I tried Advanced filter and had no luck. Each client has their own tab/worksheet. I dont want to have to copy and paste - I would like excel to grab the lines of data where the client is mentioned and filter it onto their seperate sheet. any help woudl be appreciated!!

I know how to use the filter in excel to do 'Auto Filter' but that filters on cells that have data in, i want to filter by cell colour, is this possible or is it a job for a Macro?

Hi, I have a excel worksheet set up. Column A is in numerical order. Column B contains words. I need to filter the spreadsheet using column B in alphabetical order. Input data, then go back to the original spreadsheet form. How can I do this?

I am trying to archive lots of data in Excel from different sources. I am having the problem of little spelling errors from the different sources not being recognized by excel as the same type of data. For example if one person had used the term "Table" and another used the short hand "Tab", I paste them both into a spreadsheet hoping that they are recognized as the same- but of course excel treats them as different. Is there a command in excel where I could search out every example of "Tab" and have excel change it to "Table"? Or some other quick way to get the same result?

i have been looking for schools that are offering excel courses...so they have 3 dirrerent levels and each level is cosidered as a course and each course is only 1 day long is this possible...i mean can i learn a course by only 1 day,,,and learn and the whole software in 3 days?

i have not used excel in a dogs age and i would like to try and get a program to run in excel.

i have not used excel in a dogs age and i would like to try and get a program to run in excel.

I am looking for a professional, paid, course in Excel that will be thorough and explain all of the functions needed for financial reporting. I do not need VBA-- but in depth training of sorting/pivot tables/etc are needed. A full one, or two day course is what I envision. I am looking for a professional, paid, course in Excel that will be thorough and explain all of the functions needed for financial reporting. I do not need VBA-- but in depth training of sorting/pivot tables/etc are needed. A full one, or two day course is what I envision. I live in San Francisco.

Most of the free ones that I've seen are for beginners and the advanced ones seem to cost money. Does anyone have any idea where I can access this kind of training?

I need a site that starts the course from scratch and goes into the details of Vlookups, If functions and VBA ..... Thanks a mill Cliffordm...my email ad is swifterswift@yahoo.co.uk....I appreciate it... lets see if we can get cracking on the VBA ....lol

I have basic knowledge in excel. However i need to know excel in details for job purpose[wherein 1 need 2 b well versed in ms-office] so that i can prepare MIS reports. Can any 1 tell me where I could learn excel in details[like vlookup, pivot table]

that will give you the opportunity to practice using real examples? And is it wrong to put this software on your resume if you only used this at a beginner's level? Thanks, any that you would recommend?

I have just loade Excel 2007 where I do drawings but I can't seem to find how to put in an arrow, Can anyone tell me how to get it. Cheers Coln

You can double-click a cell containing a formula and Excel will use Range Finder to highlight the cells that provide data to the formula. True False

I have Excel 2007, and when I highlight, copy and paste something, Excel will automatically highlight the same number of cells anytime I click on the worksheet. How do I prevent this from happening?

i need excel 2003 installed on my desktop. most of the software shops offer excel 2007, which is not most of the offices use. what should i do? where can i find excel 2003? where can i find a laptop with Excel 2003 installed?

i have computer apps this year and we have been doing excel for a couple of weeks. well excel isn't my strong point like word or powerpoint. i need a lot of help. are there any like worksheets that i can work with hands on? any good websites to help me? help please!

I'm using Excel 2003 and creating a spreadsheet that references data in many files. The referenced files are updated monthly and the file names are appended with the month and version number. I'd like to create a tab that lists the numerous file name that I need to reference and then carry those file names into the formulas that reference the external data via the cell reference. Is this possible?

Hi, ive got the microsoft excel on Mac and i have no idea how to do formula view on it, any experienced people about?

A friend is thinking of purchasing a Mac for personal home use, but has been frustrated when he he has used Macs to work on Excel files (which he would need to regularly send home from his Windows PC at work, to work on documents at home). I think the main issue is not features or overall compatibility. (Mac Excel 2004 has basically the same features as the Windows version.) I think the issue, instead, has more to do with how to find/use the features, particularly keyboard shortcuts. I can't find on the Web any guide that would show how certain common Windows Excel features, especially keyboard shortcuts, translate on the Mac version. Can anyone help?

I wish not to double-click a cell in order to edit the content of that cell. Once I moved on a cell (with the arrow keys), if I start typing, the new text/number replaces the existing content. I wish to edit that content, not replace it. Currently, I can only double-click to edit the existing content. On Excel PC, F2 allows to go in edition mode in the selected cell. What is the equivalent on Mac?

I know how to create new instances: Dim appXL as Excel.Application Dim wbXL as Excel.Workbook Sub Example() Set appXL = New Excel.Application Set wbXL = appXL.Workbooks.Add appXL.Visible = True End Sub But what if you already have two instances of Excel open and you want one instance to control the other? Is this possible? Set appXL = <other Excel application> Any VBA help would be greatly appreciated.

Does anyone have a recommendation on how/where to find a seasoned, part-time US-based Excel/VBA contractor and what a good/fair hourly wage would be? I have an Excel application that needs some tweaks beyond my capabilities and I have no idea where to look. Thank you for your help!

Can you guide me on how can I create an input box in excel vba. Thanks for your time.

Or should i learn Visual Basic too, Should i learn visual basic before vba or is there some other way. Kindly advice. Also will C# help me in anyway?

I'm looking for a programmer to do a job for me in Microsoft Excel, Access and, access database through the web. Please contact me.

I am a casual excel user who sometimes experiments with a bit of programming for personal projects. I would like to accomplish the following: Expect to have 6 or 7 columns where data is being added on a regular basis Trying to program each column individually so the next cell's background color changes based on previous cells data. For example: Case last 3 cells value = 0 cell background color yellow Case last 4 cells value = 0 cell background color blue Can you give me some general idea on what excel functions I should use and what to do about floating loop as new data is being added constantly!

Please help me by providing the formula that I should use when calculating the conversion from Farenheit to Celsius in Microsoft Excel.

I need a function(s) or macro that would allow me to take a number in base-10 decimal format and convert it to hex. Also counting/adding the hex numbers as more decimal numbers are added to a list.

I need a simple excel file which can calculate from one currency to another. It should have big buttons with currency picture, to select which currency is traded, an input field of howmuch foreign currency I receive and an output field which tells me howmuch to give the customer back. Besides that I must be able to input daily exchange rates for all currency's. An additional plus would be a print receipt option for customer and database option to store all days transaction. The biggest problem for me is to make buttons and to link it and make it work. Thanks