Category: Excel

star rating in Excel, star rating in Power BI, star rating measure DAX

DAX Excel Excel DataViz Power BI

Create star rating in Excel or Power BI using DAX

by Janis Sturis January 13, 2023

jitter chart in Excel, scatter jitter plot in Excel

DataViz Excel Excel DataViz

Jitter chart in Excel with average line

by Janis Sturis January 7, 2023

PERSONAL.XLSB location, Personal Macro Workbook location

Excel PERSONAL.XLSB location in Windows

by Janis Sturis January 7, 2023

quarter from date in Excel, quarter in Excel from date

Get quarter in Excel from date – fast and easy

by Janis Sturis January 6, 2023

user name in Excel, Windows login in Excel, user name with Excel macros, Excel function returns user name, user name with VBA

Get the user name in an Excel cell with a formula or VBA macro

by Janis Sturis December 17, 2022

15-minute time intervals in Excel, time interval sequence in Excel, SEQUENCE function in Excel

How to generate time intervals in Excel

by Janis Sturis December 3, 2022

variables in Excel functions, Excel function LET

Define and use variables in Excel formula by using LET function

by Janis Sturis December 2, 2022

round time in Excel, round up to the nearest time interval in Excel, round down to the nearest time interval in Excel

Round time in Excel

by Janis Sturis December 2, 2022

time from DateTime in Excel

Extract time from DateTime in Excel

by Janis Sturis December 1, 2022

Excel axis conditional formatting with format code

Excel chart axis conditional formatting

by Janis Sturis November 11, 2022