Microsoft Excel Training Courses Belfast, Online and Classroom Power BI Training in NI

MICROSOFT EXCEL

Learn how to get the most out of Microsoft Excel & leverage this powerful tool. Achieve a good understanding of how Excel works/ thinks & progress from creating basic spreadsheets to advanced dashboards - store your data correctly, format it and then (i) Use formula/ functions (ii) Link sheets/ files, apply validation & conditional formatting (iii) Analyse using charts & pivot tables (iv) Create interactive dashboards with slicers & DAX

Microsoft Excel: Introduction

1 Day

Topics Include:

Create new spreadsheets & edit existing spreadsheets (insert/ delete rows & columns, update page setup, work with sheets)
Learn how to setup your spreadsheet properly so that you can get most out of your data
Enter data correctly then format, filter & sort
Understand how to use formula & functions + - * / % $ SUM AVERAGE COUNT COUNTA MIN MAX
Create basic charts from data
See Course Outlines for detailed content
Review Dates for our Excel (Introduction) Public Schedule Courses

Microsoft Excel: Intermediate

1 Day

Topics Include:

Link sheets in a workbook & to an external workbook
Use Data Validation to enforce correct data entry
Use Conditional Formatting to highlight cells/rows with certain values (duplicates, cells meeting criteria)
Protect your spreadsheet (cells/ sheets/ files)
Use IF function to make your spreadsheet smarter
Advanced Filter inc With Colour
Update multiple sheets simultaneously
See Course Outlines for detailed content
Review Dates for our Excel (Intermediate) Public Schedule Courses

Microsoft Excel: Advanced

1 Day

Topics Include:

PivotTables/ PivotCharts
Advanced Functions: VLOOKUP, HLOOKUP, XLOOKUP, Nested IF, AND, OR, INDEX, MATCH
Create Totals for FILTERED Data
Hyperlink Your spreadsheets
Macros inc Overview of Excel VBA
Custom Views
3D Ranges
Working with Tables & DAX
See Course Outlines for detailed content
Review Dates for our Excel (Advanced) Public Schedule Courses

Microsoft Excel: Ultimate

1 Day

Excel Ultimate is for advanced users of Excel that are looking to create Interactive Dashboards & become an Excel Modelling Pro

Prerequisites:

You should have attended our Adv Course OR be an experienced user of our Interm & Adv topics
Delegates will be expected to have a full understanding of these topics - inc Pivots, Lookups, IF, Linking, Conditional Formatting, Subtotals, filters, etc
If you do not have this experience, we recommend you consider attending Interm/ Adv first
Review Content & Dates

Not Sure Which Excel Course Level Suits You?

Unsure what course level suits you best?
Complete our Pre-Course Questionnaire, return to us and we will contact you with our recommendations as soon as we have reviewed: Download Our Pre-Course Excel Questionnaire
We can also organise a meeting with one of our trainers to go through your requirements

Microsoft Excel VBA

Reduce manual tasks to the click of a button by leveraging Excel functionality with macros - automate repetitive tasks and create interactive models to analyse, consolidate & report on data.

Excel: VBA

1 & 2 Days

Introduction (2 days): Suitable for advanced users of Excel who (i) Are responsible for large/ variable amounts of data (ii) Want to learn how to program features to improve the accessibility &usability of their data
Intermediate (1 day): Covers the use of arrays, control structures, adv error handling, validation
Advanced (1 day): Looks at 3-D arrays, user forms, performance, etc
See Course Outlines for detailed content
Review Dates for our Excel VBA Public Schedule Courses

POWER QUERY & POWER PIVOT

Microsoft Excel: Power Query

1 Day

Power Query is a Business Intelligence tool that's available in Excel - it's ideal for transforming/ manipulating data to facilitate data analysis:

Process large amounts of data
Connect to your data - single or multiple (different) data sources inc Excel, CSV, SQL, Azure, etc
Tidy up & restructure to create a clean dataset
Repeat regular data transformations without coding: clean, transform, combine
Perform data analysis
Course Outlines for detailed content
Dates for our Public Schedule Courses

Microsoft Excel: Power Pivot

1 Day

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. In the course you will learn how to:

Connect to (multiple) data sources
Create relationships between multiple tables/ data sources
Transform data
Consolidate multiple data sources
Write Power Pivot DAX Expressions
Format reports - Pivots & Charts
Create dashboards to provide business insights
Course Outlines for detailed content

Microsoft Power BI

Create interactive dashboards that visualise your data, connecting directly for real time reporting or to downloads. Use single or multiple sources inc Excel, CSV, SQL, SharePoint, Online Databases, etc. Learn what Power BI can do for you and how to visualise, clean & consolidate data - where necessary, transform it to make ready for reporting. Share your dashboards with others via Teams, PDF or Power BI Online. Turn your data into information then your information into insights.

