Excel Mastery 2

What's inside

Excel Mastery 2: 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, 206 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 Dates & Times: DATE, EOMONTH, NETWORKDAYS, Time Math & Schedules
• Excel Lookup Masterclass: XLOOKUP, INDEX/MATCH, VLOOKUP & Two-Way Lookups
• Excel Text Functions: LEFT, MID, FIND, SUBSTITUTE & Clean Data
• Excel Data Validation & Error-Proof Templates
• Excel Conditional Formatting: Highlight Rules, Data Bars & Heat Maps
• Excel Financial Functions: PMT, IPMT, NPV, XNPV, IRR, XIRR & RATE
• Excel Statistical Functions: AVERAGEIFS, MEDIAN, PERCENTILE, RANK & FREQUENCY
• SUMPRODUCT & Array Formulas: Multi-Condition Sums, Counts and Lookups
• Excel Formula Errors & Auditing: #N/A, #VALUE!, #REF! and How to Fix Them
• Excel Rounding & Precision: ROUND, MROUND, CEILING, Currency & Floating-Point Traps

Details

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