目次
0章

絶対参照を学ぼう ·········································································· 1①データ入力 ························································································ 2②相対参照 ························································································· 2③絶対参照 ························································································· 3

1章

家計ノートを作ろう·········································································· 8①書式のコピー/貼り付け ··········································································· 8②行の挿入 ························································································ 11③列の挿入 ························································································ 13④セルの挿入 ······················································································ 14⑤日付の表示形式 ··············································································· 17⑥入力規則 ······················································································· 20⑦入力規則を使用した入力 ····································································· 24⑧ウィンドウ枠の固定 ·············································································· 27⑨SUMIF 関数 ··················································································· 30⑩SUMIF 関数の引数 ··········································································· 33⑪割合を計算する················································································· 40⑫パーセント スタイル ············································································· 41

2章

改ページプレビューを活用しよう ·························································· 42①改ページプレビューの表示 ······································································ 43②1 ページにおさめる方法 ········································································ 44③印刷の倍率を「拡大/縮小」に戻す ···························································· 48④改ページの挿入〈横に分割〉 ··································································· 49⑤改ページの挿入〈縦に分割〉 ··································································· 51⑥印刷範囲の変更 ··············································································· 53⑦改ページの移動 ················································································· 54⑧改ページプレビューを元の表示に戻す·························································· 55⑨ヘッダー・フッターの位置の調整 ································································· 56⑩ヘッダーの挿入 ·················································································· 59⑪フッターの挿入 ··················································································· 65⑫印刷タイトル····················································································· 70

3章

グラフに挑戦しよう①······································································ 75①データ入力 ······················································································ 76②棒グラフの作成 ·················································································· 76③グラフの要素····················································································· 79④グラフの移動〈手動〉 ············································································ 79⑤グラフのサイズ変更 ·············································································· 81⑥グラフタイトルの変更 ············································································ 82⑦グラフタイトルの書式設定〈文字〉 ······························································ 83⑧グラフの種類の変更 ············································································ 84⑨行/列の切り替え················································································ 88⑩グラフエリアの塗りつぶしの変更 ································································· 89⑪プロットエリアの塗りつぶしの変更 ······························································· 91⑫軸のオプション〈表示形式〉 ····································································· 93⑬離れたセル範囲のグラフの挿入 ································································ 96⑭系列の色の変更 ················································································ 99⑮軸のオプション〈表示単位〉 ··································································· 101⑯軸ラベルの文字列の方向 ···································································· 103⑰軸ラベルの移動 ··············································································· 105

やってみよう
4章⑱グラフ要素を追加 ············································································· 106
プロットエリアに図を挿入 ······································································ 108

グラフに挑戦しよう②···································································· 111①データ入力 ···················································································· 111②円グラフの作成 ················································································ 112③グラフの移動··················································································· 113④凡例を非表示にする ········································································· 115⑤データラベルの追加 ··········································································· 116⑥データラベルの分類名の追加 ································································ 117⑦グラフタイトルの書式設定〈塗りつぶし〉 ······················································ 121⑧既定のグラデーション ·········································································· 124⑨図形の挿入〈テキストボックス〉 ······························································· 127⑩図形の選択 ··················································································· 129⑪図形の拡大・縮小 ············································································ 130⑫図形の移動 ··················································································· 130⑬図形の挿入〈吹き出し〉 ······································································ 131⑭変形ハンドル ·················································································· 133⑮図形の書式設定 ············································································· 133⑯グラフだけを印刷 ·············································································· 136

5章

並べ替えとオートフィルター ······························································ 138①ファイルをドキュメントから開く·································································· 138②並べ替えとオートフィルター ···································································· 141③並べ替え〈昇順〉 ·············································································· 141④並べ替え〈降順〉 ·············································································· 145⑤複数のキーでの並べ替え ····································································· 146⑥オートフィルター ················································································ 151⑦オートフィルター〈１つの条件での抽出〉······················································ 153⑧すべてのデータ表示 ··········································································· 156⑨オートフィルター〈複数の条件での抽出〉 ····················································· 157⑩トップテンオートフィルター ······································································ 161⑪オートフィルターオプション ······································································ 163⑫行の非表示 ··················································································· 166⑬行の再表示 ··················································································· 167⑭列の非表示 ··················································································· 169⑮列の再表示 ··················································································· 170
ユーザー設定リスト ············································································· 172

やってみようさくいん ···································································································· 176※本書は「Microsoft Excel 2019」を使用して作成しています。

