R Lesson 1: Install R and RStudio
Install R and RStudio, find your way around the four panes, run code in the console and scripts, install packages, and set a project…
Read article →Excel, SAP, Oracle & automation tips — plus wacky facts
Install R and RStudio, find your way around the four panes, run code in the console and scripts, install packages, and set a project…
Read article →Start with Power Pivot in Excel: load tables to the Data Model, create relationships, write first DAX measures (SUM, DIVIDE, CALCULATE), build a pivot…
Read article →PERCENTILE returns the k-th percentile (inclusive). It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →CORREL returns a number between −1 and 1: near 1 means both rise together, near −1 means one falls as the other rises, near…
Read article →PERCENTILE.INC returns the value below which a given percentage of data falls — for salary bands, delivery-time targets and outliers.
Read article →STDEV.S measures how far values typically sit from the average (sample standard deviation). A small value means consistent; a large one means volatile.
Read article →POWER raises a number to a power; the ^ operator does the same. Its most useful business job is CAGR.
Read article →FLOOR.MATH rounds down to the nearest multiple — slabs, time buckets and whole units.
Read article →CEILING.MATH rounds up to the next multiple; FLOOR.MATH rounds down. Great for pricing and pack sizes.
Read article →TRUNC drops digits after a given point, moving towards zero. Unlike INT, TRUNC(−8.9) is −8.
Read article →QUOTIENT returns only the integer part of a division; MOD returns the remainder.
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…
Read article →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.