FinanceTier 020 minbeginner

Navigate a General Ledger

Move through a large general ledger quickly without losing track of which row is which.

What you will learn

• Use Ctrl+End and Ctrl+Home to find the true boundaries of a ledger
• Recognise a header row does not count as a data row when reporting a row count
• Distinguish an original-currency column from a converted-to-ZAR column

Excel skills

Grid navigation, Ctrl+End/Home · Worksheet Navigation

The task

This general ledger has 80 data rows beneath its header row. In F2, write a formula that counts how many data rows there actually are - not a number you count or type in by hand.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free