Excel Mastery 3

What's inside

Excel Mastery 3: 10 courses, 200 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 10 complete courses, 200 lessons, 202 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Excel Invoice & Quote Templates: Line Items, Tax, Numbering & Payment Tracking
• Sorting & Filtering with Formulas: Top-N Lists, Dynamic Rankings & Extracts (No FILTER Needed)
• Excel Time Intelligence: MTD, YTD, YoY, Rolling 12 Months & Fiscal Years
• Excel Named Ranges & Readable Models: Constants, Names and the Name Box
• Excel Trackers: Habit, Task, Expense & Goal Trackers with Formulas
• Excel Dynamic Arrays: FILTER, SORT, UNIQUE, SEQUENCE & Spill Ranges
• Excel LET & LAMBDA: Readable Formulas, Custom Functions & MAP/REDUCE
• Pivot-Style Summary Reports with Formulas: UNIQUE, SUMIFS, Cross-Tabs & Subtotals
• Percentages in Excel: Percent Change, % of Total, Markup vs Margin & CAGR
• Excel Calendars & Schedules: Dynamic Monthly Calendar, Shift Rota & Gantt with Formulas

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	525
Series	The Tabellab Workbook, volume 3
Author	Babala Özdemir
Delivery	Instant download after payment