Level 1

1 Day

Learn how Power BI works & understand what it can do for you
Connect to different data sources: Excel, CSV, SQL
Create attractive & interactive dashboards users can sort, filter & drill down
Add chart visualisations: Bar, Column, Pie, Line, Combi
Add visualisations: Slicers, Cards, KPIs, Tables, Maps, Text
Create calculated columns to enhance the datasets
Introduce Top/ Bottom N
See Course Outlines for detailed content
Review Dates for our Power BI (Level 1) Public Schedule Courses

Level 2

1 Day

Use the Query Editor to transform your data & get it ready for reporting: (i) Remove unwanted rows/ columns (ii) Remove duplicate rows (iii) Clean, standardise & filter data (iv) Split fields/ merge fields & extract from fields, etc)
Review the use of M & edit/ update generated steps
Create measures
Create columns/ fields using more advanced functions (IF, Nested IF, CALCULATE)
See Course Outlines for detailed content
Review Dates for our Power BI (Level 2) Public Schedule Courses

Level 3A: Advanced Data Transformations

1 Day

Consolidate data from (i) Multiple files (ii) A specified folder (using Append & Merge)
Transform data (Unpivot, Pivot)
Extract & use source file meta data: Filenames, Last Updated, Last Accessed, Source Location
Work with advanced M eg to display refresh date
Rank, Band/ Group/ Bin
Review Dates for our Power BI (Level 3A) Public Schedule Courses

Level 3B: Advanced Functions & Visualisations

1 Day

Time Intelligence Calculations (Date Tables, Missing Periods, Operating Periods, Prior Year, Date Functions)
DAX Functionality Review (Column, Measure, Evaluation Context)
Context Control Functions (FILTER, ALL, CALCULATE, EARLIER)
Contexts in Relationships (Working With Many Tables, Row/ Filter Context & Relationships, Values Function)
Using Parameters in Queries, Report Layers & the Data Model
Review Dates for our Power BI (Level 4B) Public Schedule Courses

Paginated Power BI Report Builder

1 Day

This is is a tool for authoring paginated reports that you can publish to the Power BI service:

Paginated reports are designed to be printed or shared
They're formatted to fit well on a page & they display all the data in a table, even if the table spans multiple pages
When you design a paginated report, you're creating a report definition that specifies what data to retrieve, where to get it, and how to display it
Contact Us for course details

Microsoft Project

Microsoft Project is a flexible tool that is used for creating project schedules, estimating resource requirements, analysing task dependencies & tracking project progress. During the course, delegates will learn how to create effective project plans and then update actual project progress - with emphasis on the Critical Path.

Create (Responsive) Project Plan
Set Baseline(s)
Track Actual Progress & Compare Actual to Baseline(s)
Report - on Resource Allocations, Cost/ Work Analysis, etc
Customise plans with your own work schedules, fields, tables & Project settings
Consolidate multiple plans & use resource pools

Introduction

1 Day

Learn frequently used Project Management terminology & put it into practice by creating a project plan
Gantt Chart, Critical Path Analysis, Float, Slack, Lag, Resources, Calendars, Tracking Gantt, etc
See Course Outlines for detailed content
Review Dates for our Project (Introduction) Public Schedule Courses

Advanced

1 Day

Learn advanced tracking & reporting techniques to keep on top of your project & monitor variations/ deviations from the baseline(s)
Consolidate project plans
Share resources between projects
Customise your project plan with new fields, views, tables & views
See Course Outlines for detailed content
Review Dates for our Project (Advanced) Public Schedule Courses

NEC Form of Contract

1 Day

This course is designed to show delegates how to use the programming software Microsoft Project for contracts that are carried out under the NEC form of contract
It is a hands-on course that uses Microsoft Project throughout
You will learn how to show the critical path, multiple baselines, float, TRA, etc & effectively report on compensation events - collect then report on relevant info
See Course Outlines for detailed content
Review Dates for our Project (NEC) Public Schedule Courses

SQL

Learn how to write SQL (Structured Query Language) to access, extract, organise & manipulate the data stored in your relational database. Our SQL courses range from Introduction to Advanced levels and during the course you will interrogate a number of different datasets (Personnel Directory, Client Invoicing, Event Management, etc), providing the opportunity to demonstrate different ways to apply what you have learned.

Introduction

1 Day

See Course Outlines for detailed content
Review Dates for our SQL (Introduction) Public Schedule Courses

Intermediate

1 Day

See Course Outlines for detailed content
Review Dates for our SQL (Intermediate) Public Schedule Courses

Advanced

1 Day

See Course Outlines for detailed content
Review Dates for our SQL (Advanced) Public Schedule Courses

Microsoft 365

1 Day

In order to get the most out of your Microsoft 365 account, it is important to know:

