8 Excel Features That Quickly Improve Your Work : Flash Fill, Paste Special & the Magic F4 Key

Learn Paste Special math, Flash Fill patterns, Go To Special filters, and the F4 shortcut to clean data fast and share Excel ...
MUO on MSN

Learning REDUCE in Excel completely changed how I use spreadsheets

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a ...
MUO on MSN

These wildcards in Excel are your secret weapon for faster, smarter searches

The asterisk (*) is the wildcard character that represents any sequence of characters, including when there are no characters at all. It’s the most flexible of the bunch, since it can replace any ...
BBC

How can bridging through 10 help me to add and subtract?

NARRATOR: Don't worry Snoot. A handy way of working out 5 add 7 is to make 10 first. Take your 5 shells Snoot, and add 5 from Fin's 7, which equals 10. That leaves 2 shells left over. So just add 2 to ...
BBC

Positive and negative numbers

What are positive and negative numbers? Any number above zero is a positive number. Positive numbers are written with no sign or a '\({+}\)' sign in front of them and they are counted up from zero to ...