YouTube on MSN

Cell referencing in Excel (when to add a $ in a cell)

Cell Referencing in Excel — where to add the $ sign (using the F4 key) A clear walkthrough of absolute vs. relative cell referencing using the F4 shortcut. The video presents five examples (from easy ...

The laptop I lent out hasn't been returned. I consolidated my one-person IT department's ledger into a single Excel file (free version available)

When you are the only person handling IT in a company, the state of 'who has what' exists only in your own head.In my case, ...

Leave it to AI! An instruction template to build complex spreadsheet functions in 10 seconds

"Wait, was it VLOOKUP here? Or INDEX and MATCH...?" "I got an error (#N/A), but I have no idea what's wrong!"Data aggregation ...
MUO on MSN

Once you understand SCAN in Excel, you’ll never build formulas the same way

Build formulas that remember what came before.