3章

グラフに挑戦しよう①

グラフに挑戦しよう①

3章

エクセルではグラフを簡単に作れます。
挑戦してみましょう。
〈よく使用するグラフ〉
棒グラフ

折れ線グラフ数量の大小の比較をした
い時などに使用します。

時系列に並べられた数量の推移を見たい時などに使用します。

円グラフ

構成比を見たい時などに使用します。

その他にも、グラフはいろいろあります。用途に合わせて使い分けましょう。

〈グラフに必要なデータ（例）〉
項目と系列を、表の大きさによってエクセルが自動的に判断し、グラフを作成します。
項目と系列を切り替えることもできます。
項目

1月

2月

3月

合計

電気

7569

10267

8731

26567

ガス

10367

5437

5983

21787

水道

3467

2796

3983

10246

系列

値

75

3章

グラフに挑戦しよう①➊データ入力「空白のブック」を開きましょう。

1

以下のデータを入力しましょう。その後「光熱費推移」とＵＳ
Ｂメモリに名前を付けて保存しましょう。
◢

A

B

C

D

E

Ｆ

1月

2月

3月

合計

1
2
3

電気

7569

10267

8731

26567

4

ガス

10367

5437

5983

21787

5

水道

3467

2796

3983

10246

6

合計はＳＵＭ関数を使用しましょう。

7
8❷棒グラフの作成
1

棒グラフを作成します。Ｂ２：Ｅ５を選択します。

◢

A

B

C

D

E

Ｆ

1月

2月

3月

合計

1
2
3

電気

7569

10267

8731

26567

4

ガス

10367

5437

5983

21787

5

水道

3467

2796

3983

10246

6

棒グラフに必要な条件として項目と系列と値が必要です。選択忘れのない
ようにしましょう。

7
8
9
10
76

3章

グラフに挑戦しよう①

2「挿入」タブをクリックします。

◢

A

B

C

D

E

Ｆ

1月

2月

3月

合計

1
2
3

電気

7569

10267

8731

26567

4

ガス

10367

5437

5983

21787

5

水道

3467

2796

3983

10246

クリック

6
7
8
9
挿入タブ

10

3

「縦棒/横棒グラフの挿入」をクリックします。

縦棒/横棒
グラフの挿入
◢

A

B

C

D

E

Ｆ

1月

2月

3月

合計

1
2
3

電気

7569

10267

8731

26567

4

ガス

10367

5437

5983

21787

5

水道

3467

2796

3983

10246

6
7
8
77

クリック

3章

グラフに挑戦しよう①

4「集合縦棒」をクリックします。

◢

A

B

C

D

E

Ｆ
集合縦棒

1

1月

2

2月

3月

合計

クリック

3

電気

7569

10267

8731

26567

4

ガス

10367

5437

5983

21787

5

水道

3467

2796

3983

10246

6
7
8

5

棒グラフが作成されました。

◢
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

A

B

C

D

E

Ｆ

1月

2月

3月

合計

電気

7569

10267

8731

26567

ガス

10367

5437

5983

21787

水道

3467

2796

3983

10246

Ｇ

78

Ｈ

Ｉ

Ｊ

Ｋ

Ｌ

Ｍ

3章

グラフに挑戦しよう①❸グラフの要素グラフエリア

グラフタイトル

プロットエリア

系列

横軸

縦軸
凡例（はんれい）❹グラフの移動〈手動〉
1

グラフエリアにポイントし、そのまま左側へドラッグしＢ７に
枠線の左上を合わせます。
◢
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

A

B

C

D

E

Ｆ

1月

2月

3月

合計

電気

7569

10267

8731

26567

ガス

10367

5437

5983

21787

水道

3467

2796

3983

10246

Ｇ

ドラッグ

79

Ｈ

Ｉ

Ｊ

Ｋ

Ｌ

Ｍ

3章

グラフに挑戦しよう①

2

グラフが移動しました。

◢
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

A

B

C

D

E

Ｆ

1月

2月

3月

合計

電気

7569

10267

8731

26567

ガス

10367

5437

5983

21787

水道

3467

2796

3983

10246

Ｇ

Ｈ

Ｉ

Ｊ

Ｋ

Ｌ

Ｍ

グラフの削除は、グラフを選択した状態
で、バックスペース
キーを押します。

3「グラフツール」タブも表示されています。グラフの操作は「グラフツール」タブを使用していきます。

グラフを選択することでグラフツールタブが表示されます。

80