Tips that are genuinely useful will be posted here regularly. In the meantime, explore the tutorials below or check what's available in Powerutils 1.9. More tips are on the way — keep visiting!
Tip #01 · Dates
Always Enter Dates with DATE()
Whenever you enter a date, use
=DATE(year, month, day). It takes a second longer but you can reliably perform date arithmetic — adding days, calculating differences, sorting — without regional format confusion.Tip #02 · Functions
Master These 8 Essential Functions
Invest time learning these — they will come as a blessing in critical moments every week:
=IF =AND =OR=LEFT =MID =RIGHT=LEN =VLOOKUPTip #03 · Text
Concatenate Smartly with &
The
& character joins cells or adds text inline. Example: ="Today is "&D1. Put =NOW() in D1, format as a date, make font white. Use this for dynamic labels in dashboards.Tip #04 · Accuracy
Always Wrap Formulas with ROUND()
Use
=ROUND(formula, n) where n is the decimal places. Without it, 2.3 + 2.3 formatted to zero decimals can display as 2 + 2 = 5. Your boss will not be happy. ROUND prevents the most embarrassing spreadsheet errors.
💡
More tips coming soon. Have a tip you'd like to share? Email the author — great suggestions will be added to this page with full credit.
Related Tutorials
Ready to go deeper? These step-by-step tutorials cover the most important Excel functions with worked examples.
🔍
VLOOKUP — Look up data from large ranges
Step-by-step tutorial with downloadable example file
→
⚙
IF, AND, OR — Multi-criteria decisions
Salary analysis and employee categorisation examples
→
∑
SUMIF & COUNTIF — Conditional aggregation
Count and sum data based on specific criteria
→