Microsoft Excel online tutorial course
Welcome to Excel-World, a free Microsoft Excel course written in plain English. Whether you are opening Excel for the first time or you already use it every day at work, these step-by-step guides will help you work faster and make fewer mistakes.
The tutorials follow a simple path. Start with worksheets and workbooks to learn how files are organised, then move on to entering and managing data and formatting so your sheets are easy to read. Next, learn to group rows with outlines and highlight values with conditional formatting. When your data is in good shape, turn it into insight with charts, sparklines, sorting, filtering and data analysis tools and, finally, pivot tables.
Alongside the core course you will find focused guides to the formulas people use most at work: the IF function, SUMIFS and COUNTIFS, VLOOKUP and XLOOKUP, text functions and date and time functions. Practical guides cover Excel Tables, drop-down lists and data validation, removing duplicates, absolute and relative references, fixing error messages, Power Query, printing and the keyboard shortcuts that save time every day.
Every guide includes keyboard shortcuts, practical examples you can try yourself and common mistakes to avoid. The site also lists SWIFT/BIC and correspondent bank details for banks in the UAE, which many of our readers use when preparing payment spreadsheets.
Excel Tutorials
- Worksheets and Workbooks
- Entering and Managing Data
- Use of Formatting
- Absolute and Relative References
- Excel Keyboard Shortcuts
- Excel Tables
- Data Validation and Drop-Down Lists
- Text Functions
- Date and Time Functions
- The IF Function
- SUMIFS and COUNTIFS
- VLOOKUP Function
- XLOOKUP Function
- Excel Error Messages Explained
- Find and Remove Duplicates
- Data Outlines and Conditional Formatting
- Excel Charts
- Sparklines and Collating Information
- Data Analysis
- Pivot Tables
- Power Query for Beginners
- Printing and Page Setup
Bank Details, SWIFT & Correspondent Banks
- Abu Dhabi Islamic Bank – ADIB | ABDIAEAD | UAE
- Correspondent Bank Details of Al Ahli Bank of Kuwait KSC | ABKKAEAD
- Correspondent Bank Details of Arab Bank plc | ARABAEAD
- Correspondent Bank Details of Bank of Sharjah | SHARAEAS
- Correspondent Bank Details of Barclays Bank PLC | BARCAEAD
- Correspondent Bank Details of BLOM Bank France | BLOMAEAD
- Correspondent Bank Details of BNP Paribas SA/ BNP | BNPAAEAA / BNPAAEAD
- Correspondent Bank Details of Crédit Agricole Corporate and Investment Bank CACIB | BSUIAEAD
- Details of Nostro Accounts for soliciting Inward Remittance to India