Posts

Showing posts from November, 2015

合并工作薄、合并工作表---excel外接程序插件:多薄多表合并 mergebooks_setup.exe

下载地址:http://yunpan.cn/cmPGYNFu5HkH7  访问密码 1ba7
update: there is a backup at ///box///

多薄多表合并——excel 外接程序插件
使  用  说  明

一、功能:
1、多薄合并:将当前文件夹(默认)或某一文件夹下所有工作薄合并到一个自动新建的“汇总表”工作薄中。可以选择“合并所有工作表、按位置选择的工作表、按名称选择的工作表”,还可选择“保留重复行(默认)”、“去除重复行”。

在启动excel后(未保存)的新工作薄中点击该按钮则打开“文件夹选择”对话框。

2、多表合并:将当前工作薄中的工作表合并到一个自动生成且位于最后的“汇总表”工作表中。可以选择“合并所有工作表、选择的工作表”,还可选择“保留重复行(默认)”、“去除重复行”。

3、清除数据:清除当前工作表或当前工作薄中所有工作表数据。 默认“取消”按钮(即按Enter后)仅清除当前工作表中的数据。

4、分类汇总:将所选区域第一列相同的行的其后各列数据进行汇总(求和),并将汇总结果放置到所选择的目标区域。分类汇总结果为第一列不再有重复行,即第一列“去除重复行”,其后各列数据求和。

5、拆分表格:

⑴拆分工作薄:把当前文件夹(默认)或某一文件夹下的所有工作薄(或选择的多个工作薄)中(标签)名称相同的工作表合并到一个工作薄中,重复使用,又可合回来。可以把一个工作薄拆分成多个工作薄;也可以把多个工作薄合成一个工作薄。

⑵拆分工作表:将所选单元格以下的不同文本数据拆分到不同的工作表中。

6、选择查询:在所选区域第一列中查找,并将查找结果(符合查询条件的许多行)放置到所选择的目标区域。

7、多薄汇总——求和(默认)、全部求和、平均、计数:将某一文件夹或当前文件夹下的所有工作薄中的当前工作表的数据按照所选择的单元格区域汇总(求和、平均、计数)到一个自动新建的“汇总表”工作薄中。工作表与工作表一一对应,单元格与单元格一一对应汇总(求和、全部求和、平均、计数)数据。。

8、多表汇总——求和(默认)、全部求和、平均、计数:将某一工作薄中所有工作表数据,按照所选择的单元格区域进行汇总(求和、平均、计数)。

9、插入空行:在当前单元格下隔行插入空行。

10:删除空行:删除当前单元格以下的所有空行或0值行。

