Pages
Category
- Article
- ChatGPT
- Request an explanation of Excel formulas.(ChatGPT)
- Request to prepare a response to the complaint.(ChatGPT)
- Inquire about Excel functions and formulas.(ChatGPT)
- Request ideas(ChatGPT)
- Request ChatGPT to make a table of contents.
- Asked Dr. ChatGPT What is important for a successful implementation of Power Automate Desktop in an organization.
- Asked Dr. ChatGPT about "What is important to use ChatGPT".
- Ask ChatGPT to respond in multiple languages.
- Request multiple patterns of text creation from ChatGPT.
- Asked Dr. ChatGPT about "How to increase productivity at work."
- Request content and documentation from ChatGPT
- Request a translation from ChatGPT.
- How to deal with ChatGPT responses that are interrupted in the middle of a response.
- Memorize the role.(ChatGPT)
- Request for create a summary.(ChatGPT)
- How to use ChatGPT in Excel.(Power Automate)
- How to use ChatGPT in Microsoft Teams.(Power Automate Cloud flow)
- How to use ChatGPT.(Power Automate Cloud flow)
- How to use ChatGPT.(Microsoft Excel)
- How to use ChatGPT.(Power Automate Desktop)
- How to get an API key (secret key) for ChatGPT.
- JavaScript
- Microsoft Excel
- Data(Microsoft Excel)
- Formula(Microsoft Excel)
- Function(Microsoft Excel)
- Information(Microsoft Excel Function)
- Logical(Microsoft Excel Function)
- ISOMITTED function. Function to define optional arguments.(Microsoft Excel)
- BYCOL Function. Split a cell range by columns and tally by column.(Microsoft Excel)
- SCAN function. Create a cell range for cumulative calculations.(Microsoft Excel)
- BYROW Function. Split a cell range by rows and tally by row.(Microsoft Excel)
- LET Function. Attach any name to the result of a formula.(Microsoft Excel)
- IF function.Change the result of the formula according to the results of the comparison.(Microsoft Excel)
- MAKEARRAY Function. Create a range of cells and set formulas for individual cells.(Microsoft Excel)
- REDUCE Function. Cumulative calculation of a cell range.(Microsoft Excel)
- MAP function. Decompose cell range and retrieve individual cells.(Microsoft Excel)
- LAMBDA function.Create your own function.(Microsoft Excel)
- Lookup & Reference(Microsoft Excel Function)
- UNIQUE function. Remove duplicates in range of cells.(Microsoft Excel)
- SORTBY Function. Sort range of cells.(Microsoft Excel)
- ROWS and COLUMNS functions. Get the number of rows and columns in a cell range.
- INDEX Function. Retrieves values by specifying range of cells, number of rows, and number of columns.(Microsoft Excel)
- MATCH Function. Obtains the relative position of a cell as a result of a search.(Microsoft Excel)
- HLOOKUP function. Searching for data.(Microsoft Excel)
- VLOOKUP function. Searching for data.(Microsoft Excel)
- FILTER function. Get all rows matching the condition.(Microsoft Excel)
- SORT Function. Sort range of cells.(Microsoft Excel)
- OFFSET Function. Get a cell by specifying the distance from the reference cell, height and width.(Microsoft Excel)
- WRAPROWS and WRAPCOLS functions. Sort specified range of cells in a single column or row by a specified number of rows or columns.
- VSTACK and HSTACK functions.Merge multiple range of cells.(Microsoft Excel)
- CHOOSEROWS and CHOOSECOLS functions. Obtain rows and columns at specified positions from range of cells.(Microsoft Excel)
- EXPAND Function. Expand range of cells.(Microsoft Excel)
- TOROW Function. Sort range of cells into a single row.(Microsoft Excel)
- TOCOL Function. Sort range of cells into a single column.(Microsoft Excel)
- TAKE Function. Get rows and columns from range of cells.(Microsoft Excel)
- DROP Function. Deletes rows and columns from range of cells.(Microsoft Excel)
- XLOOKUP function. Searching for data.(Microsoft Excel)
- Math & Trig(Microsoft Excel Function)
- GCD function. The greatest common divisor.(Microsoft Excel)
- LCM Function.Least common multiple.(Microsoft Excel)
- RANDBETWEEN function. Obtains a random number within the specified range.
- SUMIF function. Sum the values of cells matching the criteria.(Microsoft Excel)
- SUM Function. Sums numbers.(Microsoft Excel)
- MOD function. Surplus.(Microsoft Excel)
- RANDARRAY function. Random numbers in multiple cells.(Microsoft Excel)
- Statistical(Microsoft Excel Function)
- Text(Microsoft Excel Function)
- TEXT Function. Obtains text with formatting applied to numbers and dates.(Microsoft Excel)
- CONCATENATE Function. Concatenate strings.(Microsoft Excel)
- FIND Function. Finds the position of a string.(Microsoft Excel)
- SUBSTITUTE function. Substitutes the specified text.(Microsoft Excel)
- LEFT, MID, and RIGHT functions. Extracts strings by specifying the number of characters.(Microsoft Excel)
- LEN function. Length of a character string.(Microsoft Excel)
- CONCAT Function. Concatenate strings.(Microsoft Excel)
- TEXTSPLIT function. Split text into cells by specifying a delimiter.(Microsoft Excel)
- TEXTAFTER Function. Get substrings after a specified character (Microsoft Excel)
- TEXTBEFORE function. Obtains a substring up to the specified characters.(Microsoft Excel)
- Web(Microsoft Excel Function)
- Introduction(Microsoft Excel)
- Office Scripts(Microsoft Excel)
- Cells cut/paste.(Microsoft Excel Office Scripts)
- Cells copy/paste.(Microsoft Excel Office Scripts)
- Insert cells, rows, and columns.(Microsoft Excel Office Scripts)
- Clear cells, rows, and columns.(Microsoft Excel Office Scripts)
- Delete cells, rows, and columns.(Microsoft Excel Office Scripts)
- Set value to cell / Get value from cell.(Microsoft Excel Office Scripts)
- Basic operations.(Microsoft Excel Office Scripts)
- Script Recording and Run.(Microsoft Excel Office Scripts)
- Tips(Microsoft Excel)
- How to use ChatGPT in Excel.(Power Automate)
- How to use ChatGPT.(Microsoft Excel)
- Calculating the median in a Pivot table. Its alternative method.(Microsoft Excel)
- Formula for extracting URL parameter values.(Microsoft Excel)
- Formula for cross tabulation in Spill.(Microsoft Excel)
- How to extract only numbers from text.(Microsoft Excel)
- How to reverse text.(Microsoft Excel)
- How to remove duplicates and count them.(Microsoft Excel)
- How to put a blank in the first candidate in the pull-down.(Microsoft Excel)
- How to replace multiple texts with the SUBSTITUTE function.(Microsoft Excel)
- Formula to get the last result with the VLOOKUP function.(Microsoft Excel)
- Formula to get the image with the VLOOKUP function.(Microsoft Excel)
- How to get the left side value with the VLOOKUP function.(Microsoft Excel)
- Formulas that combine the INDEX and MATCH functions to perform searches better than the VLOOKUP function.(Microsoft Excel)
- Formula to randomly extract a specified number of cells from a range of cells.(Microsoft Excel)
- Formulas to randomly reorder a range of cells.(Microsoft Excel)
- Formulas to extract text from a cell every specified number of letters.(Microsoft Excel)
- Formulas to sort text in cells.(Microsoft Excel)
- Formulas to remove multiple types of characters from cell text.(Microsoft Excel)
- Formula to split text into cells one character at a time.(Microsoft Excel)
- Formula to extract only rows with values.(Microsoft Excel)
- How to display Hit if the item exists and Miss if it does not exist using the VLOOKUP function.(Microsoft Excel)
- Notion AI
- Power Automate Cloud flow
- Power Automate Desktop
- Action(Power Automate Desktop)
- Excel(Power Automate Desktop Action)
- Add new worksheet Action(Power Automate Desktop)
- Get first free row on column from worksheet Action(Power Automate Desktop)
- Insert column to Excel worksheet Action(Power Automate Desktop)
- Delete row from Excel worksheet Action(Power Automate Desktop)
- Insert row to Excel worksheet Action(Power Automate Desktop)
- Paste cells to Excel worksheet Action(Power Automate Desktop)
- Copy cells from Excel worksheet Action(Power Automate Desktop)
- Get selected cell range from Excel worksheetAction(Power Automate Desktop)
- Activate cell in Excel worksheet Action(Power Automate Desktop)
- Get active cell on Excel worksheet Action(Power Automate Desktop)
- Save Excel Action(Power Automate Desktop)
- Close Excel Action(Power Automate Desktop)
- Get first free column/row from Excel worksheet Action(Power Automate Desktop)
- Set active Excel worksheet Action(Power Automate Desktop)
- Attach to running Excel Action(Power Automate Desktop)
- Delete column from Excel worksheet Action(Power Automate Desktop)
- Write to Excel worksheet Action(Power Automate Desktop)
- Launch Excel Action(Power Automate Desktop)
- Read from Excel worksheet Action(Power Automate Desktop)
- File(Power Automate Desktop Action)
- Text(Power Automate Desktop Action)
- Excel(Power Automate Desktop Action)
- Data type(Power Automate Desktop)
- Introduction(Power Automate Desktop)
- Asked Dr. ChatGPT What is important for a successful implementation of Power Automate Desktop in an organization.
- Automated basic text file operations.(Power Automate Desktop)
- Features and Benefits of Utilization.(Power Automate Desktop)
- Conditional Branch.If and Switch.(Power Automate Desktop)
- Error (Exception) handling.(Power Automate Desktop)
- Loop(Power Automate Desktop)
- List(Power Automate Desktop)
- Data table(Power Automate Desktop)
- Message boxes(Power Automate Desktop)
- Tips(Power Automate Desktop)
- Select cells in Excel worksheet Action(Power Automate Desktop)
- How to delete multiple rows/columns in Excel.(Power Automate Desktop)
- How to open Excel in the background.(Power Automate Desktop)
- Insert empty rows in Excel worksheet, one row at a time.(Power Automate Desktop)
- Delete rows of Excel with specific conditions.(Power Automate Desktop)
- Move to the specified cell in the Excel book.(Power Automate Desktop)
- Create a table of contents for sheet names in an Excel book.(Power Automate Desktop)
- How to get the last row and last column of an Excel book.(Power Automate Desktop)
- How to record the contents of an incoming email line by line in an Excel book.(Power Automate Desktop)
- How to convert Excel files to CSV files.(Power Automate Desktop)
- How to convert CSV files to Excel files.(Power Automate Desktop)
- How to value paste value in Excel.(Power Automate Desktop)
- How to get the mode.(Power Automate Desktop)
- How to get the standard deviation.(Power Automate Desktop)
- How to get the median.(Power Automate Desktop Action)
- How to convert between Roman numerals and Arabic numerals.(Power Automate Desktop)
- How to get the least common multiple and greatest common divisor.(Power Automate Desktop)
- How to get the number of business days within a specified period.(Power Automate Desktop)
- How to get the number of business days for a specify month.(Power Automate Desktop)
- How to get the last business day of the specified month.(Power Automate Desktop)
- Send newsletter. Email one line at a time from an Excel book.(Power Automate Desktop)
- How to get the deviation.(Power Automate Desktop)
- How to use ChatGPT.(Power Automate Desktop)
- How to rank a list of numbers.(Power Automate Desktop)
- How to convert URL parameters (GET parameters) into Data table.(Power Automate Desktop)
- How to leave only the GET parameter from the URL.(Power Automate Desktop)
- What to do if the specified file does not exist.(Power Automate Desktop)
- Action(Power Automate Desktop)
- Python
- Warlords
- ChatGPT
- uncategorized