Mullan Training

Our Story Mullan Training is an IT training provider based in Belfast, Northern Ireland, delivering instructor-led classroom and virtual courses from city-centre suites opposite the Europa Hotel. The organization specializes in practical, hands-on software training across the Microsoft ecosystem, including Excel, Power BI, SQL, Project, and Microsoft 365, as well as complementary tools such as Visio, Crystal Reports, Power Apps, and Power Automate. Through its technology arm, Mullan Training also provides consultancy services in data analysis and data consolidation. It serves both individual delegates on public schedules and corporate clients requiring closed, tailored group sessions. Programs & Trainings 🎓 Microsoft Excel: Introduction (1 Day) — Build and edit spreadsheets, apply formatting, filtering and sorting, use foundational formulas and functions such as SUM, AVERAGE, COUNT, MIN and MAX, and create basic charts. 🎓 Microsoft Excel: Intermediate (1 Day) — Link sheets within a workbook and to external workbooks, enforce accurate data entry with Data Validation, apply Conditional Formatting, protect cells, sheets and files, and use IF functions together with Advanced Filters. 🎓 Microsoft Excel: Advanced (1 Day) — Master PivotTables and PivotCharts, advanced lookup functions including VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH, Nested IF, AND/OR logic, totals for filtered data, hyperlinks, Macros with an Excel VBA overview, Custom Views, 3D Ranges, and Tables with DAX. 🎓 Microsoft Excel: Ultimate (1 Day) — Design interactive dashboards and advanced Excel models for experienced users who already understand pivots, lookups, conditional formatting and complex functions. 🎓 Excel VBA: Introduction (1–2 Days) — Automate Excel tasks using Visual Basic for Applications programming fundamentals. 🎓 Excel VBA: Intermediate (1 Day) — Develop deeper VBA scripting skills for streamlined spreadsheet automation. 🎓 Excel VBA: Advanced (1 Day) — Build complex VBA solutions and professional macro-driven workflows. 🎓 Power Query: Introduction (1 Day) — Extract, transform and load data to prepare clean, analysis-ready datasets within Excel. 🎓 PowerPivot (1 Day) — Create sophisticated data models and perform advanced calculations directly inside Excel. 🎓 Microsoft Power BI: Level 1 (1 Day) — Connect to Excel, CSV and SQL sources; build interactive dashboards with bar, column, pie, line and combination charts, plus slicers, cards, KPIs, tables, maps and calculated columns. 🎓 Microsoft Power BI: Level 2 (1 Day) — Use the Query Editor to clean, standardize and transform data, review and edit M code, create measures, and apply advanced DAX functions including IF, Nested IF and CALCULATE. 🎓 Microsoft Power BI: Level 3A – Advanced Data Transformations (1 Day) — Consolidate multiple files and folders using Append and Merge, transform structures with Unpivot and Pivot, extract source metadata, and apply advanced M language techniques including ranking, banding, grouping and binning. 🎓 Microsoft Power BI: Level 3B – Advanced Functions & Visualisations (1 Day) — Implement Time Intelligence, custom Date Tables, complex DAX evaluation contexts using FILTER, ALL, CALCULATE and EARLIER, manage multi-table relationships, and deploy parameters across queries, report layers and the data model. 🎓 Paginated Power BI Report Builder (1 Day) — Author paginated reports optimized for printing and multi-page table outputs, designed for publication to the Power BI service. 🎓 Microsoft Project: Introduction (1 Day) — Create responsive project plans, set baselines, manage resources and calendars, and master Critical Path, Gantt charts, float, slack and lag. 🎓 Microsoft Project: Advanced (1 Day) — Execute advanced tracking and reporting, consolidate multiple project plans, share resource pools, and customize fields, tables and views. 🎓 Microsoft Project: NEC Form of Contract (1 Day) — Configure Microsoft Project specifically for NEC contracts, managing multiple baselines, float, TRA and compensation event reporting. 🎓 SQL: Introduction, Intermediate & Advanced (1 Day each) — Progressive curriculum covering database querying and management from fundamentals to complex operations. 🎓 Microsoft Visio: Introduction & Advanced (1 Day each) — Create process maps, flowcharts, organisational charts and swim diagrams for internal and external distribution. 🎓 Microsoft 365 (1 Day) — Maximize productivity across the Microsoft 365 subscription ecosystem. 🎓 Power Apps & Power Automate (1 Day) — Design no-code custom mobile and web business apps and automate workflows to streamline organizational processes. 🎓 Microsoft Word: Introduction, Intermediate & Advanced (1 Day each) — Comprehensive document creation, formatting and editing skill development. 🎓 Microsoft PowerPoint: Intro & Advanced (1 Day each) — Build and polish presentation decks for professional impact. 🎓 Microsoft Outlook: Intermediate & Advanced (1 Day each) — Enhance email management, scheduling and productivity. 🎓 Crystal Reports: Level 1, 2 & 3 (1 Day each) — Author and distribute detailed business reports from various data sources. Specialties 🎯 Microsoft Excel training from beginner fundamentals through ultimate dashboard modelling 🎯 Power BI business intelligence, interactive dashboards and paginated reporting 🎯 SQL database querying, transformation and data management 🎯 Microsoft Project scheduling, resource management and NEC contract compliance 🎯 Microsoft 365 productivity ecosystem mastery 🎯 Power Apps and Power Automate no-code application development and workflow automation 🎯 Data analysis and data consolidation consultancy 🎯 Professional business reporting with Crystal Reports and technical diagramming with Visio Methods & Approach Mullan Training delivers instructor-led, fully interactive sessions in modern physical classrooms and live virtual classrooms broadcast from Belfast. Every course is hands-on, with delegates working directly inside the software environment rather than listening to passive lectures. For Excel pathways, a pre-course questionnaire helps match participants to the correct difficulty level, and trainers are available for one-to-one consultations to tailor closed corporate courses or customize content to specific organizational requirements. Who It's For Individual professionals and delegates seeking to upgrade software proficiency; corporate teams requiring closed group training customized to their workflows; data analysts and report builders moving from spreadsheets to business intelligence tools; project managers needing schedule control and NEC contract alignment; beginners entering IT-focused or administrative roles; and advanced users aiming to master VBA, DAX, complex data transformations and interactive reporting. Facilities & Practical Info Training is delivered from high-spec IT suites in Belfast City Centre at Blackstaff Studios on Floors 1 and 5, directly opposite the Europa Hotel. Each suite accommodates up to 12 delegates, ensuring small class sizes and focused attention. The venue provides a breakout area, complimentary refreshments throughout the day, free guest WiFi, overhead projection and a dedicated third monitor so every delegate can clearly view the trainer's screen. The location sits beside Great Victoria Street bus and train stations with multiple car parks nearby. In addition to training, the rooms are available for hire as IT suites, meeting spaces or testing centres equipped with exam dividers. Location Address: Floors 1 & 5, Blackstaff Studios, 8-10 Amelia Street, Belfast BT2 7GS, United Kingdom Hours: See website for public schedule dates and availability; classroom and virtual courses run on scheduled dates throughout the year. The "+" ✅ Prime central Belfast location opposite the Europa Hotel with excellent public transport links and nearby car parking. ✅ Small class sizes capped at 12 delegates for focused, interactive, instructor-led learning. ✅ Flexible dual delivery mode offering both in-person classroom and fully interactive virtual attendance. ✅ Exhaustive Microsoft-focused curriculum spanning beginner introductions to advanced VBA, DAX, BI modelling and project management. ✅ Bespoke corporate training and consultancy services available, including tailored closed courses, data consolidation and data analysis support.