Все публикации

What is a Check Sheet? || Seven basic quality tools of quality #qualitytools #qualitytutorial

#excelfunctions Use function ROUND to round up or down to a decimal place defined #exceltips

#30secexceltips How to select only constants from a spreadsheet #exceltips

#30secexceltips How to fast copy with CTRL + D or CTRL + ' #exceltips

#30secexceltips how to generate a series of random numbers #exceltips

#30secexceltips How to filter by a selected value #exceltips

#30secexceltips How to highlight duplicated values from a series #exceltips

#excelfunctions Use RANDARRAY to create a random array of numbers by row and column #exceltips

#excelfunctions Use Sequence to create a series of numbers using a start and step number #exceltips

Create Flow Charts in Excel || Flow Chart Template #qualitytools #qualitytoolsinexcel

#excelfunctions Use the function RANDBTWEEN to create one random number #exceltips

#30secexceltips How to re-arrange cell content to display in a different way without formulas

#30secexceltips How to add slicer filter to a spreadsheet #exceltips

#30secexceltips How to separate cell content to different columns without formulas #exceltips

#30secexceltips How to create a list without duplicate records with unique #exceltips

#excelfunctions Use function AverageA to calculate the average from a range, consider text as 0

#30secexceltips How to add a status bar to a cell #exceltips

#30secexceltips How to create an email from a list of addresses #exceltips

#excelfunctions Use ISNA to evaluate if a value in a cell is an NA error #exceltips

What is a Flow Chart? || Seven basic tools of quality #qualitytools #qualitytutorial

#30secexceltips How to combine cells without formulas #exceltips

#30secexceltips How to keep column headers visible with freeze panes #exceltips

What are the Seven Basic Tool of quality #qualitytutorial #qualitytools

#30secexceltips How to create a drop down list, also called validation list #exceltips