Tuesday, May 10, 2016

RSS in Excel

Using Central Bank of Myanmar Exchange Rate RSS in Excel
1. Click Developer Tab
(If you cannot see, Click File-->Options-->Customize Ribbon-->Check Devloper-->OK)
2. Click Source in XML (See picture)
3. Click XML Maps...
4. Click Add
5. Paste the following web address in the file name box
http://forex.cbm.gov.mm/index.php/fxfeed/rss
6. OK the XML Schema warning that is shown, then click OK again.
7. Drug item and drop in selected cell
8. Refresh data


Tuesday, May 3, 2016

Advanced Excel: Formulas

Advanced Excel: Formulas

1-How to avoid broken formulas
https://support.office.com/en-us/article/How-to-avoid-broken-formulas-8309381D-33E8-42F6-B889-84EF6DF1D586

2-Find and fix a circular reference
https://support.office.com/en-us/article/Find-and-fix-a-circular-reference-C17488E3-3CBE-4FA8-A6BC-1A6FFA64DB78

3-Use error checking to detect errors in formulas
https://support.office.com/en-us/article/Use-error-checking-to-detect-errors-in-formulas-4D4C160B-8D9A-45F1-BEC7-75F4B90045F8

4-Define and use names in formulas
https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4D0F13AC-53B7-422E-AFD2-ABD7FF379C64

5-Create a formula by using a function
https://support.office.com/en-us/article/Create-a-formula-by-using-a-function-C895BC66-CA52-4FCB-8293-3047556CC09D

6-Use a formula to apply conditional formatting
https://support.office.com/en-us/article/Use-a-formula-to-apply-conditional-formatting-FED60DFA-1D3F-4E13-9ECB-F1951FF89D7F

7-Guidelines and examples of array formulas
https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-in-Excel-2016-for-Windows-bc6b94c5-f1e2-40fd-8513-cc8c452d4d89

8-Switch between relative, absolute, and mixed references
https://support.office.com/en-us/article/Switch-between-relative-absolute-and-mixed-references-DFEC08CD-AE65-4F56-839E-5F0D8D0BACA9

9-Hide and protect formulas
https://support.office.com/en-us/article/Hide-and-protect-formulas-in-Excel-2016-for-Windows-d1d84d4f-f817-4bbe-8ca9-45810269c2eb

10-Create or delete a macro
https://support.office.com/en-us/article/Create-or-delete-a-macro-F3EB0FA3-4C18-498A-9235-C66BA8E78149

Excel: Save and share files

Excel: Save and share files

1-Save a workbook in another file format
https://support.office.com/en-us/article/Save-a-workbook-in-another-file-format-6A16C862-4A36-48F9-A300-C2CA0065286E

2-Save an Excel workbook for compatibility with earlier versions of Excel
https://support.office.com/en-us/article/Save-an-Excel-2016-workbook-for-compatibility-with-earlier-versions-of-Excel-169a0336-965b-4430-8554-4e7b5db79947

3-Work together on Office documents in OneDrive
https://support.office.com/en-us/article/Work-together-on-Office-documents-in-OneDrive-EA3807BC-2B73-406F-A8C9-A493DE18258B

4-Save as PDF
https://support.office.com/en-us/article/Save-as-PDF-D85416C5-7D77-4FD6-A216-6F4BF7C7C110

5-Use a shared workbook to collaborate
https://support.office.com/en-us/article/Use-a-shared-workbook-to-collaborate-in-Excel-2016-for-Windows-49ec5cb7-0f7e-4781-be66-14ae173a7a29

6-Why do I get an "Unprotected Formula" message?
https://support.office.com/en-us/article/Why-do-I-get-an-Unprotected-Formula-message-1b6932e2-159e-47ee-97a0-2eb612d7eaf1

7-Password protect a workbook
https://support.office.com/en-us/article/Password-protect-a-workbook-7E365A4D-3E89-4616-84CA-1931257C1517

