Structure of this book
Book Usage Guide
Book Study Guide
Guide to using example files

Chapter 01 Basic functions you must know when using Excel for the first time

Lesson 01 Finding and Running Excel on Your Computer
Find Excel program on my PC
Run Excel

Lesson 02: Entering Simple Data and Saving an Excel Document
Creating a simple table format
[Excel Tips Only I Don't Know] Excel's Customization Features and Text Alignment Defaults
Save the document you created
[Excel Tips Only I Don't Know] Excel Workbook File Format and xlsx Extension
[Sister IT Video Lecture] Creating a Simple Table

Lesson 03 Using the Quick Access Toolbar
Add and remove basic menus
Add desired functions to the Quick Access Toolbar
[Excel Tips Only I Don't Know] Using the Quick Access Toolbar Shortcuts
Show the Quick Access Toolbar below the Ribbon
[Sister IT Video Lecture] Using the Quick Launch Toolbar

Lesson 04 Saving Excel in Various Ways and Easily Sharing Tables
Create a copy of an Excel file by saving it as a different name
Save as PDF file format
Send an Excel table image via KakaoTalk
[Sister IT Video Lecture] Sending Excel Table Images via KakaoTalk

Lesson 05 Editing and Deleting Data
Clear entered text and formatting
[Excel Tips Only I Don't Know] [Clear] Function to Delete Cell Contents and Formats at Once
Modify data
[Excel Tips Only I Don't Know] Entering Special Characters
[Sister IT Video Lecture] Editing and Deleting Formats and Data
[Sister IT Video Lecture] Entering Special Characters

Lesson 06: Duplicating Data Using Various Copy and Paste Methods
Copy, cut, paste
Paste data in various ways
[Excel Tips Only I Don't Know] Learn about useful paste options.
[Excel Tips Only I Don't Know] Using the [Operation] Function in the [Paste Special] Dialog Box
[Excel Tips Only I Don't Know] Copying Styles with [Format Copy]
[Sister IT Video Lecture] Various Copy and Paste

Lesson 07 Inserting and Deleting Columns and Rows, and Adjusting Width and Height
Adjust column and row header width and height
Adjust the width of multiple columns equally
[Excel Tips Only I Don't Know] Merge Multiple Cells into One
Inserting and deleting columns and rows
[Sister IT Video Lecture] Inserting and Deleting Columns and Rows

Lesson 08: Managing Excel Sheets
Add, delete, and rename Excel sheets
Copy the sheet, rename it, and then move it
Move a sheet to another Excel file

Lesson 09: Complete Data with Smart Autofill
Auto-fill various data
Autofill date data
[Excel Tips Only I Don't Know] How to Enter Dates and Select a Date Format
[Excel Tips Only I Don't Know] Filling in Weekday Dates Only in Autofill Options
[Excel Tips Only I Don't Know] Using the Quick Fill Feature
[Sister IT Video Lecture] Powerful Autofill Feature

Lesson 10: Using Frame Locking and Screen View Settings
Show title row anywhere with fixed frame
Zoom in and out on the document
Hide gridlines, headers, and formula input bar

Lesson 11: Printing Excel Documents Your Way
Print data to fit the paper exactly
Printing massive amounts of data to suit your taste
Conveniently print only the desired portion
Print the title row repeatedly
Add headers and footers to print
Insert your company logo in the header
[Excel Tips Only I Don't Know] Inserting Photos and Shape Icons into Documents

Lesson 12: Creating a Simple Schedule for Printing
Setting the A4 paper size
Fill in basic data
Formatting a Table Range
[Sister IT Video Lecture] Create a Simple Schedule in 30 Seconds
[Excel Tips Only I Don't Know] Check the Auto-Fill List and Create Your Own List

Lesson 13: Creating an Expense Request Form Using Excel Editing Features
Preparing an Expense Request Form
Fill out the Expense Request Form
Paste the payment image
Complete the Expense Request Form

Lesson 14: Freely Inserting and Deleting Notes in Excel
Inserting a note into a cell
[Excel Tips Only I Don't Know] Interactive Memo and General Memo Features
[Sister IT Video Lecture] Inserting Notes

Lesson 15: Setting and Decrypting Passwords on Excel Files
Set a password
Decrypt


Chapter 02 Excel functions and features that help with calculations

Lesson 01 Quickly Sum Data with AutoSum
Calculate totals easily with AutoSum
[Excel Tips Only I Don't Know] Using AutoSum in Various Ways
[Excel Tips Only I Don't Know] Calculating by Referencing Cells in Other Sheets
[Sister IT Video Lecture] Calculating Totals in Excel in 0.1 Seconds

Lesson 02: Quickly Finding the Mean, Maximum, and Minimum
Finding the average quickly
Finding maximum and minimum values ​​quickly

Lesson 03: Learn basic Excel functions and how to write them.
Entering the SUM function to calculate the total using the Function Wizard
[Excel Tips Only I Don't Know] Learn about function argument structure and the SUM function to calculate totals.
Enter the AVERAGE function to calculate the average using the function library.
[Excel Tips Only I Don't Know] Learn About the AVERAGE Function
Enter the MAX function to find the maximum value directly into the formula input bar.
Enter the MIN function to find the minimum value in the Function Arguments dialog box.
[Excel Tips Only I Don't Know] Learn about the MAX and MIN functions to find maximum and minimum values.
Check the functions used in the worksheet
[Sister IT Video Lecture] Learn the basic Excel functions SUM, AVERAGE, MAX, and MIN.

Lesson 04: Learn about various functions and features related to time and date.
Learn about the TODAY and NOW functions and features that input the current date and time.
YEAR, MONTH, DAY functions used to find the year, month, and day
Find the day of the week by changing the display format

Lesson 05: Calculating Rounding Up, Down, and Down with the ROUND Functions
Rounding to the first decimal place using the ROUND function
Rounding up to the nearest 10 won using the ROUNDUP function
Rounding down to the nearest whole number using the ROUNDDOWN function
[Excel Tips Only I Don't Know] Learn the Structure and Use of ROUND Functions

Lesson 06 Relative and absolute references you absolutely must know in formulas
Understanding the Concept of Relative and Absolute References
Finding exchange rates using absolute references

Lesson 07: Ranking a Range Based on Values ​​with the RANK.EQ Function
Finding the order of high-selling cars using the RANK.EQ function.
Reverse the ranking of the RANK.EQ function to obtain the lowest penalty order.
[Excel Tips Only I Don't Know] Learn About the RANK and RANK.EQ Functions

Lesson 08 Conveniently referencing cells or ranges by defining names
Define a range by name and use it in a function
Define and check table ranges at once
Edit or delete a defined name

Lesson 09: Evaluating and Grading Using the IF and IFS Functions
Evaluating goal achievement using the IF function
[Excel Tips Only I Don't Know] Learn the IF function to output desired text based on conditions.
Nesting IF functions to classify grades
[Excel Tips Only I Don't Know] Learn How to Nest IF Functions
Nesting conditions more easily with the IFS function
[Excel Tips Only I Don't Know] Easily Enter Multiple Conditions Using the IFS Function

Lesson 10 Various functions for extracting only the desired part of text
Extract only the year from the resident registration number using the LEFT function, which extracts text from the left.
Extracting the month and day from a resident registration number using the MID function, which extracts text from the middle.
[Excel Tips Only I Don't Know] Comparing the LEFT and MID Functions
Extracting job titles using the RIGHT function, which extracts text from the right.
Finding gender from resident registration number by combining the CHOOSE and MID functions
[Excel Tips Only I Don't Know] Learn about the CHOOSE function, which outputs data by number.

Lesson 11 COUNT Functions for Counting Cells
Understanding the COUNT family of functions
Counting the total number of people using the COUNT function, which counts numeric data cells.
[Excel Tips Only I Don't Know] Calculating Numbers with Auto-Calculation
Finding the number of people who paid their membership dues using the COUNTA function, which counts all cells containing data.
Finding members with unpaid dues using the COUNTBLANK function, which counts empty cells.

Lesson 12: COUNTIF function to count only the cells you want based on conditions
Learn about the structure of the COUNTIF function, which counts only the number of cells that meet a condition.
Finding the number of attendees by department using the COUNTIF function, which counts cells based on conditions.

Lesson 13: SUMIF function to add only desired values ​​based on conditions
Learn about the SUMIF function structure, which adds only the desired values ​​based on conditions.
Use table ranges by defining their names
Finding total quantity by category using the SUMIF function
Calculating the total sales by category using the SUMIF function

Lesson 14: Finding Data in a Table with the VLOOKUP Function
Find a product name using the product code using the VLOOKUP function.
Find unit price by product code using the VLOOKUP function
Finding an approximate discount rate using the VLOOKUP function
[Excel Tips Only I Don't Know] Learn about the VLOOKUP function, which finds matching values ​​in a table.
Excel Formula Errors and How to Fix Them


Chapter 03 Work Easily and Quickly with Excel Application Functions

Lesson 01: Knowing What to Keep in Mind When Entering Data
Five Things to Know When Entering Data
[Excel Tips Only I Don't Know] Structure of Excel Data Tables

Lesson 02 Sorting Data in Ascending and Descending Order
Sort by longest tenure at the company
If the position is the same, sort by highest salary.

Lesson 03 Four Frequently Used Excel Functions
Find and replace specific text at once
[Excel Tips Only I Don't Know] Find and Replace's [Options] Feature
Remove duplicates, leaving only one of the same data
Find and select only blank cells in the selected range
Split text
[Excel Tips Only I Don't Know] Shortcuts for Quickly Moving Data

Lesson 04 Enter only data specified by data validation
Select from list and enter data with data validation
Limit text length with data validation

Lesson 05: Inserting a Chart to Show Data at a Glance
Creating charts from table data
Create a chart by selecting only the desired range
[Excel Tips Only I Don't Know] Inserting Recommended Charts in Excel

Lesson 06: Modifying the chart to your desired shape
Make the title change automatically based on the cell contents
Create a chart that displays numeric data on a graph
Add axis titles to a chart
Modifying the axis number units of a graph
Change the chart style
Use chart filters to display only the data you want.
[Excel Tips Only I Don't Know] Changing the Axis of a Chart
Change the chart type and separate it into a separate sheet

Lesson 07 Organizing and Sorting Data with Auto Filters
Apply filters and do simple filtering
Filter data from shipped T-shirts with sales exceeding 200,000 won.
Clear all filtering data conditions at once
Filter only products that contain the word "one piece"
Filter by desired date
[Excel Tips Only I Don't Know] Using Date Filters
Remove automatic filters applied to your data

Lesson 08: Applying Table Functions to Data Ranges
Applying table functions to a data range
Calculate by entering formulas in a table
Add a summary row to a table and use a filter
[Excel Tips Only I Don't Know] Adding Summary Cells to a Summary Row
Using the Table Function Slicer
Disable table function

Lesson 09: Summarizing Long Lists with Subtotals
Apply partial sums
Undo partial sums

Lesson 10: Viewing Data the Way You Want with PivotTables
Applying a Pivot Table
Adding a Thousands Separator to PivotTable Data
Apply and remove criteria based on two or more fields in a pivot table
Applying a PivotTable Filter
[Excel Tips Only I Don't Know] Understanding Pivot Table Structure and Modifying [Value] Field Settings
[Excel Tips Only I Don't Know] Adding Pivot Slicers and Changing the Number of Columns

Search

With 280,000 YouTube subscribers, the IT YouTube channel's 3-minute Excel lecture for absolute beginners is now available in a book format!
An introductory Excel book that anyone can start right away with!

Have you ever given up on learning Excel? Are you suddenly faced with the need to use it but don't know how to use it? What should you learn first to get started with Excel?

Nuna IT's 3-minute Excel lecture was created to understand and help beginners in Excel.
Excel has a wide range of features, but most tasks can be accomplished with a few frequently used features, and among them, there are only a limited number of features that beginners need to know.
Nuna IT's 3-Minute Excel provides an optimized curriculum to help absolute beginners become familiar with Excel and use it easily in the shortest possible time.

If you can master Excel quickly using an optimized learning method, learning Excel will no longer be difficult.
By learning Excel by reading the entire book and reviewing it with video lectures, you too can get one step closer to escaping the Excel beginner stage.


What kind of readers is this book for?
- A complete beginner in Excel and computers who has never learned or even used Excel before.
- People who have given up on learning Excel through difficult textbooks or lectures
- People who want to quickly learn only the basic essential functions of Excel and use them in their work.
- People who need to learn the basics of Excel quickly but are short on time, such as those preparing for employment, preparing for a job change, or self-employed people


Features of this book

one.
Meet YouTube's popular Excel lectures in book form!

Discover the acclaimed "3-Minute Excel" course from the 280,000-subscriber Noona IT YouTube channel, now available in book form! The video lectures, designed to help absolute beginners quickly and easily learn Excel, have been published in book form.
If you want to quickly overcome the beginner level or build your skills by learning Excel from scratch, try Nuna IT's 3-Minute Excel! While studying, you can easily access and review the "Nuna IT Video Lecture" QR codes included in the book.

two.
Learn Excel with easy and quick configuration!

For those new to Excel, we'll teach you only the essential functions and features you need to overcome the beginner level! Whether you're just starting out with Excel or need to learn it all at once, this lesson focuses on hands-on practice and will get you up to speed quickly.
If you don't know something, you can learn shortcuts to solve problems or speed up tasks through 'Tips Everyone Knows'.
You can familiarize yourself with Excel by applying what you've learned to your own work, checking your skills, and checking for any areas you lack through video lectures.


three.
Escape from the beginner stage and upgrade your skills at the same time with practical content!

With Nuna IT's easy-to-follow 3-Minute Excel Curriculum, you can overcome the beginner stage and even upgrade your Excel skills! Reading the book from cover to cover is incredibly efficient, allowing you to master all the fundamentals of Excel.
If you want to improve your skills, you can learn more about the principles of Excel functions and the structure of functions with 'Excel Tips Only I Don't Know'.
If you continue to study with the 3-minute Excel paid video lectures, you will soon find that your Excel skills have improved significantly.

bonus.
Excel shortcut keys and function input method stand appendix provided!

The appendix included in the book is composed of shortcut keys and function input methods that are useful for Excel beginners to know.
It's a good idea to fold the shortcut stand in front of your monitor so you can use shortcut keys right away while studying a book or using Excel for work.
If you use shortcuts repeatedly, you will find that your work speed increases without you realizing it.