Free study guides

Short guides to the topics exams test hardest.

Each guide is free, stands on its own, and links to the course it comes from if you want the full lessons and practice questions.

• Part 107 Test PrepPart 107 airspace cheat sheet: classes, authorization and LAANCWhich airspace needs FAA authorization for a Part 107 drone flight, how LAANC and UAS facility maps work, and the chart details the knowledge test asks about.
• Part 107 Test PrepPart 107 operating limits: altitude, speed, visibility and cloud clearanceThe numbers every remote pilot must know under 14 CFR Part 107: 400 feet AGL, 87 knots, 3 statute miles visibility, 500 feet below and 2,000 feet horizontally from clouds, and the rules around them.
• Part 107 Test PrepHow to read a METAR and a TAF for the Part 107 testA plain-English walk through aviation weather reports: wind, visibility, weather codes, sky condition and ceilings in a METAR, and the FM, TEMPO and PROB groups in a TAF.
• Six Sigma Test PrepDMAIC explained: the five phases of a Six Sigma projectDefine, Measure, Analyze, Improve and Control: what each Six Sigma DMAIC phase is for, the typical tools, and the questions each phase must answer before moving on.
• Six Sigma Test PrepCp vs Cpk: process capability explainedWhat Cp, Cpk, Pp and Ppk measure, how to calculate them, why Cpk can never exceed Cp, and the assumptions that must hold before any capability index means anything.
• Six Sigma Test PrepWhich control chart should I use? A Six Sigma decision guideChoosing between I-MR, X-bar and R, X-bar and S, p, np, c and u control charts, plus how control limits differ from specification limits.
• CPC Exam PrepHow an ICD-10-CM code is built, and why the seventh character mattersThe structure of an ICD-10-CM diagnosis code for CPC exam preparation: category, etiology, anatomic site, severity, the seventh character, and the placeholder X.
• CPC Exam PrepCPT modifiers cheat sheet for the CPC examThe CPT and HCPCS Level II modifiers most often tested on the CPC exam: 25, 57, 59 and XE, XS, XP and XU, 51, 50, 26 and TC, 76 and 77, and the global-period modifiers 24, 78 and 79.
• CPC Exam PrepE/M coding by medical decision making: how the levels workHow evaluation and management levels are chosen by medical decision making or total time: the three MDM elements, the two-of-three rule, and common CPC exam traps.
• Project Management Certification PrepThe 2026 PMP® exam outline: what changed and how to prepareThe PMP examination content outline that took effect in July 2026: the three domains and their weighting, why Business Environment grew, and what that means for study plans.
• Project Management Certification PrepEarned value management formulas, explained with one examplePV, EV and AC, cost and schedule variance, CPI and SPI, and the EAC, ETC, VAC and TCPI forecasts, worked through a single project example for project management exam preparation.
• Project Management Certification PrepPredictive, agile or hybrid: choosing a project approachHow predictive, adaptive (agile) and hybrid project approaches differ, what drives the choice, and how scenario questions on project management exams test it.
• Excel Master ClassXLOOKUP vs VLOOKUP vs INDEX/MATCH: which to use, and whenHow XLOOKUP, VLOOKUP and INDEX/MATCH differ, the mistakes each invites, and which lookup the Excel Expert (MO-211) skills expect you to know.
• Excel Master ClassExcel dynamic arrays: FILTER, SORT, UNIQUE and the spill rangeHow Excel's dynamic array functions work, what a spill range is, how to fix the #SPILL! error, and how to reference a spilled result with the # operator.
• Excel Master ClassPivotTable basics: build a summary report in Excel the right wayHow to prepare source data for an Excel PivotTable, what the Rows, Columns, Values and Filters areas do, and the refresh, grouping and Show Values As settings people miss.
• Private Pilot Knowledge Test PrepVFR weather minimums cheat sheet: 14 CFR 91.155 by class of airspaceThe visibility and cloud clearance a VFR pilot needs in each class of airspace, day and night, plus the surface-area and special VFR rules the private pilot knowledge test asks about.
• Private Pilot Knowledge Test PrepThe private pilot knowledge test (PAR): format, weighting and how to prepareHow the FAA Private Pilot Airplane knowledge test works: 60 scored questions in 2 hours, the 70 percent passing score, how the Airman Certification Standards weight the areas, and what to bring.