Word Track Changes and Compare: Review Documents Like a Pro
Use Track Changes, comments, Accept/Reject and Compare Documents in Microsoft Word to review contracts and reports — plus how to remove hidden tracked changes before sending.
Read article →Use Track Changes, comments, Accept/Reject and Compare Documents in Microsoft Word to review contracts and reports — plus how to remove hidden tracked changes before sending.
Read article →LogicalLevel: BeginnerAvailable in: Excel 2007+NOT flips TRUE to FALSE and back — useful for “everything except”.
Read article →Understand Git in plain English — repository, commit, branch, merge — and learn the eight commands that cover almost everything, with a first project walkthrough.
Read article →Start with R using a task you know from Excel: import a spreadsheet, summarise it by group, and draw a chart — in about 15 lines of code.
Read article →When you are ready to perform the recording, be sure you know the transaction you want to execute and the data that you can use. You should also know the screens you plan to visit and the fields you will fill in.
Read article →TextLevel: ExpertAvailable in: Excel 2007+FINDB is the byte-based version of FIND.Syntax=FINDB("b",text)ArgumentWhat it meanstextText to work.
Read article →ISBLANK returns TRUE only for truly empty cells. A formula returning "" is not blank to ISBLANK — a common surprise.
Read article →LEFTB returns the first characters based on bytes. In English (single-byte) setups it behaves exactly like LEFT; it differs only when a double-byte language (Japanese, Chinese, Korean) is the default editing language.
Read article →RIGHTB is the byte-based version of RIGHT; identical to RIGHT in English setups.
Read article →FIND returns where one text starts inside another. It is case-sensitive and does not allow wildcards — use SEARCH for that.
Read article →MID returns characters from the middle of a text, starting at a position you choose.
Read article →TextLevel: BeginnerAvailable in: Excel 2007+RIGHT returns the last characters of a text value.Syntax=RIGHT(text, [num_chars])ArgumentWhat it meanstextThe.
Read article →