ITIL Reporting

ITIL 4

ITIL 4 Managing Professional Certification Course

It helps you to get certified and it is for IT people who work within technology and digital teams across businesses. It provides practical and technical knowledge about how to run successful IT enabled services, teams...
Be successfully certified ITIL 4 A&M Cloud Services

With my ITIL 4 MP and SL in the pocket, I decided to take one of the extension modules with no prerequisites...

ITIL 4 Strategic Leader Certification Course

It helps you to get certified and it is about to demonstrate that you have a clear understanding of how...
ITIL 4 Specialist A&M Cloud Services Certification Course

It helps you to get certified and it is about how cloud procurement and technology can...
Be successfully certified ITIL 4 Managing Professional

The first thing is to learn the definition, it gave me some inputs but the main focus was in the CDS, DSV...
Be successfully certified ITIL 4 Strategic Leader

My last step before to be eligible for the ITIL Master. Before the exam, there is a practical assignment...

Stacked and clustered column chart or double stacked column chart

In excel, I use a lot the combination of clustered and stacked chart...
Connect to the Jira database

I found the way to connect to my Jira project (Jira server/cloud) to extract all incidents by using my account (username and password...
Calculate based on automatic dates (quarters, months)

I will explain a way to do it that a manual update is not required so it will be done automatically...
Calculate values of a single column by row

To calculate the values of each row of a single column, I will use the OFFSET and/or WINDOW functions...

Create, publish and update a dashboard for beginners - Part 1: upload the data

If it is the first time you will open Power BI, this tutorial will guide you from A until the publication of your first dashboard to share with your audience...
Filter/slicer

I will explain different ways I use slicers (filters) but I will skip its default behaviour. To inactive/hide a filter, I will use this example...

Count and check empty cells of filtered columns using a macro in an excel report

I use this macro to check if there are blank cells after I filtered...
Delete rows out of date using a macro in an excel report

In most of the reports, when I am doing the monthly one, I just need to keep all data that are in the month...
Find a specific value then insert a row and more things using a macro in an excel report

This VBA allows me to look for a specific value, it can be...
List unique values then combine in one single cell all data using a macro in an excel report

In one of my reports, I have to list from a column the unique values...

Copy/paste a range of values after finding the current date in an excel report

This script is to check and compare each cell of a specific column to...
Insert a row after finding a specific value in an excel report

This script allows to search a particular value, once find it, a new row will be inserted above or below...
Autofill from the last row using an office script in an excel report

This script will look for the last row then it will copy and paste the data to a number of rows below...
Copy data between 2 sheets on top or bottom using an office script in an excel report

This online script allows me to copy the full data of a table to another...