Archives
ITIL
Certifications:
ITIL 4, be successfully certified ITIL 4 Managing Professional
ITIL 4, be successfully certified ITIL 4 Strategic Leader
ITIL 4, be successfully certified ITIL 4 Specialist Acquiring & Managing Cloud Services
Courses:
ITIL 4 Managing Professional Certification Course
ITIL 4 Strategic Leader Certification Course
ITIL 4 Specialist Acquiring & Managing Cloud Services Certification Course
Other topcis:
ITIL 4, the new ITIL for 2019
ITIL 4 Foundation Certification
ITIL 4 Foundation: Core Components of ITIL SVS
ITIL 4 Foundation: Four Dimensions
ITIL 4 Foundation: General Management Practice
ITIL 4 Foundation: rethinking of ITSM management
ITIL 4 Foundation: Service Management Practice
ITIL 4 Foundation: Technical Management Practice
ITIL 4 Managing Professional Certification
ITIL 4 Managing Professional Transition Module Certification
ITIL 4 Master Certification
Click Here To Show/Hide More Articles
ITIL 4 Strategic Leader Certification
ITIL 3 Capability Operational Support and Analysis Certification
ITIL 3 Capability Planning, Protection and Optimization Certification
ITIL 3 Capability Release, Control and Validation Certification
ITIL 3 Capability Service Offerings and Agreements Certification
ITIL 3 Expert Certification
ITIL 3 Managing Across The Lifecycle Certification
ITIL 4 Practitioner Certification
ITIL 3 Service Capability Certification
ITIL 3 Service Lifecycle Certification
ITIL V3, time to be ITIL 4 Expert known as ITIL 4 Managing Professional via the Transition Module
Tools to get your ITIL intermediate certifications, the missing 15 points for the ITIL 4 Managing Professional
Power Automate
Power Automate: include other people to a Power BI alarm
Power Automate: Power BI alerts to be sent by email from an excel file based on condition
Power BI
Tutorial:
Power BI: create, publish and update a dashboard for beginners - Part 1: upload the data
Power BI: create, publish and update a dashboard for beginners - Part 2: create the report
Power BI: create, publish and update a dashboard for beginners - Part 3: share with the audience
Power BI: create, publish and update a dashboard for beginners - Part 4: create the dashboard
Other topcis:
Power BI: after exporting an excel file, percentage shows as number so to format it correctly
Power BI: between slicer in formula calculating/showing all values below or above filter selection
Power BI: calculation based on month and year
Power BI: calculate based on automatic dates (quarters, months)
Power BI: calculate in percentage based on different cell values
Power BI: calculate the (high) value of unique numbers
Power BI: calculate the average of unique values
Power BI: calculate values based on multiple unique conditions
Power BI: calculate values for a specific object and show 0 instead of blank
Power BI: calculate values of a single column by cell
Power BI: calculate values of a single column by row
Power BI: change the source, refresh the data and move columns
Power BI: combine words based on criteria
Power BI: connect to the Jira database
Click Here To Show/Hide More Articles
Power BI: convert decimal to unique number for filter
Power BI: count number of characters/letters/words using a column
Power BI: count occurrences
Power BI: create a group
Power BI: create a monthly chart of a measure with 2 criteria
Power BI: create a trend chart
Power BI: create an alert for notification
Power BI: create an automatically updated calendar
Power BI: create chart in import or directquery
Power BI: create comparison chart with 1 single table
Power BI: cumulative total values
Power BI: customized result when select a specific value of a filter
Power BI: default last year date selection on filter
Power BI: define a row as header/title for a table
Power BI: define quarter based on months
Power BI: display last update information
Power BI: display table result containing key word based on main value filter
Power BI: display value on criteria with a measure
Power BI: extract columns from a table to another one
Power BI: extract keyword or everything after, before or between a key character
Power BI: extract multiple values of a single cell into one row for each of them
Power BI: filter/slicer
Power BI: filter before loading data
Power BI: find and replace words
Power BI: find the maximum value of unique numbers
Power BI: format chart column color of single data
Power BI: get a value if 2 conditions are met
Power BI: hide visual and change background color based on selection
Power BI: include the slicer as a condition in the calculation
Power BI: interaction between charts (filtering between each others)
Power BI: load data based on date (month, year, etc.)
Power BI: monthly refresh or each time a file is uploaded in the cloud
Power BI: put a new text line and special characters in measure
Power BI: reading window to display better the information
Power BI: replace value from a cell to another cell
Power BI: resolving the blank/empty cells that Power BI should not count them
Power BI: return a value based on condition
Power BI: search a word in different tables
Power BI: show negative and positive percentage
Power BI: show the amount of a specific value when selected in a column chart
Power BI: sort correctly the month name in chart
Power BI: stacked and clustered column chart or double stacked column chart
Power BI: sum weekend values to show only week date
Power BI: time management
Power BI: unique value (no duplicate) with distinctcount not showing the chart correctly
Power BI: using IF for different tables
Power BI: weekend/holiday
Excel Essential
Essential: categorize days by week/month/year in an excel report
Essential: create a bar/pie of pie chart for an excel report
Essential: create a project chart for an excel report
Essential: customize colors and forms of a radar chart in an excel report
Essential: display correctly date and hour in a pivot table for an excel report
Essential: fix the data extracted into 1 single column in an excel report
Essential: update automatically a pie chart using name manager in an excel report
Essential: update automatically a trend chart using name manager in an excel report
Essential: use a pivot table in an excel report
Essential: Windows language code for an excel report
Excel Script
Tutorial:
Office Script: use a script to create, edit and select in an excel report (part 1)
Office Script: use a script to copy, cut, paste, replace and delete in an excel report (part 2)
Office Script: create a button and associated it to a script in an excel report
Other topcis:
Office Script: autofill from the last row in an excel report
Office Script: check cell by cell in an excel report
Office Script: check if leap year (February 29) in an excel report
Office Script: count characters and words in an excel report
Office Script: copy data between 2 sheets on top or bottom in an excel report
Office Script: copy/paste a range of values after finding the current date in an excel report
Office Script: define the cell type as value in an excel report
Office Script: delete unnecessary space in an excel report
Office Script: extract particular words with an updated range in an excel report
Office Script: extract the day, month or year from cell in an excel report
Office Script: extract words from a cell in an excel report
Office Script: find the last row in an excel report
Office Script: get the row/column ID in an excel report
Office Script: identify same values after finding words in an excel report
Office Script: insert a row after finding a specific value in an excel report
Click Here To Show/Hide More Articles
Office Script: search words in an excel report
Office Script: sort from small or from big in an excel report
Excel Macro
Tutorial:
Macro: use a macro to create, edit, hide and select in an excel report (part 1)
Macro: use a macro to copy, cut, paste, replace and delete in an excel report (part 2)
Macro: create a button and associated it to a macro in an excel report
Other topcis:
Macro: add a new line into a cell in an excel report
Macro: adjust the size of a column/row in an excel report
Macro: change a value of a cell in an excel report
Macro: change the cell format into general in an excel report
Macro: change the cell value of date by a word in an excel report
Macro: change the value of a cell based on another cell then delete it in an excel report
Macro: copy data from another file to the main file in an excel report
Macro: copy data from the last row from a sheet to another sheet in an excel report
Macro: copy the TOP 10 in an excel report
Macro: count and check empty cells of filtered columns in an excel report
Macro: count number of words and more actions (split, copy, etc.) in an excel report
Macro: count the current data then copy to another sheet in an excel report
Macro: count the number of rows and columns in an excel report
Macro: create a backup of the excel report
Macro: create a new file with new sheet in an excel report
Click Here To Show/Hide More Articles
Macro: create automatically the months in an excel report
Macro: delete/clear the last row using a macro in an excel report
Macro: delete all rows after counting the number of rows in an excel report
Macro: delete contents of the filtered column in an excel report
Macro: delete duplicate for multiple columns in an excel report
Macro: delete entire row of an empty cell based on the current month in an excel report
Macro: delete entire rows for empty cells in a table in an excel report
Macro: delete negative numbers in an excel report
Macro: delete rows/columns/cell data in an excel report
Macro: delete rows out of date in an excel report
Macro: delete the entire row if find the word in an excel report
Macro: delete the entire row if next or previous month in an excel report
Macro: delete the entire row of useless empty cells in an excel report
Macro: delete the entire rows that contain duplicate incident ticket numbers in an excel report
Macro: delete the heading and trailing space at the beginning and at the end in an excel report
Macro: different options to delete rows in an excel report
Macro: display a text box about information each time the excel report opens
Macro: double click or right click to change the color of a cell in an excel report
Macro: execute a macro based on the day or time in an excel report
Macro: execute a macro when I click on save or before to close the file in an excel report
Macro: execute another macro from a macro in an excel report
Macro: export data from IQY file in an excel report
Macro: extract data from internet in an excel report
Macro: extract specific words with a dynamic range in an excel report
Macro: fill a column when another column has empty cells in an excel report
Macro: fill all empty cells if another cell is not empty in an excel report
Macro: fill up a cell based from another cell in an excel report
Macro: filter a date or between 2 dates in an excel report
Macro: filter a particular criteria then delete the selection in an excel report
Macro: filter a pivot table with or without an asterisk in an excel report
Macro: find a specific value then insert a row and more things in an excel report
Macro: find a specific value of the last cell then copy cells from another sheet in an excel report
Macro: find the last cell before/after an empty cell to copy it in an excel report
Macro: find the last column/row then copy to a new row/column in an excel report
Macro: find the last row of a column and the last column of a row in an excel report
Macro: format the date in an excel report
Macro: freeze the column/row in an excel report
Macro: insert a new row/column in an excel report
Macro: insert a text box into a sheet in an excel report
Macro: know the last column letter of a row in an excel report
Macro: know the letter/number of a column in an excel report
Macro: know the row ID to create a formula in an excel report
Macro: list unique values then combine in one single cell all data in an excel report
Macro: match same values after finding words in an excel report
Macro: merge and unmerge cells in an excel report
Macro: mix text and formula into a cell in an excel report
Macro: open and copy data to another file in an excel report
Macro: open and copy data to another file for a table style in an excel report
Macro: open and export data in an excel file with access
Macro: open and save a file including an asterisk in an excel report
Macro: popup a message box the value of different cells of the same row in an excel report
Macro: popup a validation message the cell value in an excel report
Macro: put a date after checking that another cell is not empty in an excel report
Macro: put a formula in an excel report
Macro: put a new value in another cell once find a specific word in an excel report
Macro: put an array formula in an excel report
Macro: put an hyperlink in an excel report
Macro: put the date and format it in an excel report
Macro: put the date of any days of the week in an excel report
Macro: refresh a pivot table in an excel report
Macro: refresh and filter then copy data in an excel report
Macro: remove filter in an excel report
Macro: replace a word by another one in an excel report
Macro: replace an entire letter/word in an excel report
Macro: replace cell value of a table by another value in an excel report
Macro: save a file with a date in an excel report
Macro: save a macro excel file into a normal excel file to disable all macros in an excel report
Macro: save and upload a report in an excel report
Macro: schedule a macro to run at a specific time in an excel report
Macro: search the name in column then fill rows in an excel report
Macro: skip empty cells in an excel report
Macro: sort from top or from down in an excel report
Macro: update a formula for a 12 months trend chart in an excel report
Macro: update the date in an excel report
Macro: update the year in an excel report
Excel Formula
Tutorial:
Formula: use a formula in an excel report
Other topcis:
Formula: add a new line in an excel report
Formula: add an hyperlink to a ticket number in an excel report
Formula: add the time zone in an excel report
Formula: calculate a weighted average for a SLA and a conversation time in an excel report
Formula: calculate SLA overdue in an excel report
Formula: calculate the country outage (downtime) based on its bank holidays and its time schedule in an excel report
Formula: calculate the duration between 2 time schedules and 2 time frames in an excel report
Formula: calculate the duration between 4 different times in different countries in an excel report
Formula: calculate the percentage of and convert it to number in an excel report
Formula: calculate the result of a group in an excel report
Formula: calculate number of working days excluding a week day and public holidays in an excel report
Formula: check if new data for previous month in an excel report
Formula: check if the cell contains only numbers in an excel report
Formula: check if the day is a bank holiday after converting day and month into one single cell in an excel report
Formula: check if the value is between 2 numbers in an excel report
Formula: convert a decimal number into hour/minute/second in an excel report
Formula: convert cell into real date format in an excel report
Click Here To Show/Hide More Articles
Formula: convert European time into other country times in an excel report
Formula: count a specific value within a month in an excel report
Formula: count data for a specific value in a month in an excel report
Formula: count question mark in an excel report
Formula: count the repetitive value in an excel report
Formula: count unique value in an excel report
Formula: create a circle formula to display missing value in an excel report
Formula: delete the heading and trailing space at the beginning and at the end in an excel report
Formula: different ways to calculate/sum in an excel report
Formula: different ways to calculate a calendar with or without bank holiday in an excel report
Formula: different ways to count values in an excel report
Formula: different ways to use the time and date in an excel report
Formula: display important incidents to review in an excel report
Formula: display other result than an empty cell, 0 or n/a in an excel report
Formula: display row results in column in an excel report
Formula: display the comment after finding the key word in an excel report
Formula: display the correct data of duplicate cells in an excel report
Formula: display the data from another sheet in an excel report
Formula: display the data of the previous/next/above/below cell in an excel report
Formula: display the date in a sentence in an excel report
Formula: display the month in an excel report
Formula: display the month name in an excel report
Formula: display the value when the condition matches in an excel report
Formula: empty cell in an excel report
Formula: extract values from columns or rows into one single cell with a formula in an excel report
Formula: extract multiple values into one unique cell if matching criteria in an excel report
Formula: find a specific word in a comment if it is into a list in an excel report
Formula: find a specific word in a comment in an excel report
Formula: find all results of an unique group in an excel report
Formula: find an email address in an excel report
Formula: find and replace characters with a formula in an excel report
Formula: find duplicate in an excel report
Formula: find the good data by matching 2 different criterias in an excel report
Formula: find the good data by matching 3 different criterias in an excel report
Formula: find the last cell even if there is a blank cell in an excel report
Formula: find the row ID in an excel report
Formula: highlight a cell with a color with the conditional formatting option with or without a formula in an excel report
Formula: know how long a service is impacted in an excel report
Formula: know the last day of the month in an excel report
Formula: loop vlookup until the good data in an excel report
Formula: match 2 criterias with or without cells containing a phrase in different columns in an excel report
Formula: match the first letters in an excel report
Formula: match value if 1 cell contains many values in an excel report
Formula: match value in 2 different sheets in an excel report
Formula: mix text and formula into a cell in an excel report
Formula: prevent a formula to be updated in an excel report
Formula: put a specific value if cell not empty and if no information in an excel report
Formula: put a specific value if match an ID and find a specific word in an excel report
Formula: put this result if not this value in an excel report
Formula: remove the time zone code to display only the date and time in an excel report
Formula: round a number in percentage into a text in an excel report
Formula: search in different sheets then display the wanted data in an excel report
Formula: show a customized result if an error occurs in an excel report
Formula: show a specific result if the number is inferior, superior or between in an excel report
Formula: show a specific value when matching multiple data with or without characters in an excel report
Formula: show negative time/hour in an excel report
Formula: show other result for 0 and empty cell in an excel report
Formula: show the corresponding value when matching cells in horizontal and in vertical in an excel report
Formula: show the corresponding value when matching different cells in an excel report
Formula: show the value of the last cell in an excel report
Formula: sum and count sales in an excel report
Formula: sum weekend values to show only week date in an excel report
Formula: use the time including the date and hour in an excel report
Formula: validate cells with the same value in an excel report
Formula: vlookup, a quick way to find the value of a condition in an excel report
Interesting Topics
-
Be successfully certified ITIL 4 Managing Professional
Study, study and study, I couldn’t be successfully certified without studying it, if you are interested...
-
Be successfully certified ITIL 4 Strategic Leader
With my ITIL 4 Managing Professional certification (ITIL MP) in the pocket, it was time to go for the...
-
Hide visual and change background color based on selection
Some small tricks to customize the background colour of a text box...
-
Stacked and clustered column chart or double stacked column chart
In excel, I use a lot the combination of clustered and stacked chart...
-
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...
-
Execute a macro based on the day or time in an excel report
In some excel files, I am using a macro to tell it in which moment to do the report. For instance, if I am...
-
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...
-
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...
-
Use a script to copy, cut, paste, replace and delete in an excel report (part 2)
This is the second part of my tutorial and it will be focused on...
-
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...
-
Calculate a weighted average for a SLA and a conversation time with a formula in an excel report
In one of my experiences, I had a tool that gave me the weighted average...
-
Search in different sheets then display the wanted data with a formula in an excel report
vlookup and hlookup are formulas that allow to search a data in another...
-
Find the good data by matching 3 different criterias with a formula in an excel report
It is a combination of “index” and “match” formulas, much better...
-
Sum and count sales with a formula in an excel report
Extracting data from salesforce or qlikview may not give the information I needed, it already happened...
Know how long a service is impacted with a formula in an excel report
It is important to know how long the service has been impacted by...