Guides
Practical Excel guides you can apply right away
Korean Year-End Tax Settlement Guide — 7 Strategies to Maximize Your Refund and Every Major Deduction Explained
How is the final tax liability calculated, and what determines your refund? A complete walkthrough of the 4-step calculation, every major tax credit, and 7 practical refund-boosting strategies under 2026 Korean tax law.
Korean Annual Leave Law 2026: Article 60 Guide (LSA Complete)
Complete guide to annual leave under Korean Labor Standards Act Article 60. Accrual rules (15 days + seniority), unused leave payout formula, menstrual leave, and rules for foreign workers in 2026.
BMI Complete Guide — Understanding Body Mass Index & Healthy Weight Management
What is BMI and how should you use it? Korean/Asian BMI standards, limitations of BMI, body fat percentage, waist circumference, and healthy weight management strategies.
Excel Budget Planner Guide — How to Track Income, Expenses & Savings Effectively
Learn how to create an effective Excel budget. 50/30/20 rule, expense categorization, auto charts, savings goals, and free template download.
ISO Certification Guide for SMEs — 9001, 14001 & 45001 Costs, Process & Preparation
Complete ISO certification guide for small and medium businesses. Compare ISO 9001/14001/45001, understand the audit process, estimate costs, find government subsidies, and prepare for internal audits.
Excel Invoice & Quotation Guide — Auto-Calculate Totals, Tax & Create Professional Documents
How to create professional invoices and quotations in Excel. Required fields, auto-calculation formulas, sequential numbering, PDF conversion, and free templates.
Percentage Calculator Guide — Discounts, Growth Rates & Ratios Explained Simply
Struggling with percentage calculations? From shopping discounts to salary raises, investment returns to tax rates — learn all common percentage formulas with practical examples.
Excel Charts: Complete Guide to Creating Visualizations
Learn how to create bar, pie, line, and combo charts in Excel — from inserting your first chart to formatting it for professional presentations.
Excel Conditional Formatting: Complete Guide
Learn how to use conditional formatting to automatically highlight important data with colors, data bars, icons, and custom formulas. Practical examples included.
Excel Data Validation: Complete Guide to Controlling Cell Input
Learn how to use Excel data validation to create dropdown lists, restrict numbers and dates, apply custom formulas, and configure error messages.
Excel IF Function & Nested IF: A Practical Guide
Learn the IF function from basics to nested IF, IFS, and AND/OR combinations with real-world examples you can use immediately.
Excel Pivot Tables: From Beginner to Pro
Learn how to create and use pivot tables to summarize thousands of rows in seconds. Covers slicers, grouping, calculated fields, and troubleshooting.
Essential Excel Keyboard Shortcuts (Windows & Mac)
A comprehensive reference of the most useful Excel keyboard shortcuts for navigation, formatting, data entry, formulas, and sheet management on both Windows and Mac.
SUMIFS Function in Excel: Multi-Criteria Sum Guide
Master the SUMIFS function to sum values based on multiple conditions. Covers date ranges, wildcards, comparison operators, and differences from SUMIF.
Master VLOOKUP in Excel: A Beginner's Complete Guide
Learn the VLOOKUP function step by step with practical examples. From basic syntax to error handling and the modern XLOOKUP alternative.
No results found.
Try a different search term.