JournalofAccountancy

Using Excel’s Goal Seek for data analysis

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?
Geeky Gadgets

Awesome no-code MS Excel data analysis tips and tricks

If you use Microsoft Excel on a daily basis you will already know how much of a vital tool it is for spreadsheet data analysis and calculations. However there are several no-code tips and tricks you ...
JournalofAccountancy

Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...
TechRepublic

microsoft excel data analysis

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components with this step-by-step tutorial. Microsoft Excel produces great charts, but ...