Sign in
KREN
← All lectures

Excel Course

Basics · Intermediate · Advanced — one lesson a day

Learn the Excel you actually use at work, step by step: new lines in a cell, tables and freeze panes first, then functions and PivotTables. Every lesson comes with tested results and practice files.

1 published · 8 planned
Tested on — Tested in Microsoft 365 Excel on Windows (Korean display language); English menu names follow Microsoft's English documentation.
Course repository — practice and answer files for every lesson: github.com/cflab2017/Lecture_Excel

Contents

Basics

  1. Basics 1How to Start a New Line in an Excel Cell — Alt+Enter, Wrap Text, and Removing Line Breaks11/4
  2. Basics 2How to make a table in ExcelComing 11/5
  3. Basics 3How to freeze panes in ExcelComing 11/6
  4. Basics 4AutoFill and inserting rows in ExcelComing 11/7
  5. Basics 5How to merge cells in ExcelComing 11/8
  6. Basics 6How to sum and average in ExcelComing 11/9
  7. Basics 7How to copy and protect a sheet in ExcelComing 11/10
  8. Basics 8Excel shortcutsComing 11/11

Intermediate

Coming after the Basics

Advanced

Coming after the Basics