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 use filters and slicers in Power BI with this easy step-by-step guide. Discover how to add, format, and customise interactive filters for clear data insights.
Learn how to add and format text boxes in PowerPoint with this easy step-by-step guide. Discover how to position, style, and customise text for professional presentations.
Learn how to use bullets and numbering in Microsoft Word with this step-by-step guide. Discover how to create, format, and customise lists for professional documents.
Learn how to use PivotTables in Excel with this easy step-by-step guide. Discover how to summarise, analyse, and visualise your data with examples and tips.
Learn how to combine data with VLOOKUP in Excel. Step-by-step guide for beginners and professionals. Includes examples, tips, and best practices.
Learn how to set task durations in Microsoft Project with this step-by-step guide. Covers basic, estimated, fixed, and effort-driven durations, plus tips and best practices.
Learn how to build a basic Power BI dashboard with this step-by-step guide. Covers data connection, cleaning, visuals, filters, and publishing for beginners.
Learn how to use IF statements in Excel with this easy step-by-step guide. Covers basic IF, nested IF, AND/OR, text, IFS, and real-world examples.
Learn how to create drop-down lists in Excel using Data Validation. Step-by-step guide with tips for basic, dynamic, and dependent lists. Perfect for beginners and advanced users.
Learn how to apply and customise PowerPoint themes. Step-by-step guide explains how to use colours, fonts, backgrounds, and Slide Master for professional presentations.
Learn how to add tasks and milestones in Microsoft Project. Step-by-step tutorial covers creating tasks, setting durations, linking dependencies, and using milestones.
Learn how to create your first Power BI report. Beginner-friendly guide explains how to connect data, build visuals, use slicers, format reports, and publish.
Learn how to use Conditional Formatting in Microsoft Excel. Step-by-step tutorial covers highlight rules, colour scales, icon sets, custom formulas, and best practices.
Learn how to create a new project in Microsoft Project. Step-by-step tutorial covers calendars, tasks, dependencies, resources, baselines, and tracking progress.
Learn how to create a new PowerPoint presentation. Step-by-step tutorial covers layouts, themes, text, images, transitions, and slideshow basics for beginners.
Learn how to format text in Microsoft Word. Step-by-step tutorial covers fonts, sizes, colours, bold, italic, underline, and styles for professional documents.
Learn how to create and save a document in Microsoft Word. Step-by-step tutorial covers starting a new file, formatting basics, saving options, and best practices.
Learn how to import data from CSV files into Microsoft Power BI. Step-by-step guide covers loading, cleaning, combining files, and building reports with CSV data.
Learn how to connect Power BI to Excel data. Step-by-step guide shows how to import, clean, and visualise Excel spreadsheets in Power BI for better reporting.
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}
