Excel
Data stored in defined web page tables is now more accessible directly.
It might take some maneuvering, but you can probably disassemble a file with funky dates, then reassemble it with text functions.
Two of them are new.
You may have heard the term; you may even be somewhat familiar with what it does. But do you know why you might need one?
Did you know that you can create maps from geographically recognizable data in Excel using standard country/region, state/province, county or postal code?
There are many tools to help you squeeze information out of your data, but it needs to be in the right shape.
In the newest version of Excel, you may have noticed the “data model.” This allows you to connect multiple datasets and analyze them as one.
Keeping minutes; find/replace; formatting
Q. Is there an easier way to create a formula across work sheets than clicking on each cell you want to add to the formula?
Q. I can’t get FlashFill to work in Excel 2013. What am I doing wrong?
The Office app remains a relatively new option for iPad users, but one that can really help you boost productivity when you can’t use your laptop or desktop computer.
Microsoft Office Certified Trainer answers two questions about pound signs and circular cell references.
Improve your Microsoft Excel skills and build better spreadsheets with these tips from OfficeTeam.
