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

Download Example:https://www.dropbox.com/s/2k6omav04iw4oxx/CBM_ExchangeRate.xlsx?dl=0

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