Archives

 

ITIL

ITIL 4, be successfully certified ITIL 4 Managing Professional Transition
ITIL 4, be successfully certified ITIL 4 Strategic Leader
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
ITIL 4 Strategic Leader Certification
ITIL Capability Operational Support and Analysis Certification
ITIL Capability Planning, Protection and Optimization Certification
ITIL Capability Release, Control and Validation Certification
ITIL Capability Service Offerings and Agreements Certification
ITIL Expert Certification
ITIL Managing Across The Lifecycle Certification
ITIL Practitioner Certification
ITIL Service Capability Certification
ITIL 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

 

Team Management

Part 1: A good manager, better team motivation, better team productivity, better team results
Part 2: A good manager, better team motivation, better team productivity, better team results
Self-consciousness motivation, a team self-inspiration

 

Service Management

A good team calendar for a better service management
Build a strong trust relationship with the customer to improve the service and to win new market
The importance of the first customer meeting for the service

 

Report Management

A good powerpoint presentation of the IT service results for a good success
Categorize days by week/month/year in an excel report
Create a bar/pie of pie chart for an excel report
Create a button and associated it to a macro in an excel report
Create a project chart for an excel report
Customize colors and forms of a radar chart in an excel report
Display correctly date and hour in a pivot table for an excel report
Fix the data extracted into 1 single column in an excel report
Report optimization, increase your time management
Show negative time/hour in an excel report
Update automatically a pie chart using name manager in an excel report
Update automatically a trend chart using name manager in an excel report
Use a formula in an excel report
Use a macro to create, edit, hide and select in an excel report (part 1)
Use a macro to copy, cut, paste, replace and delete in an excel report (part 2)
Use a pivot table in an excel report
Use the time including the date and hour in an excel report
Vlookup, a quick way to find the value of a condition in an excel report
Windows language code for an excel report

 

Tool Management

Power BI: after exporting an excel file, percentage shows as number so to format it correctly
Power BI: calculate average based on 2 columns with unique number
Power BI: calculate based on automatic dates (quarters, months)
Power BI: calculate in percentage based on different cell values
Power BI: calculate values for a specific object and show 0 instead of blank
Power BI: change the source, refresh the data and move columns
Power BI: create a group
Power BI: create a trend chart
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: put a new text line in measure
Power BI: show negative and positive percentage
Power BI: show the amount of a specific value when selected in a column chart
ServiceNow: add reports/charts in the dashboard
ServiceNow: add reports/charts in the homepage
ServiceNow: breakdown to group/filter data for a report management
ServiceNow: create a CAB meeting
ServiceNow: create reports for a report management
ServiceNow: dashboard to optimize the widget management
ServiceNow: formula indicator to define my chart for a report management
ServiceNow: indicator groups to optimize the indicator management
ServiceNow: indicator to define my chart for a report management
ServiceNow: reports vs widgets for a report management
ServiceNow: widget to create a chart for a report management
ServiceNow: widget to create a chart with multiple values for a report management

 

Excel Macros

1 click macro tool: Change Management - create a monthly report in excel
1 click macro tool: Incident/Problem Management - create a daily report in excel
1 click macro tool: Incident/Problem Management - create a daily report and a public version in excel
1 click macro tool: Incident/Problem Management - create a monthly report in excel
1 click macro tool: Configuration Management – create a monthly report in excel
1 click macro tool: Problem/Incident Management - create daily reports and compile them in 1 to create the monthly report in excel
1 click macro tool: Problem/Incident Management - compile multiple daily excel files in 1 with access
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: create a backup of the excel report
Macro: create a new file with new sheet in an excel report
Macro: create automatically the months in an excel report
Macro: delete all rows after counting the number of rows using a macro 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 using a macro 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: 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: extract data from internet in an excel report
Macro: export data from IQY file 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 using a macro 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 pivot table with or without an asterisk 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: 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: refresh a pivot table in an excel report
Macro: refresh and filter then copy data 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: 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: update a formula for a 12 months trend chart in an excel report
Macro: update the date in an excel report

 

Excel Formulas

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 result of a group in an excel report
Formula: check if the cell contains only numbers 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 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 count values 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 with a formula 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: 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 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 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 with a formula 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 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: validate cells with the same value in an excel report

TOP Excel Macro

Interesting Management