Essentials · Workpapers
Advanced Formulas
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. INDIRECT and variable referencesAll-Access Pass
Build a reference from text, and know the cost.
14 marked steps
- 2. SUMPRODUCTAll-Access Pass
Aggregate with conditions before the IFS functions can help.
14 marked steps
- 3. Dynamic arrays: UNIQUE, SORT, FILTER, SEQUENCEAll-Access Pass
Return a whole result set from one formula.
14 marked steps
- 4. Formula auditing and tracingAll-Access Pass
Trace precedents, evaluate step by step, find the fault.
14 marked steps
Finished Workpapers? Sit the Workpapers exam for its certificate.
Everything on LogicExcel for 27¢ a day
- 169 lessons and 1,932 steps, marked as you go
- 4 exams and a certificate to show an employer
- The full accounting course and 3 premium templates
- No ads on any page
The course and templates alone cost $168 bought separately.
Everything opens today. Full refund up to day 14. Cancel any time.
Monthly and yearly renew automatically until you cancel; cancel any time from your account. Lifetime is one payment. Every plan has a 14-day full refund. See the terms. Already paid? Email me my sign-in link · Teams and classes: email us