Read this article first: Frustration = Feature Guarantee! (Table Row breaking across pages). Here we saw how to ask Word to manage repeating the header automatically across pages.
What I learnt today is that the Repeat Header Rows feature works across columns as well. This is very useful when we have a narrow table shown in multiple columns on the same page.
Finally, here is a proven set of best practices to make your Excel usage simpler, faster and more accurate.
Continue reading Excel Tables 12 – Standard Operating Procedure
Like column names, table names can also be used in formulas. Read the previous article to understand the context.
Continue reading Excel Tables 10 – Everything is in a name
Readable formulas in Excel tables are so nice, you will curse yourself for not noticing earlier (since 8 years!). Teach this to everyone around you – NOW! Show off
Continue reading Excel Tables 9 – Readable Formulas in Calculated Columns
Yes. It is not only formulas which get copied when you extend a table. Everything gets copied. Read on to find out about Automatic copying and how much time you are wasting by not knowing this!
Continue reading Excel Tables 8 – Automatic copying of everything!
Simple one. But deserves a separate article so that the world takes notice!
Continue reading Excel Tables 7 – Freeze “Pain”killer
Most probably, you have been missing this Auto-copy feature for the last 8 years. Take 3 minutes to find out how it can simplify your life and increase accuracy.
Continue reading Excel Tables 6 – Miraculous Formula Auto-Copy
Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify data into GOOD or BAD (requires clean-up).
Continue reading Excel Tables 5 – Good Data Checklist