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

Bank Details, SWIFT & Correspondent Banks