Essentials · Foundations

Presentation

4 lessons and 56 marked steps, with a workbook to open in Excel alongside. Your first two lessons on LogicExcel are free with a free account; after that every lesson opens with the All-Access Pass.

1. 1. Number and date formattingAll-Access Pass

   Apply the built-in number, date and time formats, and explain why formatting changes what is drawn and never what is stored.

   14 marked steps

2. 2. Worksheet formatting and cell stylesAll-Access Pass

   Format a sheet for legibility using named cell styles rather than one-off manual formatting, and explain what that buys when the formatting has to change.

   14 marked steps

3. 3. Custom number formatsAll-Access Pass

   Write a custom number format to scale a figure to thousands, carry a unit, and draw negatives and zeros differently, without changing what the cell holds.

   14 marked steps

4. 4. Printing and page setupAll-Access Pass

   Set a print area, scale a wide sheet to the page, repeat headings on every page, and control where the breaks fall on a long list.

   14 marked steps

Finished Foundations? Sit the Foundations exam for its certificate.