Microsoft Excel
Paste Transposed in Excel and Keep Formula References! (Two Great Ways to Achieve that!)
Paste transposed in Excel without breaking formula references, using two methods: Find and Replace, or pasting links that keep the original values.
Microsoft Excel
Find and Filter unique Values in Excel (Only 4 Simple Steps!)
Find and filter unique values in Excel with the Advanced Filter in 4 steps, using X, Y, Z coordinate data. Filter in place or copy to a new range.
Microsoft Excel
If This AND/OR That (A Quick Excel Tip)
Test multiple conditions in Excel by combining the IF function with AND and OR, with simple examples for checking different cells or a single cell.
Microsoft Excel
IF This Then That? (Quick Excel Tip!)
Use the Excel IF function with a simple Cut or Fill elevation example, from basic syntax to nested IF statements for testing several conditions.
Microsoft Excel
How to Find and Remove Duplicates in Excel! (2 Easy Tricks!)
Find and remove duplicates in Excel with two easy tricks: highlight duplicate cells using Conditional Formatting, then delete the duplicate rows.
Microsoft Excel
Excel formulas are not working (8 Common Mistakes and Solutions)
Excel formulas not working? Check 8 common mistakes, including quoted numbers, wrong argument separators, parentheses, missing arguments and text formats.
Microsoft Excel
Excel Formulas are not working, not updating & calculating (Quick and Easy fixes!)
Get Excel formulas that are not working, updating or calculating back on track by switching calculation to Automatic or forcing a recalculation.
Microsoft Excel
Flip Columns in Excel - 2 Extremely Quick and Easy Methods!
Flip a column of data upside down in Excel with two quick methods, including a Sort trick with a helper column, plus a bonus tip for rows.
Microsoft Excel
How to Remove Background from Pictures Without Specialized Software? EASY!
Remove a picture background without Photoshop: use Set Transparent Color in Microsoft Office, or try free online tools for complex backgrounds.
AutoCAD Tips