Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
% Change
I have daily data that I need monthly and yearly price change, how do I do that?
Jay
Jay
Data Manipualtion
Hi, how can I turn daily pricing data, into monthly price data, and yearly price data.
Thank you,
Thank you,
WLSRegression using Excel VBA
Hello,
I'm using the following code to create a diagonal matrix and then to produce the Betas for a regression analysis. For some reason my output ends as 0, or I receive an #Value error stating one of my values is of the wrong data type. My analysis involves a y-intercept and 2 independent vari...
Read More
Adding hyperlink to header in Excel
I am having difficulty adding a hyperlink to a header of an excel sheet and I think it requires some VBA. However, when I click on the header (from the page layout view), I can't even access VBA. Any ideas on how to access it and what syntax is needed to add a hyperlink? Thanks a bunch, Elliot
New Collection and Looping
I want to build a new collection from a desired range, but I want to skip the blank cells. I tried to begin the loop with Do While Not (ISempty(activecell)), but this is still pulling blank cells. The collection involves 2 thresholds - a minimum and maximum budget variance - corresponding to a list...
Read More
An alternative needed to a multi-select drop-down list
I am in search of a way to convert multiple selections in a drop-down list into a single field with the selections separated by a semicolon. Background: I need to get contact data into a specific format that is importable into a particular on-line software app. I was contemplating having a user-f...
Read More
Shortcut Keys for Macros Not Working
For some reason, macros work when I click on them in the Developer/Macros dialogue box. But when I hit the shortcut keys, the macro fails to run. I created the macro by recording it, so it prompted me for what shortcut key I wanted. I've created macros this way many times in the past so I don't th...
Read More
Advanced Excel for Data Analysis Course Questions
1) I am working off a version of Windows Excel 2016. Do you know what the home key shortcut is? "Fn" does not and work neither does "alt +h."
2) For Excel 2016 In the Pivot Tables Section, when I get to step 3 out of 3 to set up the table, excel doesn't give me the option of clicking layout (it'...
Read More
Saving function across workbooks in Excel 2010
Hi, I have a Personal.XLSB filed saved the location discussed in the link "Saving macros across workbooks in 2007".
I see my macros in other workbooks and that works. But a function I created/copied in VBA does not appear in other workbooks. The new function works perfectly in the Personal.xl...
Read More
External File Links
I am working with a model that references an external file to pull in specific data points for multiple business units. The referenced file has all of the BUs in separate tabs. However, my model has all BUs in a single sheet. If I include in my file the exact BU tab names from the external file, can...
Read More
waterfall chart with multiple series
Hi. I have encounter a problem when trying to do a waterfall chart with multiple series in excel.
I have income data for a sector and don't know how to put them into one waterfall chart with time series. What I want to accomplish is something like the chart below. Could you advice a method to do...
Read More
I have
I am using a SUMPRODUCT that is contingent upon 2 criteria: region and product division. Regions are NAM, LATAM, ASPAC, and EMEA. Product divisions are CS, TT, and FL. The criteria are located in a drop down list to limit responses. My model works fine if I select both a region and a division, such...
Read More
formula on how to dynamically average four quarters' numbers of each year
Hi, if I wish to average, say, four quarters' numbers for each year from, say 2001-2015, how would I do that? I tried the below but it returned #DIV/0!
AVERAGEIFS($B$180:$BA$180,$B$5:$BA$5,"=$BC5")
$B$180:$BA$180 is the range to average
$B$5:$BA$5 is the range from 1Q05 to 4Q15 and I have alr...
Read More
formula on how to dynamically copy a cell
i have a question on excel if you can help me in the right direction. i have those 1 and 0 trigger. if the trigger is on (as 1), then i sell half of the stock (convert into cash and hold it until trigger is off) and leave half of stock invested. So as my excel goes, i need to copy the cash value as ...
Read More
Run-time error 1004 when formatting numbers
Some students have received this error message when formatting numbers via Ctrl + Shift + M, etc.: "Run-time error 1004: Unable to set the NumberFormat property of the Range class"
Creating a summary page for dozens of tabs
I have 200+ tabs of individual account data. I am working to have a summary tab pull in information from the same cell on every worksheet. Currently, my only solution is to copy/paste the formulas and ctrl+f and replace the tab titles. Is there a way to speed this process up? Or, is there a way to r...
Read More
Add-in on Excel Workbook
How would I add the WST Macro Add-In if I am using a Microsoft Surface Excel Workbook? Thanks
Ctrl space/ shift space to select entire column/row not working
Even after changing key settings (Control Panel >> change keyboard >> advanced key settings) and disabled the key for switching language, it will stil automatcally switch back.
Macros not installing properly
Hi Guys-
I had no difficulties installing the macros during class but once I reached the desk the macros only partially installed. I use excel 2007 and run windows 7 and I followed the instructions a few times trying to fix the issue myself. The problem persists in the form of basic functions lik...
Read More
Editing WST Macros
Hey guys,
I'm embarking on a large modeling project and per a senior banker's request, I need to use specific formatting (colors, text type, etc.) for his model. Oh the joys of a power-hungry MD.
Anyways, I've been using WST macros for years now and he's trying to make me stop using them and u...
Read More
Data skip blank and split window toggle
Hi there,
1) i hv some quarterly data series placed vertically, i need to sum 4 quarters to get full year, how can i do it quickly if i hv over 20 years data. (using skip blank function in paste special doesn't work)
2) using split window, how can i toggle all 4 quadrants
1) i hv some quarterly data series placed vertically, i need to sum 4 quarters to get full year, how can i do it quickly if i hv over 20 years data. (using skip blank function in paste special doesn't work)
2) using split window, how can i toggle all 4 quadrants
Excel 2007 adoption
I have a question regarding the newest versions of excel and how it affects learning with the video platform and training for an investment banking career. Are investment banks switching to Microsoft's latest version of Excel or are they sticking with the previous versions of 2003 or lower?
Pesky Technical Question
I continue to work daily with the WST macros, and have run into a few quirks I was hoping you could help with. I am using Excel 2002, SP3. It ain't broke....except:
1. I enter data. Cells that have calculations dependant on that data sometimes self-fill, and other times I have to copy and paste....
Read More
INDEX vs CHOOSE
Is there any reason to avoid using INDEX in a model? It's working out great for me in model but I'm cautious since I haven't used it before.
Text to Row
I know excel has a "Text to Column" function, but is there anyway to automate a "Text to Row" function. Please see below data. I would like to have Operator, Address, Phone, Operator, Address, Phone, etc., all on different rows going down the spreadsheet. Currently, each Operator...
Read More
Macro formatting question
Hey, is it possible to change the macro you have for %, so that negative and positive %'s would align with one another? Is there a way I could do that or you could? Also, is there a way to get rid of the space between $ #,### format. I would rather have if $#,###.
Printing
How do a write a macro to print the entire worksheet except for page one and the last page. Each time I print, there will be a different number of pags so this needs to adjust as I add / delete tabs.
vlookup question
Is there a way to match hard coded text from a referenced cell on one worksheet to a corresponding cell on an adjacent worksheet as a letter?
I.e. Cell B5 on Tab 1 says “Marinello” and I want that to trigger the exact same cell, except on Tab 2, to say “A”
Its probably really easy, but ...
Read More
lookup vs pivot table
I am trying to figure out the best way to combine several data sets
and calculate an average for each field (ROE, ROA, etc quarterly going
back 3 years).
Not all of the data sets include the same quarters depending on
whether they have reported yet. For example one set starts with Q2
2005 and...
Read More
Charts suddenly not visible/filled in box of one colour
All of a sudden all of my charts in my model are exhibiting the following problem:
- they are completely filled up in grey
- as if one box but the chart is not visible
- I can only see the chart data/output when i click on the chart
- as soon as i click anywhere else in the model the chart is autom...
Read More
Technical Question: Excel for PC vs Excel for Mac shortcuts
What are the major differences in Excel for PC vs Excel for Mac shortcuts?
Data Table Question
I took your class at NYSSA a couple of years ago and had a random question that I hope you could help with... I want to create two variable data table for each year over a twenty year period. Is there a more efficient way of doing this without having to create a separate table for each year?
WST Macro
all shortcut keys involving ctrl+shift+alt does not work on my excel. Everything else does. I have no additional addons installed.
Help! thanks!
Help! thanks!
Copy and Paste Exact Formula
I seem to remember a WST macro or shortcut that would copy and paste formulas absolutely. As in, if I have =A1+B2 and I copy that to another cell it’ll end up being A1+B2 rather than something like C1+D2 without the use of F4 to lock cells. Is there such a thing?
Toggle Reference File Links
I am trying to pull in data from different workbooks that have data sorted by month and worksheets sorted by division. For example, the file name could be: “Product Line by Division 10.13” for October 2013 and the tab name could be “NE Vermont”. How can I pull the same information from the ...
Read More
General Inquiry
How could you line in a pivot table and not make it come out of the total?
Excel Question
If you have to worksheets; one is all the stocks in the S&P and another with just Argentinian stocks and you want to see which ones overlap, what do you do? I did a vlookup but the problem is that some have the same names but some have periods, commas or extra spaces in the names so you cant do ...
Read More
Name check
Hi,
I have a column of names ( Column A - First then Last Name no commas) and another column of names ( Column B - Last Name comma First Name).
Is there a way to check whether names from Column B are on Column A through a lookup of some sort?
I have a column of names ( Column A - First then Last Name no commas) and another column of names ( Column B - Last Name comma First Name).
Is there a way to check whether names from Column B are on Column A through a lookup of some sort?
How can Excel pull stock quotes?
What is the best way to retrieve stock quotes for an array of stock symbols?
Print Tiles - Entire Workbook
In Excel 2010, I can set which rows to repeat at the top of a sheet from Print Tiles.
Is there a way to set this up for all the sheets in an excel workbook?
Is there a way to set this up for all the sheets in an excel workbook?
Scatter Plot Data
Hi,
I need to plot 3 variables on a scatter plot diagram for a report I create. I have been doing this manually since I started because I dont know how to automate the process.
the 3 variables are
asset class: equity, credit, rates, commodity, fx, hybrid (which I can use as the y-axis)
Maturity(...
Read More
Finding specific cells in a workbook
I have a multi-tab workbook LBO enhanced model that I have had to de-bug by re-writing formulas that previously linked to other files. Yet every time I open it I get a dialog box asking if i want to update the data from outside links.
How do I trace through the model to find (and fix) all cells t...
Read More
Excel related question
I am trying to figure out a way to format my entire workbook where hard coded data is in BLACK font and all formulas are in BLUE font. Essentially, for every new worksheet I insert it automatically takes up this formatting. I suppose this would be a macro that is activated the moment I open a new ...
Read More
Problem with choose and average formulas
I have been on the Advancd LBO Modeling course, and some of the formulas that Mr. Lin introduces actually aren't doing what they are supposed to do, and I don't know why. Specifically, in the Interest expense section at the 34th minute, he asks us to put in the following formula =Choose($P$64,Q34,av...
Read More
data table
I input the data table information for the Advanced LBO Modeling course (right near the end of the final video) but there must have been a mistake because the table is populated by the word Year 1. My problem is that the program won't let me undo what I've done. Whenever I try to change any cell i g...
Read More
simple data table question
I made a mistake in typing in a data table formula, and now excel won't let me undo it. How do you undo a data table? (In my case every cell now reads Yedar 1.) Thanks.
Macro error: compile error in hidden module: thiswork
Hello,
I am using Excel 2011 for Mac, when I tried to to install the WST macro from tool -> add-in menu, an error shows up:
"Compile error in hidden module: thisworkbook"
And the WST did not show up after the error prompted. Please advise how I can fix this, thanks.
Note: I download...
Read More
daily number and quarterly data on chart
Hi, i hv say a few years of daily stock price and i want to overlay some quarterly inventory number or the yoy change on the inventory number to see how it moves with the share price. but since i maybe hv 10-15 rows of quarterly number, but i hv thousands of row in the daily stock price, how can i l...
Read More
I need a Function to Start With (Summing alternate row)
I’m not sure what function to use for my issue. I desire a formula I can enter into a cell, and I don’t want to use filters.
1.) I want excel to search down a column and identify the status “Completed.”
2.) After it finds all instances, I want it to go to the next column (this is a numbe...
Read More
Zoom in Excel
What are the shortcut keys for zooming in and out of EXCEL using only the keyboard?
Thanks,
Thanks,
How to not auto-resize rows when using Underline
I really like the custom formatting that is used in the WST models and i'm adopting it for use throughout all of my models. The model templates all come with even row heights (size 12.00), even for rows that have underlines in them. However, if I were to hit ctrl + U to create the custom long-underl...
Read More
Excel Macros
How can I create an excel macro that uses the ctrl + shift + alt buttons, like you guys have in your wall st training macros? I cant figure out how to do more than just shift + ctrl shortcuts.
Custom fonts for Chart Y Axis.
Could someone walk me through the steps on how I can get my y axis labels in a chart to only have the dollar sign at the top marker and the rest aligned correctly but not with the dollar sign obviously. I have tried to do this as he is doing in video over and over again but it doesn't work.
Conditional Formatting
I have a project for which there are three distinct phases and each one needs a different color. It needs to be color coded across the entire row.
There are multiple steps for each phase. Although the steps stay the same, we make iterations in which they change phase constantly.
Can I use condit...
Read More
Why do bankers use the paste enhanced picture for excl chart
It seems that pace enhanced pictures into ppt from excel for charts do not look nearly as clear as just pasting the actual chart in chart form. Why is the Paste enhanced picture the preferred format?
COUNTIF, Then What?
I have a list. Columns are A.) Date Trained and B.) Certified? (this is TRUE or FALSE)
I want to make multiple pie charts from one table. I need the pie charts to show percentage certified and percentage not certified. Each pie chart needs to depict a different Date Trained.
I currently am usin...
Read More
Automatically Importing Formatted Data
]I have a standard report template in excel. I paste data into this Excel template based on a copied selection from an Access query.
There are two columns, A.) Name and B.) Dollars
The bottom row is a SUM of all the dollars above
The columns remain static, but the rows will change depending on ho...
Read More
a quick question about formatting
Hi,
In your template, you use $ in front of numbers in the first and last line, and use underline for summation. How do you get/define these formats in a quick way? Any shortcut? Thanks.
In your template, you use $ in front of numbers in the first and last line, and use underline for summation. How do you get/define these formats in a quick way? Any shortcut? Thanks.
Clear Content Shortcut or VBA script?
I wonder if there is any shortcut key for the "clear content" function. If not, is there any VBA script that I can use to make it an add-in?
toggle formula in cell display
Hi, i accidentally hit some stroke and now one of my row only shows formula (ie =a16*b5) instead of the calculated result. how can i change that. thx
UNINSTALL WST ADD-INS FROM EXCEL 2007
How do I remove all WST add-ins from my excel. I have tried deleting, however, in the add ins option the Wall St training images are still available. I want to uninstall them completely. Thank you.
Issues with Center No Merge
I'm using the macro Cntrl + Shift + E, and at first, it works fine when I set it in the template.
I open the template and import my data so the report populates. I need to recenter (no merge) the title because I have fewer columns than I did on my original template.
I attempt to use the macro aga...
Read More
Basic Fundamental Knowledge
Prior to this training, I have not ever tried to make good use of quick keys. I see the light. Is there some fundamental logic that will help me know when to use CTRL + something vs ALT + something?
Building models from scratch?
Is there a package that teaches building fully integrated financial and valuation projection models from blank spreadsheets? From what I've seen and read, WST provides templates to work from, but I think it would be really useful to know how to correctly format and build a model from a blank spreads...
Read More
Permutation
Is there a function / macro in excel that generates various combination of numbers across different cells? Those set of numbers adding up to a certain sum.
This has to do with a Monte Carlo Model I’m doing that seeks to generate the optimal Portfolio Mix for a Fixed Income Portfolio based on key ...
Read More
Macro partially disabled
Hi there,
I have been using the great macro for a while, but recently I encountered some problem when I switch to another laptop.
On this new laptop part of the macro features are disabled, i.e. some work while some don't. This is a Lenovo thinkpad X61 with Windows XP system, what might be the reas...
Read More
Using References with Inequalities
I am trying to quickly count how many entries are between certain dates. At the moment, if I want to count everything in Q3 and Q4 2011, I use the formula =COUNTIFS($A:$A,"<=40908",$A:$A,">40724")
I would like to refer to a cell rather than use the numeric date value. Ho...
Read More
Making COUNTIF More Adaptable
I'm trying to count how many times a name occurs in a specific column. However, depending on where the person sits in the hierarchy, their name will appear in a different column.
How do I make the "criteria range" in a COUNTIF function dynamic?
I need a way to reference a key cell in the...
Read More
Watermark Help
I am currently viewing excel via the "Page Break Preview" mode. Is there any way to STAY in Page Break Preview, but remove the "Page 1", etc. watermarks that are present?
Thanks.
Thanks.
Displaying Color Info
[b:2azaf549]Why I'm Asking[/b:2azaf549]: I have a list of dozens of different job positions I am trying to sort and classify. The conditional formatting of "Text begins with" "text ends with" and "Text Contains" is the best way I know to easily color code then sort the...
Read More
How do I assign a shortcut key to previously created macros?
Full Question:
How do I add the keystroke shortcut if I have already initially bypassed the prompting to do so when you recording the macro?
How do I add the keystroke shortcut if I have already initially bypassed the prompting to do so when you recording the macro?
How to I automate blue and black cells for inputs/outputs?
Full Question:
I was wondering how to build a macro for formulas and constants to be black and blue.
I was wondering how to build a macro for formulas and constants to be black and blue.
How do I get the file name automatically in a given cell?
Full Question:
Is there a formula or command that will state the file name you are currently working on in a cell? We wanted to have the title automatically update with the version we were working on. Thank you.
Is there a formula or command that will state the file name you are currently working on in a cell? We wanted to have the title automatically update with the version we were working on. Thank you.
What is the keyboard command for the right mouse click?
Full Question:
What is the keyboard command for the right mouse click?
What is the keyboard command for the right mouse click?
How do I shade every 3rd row instead of alternate rows?
Full Question:
I had a follow-up question to the auto row shading taught in the Advanced Excel for Data Analysis class - what would the formula be if I wanted every 3, (or 4 or 5) rows colored, rather than every other row?
I had a follow-up question to the auto row shading taught in the Advanced Excel for Data Analysis class - what would the formula be if I wanted every 3, (or 4 or 5) rows colored, rather than every other row?
How do I create a long underline?
Full Question:
How do I create a long underline?
How do I create a long underline?
Excel 2003 to Excel 2007
Can you guys assist my company with the transition and migration from Excel 2003 to Excel 2007?
thank you.
thank you.
How do I create a data table? - and limitations
Full Question:
What is the [=TABLE] function that I see and how do I re-create this "data table"
What is the [=TABLE] function that I see and how do I re-create this "data table"
Linking between files
Full Question:
Currently I am working on an independent workbook that is located on company's share drive, and I have a dependent workbook that is linked to the independent workbook, also on the share drive. Up till now that links has been working great however, I notice today that the link has bee...
Read More
Limitation on number or rows in excel 2003
Full Question:
I have a question about the limitation of rows in excel 2003. I remember being informed that the limitation in excel 2003 was over 1 million rows or greater tahn 65,999 . When I tried to open a file with more than 66 thousands it seems I get an error. When I google the error it state...
Read More
Stock Price Annotations in Excel charting
Full Question:
Helping someone work on a powerpoint project, and I was wondering if there is a better way (other than moving the arrow along the stock chart line) to link an arrow to a certain stock price on the graph. I hope all is well, I have loaded your macros, and I have the shortcuts on my w...
Read More
How do I group/ungroup cells?
Full Question:
I see in Wall Street sell-side models that "+"/"-" buttons ( near the row and column headings) and "1"/"2" buttons (in the upper left hand corner) are created to unhide/hide a bunch of columns/rows by simply clicking on the buttons. How do I create these buttons ?
I see in Wall Street sell-side models that "+"/"-" buttons ( near the row and column headings) and "1"/"2" buttons (in the upper left hand corner) are created to unhide/hide a bunch of columns/rows by simply clicking on the buttons. How do I create these buttons ?
How do I move a row without the mouse?
Full Question:
I want a quick way to move entire row with no mouse. I know to highlight and cut you would do Shift space bar -- then hit Ctrl + C. How do I put it in the proper place? When I highlight the row in which i want my selection to go above, it simply copys over that row instead of inser...
Read More
Sum + If Array
I recently attended your excel for data analysis class. I have a question regarding the sum+if example. Can you please walk me through the logic behind the array in the sum + boolean example (approach 4)? In other words, how does * connect the three formulas? Everything else makes sense and I get it...
Read More
SUMIF problem
Full Question:
What am I doing wrong with this formula it keeps returning “0”?
=SUMIF(A7:A21,"MONTH(3)",C7:C21)
Notes:
A7:A21 are dates in this format (3/5)
Condition is to see if the Month is March (thus I use 3)
C7:C21 is the sale amount to add if condition is true
I also tried the f...
Read More
Saving macros across workbooks in 2007
Can I save a "startup file" for Excel 2007 that would have my personal macros just like you did for 2003? I tried to follow along, but there is no customizing or adding toolbars in 2007 according to Help. If I save an Excel workbook with my saved macros in the same location as I saved the ...
Read More
General Inquiry
I have recently subscribed to a few of Wall Street Training's online modules and have found them very useful. I have also downloaded the keystroke shortcuts macro which I have found to be very useful as well. My only question is that the dollar and number formats traditionally used at my company a...
Read More
Lost Formatting in Excel '07
I'm building the company financial model and as you can imagine it has gotten bigger than any spreadsheet I've ever created with many more references, but I wouldn't say it is a massive file. 232KB if that means anything to you. As it is a company model is has the circular reference built in, but I ...
Read More
Excel's Automatic Filters
I am dumping data from Access into Excel. One column is "Date Trained" I want to be able to sort the list based on this column. However, Excel is recognizing the column as Text and not as Dates. Because it is not recognizing the column as Dates, I cannot sort them chronologically.
I h...
Read More
Automatically Importing Formatted Data
I'm importing data from Microsoft Access, and one column is a list of dates. When I paste this data into Excel and apply a filter, so I can sort the dates chronologically, it only offers text filters. There are no date filters to sort by date.
I have tried changing the format to Date using both t...
Read More
Circular reference calculation not refrehsing automatically
In my financial model, there is a circular reference calculation for finance lease. I have selected "enable iteration" in the Excel settings, and the calculation runs well in normal circumstances. However, whenever there are some invalid cell references, say I delete an input row (which is...
Read More
How to set grey background in Windows 8?
Please kindly help!
Best way to set grey background for Mac
Hi,
I'm using Microsoft Office 2011 in Mac to build a DCF model with WST template. However, the figures in previous years (fonts in white) cannot be shown properly because of the default white background. What is the best way to set grey background in spreadsheet with Mac? Thanks.
Best Reg...
Read More
Best way to set grey background for Mac
Hi,
I am using MS Office 2011 to build a DCF model with WST template. It works fine except that the financial figures in early years (in white fonts) cannot be shown properly in white spreadsheet background. What is the best way to set the spreadsheet background color to grey, as WST suggest...
Read More
Cannot FULLY use WSTMacros3.4.2.xla on Excel 2013
Any functionality that requires you to start with "Alt+S" doesn't work on Excel 2013.
AFM Enhancements: Printing Set Up
Hi there,
Hope this is not too trivial - I realised that the printing setup for the template includes the row & column numbers. I tried many ways to eliminate that but still couldn't solve this issue.
Appreciate your advice in doing so.
Thanks
Stanley
Darby Private Equity
Fran...
Read More
Array formula
I attended your Excel Advanced course on the last day of the Financial Analysis Series (7 Nov 08)
There is an array formula which I tried to replicate but have problem.
I have a series of monthly returns in % and would like to multiply by 0.5 instead of adding 1 to the array range T11:T32.
But the ...
Read More
Urgent: Automating Scorecard Metrics grading
Dear WST,
Can you please advise a way to automate the following scorecard metrics grading?
Metrics: Target Market Growth Rate
[b:2de2qnsf]Metrics Points[/b:2de2qnsf]
>20% 12
10%-20% 8
<10% 4
The market growth can range from negative 100% to 1000%,...
Read More
WST Macro Problem
Hi,
My WST Macros (3.2.5) aren't working in Excel 2003. I have the Capital IQ plugin installed as well, as well as a couple of other plugins and addins. Is there a way to disable them when necessary and then re-enable them when needed? I would like to use the WST Macros primarily.
Thanks.
My WST Macros (3.2.5) aren't working in Excel 2003. I have the Capital IQ plugin installed as well, as well as a couple of other plugins and addins. Is there a way to disable them when necessary and then re-enable them when needed? I would like to use the WST Macros primarily.
Thanks.
Automatic Updates
Hi,
Problem: I add data to an INPUT column in a spreadsheet monthly. How do I make my functions, other lists and charts, that also need to update accordingly based on the original INPUT column (some of them may be in another worksheet in the same excel file), to automatically recognize that ther...
Read More
Accessing the file location for auto-starting macro toolbar
Full Question:
I do not understand how to save the macro toolbar file into the assigned folder (C:\Documents and Settings\<USER NAME>\Application Data\Microsoft\Excel\XLSTART)
I do not understand how to save the macro toolbar file into the assigned folder (C:\Documents and Settings\<USER NAME>\Application Data\Microsoft\Excel\XLSTART)
Selecting two or more non-adjacent cells to quicky get sum
Full Question:
Is there any way to highlight two or more NON-ADJACENT cells to make formatting changes to? Also, would like to highlight two non-adjacent cells to get a quick sum of the values.
Is there any way to highlight two or more NON-ADJACENT cells to make formatting changes to? Also, would like to highlight two non-adjacent cells to get a quick sum of the values.
Summarize ways to copy & paste efficiently in Excel
Full Question:
The commands that move data/formats/formulas over such as Ctrl+R, highlighting and hitting Ctrl Enter, etc. I know some bring just the formula over and some bring the formula over as well as the formatting. Can you provide a summery of which provides which?
The commands that move data/formats/formulas over such as Ctrl+R, highlighting and hitting Ctrl Enter, etc. I know some bring just the formula over and some bring the formula over as well as the formatting. Can you provide a summery of which provides which?
List of random numbers from -1 to 1 with given std dev
Full Question:
Is it possible to create a list of random numbers from -1 to 1 with a given standard deviation?
Is it possible to create a list of random numbers from -1 to 1 with a given standard deviation?
conditional average
what would be the formula to calculate conditional average, i.e. if conditions a,b, and c are met then average the rows x1:x40? I used average and if functions in an array formula and it did not accept all the conditions. The results displayed were not consistent with pivot table results.
Short cut for increase/decrease decimal point
Can you please remind me how to put that short cut in - I had done it previously for it to appeart in the Format menu.
dollar sign to "R"
Hi:
I have found your course extremely useful in assisting me to quickly develop financial models. your work is much appreciated.
i kindly enquire how one would change the excel to use "R" for south african rand instead of the dollar sign in one's financial model?
example: R 8602 inste...
Read More
Software for Financial Analyst
What kind of software that financial analyst usually used?
For example - in the below table I would want to type in a formula that gives me the column (x) and the row (c) for the minimum value. I am okay with these being separate functions for row and column
x y z
a 7 8 9
b 6 6 5
c 2 9 4 Read More