Seikimatsu Kyūseishu Densetsu Excel Kansū Hokuto Hyakuretsu Ken (Gakken Plus, 2015) 世紀末救世主伝説 エクセル関数北斗百列拳

Table of contents

Introduction

1. Purpose of the book, how to use it, index by objective and by function (本書の目的, 本書の読み方, 目的別インデックス, 秘孔・奥義（関数）別インデックス)p. 4-20Presentation of the method, followed by two entry indexes, one by need and the other by function, with functions presented as vital points and secret techniques (秘孔・奥義).

Chapter 1: "The Law of Functions" (関数の掟) (p. 21-44)

1. Lessons 1 to 9, from mechanism to input and errorsp. 22-43Using a function, understanding its arguments, entering it quickly, copying it, reading cell formats and series values, reacting to an error, functions in a table.
2. Vital point transmission 1, wildcard charactersp. 44

Chapter 2: "Martial Arts and Combat Techniques of Calculation" (数値計算の拳法・闘技) (p. 45-62)

1. Lessons 10 to 18, adding, truncating, roundingp. 46-61Simple and conditional sums, subtotals, rounding to a multiple or to a number of digits, rounding up or down.
2. Vital point transmission 2, quotient and remainder of a divisionp. 62

Chapter 3: "These Are the Vital Points of Totaling and Analysis" (これが集計・分析の経絡秘孔だ) (p. 63-84)

1. Lessons 19 to 37, counting, averaging, rankingp. 64-83Simple and conditional averages, cell counting, ranks, extreme values, standard deviation, mode, conditional calculations on a column.
2. Vital point transmission 3, maximum and minimum under conditionp. 84

Chapter 4: "The Vital Points That Count Dates and Times" (日付や時間を数える経絡秘孔) (p. 85-100)

1. Lessons 38 to 48, dates, intervals, business daysp. 86-99Today's date, year, month and day, constructing a date, month offsets, end of month, day of the week, business days excluding weekends and holidays, durations in years, months and days.
2. Vital point transmission 4, extracting hours, minutes and secondsp. 100

Chapter 5: "Text Extraction and Replacement of the Man of Deep Love" (愛深き男の文字抽出・置換！) (p. 101-116)

1. Lessons 49 to 59, concatenating, searching, extractingp. 102-115Concatenation, replacement by search or by position, position of a string, extraction from the left, right or middle, length, removal of non-printable characters, phonetic reading.
2. Vital point transmission 5, unifying uppercase and lowercasep. 116

Chapter 6: "Processing by Condition with the Soft Fist" (柔の拳で条件別に処理をする) (p. 117-128)

1. Lessons 60 to 65, conditions and errorsp. 118-127Branching by a condition, all conditions or any of them, negation, replacement and detection of error values.
2. Vital point transmission 6, knowing the data type of a cellp. 128

Chapter 7: "The End of the Man Who Sought Data in a Table" (表からデータを探し求めた漢の最期！) (p. 129-136)

1. Lessons 66 to 68, table lookupp. 130-135Vertical lookup, value by row and column numbers, position of a data item.
2. Vital point transmission 7, row and column numbers of a cellp. 136

End-of-volume feature 1: "Rihaku of the Sea, of the Five Chariots of Nanto: The Document Creation Art of the Genius Strategist" (南斗五車星 海のリハク！天才軍師の書類作成術) (p. 137-154)

1. Lessons 69 to 72, four management documentsp. 138-153Sales table by day and by store, report card, invoice, directory with search function.
2. Vital point transmission 8, restricting input outside of a cellp. 154

End-of-volume feature 2: "I Am a Genius! Amiba's Time-Saving Shortcut Vital Point Laboratory" (おれは天才だ！アミバの時短ショートカット秘孔研究所) (p. 155-173)

1. Lessons 73 to 90, eighteen keyboard shortcutsp. 156-173Copy, multiple input, line break, sheet switching, selection, insertion, correction, undo, moving, repetition, saving.

End of Volume

1. Index by keyword, exercise file download (キーワード別インデックス, 練習ファイルのダウンロードについて)p. 174-177

Table of contents translated and entry compiled by Hokuto Chronicles from the original book. First published on October 6, 2026, updated on October 18, 2026. © 2026 Hokuto Chronicles. Any reuse, even partial or reworded, must credit Hokuto Chronicles with a link to this page.