Works matching AU Jelen, Bill
Results: 199
Excel: Improving Pivot Tables with MDX.
- Published in:
- Strategic Finance, 2024, p. 49
- By:
- Publication type:
- Article
Excel: Copilot for Excel Adds Advanced Python Analysis.
- Published in:
- Strategic Finance, 2024, p. 6
- By:
- Publication type:
- Article
Excel: Calculated Items in a Pivot Table.
- Published in:
- Strategic Finance, 2024, p. 1
- By:
- Publication type:
- Article
Excel: AVERAGEIFS with Two Conditions In The Same Column.
- Published in:
- Strategic Finance, 2024, p. 1
- By:
- Publication type:
- Article
Prevent Others From Unhiding Columns in Excel.
- Published in:
- 2024
- By:
- Publication type:
- Instruction
Excel: Return Cells Visible from a Filter.
- Published in:
- Strategic Finance, 2024, p. 1
- By:
- Publication type:
- Article
Excel: Quickly Deleting All Blank Columns.
- Published in:
- 2024
- By:
- Publication type:
- Instruction
Scatter Chart with Colored Labels.
- Published in:
- 2024
- By:
- Publication type:
- Instruction
Filling Quarters in Excel.
- Published in:
- 2024
- By:
- Publication type:
- Instruction
Excel: Adding a Hierarchy to a Pivot Table.
- Published in:
- 2024
- By:
- Publication type:
- Product Review
Microsoft Copilot Brings More AI to Excel.
- Published in:
- 2024
- By:
- Publication type:
- Product Review
Microsoft Debuts GROUPBY and PIVOTBY Functions: Microsoft introduces two new functions that allow a formula to generate a summary that looks like a pivot table.
- Published in:
- 2023
- By:
- Publication type:
- Product Review
Python Inside of Excel: Microsoft brings support for Python into Excel, adding the power of the programming language within the familiar Excel environment.
- Published in:
- Strategic Finance, 2023, v. 105, n. 5, p. 59
- By:
- Publication type:
- Article
Stale Value Formatting in Excel: Manual calculation mode in Excel hasn't changed in 44 years. A new formatting feature shows which cells need to recalculate.
- Published in:
- Strategic Finance, 2023, v. 105, n. 4, p. 73
- By:
- Publication type:
- Article
Using a Picture as the Lookup Value in Excel: A new image data type in Excel allows you to find the name or description from a picture stored in a cell.
- Published in:
- 2023
- By:
- Publication type:
- Instruction
Modeling Risk Scenarios Using BASE: The BASE function helps to generate all possible combinations of several input variables to model future outcomes.
- Published in:
- Strategic Finance, 2023, v. 105, n. 2, p. 99
- By:
- Publication type:
- Article
Embedding a Range in a Word Document.
- Published in:
- 2023
- By:
- Publication type:
- Instruction
Excel: COMBINING SUBFORMULAS USING EXCEL LABS.
- Published in:
- 2023
- By:
- Publication type:
- Instruction
TEXT TO COLUMNS WITH TEXTSPLIT.
- Published in:
- 2023
- By:
- Publication type:
- Instruction
Excel: FORMULA DEBUGGING IN EXCEL.
- Published in:
- Strategic Finance, 2023, v. 104, n. 10, p. 56
- By:
- Publication type:
- Article
Excel: HOW WELL DOES CHATGPT KNOW EXCEL?
- Published in:
- Strategic Finance, 2023, v. 104, n. 9, p. 56
- By:
- Publication type:
- Article
MAX MINUS MIN IN A PIVOT TABLE.
- Published in:
- 2023
- By:
- Publication type:
- Instruction
Excel: USING THE FILTER FUNCTION FOR COLUMNS.
- Published in:
- Strategic Finance, 2023, v. 104, n. 7, p. 60
- By:
- Publication type:
- Article
Excel: CHOOSE A RANDOM WORKDAY.
- Published in:
- Strategic Finance, 2022, v. 104, n. 6, p. 60
- By:
- Publication type:
- Article
Excel: FIND DIFFERENCES WITH GO TO SPECIAL.
- Published in:
- 2022
- By:
- Publication type:
- Product Review
Excel: NEW FORMULA TO SHOW IMAGES IN EXCEL.
- Published in:
- 2022
- By:
- Publication type:
- Instruction
Excel: NEXT LARGER ITEM WITH XLOOKUP.
- Published in:
- Strategic Finance, 2022, v. 104, n. 3, p. 60
- By:
- Publication type:
- Article
VLOOKUP FOR SPEED.
- Published in:
- Strategic Finance, 2022, v. 104, n. 2, p. 60
- By:
- Publication type:
- Article
Excel FINDING TEXT AFTER A DELIMITER.
- Published in:
- Strategic Finance, 2022, v. 104, n. 1, p. 60
- By:
- Publication type:
- Article
FINDING PARTICULAR DAYS OF THE MONTH.
- Published in:
- 2022
- By:
- Publication type:
- Instruction
Excel: IMPROVEMENTS TO VERSION HISTORY.
- Published in:
- 2022
- By:
- Publication type:
- Instruction
Excel: COMPARE TWO ITEMS IN A PIVOT TABLE.
- Published in:
- 2022
- By:
- Publication type:
- Instruction
Excel.
- Published in:
- 2022
- By:
- Publication type:
- Instruction
Excel: SORTING LEFT TO RIGHT.
- Published in:
- 2022
- By:
- Publication type:
- Instruction
Excel: CHANGES TO THE QUICK ACCESS TOOLBAR.
- Published in:
- 2022
- By:
- Publication type:
- Product Review
Excel.
- Published in:
- 2021
- By:
- Publication type:
- Instruction
Excel FULL-SCREEN MODE AND SKETCH TYPES: They say no one knows every feature in Excel. This adage must apply to the Excel team in Redmond, Wash., because they just added a new full-screen mode feature to Excel when the old Full Screen View was never actually removed
- Published in:
- 2021
- By:
- Publication type:
- Product Review
Excel: CLEAN DATA WITH GET & TRANSFORM.
- Published in:
- 2021
- By:
- Publication type:
- Instruction
EXCEL SMOOTH SCROLLING FOR LARGE CELLS.
- Published in:
- Strategic Finance, 2021, v. 103, n. 3, p. 60
- By:
- Publication type:
- Article
SHOW CHANGES DEBUTS.
- Published in:
- Strategic Finance, 2021, v. 103, n. 2, p. 68
- By:
- Publication type:
- Article
EXcel: USING A SLICER ON A DASHBOARD.
- Published in:
- Strategic Finance, 2021, v. 103, n. 1, p. 60
- By:
- Publication type:
- Article
Excel: CALCULATIONS BASED ON VISIBLE ROWS.
- Published in:
- Strategic Finance, 2021, v. 102, n. 12, p. 58
- By:
- Publication type:
- Article
IS EXCEL'S ROUNDING SKEWING DATA?: Excel has a very elementary take on rounding. It's the same method you learned early in grade school: If you're rounding to a whole number, decimals from 0.1 to 0.4 round down and decimals from 0.5 to 0.9 round up. But always rounding 0.5 up may cause problems
- Published in:
- Strategic Finance, 2021, v. 102, n. 11, p. 58
- By:
- Publication type:
- Article
USE SEQUENCE TO LOOP THROUGH CHARACTERS.
- Published in:
- Strategic Finance, 2021, v. 102, n. 10, p. 58
- By:
- Publication type:
- Article
Excel: ENCAPSULATE COMPLEX FORMULAS IN LAMBDA.
- Published in:
- 2021
- By:
- Publication type:
- Instruction
FORMAT NUMBERS WITH FLASH FILL.
- Published in:
- 2021
- By:
- Publication type:
- Instruction
Excel: FUZZY MATCHING.
- Published in:
- 2021
- By:
- Publication type:
- Instruction
ADD YOUR OWN LINKED DATA TYPE: With the Microsoft 365 subscription model, the Excel team is able to release features every month. This allows it to release an early version of a feature and receive feedback on it before it's complete. One feature it has been using this strategy with is Linked Data Types, which now lets you create your own custom data type
- Published in:
- Strategic Finance, 2020, v. 102, n. 6, p. 58
- By:
- Publication type:
- Article
Excel: EXCEL PERFORMANCE IMPROVEMENTS.
- Published in:
- Strategic Finance, 2020, v. 102, n. 5, p. 56
- By:
- Publication type:
- Article
Excel: HACK FOR FILTERING A PIVOT TABLE.
- Published in:
- Strategic Finance, 2020, v. 102, n. 4, p. 56
- By:
- Publication type:
- Article