How To Guides – Microsoft Excel, Power BI, Word & More
Explore step-by-step tutorials to help you get more from Microsoft Office and technical tools. From Excel formulas and Power BI dashboards to Word formatting and project management tips, our guides make it easy to learn new skills. Each guide links directly to our related training courses so you can go further.
Learn how to freeze panes and split windows in Excel. Step-by-step tutorial explains how to lock headings, compare data, and navigate large spreadsheets easily.
Learn how to create and format charts in Microsoft Excel. Step-by-step guide covers chart types, formatting, advanced options, and links to relevant Excel training courses.
Learn how to sort and filter data in Microsoft Excel with step-by-step examples. Covers basic and advanced techniques including multi-level sorts, filters, and Tables.
Learn how to use basic formulas in Excel, including SUM, AVERAGE and COUNT. Step-by-step examples show how to total, average and count data quickly. Perfect for beginners.
Learn how to enter and format data in Microsoft Excel with this step-by-step guide. Covers text, numbers, dates, styles, tables and formatting tips. Ideal for beginners who want to build a strong foundation in Excel.
.png){kind=small}