8-Protect a worksheet with or without a password
https://support.office.com/en-us/article/Protect-a-worksheet-with-or-without-a-password-in-Excel-2016-01e05aab-64a9-4e9d-8b94-c3f79bc6ac7f

9-Add or remove protection in your document, worksheet, or presentation
https://support.office.com/en-us/article/Remove-a-password-from-a-worksheet-or-workbook-in-Excel-2016-for-Windows-3e80ad20-adbb-4f9a-9426-297d02c96963

10-Remove a password from a worksheet or workbook
https://support.office.com/en-us/article/Remove-a-password-from-a-worksheet-or-workbook-in-Excel-2016-for-Windows-3e80ad20-adbb-4f9a-9426-297d02c96963

11-Lock cells to protect them
https://support.office.com/en-us/article/Lock-cells-to-protect-them-in-Excel-2016-for-Windows-cb7835f6-9c37-4161-bb53-d1c410acaf21

Excel: Worksheet basics

Excel: Worksheet basics

1-Create a drop-down list
https://support.office.com/en-us/article/Create-a-drop-down-list-in-Excel-2016-for-Windows-f63c0712-8d46-4afc-92d7-afd67cad0b1d

2-Find or replace text and numbers on a worksheet
https://support.office.com/en-us/article/Find-or-replace-text-and-numbers-on-a-worksheet-in-Excel-2016-for-Windows-487f1af9-057e-4077-8da9-454c04391f1b

3-Split text into different cells
https://support.office.com/en-us/article/Split-text-into-different-cells-30B14928-5550-41F5-97CA-7A3E9C363ED7

4-Combine text from two or more cells into one cell
https://support.office.com/en-us/article/Combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6

5-Merge cells
https://support.office.com/en-us/article/Merge-cells-C564AE6C-3D9E-4512-8D24-1AD3B21F089A

6-Fix text-formatted numbers by applying a number format
https://support.office.com/en-us/article/Fix-text-formatted-numbers-by-applying-a-number-format-in-Excel-2016-for-Windows-9edbc6c8-b3d8-4b4f-8867-eb3359a9f77e

7-Wrap text in a cell
https://support.office.com/en-us/article/Wrap-text-in-a-cell-2A18CFF5-CCC1-4BCE-95E4-F0D4F3FF4E84

8-Freeze rows and columns
https://support.office.com/en-us/article/Freeze-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f

9-Transpose (rotate) data from rows to columns or vice versa
https://support.office.com/en-us/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419F2E3-BEAB-4318-AAE5-D0F862209744

10-Create an Excel table in a worksheet
https://support.office.com/en-us/article/Create-an-Excel-table-in-a-worksheet-e81aa349-b006-4f8a-9806-5af9df0ac664

Excel: Getting started

Excel: Getting started

1-Basic tasks in Excel
https://support.office.com/en-us/article/Basic-tasks-in-Excel-2016-for-Windows-dc775dd1-fa52-430f-9c3c-d998d1735fca

2-Find or replace text and numbers on a worksheet
https://support.office.com/en-us/article/Find-or-replace-text-and-numbers-on-a-worksheet-in-Excel-2016-for-Windows-487f1af9-057e-4077-8da9-454c04391f1b

3-Change the column width and row height
https://support.office.com/en-us/article/Change-the-column-width-and-row-height-486cd65a-cb26-478a-a937-20e12003e8ec

4-Format numbers as currency
https://support.office.com/en-us/article/Format-numbers-as-currency-in-Excel-2016-9621748b-61df-4e3c-8051-86013de6a21a

5-Video: Use Flash Fill
https://support.office.com/en-us/article/Flash-Fill-3fb96b4a-ee83-4493-af45-6522324477bd

6-Video: Use AutoFill
https://support.office.com/en-us/article/Video-AutoFill-9BAD52FB-410D-470E-B17F-618C605E165B

7-Create a simple formula
https://support.office.com/en-us/article/Create-a-simple-formula-11A5F0E5-38A3-4115-85BC-F4A465F64A8A

8-Keyboard shortcuts in Excel
https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Windows-e56d0e8f-a566-4094-8604-5190ae802612