by DerekHenry | Feb 28, 2024 | Efficiency, Excel Tips
QConditional Formatting Rules Manager Screenshot Close QConditional Formatting Menu Screenshot Close QConditional Formatting Screenshot - Stop If True Close QConditional Formatting Show For Sheet Screenshot Close QConditional Formatting Duplicate Values Rule...
by DerekHenry | Feb 21, 2024 | Efficiency, Excel Tips
QNamed Range Screenshot Close QName Box Screenshot Close QName Manager Screenshot Close QNamed Range Define From Selection Screenshot Close QNamed Range Navigation Screenshot Close QNamed Fixed Value Screenshot Close QNamed Range Relative Reference Screenshot Close...
by DerekHenry | Feb 14, 2024 | Efficiency, Excel Tips
Overview Formulas are the backbone of Excel. Without them, it wouldn’t be much more useful than grid paper. Whether they are simple or extremely complex, they power calculations of all kinds, from finance to engineering to generic data analysis. If you’re...
by DerekHenry | Feb 7, 2024 | Efficiency, Excel Tips
Overview We’ve all heard the phrase “garbage in, garbage out” when it comes to data quality. But it’s amazing how many companies still place such important decisions on bad data. It’s a problem across industries, functional groups, and...
Recent Comments