Newest Microsoft Excel Questions | Wyzant Ask An Expert

484 Answered Questions for the topic Microsoft Excel

Microsoft Excel

05/19/19

How can I trade in Excel, like placing buy or sell order?

Follows • 2

Answers •1

Microsoft Excel Excel Ssrs Reporting Services

05/15/19

OfficeWriter designer .net for excel - parameters dialog not showing?

I am trying to view an SSRS report (2008 R2 .rdl) with parameters in OfficeWriter designer .NET for excel but its not showing the parameters dialog also not displaying any alert/error. How can i... more

Follows • 1

Answers •1

Microsoft Excel Excel Ssrs Reporting Services

05/13/19

Excel as a data source in SSRS Query a Specific Column of a Sheet?

I want to query the data from an excel file utilizing ODBC System DSN for Excel 12.0. What will be the right syntax to query specific columns from a worksheet and not the whole worksheet like... more

Follows • 1

Answers •1

Microsoft Excel Excel Ssrs Reporting Services

05/12/19

Connection String for ODBC on report server?

I want to create a datasource on report server from an excel. I put my excel to report server. Than i wrote a connection string, but it did not work. What is wrong? "Data... more

Follows • 1

Answers •1

Microsoft Excel Excel Visual Studio Ssrs

05/11/19

ssrs exporting to excel as csv?

I am calling SSRS reports from an in house piece of software. All the reports made before me render as xlsx or xls and mine continuously are rendering as csv files which is messing up my... more

Follows • 1

Answers •1

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

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

Answers •1

Microsoft Excel Excel Ssrs Reporting Services

05/11/19

SSRS footer text color not changing?

We are applying a stylesheet to SSRS report footer. Footer Font color is set dynamically based on the configuration in the database. When report is exported into Excel, footer color is always... more

Follows • 1

Answers •1

Microsoft Excel

05/11/19

How can I assign colors and Background Image in Excel?

Follows • 1

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

Answers •1

Microsoft Excel

05/08/19

What type of Microsoft Excel knowledge are business consultant jobs looking for?

Follows • 1

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

Answers •1

Microsoft Excel

05/03/19

What is the excel formula to calculate average value ignoring blank cells?

Follows • 1

Answers •1

Microsoft Excel

05/03/19

How do I sum a range of data ignoring zero in Excel?

Follows • 1

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

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

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

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

Answers •1

Microsoft Excel Excel

04/01/19

What does set print area mean in Excel?

Follows • 1

Answers •2

Microsoft Excel Microsoft Office Microsoft Word Microsoft Powerpoint

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

Answers •2