11、插入表头:在所选择的表头区域下方,隔行插入表头(…

Russian warplane, Turkey missile, Syria territory, ISIS and petrol business

Image
1
When reading international news with my phone, I am VERY astonished to read this news that Turkey government military shot down one of the 2 Russian warplanes SU-35, these 2 Russian warplanes were on the way to air base after they carried out a task aimed at ISIS.
I guess most people will also be astonished, turkey must be crazy!

The Russian warplane was shot down in Syria territory where was controlled by anti-Syrian and pro-Turkish Turkmenistan armed militants.
Both the two pilot parachuted from the destroyed warplane, but were supposed to be shot by pro-Turkish militants.

2
Turkey president Erdoğan said it is needed because the Russian warplanes were violating Turkish airspace as as 17 secs.
Then, Turkey gov summoned the 5 permanent member state (of UN Security Council): USA, China, UK, France and RUSSIA.

3
Russia president Putin said this is "stab in back".
The USA said USA is not involved in this incident.
The Europe, UK and France called both sides to be calm down.

step-by-step: How to open Excel 2010 files in separate windows in Windows 7

By default, Excel files are opened in a same window in Windows 7. But sometimes you might want to view some files at the same time on your screen. To do this, you can start a new Excel process (excel.exe) by clicking the Excel button from the Start menu.

However, you can configure your computer to always open Excel files in separate windows. We recommend that you only use the method in this article when your computer has sufficient RAM.To have us configure your computer to open Excel files in different windows for you, go to the "Here's an easy fix" section. If you prefer to configure your computer to open Excel files in different windows yourself, go to the "Let me fix it myself" section.

Here's an easy fix

To fix this problem automatically, click the Download button. In the File Download dialog box, click Run or Open, and then follow the steps in the easy fix wizard.
Because the change involves modifying registry keys, the easy fix solution will create a r…

good computer softwares

眼睛护士
经常使用计算机的您是不是有眼睛干燥,疲劳不适的情况呢? 眼睛护士(eyefoo.com)是一个可以定时提醒休息,保护眼睛的护眼软件、健康软件。//////下载见box

ccclear 电脑清理工具

KMPlayer

office-skills

Image
excel身份证提取出生年月日 将函数=MID(B2,7,8)输入如图所在位置,回车或是点击任一单元格,即自动提取出出生日期。B2为身份证号的坐标,7为从第7位数字提了起,8为提取8个连续数字。如只想提取出年月,可以输入=MID(B2,7,6)

excel 身份证 年龄


身份证 excel 提取性别

win7 excel 多窗口独立显示//////不相互覆盖---EN
下载这个小工具MicrosoftEasyFix**** //////box-软件安装

合并多个excel---多薄多表合并 search in this blog

excel 页眉页脚 一共几页第几页 设置
“页面布局”—>“打印标题”—“页眉/页脚”---自定义页眉等等




bubblews.com was shut down

Today when I want to login my bubblews account, it shows:
Greetings,

After being up and running for almost 3 years now we regrettably need to inform you that we will be shutting Bubblews.com down. The climate for display advertising has drastically changed and made it impossible for us to sustain the business model and operations.

We want to thank everyone that was a part of this journey. We wish you all the very best.

–Bubblews

I have earned some extra dollars by writing articles at bubblews years ago, and there are many people said bubblew com could not last long at that time, now it becomes true.

whatever, to bubblews com.



Here is one short analysis I wrote befor bubblews' going down about why bubblews.com will be shut down:
The reasons why Bubblews will be shut down in the coming future:
I always insist that there will be one day Bubblews should and will shut down, sooner or later. Here is why:
1, Because Bubblews shares too high revenue with the users that actually Bubblews itself…

The 6 kinds of people who don't replace a new cell phone after using their phones more than 3 years

Image
recently, I read one interesting Chinese article online, I really want to share this to most people, so translate it from Chinese to English.

the question is that who will do not replace a new cell phone after using his phone 3 years.
1 the ones who use nokia phones. nokia phone is the "best" phone of the world.
2 the ones who use iphone4 or iphone4s. Steve Jobs will be very proud of iphone4/4s.
3 the ones who only use cell phone to send messages and give calls. these phones are are designed simple, "if you dont use it, it is just something like a brick".
4 the ones who only love the brand. different people have different preferences when they are choosing their phones, some only use apple iPhone, some only use Samsung, some only use blackberry... if you ask them why, the answer will be that "there are no reasons, we are just fans"
5 the dawdlers. the dawdlers are so lazy that they dont even want to buy a new cell phone on the web store.
6 the poor people who ar…

社会阶层 社会资源

给你提供个全新的角度。
社会层级用信息的获取能力和占有量来衡量:
最底层:没电脑没电视没报纸,信息由每晚村口聊天得来。信息具有极大的局限性。
底层:有电视有报纸,被动接受信息。
中下层:会使用电脑等设备获得信息,但大部分信息没有实际意义。
中层:有一定的信息渠道,有一定信息转化为产出的能力。
中上层:信息渠道较稳定高效,以获取的信息数量和质量来决定行动,信息基本就是生产力。
上层:信息资源的创造者和分配者。

看了这个分法,你就明白为什么芙蓉姐姐之流拼了命也要出名的原因了,也能明白最红的明星总是传言不断的了。
———————————————————————
在学术界有种观念与大家分享:世界上的万事万物都可以归结为信息的集合。从这个角度来看,一切实物和虚拟的社会资源均可称之为信息资源。这种观点常见于科幻小说和电影(ps:别以为写科幻小说的作家都是白痴,其中有很多大牛)。
所以说,以资源占有量划分阶层的方法,也可归结到以信息占有量划分阶层方法里面。
via http://www.zhihu.com/question/21183775/answer/17500905

把信息资源转换为生产力

Which country is the most powerful in Europe---United-Kingdom, France or Germany?

A British, a German and a French are talking about this, here is what they say:

German(cautious): if i say it is Germany, you will not launch sanctions against Germany.
French(irony): hmm, whatever, it is not British.
British(anti-irony): what is the question? Actually mentioned France?!

German(serious): ok, if not allow me to say Germany, that should me British.
French(helpless): fr-de friendship is over!!!
British(satisfied): this question is over.

Muji

When I went to the MUJI store at the first time in a city where there is no home, I found that I have deeply loved the MUJI products. And I told me that I will buy the MUJI stuff as possible as I can.

What is MUJI? MUJI, whose full name is "Mujirushi Ryohin", is one Japanese groceries-retail company which mainly sells a wide variety of household and consumer goods. In Japanese, "Mujirushi Ryohin" means the quality product without label. MUJI products are paid attention to be simple, environmentally friendly and natural.

The characteristics of MUJI goods:
Backing to nature:good design, quality raw material, nice craftwork. That is quality product.
Be simple: Muji product is the product what the product itself should be, be simple is one important character of Muji goods, be simple and there are no labels as little as possible.
Be concentrate on every detail. rational analysis,simple product tone, full of design sense and full consideration on every detail.

In short, Muji…