PowerPoint Lesson 5: SmartArt and Diagrams
Turn bullet lists into processes, timelines, cycles and hierarchies with SmartArt, restyle them with theme colours, and convert to shapes when you need full…
Read article →Atul Vij
PowerPoint Lesson 4: Charts and Tables From Excel
PowerPoint Lesson 4: Charts and Tables From Excel
Show numbers clearly in PowerPoint: insert and edit charts, paste or link Excel charts, simplify (title with the point, direct labels, no clutter), and…
Read article →PowerPoint Lesson 3: Images, Icons and Designer
PowerPoint Lesson 3: Images, Icons and Designer
Use pictures well: full-bleed images, cropping to shape, stock images and icons, removing backgrounds, Designer suggestions, aligning objects, and compressing pictures so decks stay…
Read article →R Lesson 5: ggplot2 Charts
R Lesson 5: ggplot2 Charts
Make clean charts with ggplot2: the aesthetics-geometry idea, bar and line charts, ordering bars, labels and themes, and saving PNGs for reports.
Read article →PowerPoint Lesson 2: Writing Slides People Can Read
PowerPoint Lesson 2: Writing Slides People Can Read
Turn walls of text into slides that work: headline titles that state the point, one idea per slide, few words in large type, detail…
Read article →PowerPoint Lesson 1: Slide Layouts and the Slide Master
PowerPoint Lesson 1: Slide Layouts and the Slide Master
Use layouts instead of loose text boxes, change fonts, colours and logos once in the Slide Master, reset slides that drifted, and build a…
Read article →Beautiful Charts in R with ggplot2 (for Excel Users)
Beautiful Charts in R with ggplot2 (for Excel Users)
Build bar, line and scatter charts in R with ggplot2, and learn the “grammar of graphics” idea that makes every chart the same few…
Read article →Bank Reconciliation in TallyPrime (BRS) — Step by Step
Bank Reconciliation in TallyPrime (BRS) — Step by Step
Reconcile your bank account in TallyPrime: open the bank ledger, enter bank dates, import statements, and read the reconciliation statement to find unpresented cheques…
Read article →Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Get the latest price, last status or most recent date for an item with the famous LOOKUP(2,1/(range=value)) formula — explained step by step, plus…
Read article →CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC totals the principal part of loan payments between two periods — how much of the loan you actually cleared this year.
Read article →COVARIANCE.P Function in Excel: Covariance of a Whole Population
COVARIANCE.P Function in Excel: Covariance of a Whole Population
COVARIANCE.P measures how two complete data sets move together, dividing by n (COVARIANCE.S divides by n-1).
Read article →XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version
Look up a value using two conditions — product AND region, or employee AND month — with XLOOKUP, INDEX-MATCH, or a helper column. With…
Read article →