How and when to use each app
The benefits of using Web V Desktop apps
How your apps integrate

Learn how to effectively use:

Productivity Apps (Word, Excel, PowerPoint, Outlook, etc)
Collaboration Apps (OneDrive, SharePoint, Teams, etc)

See Course Outlines for content
Review Dates for our 365 Public Schedule Courses

SharePoint

1 Day

Understand the role of SharePoint in the workplace - as an online collaborative portal that offers file & data storage, version control, document approval, etc
Create & Use Document Libraries
Use SharePoint Search Tools to find information
Use the functionality of a basic Team site
Create and use a Custom list
Use/Create a Meeting Workspace

See Course Outlines for content
Review Dates for our SharePoint Public Schedule Courses

Teams

1 Day

Get an overview of the capabilities of Teams & how/ when to use the web version as opposed to the app
Understand how it can be used effectively - as a Communication and Collaboration tool
Online Meetings with screenshare, recording, access to work contacts (calendars & profiles), whiteboard, note taking, etc
Teams & Channels
Use Messaging & Calling capabilities
Integration with Microsoft 365 Suite
File & Chat Storage

PowerPoint

1 Day

Create & deliver engaging PowerPoint presentations:

Use the basic features & functions of PowerPoint
Bring your presentation to life & apply transitions & animations to slides, charts, graphics
Deliver your presentation & export as a video/ animated image
Make use of hyperlinks, action buttons & custom shows to make the presentation delivery as seamless as possible

See Course Outlines for detailed content
Public Course Schedule - Online & Classroom

Word

1 Day

Manage Word documents efficiently:

Divide a document into sections & columns, format tables and create table styles
Add recurrent data to documents
Prepare mail merge labels and envelopes & setup a template for future mailing
Share & collaborate on documents
Produce well-defined forms
Work with large documents
Use macros to speed through repetitive functions

See Course Outlines for detailed content
Public Course Schedule - Online & Classroom

Outlook

1 Day

These courses are designed for users who are using Microsoft Outlook and want to develop their skills further.

See Course Outlines for detailed content
Public Course Schedule - Online & Classroom

Crystal Reports

Crystal Reports empowers the user to connect directly to data tables & create reports based on LIVE data. Where it was previously necessary to export to Excel & repetitively create PivotTables & PivotCharts to analyse, with Crystal you will learn how to connect directly to the live data, create a report and REFRESH to obtain the live & essential data.

Use this powerful report writer to:

Connect to multiple data sources
Create interactive reports from a variety of data sources without having to write code
Provide users with a variety of visualisations to analyse data - creating custom fields using advanced formula & functions

Introduction, Intermediate & Advanced

1 Day

All courses are 1 day duration
Delegates will learn how to create reports and interrogate data from the main database
From creating lists of data, charts & summary reports to interactive reports that engage with the user

See Course Outlines for detailed course content
Contact Us to organise a course

mullanITtraining.co.uk: Crystal Reports - SAP

Microsoft Visio

Microsoft Visio gives business and technical users the power to communicate information at a Glance - with Process Maps/ Flowcharts, Organisational Charts, Swim Diagrams, etc. Once created, they can then be distributed to a wider audience - internally & externally. Use the simple, flexible tools in Visio to easily create business and technical charts & graphics that capture workflows & communicate with impact:

Introduction

1 Day

Turn your information into graphics: with:

Flow Charts
Network Diagrams
Workflows
Organisational Charts
Swim Diagrams

See Course Outlines for detailed course content
Review Dates for our Visio Public Schedule Courses

Excel - SQL - Power BI - 365 - Project - Belfast:Online & Classroom Courses

Course Overview & Outlines

[Click a logo to jump to course details...]

Excel Training Courses

MICROSOFT EXCEL

Microsoft Excel: Introduction

Microsoft Excel: Intermediate

Microsoft Excel: Advanced

Microsoft Excel: Ultimate

Not Sure Which Excel Course Level Suits You?

Microsoft Excel VBA

Excel: VBA

Power Query & Power Pivot training Courses

POWER QUERY & POWER PIVOT

Microsoft Excel: Power Query

Microsoft Excel: Power Pivot

Power BI Training Courses

Microsoft Power BI

Level 1

Level 2

Level 3A: Advanced Data Transformations

Level 3B: Advanced Functions & Visualisations

Paginated Power BI Report Builder

Project Training Courses

Microsoft Project

Introduction

Advanced

NEC Form of Contract

SQL Training Courses

SQL

Introduction

Intermediate

Advanced

365 Training Courses

Microsoft 365

SharePoint

Teams

PowerPoint

Word

Outlook

Crystal Reports Training Courses

Crystal Reports

Introduction, Intermediate & Advanced

Visio Training Courses

Microsoft Visio

Introduction

This website uses cookies.