How to sum data from different Excel sheets?

It is referred to as to consolidate data from multiple sheets into a master sheet.

1. Drag your mouse to select the cells corresponding to those in multiple sheets. Note: It would not work if you click the top-left corner box.
2. Date | Consolidate.
3. Click the icon under 'Reference'.
4. Go to the first data sheet, and drag-select all the cells. Click the icon again. Click 'Add'.
5. Go to the second data sheet, and repeat Step 4. Repeat until all the data sheets are done.
6. Click OK.

Done.

In addition to 'Addition', you can also do average, counting, max, min, product, etc.

Chrome - In Outlook Web App, can not attach files when composing a new email

There are two solutions -

1. Checking 'Use the light version of Outlook Web App' when signing in. Will be able to attach files.

2.

http://www.c7solutions.com/2014/09/group-policy-import-to-fix-google-chrome-v37-issues-with-exchange-server-and-microsoft-crm

A recent update to Google Chrome (37.0.2062.120) removed the ability to support modal dialog boxes. This are dialogs that require your attention and stop you going back to the previous page until you have completed the info required – these are very useful in workflow type scenarios.
Google claim that as 0.004% of web sites use them (from Google anonymous statistics gathering that you can opt into in Chrome) they are justified in removing support for them – but they have not removed other things that have the same level of support!
With this version of Chrome (or the Chromium open source browser) there is a work around until April 30th 2015 that will allow modal dialogs to work again. Without this work around clicking links in OWA and ECP in Exchange 2010 and OWA and EAC in Exchange Online and Exchange 2013 will not popup. This can cause issues such as the inability to attach files in OWA and to create objects in ECP/EAC for the administrator. Popups in Microsoft CRM also do not work.
As a work around you could use a different browser, but if Chrome works for you (or does not in this case) and you are joined to a domain then you can download the following GPO export file and import it into your Active Directory to enable modal dialogs to work again in Exchange Server, Office 365 and Microsoft CRM products.
To download and import this GPO file to enable Chrome modal dialog box functionality to resume (until 30th April 2015, when Google stop allowing the work around) follow these steps:

1. Download Google Chrome Show Modal Dialog Before 30 April 2015.zip
2. Copy to a domain controller and expand the zip file. Ensure the contents of the zip file are not placed directly on your desktop as you cannot import from the desktop directly, so if you expand the zip to the desktop then copy the one folder that was created into a new subfolder.
3. Start Group Policy Management MMC admin tool.
4. Expand Forest > Domain > Your Domain > Group Policy Objects.
5. Right click “Group Policy Objects” and choose New
6. Create a new GPO called “Chrome and Chromium Modal Dialog Box Allow”:
   
7. Right click “Chrome and Chromium Modal Dialog Box Allow” GPO that you just made and choose Import Settings
8. Proceed through the import wizard. You do not need to backup this new GPO on the second page of the dialog as the new GPO is empty.
9. On the third page of the wizard browse to the parent folder containing the contents of the download above:
   
10. Click Next and you should see one backed up GPO listed:
    
11. Click Next to import this. If you click View Settings first a web page will open showing you that this GPO sets two registry keys for the computer and two registry keys for the user. These set SOFTWARE\Policies\Chromium\EnableDeprecatedWebPlatformFeatures and Software\Policies\Google\Chrome\EnableDeprecatedWebPlatformFeatures (for both Chromium and Chrome browsers) with a reg key (type string) 1:ShowModalDialog_EffectiveUntil20150430
12. Proceed with Next and then Finish and the import will begin:
    
13. Click OK.
14. Now link the GPO object to the root of your domain so it impacts all users and to the root of any OU that blocks inheritance. Import to other domains as above or link from this domain depending upon your current policy for managing GPO cross domains.
15. Delete the zip and folder you downloaded. They are not needed any more.

How to copy Chinese and English texts from a photo PDF file?

Adobe Acrobat
Tools | Text Recognition | In this file | Edit | Priamary OCR Language,

Choose Chinese, then English will also be OK.