478 Answered Questions for the topic Microsoft Excel

Microsoft Excel Excel Export Ssrs

05/11/19

Save Excel File with a Timestamp when Exporting a Report in SSRS 2016?
I've been fiddling around with SSRS 2016 and tried, without any success, to add a timestamp to the saved excel file when exporting a report. Is there a way, preferably one that isn't much of a... more
Follows • 1
Expert Answers •1
Microsoft Excel Excel Report Ssrs

05/11/19

SSRS: creating a report optimized for exporting to Excel?
I have a client that needs a particular report that he can export to excel. I haven’t started to build the report, but I’m thinking the best way to do this is to keep the report as simple as... more
Follows • 1
Expert Answers •1
Microsoft Excel

05/11/19

How can I assign colors and Background Image in Excel?
Follows • 1
Expert Answers •2
Microsoft Excel

05/11/19

Using Google Sheets, how can I allow a user to select more than one option to populate a cell? Can this be done with data validation or some kind of pre-defined clickable list?
Follows • 2
Expert Answers •1
Microsoft Excel

05/08/19

What type of Microsoft Excel knowledge are business consultant jobs looking for?
Follows • 1
Expert Answers •1
Microsoft Excel

05/05/19

How do I solve the “VBE6EXT.OLB could not be loaded” out of memory error in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel

05/03/19

What is the excel formula to calculate average value ignoring blank cells?
Follows • 1
Expert Answers •1
Microsoft Excel

05/03/19

How do I sum a range of data ignoring zero in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel

05/03/19

How can I create a formula or button in Excel to automatically copy from a set point to the first reading of ISBLANK() =FALSE and then move the set point one below?
Follows • 1
Expert Answers •1
Microsoft Excel

04/30/19

y=a•b^x A scientist is experimenting with bacteria growth populations. He starts with 100 bacteria in a petri dish and estimates that the population will triple each day.

1) a=2) b=3) Exponential Function:4) How many bacteria will there be after two days?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

04/28/19

Need help regarding Excel formula
If multiple values are given in Excel sheets, then how to calculate the any percentage on fixed value for example we have 18000 thousand rupees but we need to Calculate any percentage on only 15000... more
Follows • 2
Expert Answers •1
Microsoft Excel

04/11/19

p value and excel formula
A publisher reports that 31 % of their readers own a particular make of car. A marketing executive wants to test the claim that the percentage is actually more than the reported percentage. A... more
Follows • 1
Expert Answers •1
Microsoft Excel Excel

04/01/19

What does set print area mean in Excel?
Follows • 1
Expert Answers •2

04/01/19

How to simultaneously rename a file in MS Office and delete old version?
In Microsoft Office, when wanting to save a file to a different file name without keeping a copy of the previous file name, doing so requires two steps: - First, File -> Save As... and select... more
Follows • 1
Expert Answers •2
Microsoft Excel Excel

04/01/19

Why do we use a dollar sign in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/31/19

What is the formula in Excel for a zigzag indicator?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/31/19

Is it possible to create a Word document using Excel VBA and data contained in the Excel worksheet?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/31/19

How do you rank a tie in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/30/19

How do you make Excel add faster?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/30/19

How do I get a unique rank in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/30/19

When should we use ByVal and ByRef in VBA?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/30/19

How do I extract a name from a sentence using Excel?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/30/19

How do you enter dates in Excel?
Follows • 1
Expert Answers •1
Microsoft Excel Excel

03/29/19

What are the most important things a new user of Excel should know?
Follows • 1
Expert Answers •1
Microsoft Excel Accounting Excel

03/28/19

Excel: Computing Regular Deposits for a Specified Future Amount?
I had tried to run some example from my calculator on excel. I cannot get the correct answer of 203.13. Can someone try to pinpoint the error in my formula? You plan to open a savings account and... 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.