Question about Microsoft Excel for PC

1 Answer

Need help creating a finction

Need to create an excel query with import range using a key words

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 156 Answers

Please provide exact problem statement in terms of dataset.


For more clarification please mail on ali_zulfikar@yahoo.com with screenshots.

Posted on Sep 16, 2017

Ad

6 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
New users get to try the service completely Free afterwhich it costs $6 per call and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad
Dinoza
  • 112 Answers

SOURCE: MICROSOFT EXCEL GAMES

Guess you'll need to master VBA first

Posted on Oct 30, 2007

  • 36 Answers

SOURCE: ms word 2007 docs print every other line

This seems like a print driver problem. You may have to get an updated driver for your printer for Msoffice 2007.

Sean

Posted on Nov 30, 2007

  • 214 Answers

SOURCE: average handle time

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Posted on Apr 08, 2008

  • 1 Answer

SOURCE: using drop-down form field in a word 2007 template

You need to protect the form (Protect Document, Editing Restrictions (Filling in Forms) then Start Enforcing Protection, the drop down menu will then work.

Posted on Sep 29, 2008

  • 1 Answer

SOURCE: Microsoft Excel Temp Files

I just finished with Trend Micro help support and they solved this problem for me. Open the main console for Trend Micro. Click on Viruses & Spyware Controls. Click on the "settings" for Protection Against Viruses & Spyware. Click on Advanced Settings. Under the section for "What Should TMIS Check for Threats" click on the circle for "Specify Targets that you choose". Click on "Select" next to "Ignore Specific Files & Folders". Then Add and folders of files that you do not want Trend Micro to check and make backups for. That solved my issue...hope it helps you too.

Posted on Feb 05, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How to create helpfile for microsoft access 2013


This link will give you step by step on how to create and index your help files.

http://support.microsoft.com/kb/177116

Jul 24, 2014 | Microsoft OFFICE 2013 PROFESSIONAL 1 PC...

Tip

Microsoft Excel tips


Auto sum shortcut key
Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .
Create hyper links in Excel
Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once
Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".
Quickly open recently opened files
Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.
Create underlines without any text
This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .
Print only sections of a document
Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.
Repeat recent action
Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.
Quickly undo
Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.
Quickly above cell contents
In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

on Dec 27, 2009 | Computers & Internet

1 Answer

WHAT ARE THE IMPORTANCE OF POWERPOINT, WORD, & EXCEL


MICROSOFT POWERPOINT IS USED TO CREATE SLIDESHOWS,GREETINGS,INVITATION CARDS AND MANY MORE PRESENTATIONS.....

MICROSOFT WORD IS USED TO CREATE
RICH DOCUMENTS,HIGH QUALITY TEXTS

MICROSOFT EXCEL IS USED TO CREATE
CHARTS ,MARKS LIST,BILLS .RELATED TYPES OF DOCUMENTS,,IT IS MAINLY USED IN OFFICE

Oct 22, 2010 | Microsoft Computers & Internet

1 Answer

I want to download free version of excel 2007


No such thing.

You CAN download a trial version but it will time-out at the end of the trial period requiring either registration (for the M$ hefty fee) or removal. If you need Excel specifically - then you have to buy it. If another program will suffice that will create, import & export Excel compatible files, then I recommend OpenOffice. I use OpenOffice a lot. It's not the same, but it is a very good office suite. The Writer (Word counterpart) doesn't properly import correct formatting of things such as bullets and some tables, but it does export well into Word format. The thing is - it's free. It can be downloaded at http://www.openoffice.org .

Otherwise, you will have to purchase either Excel or Micro$oft Office.

If you find this solution helpful, then please take a moment to rate this post. - Thanks.

Jun 19, 2010 | Microsoft Windows XP Professional With...

1 Answer

Create labels on Word 7 with Avery 8250 labels


I am assuming that you want to do a mail merge from a list.

If you list is in Excel, you should be able to click mailings in Word. It will take you through the steps to create your set of labels. [It will help with other places for your lists besides Excel, too.

May 24, 2010 | Computers & Internet

1 Answer

I need to print mailing labels imported from excel to word in columnar order instead of in order by rows across the page.


hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

Dec 14, 2009 | Microsoft Windows XP Professional

1 Answer

Reminder in excel


There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.

Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.

Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.

Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.

May 31, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

How to open the reports in excel in oracle 10g


You can create a .CSV file using Text_IO builtin.

Latest Answer : Steps:---------------1) Download rep2excel.exe from the site:- http://www.brothersoft.com/downloads/html-to-excel.html 2) the from Oracle report save the file as .html3) From command prompt run.
needs three types of queries
3 types of queries. ref cursor query, online query, execute query.

check this site might help u out
http://www.geekinterview.com/question_details/22033

good luck...

Jan 29, 2009 | Microsoft Office Outlook 2003 for PC

1 Answer

Send a excel page directly from excel through net


hi,
Here is the Solution for you to try.
Create your File in Excel or Word or Powerpoint Click on Office Button --> Send--> Email.
Here you will get other options like For Review, as Attachment etc.

Hope your Query is Solved now.

bye.

Aug 20, 2008 | Microsoft Office Professional 2007:...

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

109 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2839 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...