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
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
Check each cell for a specific value (date) using office script 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: between slicer in formula calculating/showing all values below or above filter selection
Power BI: calculation based on month and year
Power BI: calculate a specific criteria automatically for the current month
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 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
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 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 or before 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: 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: interaction between charts (filtering between each others)
Power BI: monthly refresh or each time a file is uploaded in the cloud
Power BI: put a new text line 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
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: 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
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: 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 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: 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: 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: 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 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 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
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 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 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: validate cells with the same value in an excel report

TOP Excel Macro

Interesting Management