Excel
Keeping minutes; find/replace; formatting
The Conditional Formatting tool on the Home tab, Cell Styles group offers something called Highlight Duplicate Values. Before you start jumping for joy, it really means values, not rows.
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?
Recover your outline levels in subtotal mode … Hide a row quickly … Create a table from anywhere inside a well-built list.
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.
Q. How can I avoid changing the data source each time my source data grows?
How is the new Excel Sumlfs different from SumIf, and how do you dissect a formula to troubleshoot?
Q. I’d like to provide a “legend” so people know what the different Conditional Formatting colors mean in Excel. How can I do this?
Q. My tables never look right when I paste them into PowerPoint. How should I paste Excel data into PowerPoint?
Q. How can I return characters to the left of a dash in an Excel cell using the LEFT function?
