Advanced Spreadsheets teaches you skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.

Category

Formatting

Skill Set

Category

Formulas and Functions

Task Item

Skill Set

Formatting Charts

Skill Set

Task Item

Create named scenarios.

Show, edit, delete scenarios.

Create a scenario summary report.

Category

Enhancing Productivity

Skill Set

Skill Set

Automation

Task Item

Record a simple macro like: change page setup, apply a custom number format, apply autoformats to acell range, insert fields in worksheet header, footer.

Run a macro.

Assign a macro to a custom button.