Get instant live Excel expert help to learn how to create and adjust tables in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am making a dashboard in excel with multiple pivot tables and slicers and would like to know how the tables and graphs can automatically extend without overlapping
Solved by A. L. in 30 mins
I am making a dashboard in excel with multiple pivot tables and slicers and would like to know how the tables and graphs can automatically extend without overlapping. Moreover I'm making charts/graphs with no default settings which I would like to save as templates but I don't know how to make them remain or extend when selecting other things in the slicers.
Solved by T. B. in 13 mins
Making pivot tables in excel with charts templates. I have difficulties with the grahs and how the tables extend whenever I'm selecting new options with slicers.
Solved by Z. D. in 26 mins
The demand curve for tickets at an amusement park is:
Q=D(p)=1900−45p
Q=D(p)=1900-45p
, p > 0
The marginal cost of serving a customer is $14.
Using calculus and formulas (but no tables or spreadsheets) to find a solution, what is the profit-maximizing price?
Round the equilibrium quantity DOWN to its integer part and round the equilibrium price to the nearest cent.
Solved by S. Q. in 29 mins
The demand curve for tickets at an amusement park is:
Q=D(p)=1300−46p, p > 0
The marginal cost of serving a customer is $13.
Using calculus and formulas (but no tables or spreadsheets) to find a solution, what is the total contribution margin (revenue less variable costs) to the amusement park?
Solved by O. F. in 25 mins
Private Sub Workbook_Open()
Dim wsh As Variant
For Each wsh In Worksheets(Array("employee wages", "concrete (hanson)", "accounts & 30 days", "Tables", "cash expense", "master"))
wsh.EnableOutlining = True
wsh.EnableAutoFilter = True
wsh.Protect UserInterFaceOnly:=True, Password:="abc"
Next wsh
Range("Hidemainsheet").Select
Selection.EntireColumn.Hidden = True
End Sub
Solved by A. W. in 21 mins
Private Sub Workbook_Open()
Dim wsh As Variant
For Each wsh In Worksheets(Array("employee wages", "concrete (hanson)", "accounts & 30 days", "Tables", "cash expense", "master"))
wsh.EnableOutlining = True
wsh.EnableAutoFilter = True
wsh.Protect UserInterFaceOnly:=True, Password:="abc"
Next wsh
Range("Hidemainsheet").Select
Selection.EntireColumn.Hidden = True
End Sub
how do i add ranges hideEXcolumn and hidetable2 to this code? I tried altering code to
Range("Hidemainsheet, hideEXcolumn, hidetable2").Select
but its not working?
Solved by E. J. in 20 mins
How do I use IRR in excel and make pivot tables. Thanks,
Solved by T. W. in 18 mins
Hey, I need help with using vlookups. I have two tables with dates, numeric codes, and marketing metrics. I need it to search for both the date and numeric code and then report back the marketing metric for that date and code.
Solved by V. E. in 12 mins
I have a spreadsheet set up in Excel which pulls data from a .csv file (from an MIS system) set up using Microsoft Query. All working fine until today - when I'm selecting available tables columns, my column headers have been replaced from the correct labels to F1, F2, F3 etc. The raw database appears OK. Any ideas?
Solved by I. Y. in 14 mins