475 Answered Questions for the topic Microsoft Excel

Microsoft Excel

11/23/23

Formatting imported .CSV file quickly
As part of my job, every day I import data from an online database into an Excel spreadsheet. The data is downloaded as a .CSV file then opens in Excel. The data is always sloppy. The font is wrong... more
Follows • 1
Expert Answers •1
Microsoft Excel

11/23/23

Using IF function to hide results under certain conditions
I’m keeping a running ledger of transactions that has a balance column. I have a formula in the balance column that automatically returns the balance on the next line based on the value typed in... more
Follows • 1
Expert Answers •1
Microsoft Excel

11/23/23

Finding missing data in large data sets
I have a large data set with several columns and more than 3,000 rows. In some of the columns, data is missing on one or more rows below. How can I quickly identify which rows are missing data?
Follows • 1
Expert Answers •1
Microsoft Excel

11/23/23

Finding missing data in large data sets
You can do this easily with filters. First, be sure to have a header row that has a label over every column. It is best to make the text in this row bold and to freeze the header row. To freeze the... more
Follows • 1
Expert Answers •1
Microsoft Excel

11/23/23

Formatting imported data from .CSV file
I have a large data set with several columns and more than 3,000 rows. In some of the columns, data is missing on one or more rows below. How can I quickly identify which rows are missing data?
Follows • 1
Expert Answers •1
Microsoft Excel Math Business Algebra 2

10/17/23

Wall Street Journal reported on several studies that show massage therapy has a variety of health benefits & it's not too expensive.

A sample of 10 typical 1 hr massage therapy sessions showed an average charge of $61. The population standard deviation for a one-hour session is σ = $5.6. Using 95% confidence, what is the margin... more
Follows • 1
Expert Answers •1
Microsoft Excel

10/16/23

What is the VLookUp function in Excel?
What is the primary function of VLookUp, how is it leveraged as an analytical tool and what are some common mistakes or errors to watch out for?
Follows • 0
Expert Answers •1
Microsoft Excel Gis Microsoft Word

10/16/23

What is your number?
Here are a few possible answers:My favorite number is 7.My lucky number is 13.My phone number is (254)702288830.My number is 42, the answer to the ultimate question of life, the universe, and... more
Follows • 1
Expert Answers •1
Microsoft Excel

09/19/23

How to cancel a scheduled lesson
How to cancel a scheduled lesson
Follows • 3
Expert Answers •1
Microsoft Excel

09/09/23

What's the best way to filter data?
There are multiple ways to filter data based on your needs. This can be done with formulas, filter dropdowns, or an advanced filter.
Follows • 2
Expert Answers •2
Microsoft Excel

09/09/23

How do I slice data in Excel?
Slicers are a great visual filter that can be added to tables or pivot tables.
Follows • 1
Expert Answers •1
Microsoft Excel

09/09/23

How do I look up data in Excel?
There are multiple look-up functions and formulas that return one value or multiple values depending on what you're looking for.
Follows • 1
Expert Answers •1
Microsoft Excel

09/09/23

What are pivot tables?
Pivot tables are a quick and easy way to organize and summarize data.
Follows • 1
Expert Answers •1
Microsoft Excel

08/16/23

Ever wonder how to create dynamic dropdown list? No more changing the data validation->list->source when you add or delete items from the list.
Hint: use OFFSET to create dynamic dropdown lists? Create once and then rest assure the dropdown list will stay up to date with the latest set of items you want to display in the dropdown
Follows • 1
Expert Answers •1
Microsoft Excel

08/15/23

Recording from 8/12
Hi,I had a recording from 8/12 and it seems to have expired. Could I please access this video as I didn't get a chance to review it before it went away. Thank you for all.-Dmitry
Follows • 1
Expert Answers •1
Microsoft Excel

06/11/23

Finding the Lowest Risk% with the Highest Return% while ensuring each subsequent record has a higher return% and risk% than the previous record
 I have a table of Stocks with Return% and Risk%, how do I find the lowest risk percentage with the highest return percentage while ensuring that each subsequent record has a higher return% and... more
Follows • 2
Expert Answers •2

05/23/23

Any tips on how to write VBA for a Microsoft Office program?
Follows • 1
Expert Answers •2
Microsoft Excel

05/20/23

My tutor has no clue how to enable recording

My tutor has no clue how to ipt into recording. Right its saying she doesn't have it enabled. How does she fix that to allow recording
Follows • 1
Expert Answers •1
Microsoft Excel

04/10/23

Excel: How to summarise results for each student and for each subject?
I'm trying to summarise data where each row of data is a particular test.Each subject may have multiple tests and each student may have multiple subjects.We don't know how many subjects per student... more
Follows • 2
Expert Answers •2
Microsoft Excel

04/04/23

Where are my other recordings? Can they be accessed?
Hello, I went to prepare to take more lessons by reviewing a past lesson and it is gone.I picked Wyzant specifically for this reason. I really need my lesson with Sue, I plan to move forward with... more
Follows • 1
Expert Answers •1
Microsoft Excel

03/16/23

Reformatting words in a cell
In cell A1, it says "269 Southwest 13th Avenue, Pompano Beach, FL".In cell A2, I want it to be reformatted to "Pompano Beach, FL; 269 Southwest 13th Avenue".What formula would I use to reformat?
Follows • 3
Expert Answers •3
Microsoft Excel

03/11/23

Access to lesson past 30 days
I would like to access my lesson after the 30 period. Is it possible? Would I have to pay?
Follows • 1
Expert Answers •1
Microsoft Excel Math Business Statistics

02/24/23

Business Statistics - Probability
The speed with which utility companies can resolve problems is very important. GTC, the Georgetown Telephone Company, reports it can resolve customer problems the same day they are reported in 70%... more
Follows • 1
Expert Answers •1
Microsoft Excel Math Business Statistics

02/24/23

Buisiness Statistics - Probability
The speed with which utility companies can resolve problems is very important. GTC, the Georgetown Telephone Company, reports it can resolve customer problems the same day they are reported in 70%... more
Follows • 2
Expert Answers •1
Microsoft Excel Math Business Statistics

02/24/23

Business Statistics - Probability Distribution
Industry standards suggest that 7% of new vehicles require warranty service within the first year. Jones Nissan in Sumter, South Carolina, sold 9 Nissans yesterday. (Round your mean answer to 2... more
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.