Simon Merrett

[Simon Merrett @SimonMerrett]

#ExcelExpert: If you've put in dates properly, you can find the difference in days, test for expiry dates, etc

[Simon Merrett @SimonMerrett]

#ExcelExpert: Don't enter dates with full stops. Use slash (/) or dash (-). Otherwise Excel doesn't see them as dates.

[Simon Merrett @SimonMerrett]

#ExcelExpert: IF statements can be up to 64 levels deep, but beyond 3 levels makes your head spin!

[Simon Merrett @SimonMerrett]

#ExcelExpert: make the column width fit all its data by double-clicking at the top. A useful timesaver!
https://t.co/sowOaW6rxs

[Simon Merrett @SimonMerrett]

#ExcelExpert: Happy New Year

[Simon Merrett @SimonMerrett]

#ExcelExpert: Happy New Year

[Simon Merrett @SimonMerrett]

#ExcelExpert: Happy New Year

[Simon Merrett @SimonMerrett]

#ExcelExpert: Online data often download as a csv file: commas separate the values, and opens in Excel as a single column

[Simon Merrett @SimonMerrett]

#ExcelExpert: Avoid using asterisk [*] or a question mark in text because they are wild cards used in searches

[Simon Merrett @SimonMerrett]

#ExcelExpert: Freeze panes is a toggle [1st time it switches on, 2nd time it switches off, 3rd time, on, etc

[Simon Merrett @SimonMerrett]

#ExcelExpert: to freeze panes go to View, Freeze Panes

[Simon Merrett @SimonMerrett]

#ExcelExpert: Use freeze panes to see your data and the column headings at the same time

[Simon Merrett @SimonMerrett]

#ExcelExpert: There's often several ways of doing some thing, eg using the menu, right clicking, and Ctrl+V are 3 ways to Copy

[Simon Merrett @SimonMerrett]

#ExcelExpert: To extract characters from inside a string, use =mid(cell-addr,start, no of chars), eg =mid(A3, 5, 4)

[Simon Merrett @SimonMerrett]

#ExcelExpert: In 2007 use Ctrl+F2 to jump to Print Preview

[Simon Merrett @SimonMerrett]

#ExcelExpert: If something unexpected happens use Undo. Don't try fixing it yourself: it could make matters worse!

[Simon Merrett @SimonMerrett]

#ExcelExpert: Use Autofilter to quickly identify and analyse groups of data in your spreadsheet

[Simon Merrett @SimonMerrett]

@AndrewEMogford Very true.

[Simon Merrett @SimonMerrett]

#ExcelExpert: It may seem a hassle, but it makes information more powerful if it's in the correct column

[Simon Merrett @SimonMerrett]

#ExcelExpert: By editing a cell, you can format individual words and characters

[Simon Merrett @SimonMerrett]

#ExcelExpert: To copy a format from one cell to another use the format brush