由买买提看人间百态

topics

全部话题 - 话题: excel
首页 上页 1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)
r********e
发帖数: 1686
1
来自主题: Statistics版 - 菜鸟关于excel ,access 问题
发现很多analyst的职位,都要求expert in excel and access,说实话excel用的也就
是课堂上能接触到的,但是知道它功
能很多,而且有些公司貌似主要都是用它来管理data,可是怎么能变成expert呐,是不
是上网看些tutorial 啊?
还有就是access,从来美接触过,知道是database,这个自学容易吗?
还见过要excel certification的,有大虾知道这是啥东东吗?
c**d
发帖数: 104
2
Suppose you have a lot of excel files under H:\Temp
/* get excel names */
filename myxls 'dir "H:\Temp" /b' LRECL=5000;
data myfile;
infile myxls length = len;
input fname $200. len;
run;
/* save each into a macro variable */
proc sql;
select fname into :a1 - :a9999
/* do loop to input excel */
d******9
发帖数: 404
3
A job agent asked me to take Excel/Access test for a business data analyst
job, which uses a lot of Excel/Access: "Expert proficiency of Access and
Excel "
It is a test on computer, not multiple-choice style, 30 min for each.
请问,这些都考什么内容啊?哪位有经验的话,请展开说说。
v*********0
发帖数: 941
4
Now I have two Excel spreadsheets as below:
Spreadsheet1
Gene change padj
1 212 0.0006
2 99 0.09
3 15 0.7
4 59 0.456
5 418 0.00001
6 566 0
Spreadsheet2
Gene statistic FDR
1 28 0.0005
2 17 0.007
3 3 0.81
4 8 0.28
5 48 0.002
6 111 0
Using Excel, how can I create one new spreadsheet that only includes the
Genes with both padj and FDR are less than 0.05?
A... 阅读全帖
s******r
发帖数: 1524
5
来自主题: Statistics版 - 信用卡公司用Excel做些什么?
you can do lots with excel.
1. report with/without vba, you can create button and other fancy stuff to
draw attention.
2. Automate report by connecting to database, thought I think it is better
with access.
3. You can do some very simple model with excel. Simple but easy for
presentation.
4. You even can plug SAS add-on in excel. Though I thought it is terrible
idea.
问问题连个job description 都不放上来.
s*****n
发帖数: 839
6
来自主题: Statistics版 - 信用卡公司用Excel做些什么?
非常感谢,很有启发。
job description 很简单,没有太多信息。虽然说要SAS,但是他们的hiring manager
告诉我他们不怎么用SAS,主要用SPSS和Excel, 对于新手来说Excel更重要。:
for its Risk Analytics group. Candidate should be an expert in quantitative
analysis, econometrics, modeling & statistical analysis, and data analysis,
and must possess exceptional skills in Excel, SPSS/SAS and other software
analytical tools. Candidate should have a top-tier educational background
with strong quantitative skills.
z**********i
发帖数: 12276
7
来自主题: Statistics版 - excel一问
200多个EXCEL FILE,都是相同的格式.
我只想把其中几个数据提出来,合并到一个EXCEL或SAS DATASET中.
不知有什么巧妙的办法.
我想到的,比较笨,把这200多EXCEL都IMPORT到SAS中,然后,MERGE到一起,再设定条件,拿
到我想要的数据.
多谢!!
t********m
发帖数: 939
8
如果excel文件中有很多变量,比如说有几百个变量,有些变量对分析有用,有些变量
对分析没用,将该excel文件import进excel时,有没有什么办法只选择那些将要用到的
变量?还是说只能全部输入后,再用keep语句来实现?请大牛指点,谢谢!
t****e
发帖数: 23
9
来自主题: Statistics版 - 求帮助:excel数据转csv和sas的读取
收到excel格式的数据,需要先转成csv 再在SAS中import(无法直接读取excel数据)
。 如果打开excel用另存为csv的话,文本格式的id的leading zero就自动消失了。而
且id的长度不定,有数字也有字符。求问如何转换能保留leading zero,或者最后如何
修改sas数据。。。。
c**********e
发帖数: 2007
10
来自主题: Statistics版 - proc export to Excel: can not read it!
I use the following code to tranform a SAS dataset an Excel file on Unix.
libname myfolder '/abcd/efgh/ijkl';
proc export DBMS=XLS
data=myfolder.mydata
outfile="/abcd/efgh/ijkl/myfile.xls"
replace;
run;
quit;
But my Excel file can not be opened. Anybody knows how to solve it?
The error message:
"Excel found unreadable contents in 'myfile.xls'.
Do you want to recover the contents of this workbook?
If you trust the source of this workbook, click Yes."
s********a
发帖数: 154
11
我有一个sas dataset, variables 全是numeric type, 并且每个variable都有
format, 我现在要把这个dataset 输出到excel,期望输出的dataset在excel里,
variable 的format value 在左边,真实值在右边。 大家有啥快捷的方法么?貌似用
proc export 每次只输出真实值,user created format excel 不认识。
C***m
发帖数: 102
12
Job Title: Excel / VBA Consultant
Location: Boston, MA
Duration: 6+ Months
Basic Qualifications:
Our client is in need of a junior resource that has strong Excel / VBA
skills. The successful candidate will be responsible for developing the
group's automation tools and this role will grow and more responsibilities
will be given based on performance. This candidate should be committed and
be willing to work hard.
6 months to 1 year of experience
Excel/VBA skills - Schooling - or self-taught.
We ar... 阅读全帖
g**********l
发帖数: 214
13
来自主题: DataSciences版 - python/excel suggestion/replacement
请问一下大牛经验
我用excel and python 做了一个POC. excel to pass in parameters into python (
via xlwings) as the backend for computation (simulation).
now i just send the xls, pyc, and csv (underlying data) files to the
business users for POC.
现在要 implement, 给大概20人用。同时要求不大,最多5个人会同时用。
请问有什么折腾比较小的建议来implement.
(最简单的就是把这几个文件丢到network drive上, one copy only. 但同时用,
excel可能不太好用?)
所以想请教大家一下经验。(like maybe use ipython notebook as the user UI and
run a python webservice?)
thanks!
g******r
发帖数: 347
14
这里人多,问个技术问题,500个xml文件Incorporate into一个excel文件:
我有500个xml文件,我需要把这个500个文件按照他们的名字的顺序,加入一个excel文
件。不知道怎么处理,谢谢大家
w****a
发帖数: 1623
15
来自主题: Military版 - 借人气问个excel的问题
我整天写Excel VBA算点小东西,工资很低。求高薪Excel VBA工作。
q*******n
发帖数: 360
16
实在没法子了,这里人多,上来求救excel高手,包子酬谢,我尽量说得详细点,别嫌
啰嗦,实在不行就站内说话。
(1),建立了两个表格Sheet1和Sheet2,
(2),在Sheet1中需要手工输入了两个数据(例如一个在A2,另一个在E2输入的)
(3),然后要求在Sheet1中E2输入的数据自动传到Sheet2中D5的位置(位置要求是:
Sheet2中的A5等于Sheet1中的A2)
(4),我在Sheet2中D5上使用的命令是D5=VLOOKUP(A5,Sheet1!$A$2:$F$10,5,0),这
样,Sheet1中的E2就显示在Sheet2中的D5位置。
问题是:如果在Sheet1中换另外一组A2和E2,Sheet2中D5的位置就没有数值了,如何才
能把上一步D5中显示的数值保持住?
不知道我说明白了没有?我不知道怎么能上传excel文件。急等!先谢谢了。
w********e
发帖数: 8594
17
这事儿最好写个程序整吧。统计软件弄这事最方便。估计一条merge命令就搞定。excel
也能实现,但大家听你这样解释很吃力,跟你解释也吃力。在excel里用vba写个小宏也
成。
S***E
发帖数: 1977
18
我也被这个问题困扰
有个部分作用的解决方法
开一个全新的Excel文件
在粘贴任何内容前
把所需要设置为数字而不是日期的column的格式设置为“number”或者“text”
然后把原有excel内容粘贴过去,注意粘贴的时候选择values格式
或许可解。
有时候也不work。
n*******r
发帖数: 2010
19
来自主题: Military版 - 问大家一个EXCEL 问题, 先谢
真替你急。
你的问题和你有没有chart有关吗? 和你有几十个tab有关吗?
你的问题就是excel spreadsheet greyed out, 你不能用这四个关键字google吗?

