COMBINA Function in Excel: Combinations With Repeats
COMBINA counts selections where the same item can be chosen more than once — scoops of ice cream from four flavours.
Read article →Atul Vij
MUNIT Function in Excel: Identity Matrix
MUNIT Function in Excel: Identity Matrix
MUNIT returns an identity matrix — 1s on the diagonal, 0s elsewhere. Handy for checking MINVERSE results.
Read article →Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
Office Scripts in Excel for the Web: Your First Script, Explained Like VBA
What Office Scripts are, how they differ from VBA, how to record and edit a script, a real clean-up example in TypeScript, and how…
Read article →CEILING.PRECISE Function in Excel: Round Up to a Multiple (Sign-Safe)
CEILING.PRECISE Function in Excel: Round Up to a Multiple (Sign-Safe)
CEILING.PRECISE rounds up to a multiple regardless of the signs of number and significance; negatives round toward zero.
Read article →Word Lesson 10: PDF, Sharing and Co-authoring
Word Lesson 10: PDF, Sharing and Co-authoring
Finish and share documents properly: inspect and remove hidden data, save as PDF with bookmarks, restrict editing, protect with a password, share OneDrive links…
Read article →ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING Function in Excel: Round Up, Ignoring the Sign
ISO.CEILING always rounds towards positive infinity, whatever the sign of the multiple — useful when data mixes positive and negative adjustments.
Read article →Word Lesson 9: Word Shortcuts That Matter
Word Lesson 9: Word Shortcuts That Matter
The keyboard shortcuts that make a real difference in Word: selecting text, formatting, styles, Find and Replace, change case, repeat last action, navigation and…
Read article →Word Lesson 8: Templates and Quick Parts
Word Lesson 8: Templates and Quick Parts
Stop rebuilding the same letter: create a company letterhead template (.dotx), start new documents from it, save reusable blocks with Quick Parts and AutoText,…
Read article →Word Lesson 7: Track Changes and Comments
Word Lesson 7: Track Changes and Comments
Review documents without losing anyone’s edits: turn on Track Changes, choose markup views, accept or reject edits, reply to and resolve comments, lock tracking…
Read article →Word Lesson 5: Images, Shapes and Text Wrapping
Word Lesson 5: Images, Shapes and Text Wrapping
Insert pictures and icons, compress them, control text wrapping and position so images stop jumping around, anchor and lock them, add captions, and use…
Read article →FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR Function in Excel: Round Down to a Multiple (Classic)
FLOOR rounds down to a multiple — full boxes you can ship, 15-minute billing blocks.
Read article →Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins
Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins
Machine learning starts with a straight line. Fit a regression in Excel with SLOPE, INTERCEPT, RSQ, LINEST and FORECAST.LINEAR, and learn how to read…
Read article →