@itilreporting.bsky.social
+ Follow
2
followers
2
following
100
posts
Posts
Media
Videos
Starter Packs
itilreporting.bsky.social
@itilreporting.bsky.social
· 1d
Using a macro in excel, create a new file with a new sheet
www.itilreporting.com/excel/macro/...
#excelmacro
Create a new file with new sheet using a macro in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· 6d
Using a formula in excel, convert a time zone to another one
www.itilreporting.com/excel/formul...
#excel
Convert European time into other country times with a formula in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· 20d
In Power BI, calculate values of a column by row
www.itilreporting.com/powerbi/powe...
#powerbi
Power BI: calculate values of a single column by row
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· 22d
Refresh a Power BI dashboard with Power Automate by month, by year, etc.
www.itilreporting.com/powerautomat...
#powerautomate
Power Automate: refresh Power BI
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· 27d
Using a cloud script for excel to find the last row
www.itilreporting.com/excel/script...
#excelscript
Find the last row using office script in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Sep 20
In excel with a macro, create an automatic backup of the files in case if the original file gets corrupted
www.itilreporting.com/excel/macro/...
#excelmacro
Create a backup of the excel report using a macro
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Sep 13
Using a formula in excel, convert cell into a "real" date format
www.itilreporting.com/excel/formul...
#excelformula
Convert cell into real date format with a formula in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Sep 9
In Power BI, calculate values of each row for the same column
www.itilreporting.com/powerbi/powe...
#powerbi
Power BI: calculate values of a single column by cell
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Sep 6
Planned your action based on a specific date for your workflow in Power Automate
www.itilreporting.com/powerautomat...
#powerautomate
Power Automate: previous and/or next date/time (hour, month, year, etc.)
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Aug 12
With an office script in an excel, extract words
www.itilreporting.com/excel/script...
#excelscript
Extract words from a cell using office script in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Aug 7
With a macro in excel, know how many rows and columns
www.itilreporting.com/excel/macro/...
#excelmacro
Count the number of rows and columns using a macro in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Aug 3
Using a formula in an excel, convert numbers into time
www.itilreporting.com/excel/formul...
#excelformula
Convert a decimal number into hour/minute/second with a formula in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 31
In Power BI, calculate values of previous or next month within a range
www.itilreporting.com/powerbi/powe...
#powerbi
Power BI: calculate values of a previous/next month and within a range based on selected month with a filter
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 29
Create a workflow in Power Automate to send Power BI alerts by email with an excel file
www.itilreporting.com/powerautomat...
#powerautomate
Power Automate: Power BI alerts to be sent by email from an excel file based on condition
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 18
With an office script in an excel file, extract the date
www.itilreporting.com/excel/script...
#excelscript
Extract the day, month or year from cell using office script in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 14
Using a macro in an excel, count the data then copy them to another sheet
www.itilreporting.com/excel/macro/...
#excelmacro
Count the current data then copy to another sheet using a macro in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 10
Check if a number is between 2 values in an excel with a formula
www.itilreporting.com/excel/formul...
#excelformula
Check if the value is between 2 numbers with a formula in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 7
With Power BI, calculate the value of a specific criteria then show 0 instead of blank
www.itilreporting.com/powerbi/powe...
#powerbi
Power BI: calculate values for a specific object and show 0 instead of blank
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 5
Create Power BI alarm with Power automate and include multiple persons
www.itilreporting.com/powerautomat...
#powerautomate
Power Automate: include other people to a Power BI alarm
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jul 1
With an office script in an excel, extract specific values
www.itilreporting.com/excel/script...
#excelscript
Extract particular words with an updated range using an office script in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jun 29
With a macro in excel, count words and copy, split... in one single click
www.itilreporting.com/excel/macro/...
#excelmacro
Count number of words and more actions (split, copy, etc.) using a macro in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jun 27
In excel with a formula, check if it is a bank holiday after combining day and month
www.itilreporting.com/excel/formul...
#excelformula
Check if the day is a bank holiday after converting day and month into one single cell with a formula in an excel report
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jun 26
In Power Bi, calculate values using multiple criteria
www.itilreporting.com/powerbi/powe...
#powerbi
Power BI: calculate values based on multiple unique conditions
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jun 25
In Power Automate, create an automatic email with pictures, tables and more
www.itilreporting.com/powerautomat...
#powerautomate
Power Automate: email in html (table, link, image, etc.)
www.itilreporting.com
itilreporting.bsky.social
@itilreporting.bsky.social
· Jun 22
With a cloud script in excel, delete spaces
www.itilreporting.com/excel/script...
#excelscript
Delete unnecessary space using office script in an excel report
www.itilreporting.com