:有一个TAB, 上面有个CHART, 我可以改这个CHART 的DATASOURCE。 但是这个CHART
以外的EXCEL CELL, 就是整个这个TAB 的BACKGROUND, 不能让我选择或做任何改动,
: 好像GREYOUT 的样子。 我看了, 好像也不是用PASSWORD PROTECT 的。 那
怎么就开这 PROTECT?
m******8
发帖数: 1676
20
来自主题: Military版 - 问大家一个EXCEL 问题, 先谢
这个WORKBOOK 是公司的, 都不知道原先作者是谁。
现在我要用现有的格式, 用新的DATASOURCE, 画图。最后存成PPT 或PDF。
所以我想在EXCEL 时就加上COMMENT, 不要等到后面PPT 或 PDF。
但是这个EXCEL 的CHART 没问题, 只是背景不能EDIT 加东西。
S*******i
发帖数: 2018
21
来自主题: USANews版 - Trump’s Excellent Judges
https://www.wsj.com/articles/trumps-excellent-judges-1506889547
The start of a new Supreme Court term is a good moment to note some under-
reported news: President Trump is rapidly remaking the federal appellate and
district courts, with highly qualified nominees who fulfill his campaign
promise to pick “constitutional conservatives.”
The White House announced its eighth batch of judicial nominees on Thursday,
including four excellent choices for the Fifth Circuit Court of Appeals.
They include ... 阅读全帖
l*y
发帖数: 565
22
【 以下文字转载自 NewYork 讨论区 】
发信人: bostonkkk (bostonkkk), 信区: NewYork
标 题: 卖车: 2009 Honda Accord LX Excellent Condition
发信站: BBS 未名空间站 (Tue Mar 29 22:15:42 2011, 美东)
2009 Honda Accord LX, 2.4L 4-cyl. engine, Automatic transmission, Silver
Color, Excellent condition, 51k miles. located in north New Jersey.
Asking for $15,995
If interested, please call 410-800-3168, or send message on this web.
Thanks
r*******f
发帖数: 24
23
First owner. Excellent condition, well maintained. Garage parked. Mileage:
around 18,500 miles. Exterior Color: Dover White Pearl. Interior: Black
Cloth. 2.4L SOHC MPI MIVEC. SPORTRONIC 4-SPD AUTO O/D TRANS. MPG: City –
23, Highway – 30. twelve months Warranty left.
KBB value: $11,000 on excellent condition. Asking $10,500 only.
Pictures and more detailed specification could be provided if interested.
Thanks!
Owner Contact: r******[email protected]
(the car is located in Manhattan, NYC)
q**j
发帖数: 10612
24
【 以下文字转载自 SanFrancisco 讨论区 】
发信人: sailors (Learning Machine), 信区: SanFrancisco
标 题: 2001 Toyota Camry LE in Excellent Condition for sale
发信站: BBS 未名空间站 (Sat Dec 14 14:58:15 2013, 美东)
http://sfbay.craigslist.org/sby/cto/4243943780.html
Bought in 2007 from a private party, when the odometer was 54000. It has
been running excellent ever since then. I am the second owner of this car.
Regularly maintained (front brake pads changed earlier this year, engine oil
changed regularly every 3 months or 300... 阅读全帖
p*********4
发帖数: 3
25
本人第一次发帖,不知在此地贴广告是否可行。
2008 Honda Accord Lx 43700 mile, excellent condition. First owner.
Very clean, no serious scratches.
Brand new tires.
KBB.COM recommend price for excellent condition $12,700
Now ask for 12,300 O.B.O
Here is the past of link of craigslist.org
https://post.craigslist.org/u/_uegehuK4xGX0nU7sjVu7A/j2mcq
The above link contains free carfax.com report. You can have a look the very
cleaned car history with free.
Please text me @ 248-238-0573 or email to n*******[email protected] for m... 阅读全帖
t**r
发帖数: 3428
26
【 以下文字转载自 Money 讨论区 】
发信人: taar (taar), 信区: Money
标 题: 信用760多分,credit karma说是刚过excellent线
发信站: BBS 未名空间站 (Sat Oct 31 01:16:06 2015, 美东)
信用760多分,credit karma说是刚过excellent线
买车贷款,然后1-2年还清据说可以幫助提高信用分数?這個说法可靠么?
謝謝
k*********s
发帖数: 4474
27
【 以下文字转载自 Carolinas 讨论区 】
发信人: mlnx8 (小龙), 信区: Carolinas
标 题: 卖车 2014 Honda Accord LX, excellent condition, 只有6000 mile
关键字: 2014 Honda Accord,卖车 北卡
发信站: BBS 未名空间站 (Thu Nov 12 22:03:10 2015, 美东)
因为近期回国,想为爱车找下一任主人。
2014年所购新车,很漂亮的白色。 2014 Honda Accord LX,无事故,无刮痕,
excellent condition. 最重要的是只有6000 mile, 您买了之后,不用担心这车贬值。
KBB价$18,000. 买一年新的车比直接买新车划算,因为可以省下好几千块钱。
我住在Durham,在RTP工作。
如果您有兴趣,请联系[email protected]
/* */看车的照片
r*******g
发帖数: 1335
28
来自主题: Automobile版 - 求lease新车计算月供的excel
考古发现原来这个东西有excel,不知道哪位大侠还保存的有这个excel。
小弟谢过了。
t******8
发帖数: 418
29
One Palatino 48" Upright Piano for Sale
Very beautiful high gloss black finish 4 years old Palatino PUP123T upright
piano
• Original owner. Piano never moved.
• Mint condition; no dent, no scratch; extremely well maintained.
• Voiced and tuned twice first year then yearly afterwards by
certified technician. Last tuned in July 2011.
• Includes original adjustable leather bench (excellent condition)
with storage compartment and cloth cover.
• Excellent piano for begin... 阅读全帖
h******n
发帖数: 50
30
2004 Ford Explorer Limited 4x4 --loaded, excellent condition, low mile
76,800 miles
Excellent Condition
Black Exterior
Leather Interior
Vehicle Highlights
Max Seating: 7
Doors: 4 Engine: V8, 4.6 Liter
Drivetrain: 4WD Transmission: Automatic
EPA Class: Sport Utility
Vehicles Body Style: Sport Utility
Country of Origin: United States
Country of Assembly: United States
Used 2004 Ford Explorer
Pricing Report: 11,449
Style: Limited Sport Utility 4D
Mileage: 76,800
Your Configured Options
Our pre-sele... 阅读全帖
N****g
发帖数: 5246
31
很奇怪,不知道拍错了哪个键,
在excel里面按左右箭头,那个表示选定某格子的粗黑框框不肯听话挪动了,
而是固定呆在某个格子里面,现在按左右箭头,只是下方滑动条来回移动
我按错啥了 @@?
印象中版上有excel高手。。。包子求教
N****g
发帖数: 5246
32
got thanks
haha, davidhero太牛了,以后你就是俺滴偶像乐~

很奇怪,不知道拍错了哪个键,
在excel里面按左右箭头,那个表示选定某格子的粗黑框框不肯听话挪动了,
而是固定呆在某个格子里面,现在按左右箭头,只是下方滑动条来回移动
我按错啥了 @@?
印象中版上有excel高手。。。包子求教
N****g
发帖数: 5246
33
那俺以后碰到excel问题直接捧着包子pm你去好了,hiahia

haha
我还是开一个excel问题专答俱乐部版好了,天天吃三黄包
谢谢bz;)
b**j
发帖数: 20742
34
来自主题: ebiz版 - 问个excel问题
库存用excel管理。
简单一下说,有这些column,
item description, cost, sales_after_fees, sold_or_not
怎么写个excel公式看看已经卖掉的里面(sold_or_not = 'sold')多少个是亏钱的?
s*********e
发帖数: 2076
35
【 以下文字转载自 WaterWorld 讨论区 】
发信人: smalldimple (郁闷的农民), 信区: WaterWorld
标 题: 包子求助~~~关于设计一个EXCEL 表格
发信站: BBS 未名空间站 (Mon Jan 21 11:46:58 2013, 美东)
设计一个EXCEL 表格,可以体现AGENT的Commission。
一个Agent可能推荐好几个客户, 给agent的commission 为,5个以下 10%, 超过5个
15%。
如果第二年,第三年客户还继续合作,则付给AGENT 客户年费的5%。
这样的 表格应该怎么做啊? 包子感谢啊
d******s
发帖数: 228
36
【 以下文字转载自 SanFrancisco 讨论区 】
发信人: daysdays (dayday), 信区: SanFrancisco
标 题: 怎样让 Excel 格线消失和显示?
发信站: BBS 未名空间站 (Tue Nov 23 20:52:12 2010, 美东)
excel cell灰色的格子线,怎样让它消失, 和显示?
s*******g
发帖数: 37
37
来自主题: FleaMarket版 - 2008 Toyota Camry LE in excellent condition
It has 34k miles on it. This LE has a fuel efficient yet powerful 2.4 L, 4
cylinder engine.
Features:
ABS (4-Wheel)
Air Conditioning
Power Windows
Power Door Locks
Cruise Control
Power Steering
Power start engine
Tilt Wheel
AM/FM Stereo
CD player
Power Driver Seat
Price: $12,750 or Best Offer, priced to sell!
(KBB: Good Condition - $15,490 and Excellent Condition - $16,490)
If interested contact Susan (857) 988-8092 or send me an email at
x****************[email protected]
• Location: New... 阅读全帖
t******8
发帖数: 418
38
One Palatino 48" Upright Piano for Sale
Very beautiful high gloss black finish 4 years old Palatino PUP123T upright
piano
• Original owner. Piano never moved.
• Mint condition; no dent, no scratch; extremely well maintained.
• Voiced and tuned twice first year then yearly afterwards by
certified technician. Last tuned in July 2011.
• Includes original adjustable leather bench (excellent condition)
with storage compartment and cloth cover.
• Excellent piano for begin... 阅读全帖
s*******g
发帖数: 260
39
【 以下文字转载自 PDA 讨论区 】
发信人: simenking (simenking), 信区: PDA
标 题: [For sale] Excellent Iphone 4 32GB AT&T $295 net to me (
发信站: BBS 未名空间站 (Thu Nov 17 12:35:55 2011, 美东)
发信人: simenking (simenking), 信区: Apple
标 题: [For sale] Excellent Iphone 4 32GB AT&T $320 net to me
发信站: BBS 未名空间站 (Thu Nov 17 12:35:32 2011, 美东)
状况很好,带charger和保护套。 OS 5.0
5.0的暂时还不能用在TMOBILE上,但是可以用在att的prepaid上
站内联系。谢谢
b**********i
发帖数: 1482
40
二手交易风险自负!请自行验证是否合法和一手卡!:
我想卖的物品:
iTunes $10 x702 code in excel with s**[email protected]
单张面值:
10
可接受价格(必须明码标价!):
code in excel 0.91
物品新旧要求:
邮寄方式要求:
300dpi灰度扫描,字符清晰
买卖双方谁承担邮寄损失(Required if not code only):
付款方式说明:
BOA/Chase
其他补充说明:
广告的有效期:
物品来源(Required for All Cards!):
bb
我的联系方式:
Warranty期限:
能否证明是合法的一手卡?(Required for All Cards!):
state and zip:
j******k
发帖数: 15
41
IPHONE 7 Plus Rose Gold (Unlocked) - Excellent Condition - 32G
IPHONE 7 Plus Rose Gold - Excellent Condition
Unlocked
10/10 condition
No Scratch on both front and back
with Full payment already, will show you receipt & serial number
32G
Case AS a Gift
with full accessories.
will transact inside bank, cash only, verify Cell phone online and receipt.
verify cash also.
Email: desperado.sp ( at )gmail.com
s*******s
发帖数: 28
42
【 以下文字转载自 NewYork 讨论区 】
发信人: shoppings (Shopping), 信区: NewYork
标 题: Sublet: $60/day - Jan 1st-24th Excellent 1 BR in Financial Dist.
发信站: BBS 未名空间站 (Tue Dec 11 16:50:57 2007)
I am subletting One BR room in an excellent doorman building from Jan
1st to Jan 24th.
About the building
Zero minutes to 4/5 train wall st subway station, 1 minute to R/W/1
Rector St station and J/M/Z Broad St station, 3 minutes to 2/3 train
Wall St. station, 5 minutes to E train and WTC, Battery Park and South
Ferry. Go
w****f
发帖数: 684
43
来自主题: JobHunting版 - Does anyone use Excel for data analysis?
朋友帮忙推荐了一个 “Business Intelligence Analyst” job description listed
: data mining, SQL。。。
But also “ Excel wizardry is a requirement”。
Does anyone know how to use Excel for data analysis? Any quick learning
material?
Thanks in advance!
w****f
发帖数: 684
44
来自主题: JobHunting版 - Does anyone use Excel for data analysis?
Do you have any (quick) learning materials on Excel? I never used Excel
for any purpose...
g*******e
发帖数: 156
45
请问如下的日期格式在excel里面是要怎样才能排序啊?
我试了excel的sorting功能,排完了貌似日期从远至近排好了,可是年号还是乱糟糟的
谢了
12/07/2011
08/31/2012
10/22/2012
10/31/2012
12/31/2012
07/01/2012
12/19/2012
12/31/2010
08/22/2011
09/24/2011
10/21/2011
11/22/2011
12/21/2011
12/21/2011
12/22/2011
01/17/2012
01/17/2012
01/21/2012
02/21/2012
02/22/2012
03/20/2012
03/21/2012
03/22/2012
04/21/2012
04/22/2012
B***S
发帖数: 73
46
Qualifications
. Bachelor's degree in computer science
. 1-2 years' experience working with systems.
. Excellent analytical and computer skills (must be proficient
in Excel
and SQL, Visual Studio experience preferred)
. Strong communication and problem solving skills
. Organized with a willingness to learn and be challenged
. Strong attention to detail
x*****i
发帖数: 4035
47
just found a Home Maintenance Schedule template in MS excel. could come in
handy for new homeowners. download from Excel 2007 templates - schedules
content:

Quarterly Date last completed
Plumbing
Faucets and shower heads Check interior and exterior faucets for leaks.
Clean aerators. Replace washers if necessary.
Drains Clean with baking soda. Pour water down unused drains.
Pipes Inspect visibl
c****e
发帖数: 61
48
谁又精算子的 mortgage loan calculator excel file,可以下载。
就是下边连接体提到的excel 文件,谢谢
http://www.mitbbs.com/article_t/ECUST/31189559.html
f**********n
发帖数: 3081
49
来自主题: Money版 - excel账本模板
excel is good enough to a lot of excel daily users.
s*****n
发帖数: 471
50
这有excel高手妈妈吗?会设计macro的?现在工作中遇到要用excel 做出大量图表,并
且转到word形成文档。手动完成几乎不可能,只有靠macro,但我又完全不懂macro。
bbs账户里一共只有31。4全部用来请求帮忙。谢谢~
首页 上页 1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)