CHAPTER 01 How to work faster in Excel, start with Olli!

LESSON 01 If you just know the ribbon menu properly, you can do the basics!

STEP 01 How to use the ribbon menu
Restore the disappeared ribbon menu
Understanding the Excel main screen
Open a new document with a shortcut and save it with a different name
Ollie's Tip: Save as a PDF file in a different file format
STEP 02 Menu key and quick launch toolbar
If you just use the menu key well, you can use the mouse less!
Using the Quick Launch Toolbar
Widely use the Quick Access Toolbar
Remove the search box from the title bar
STEP 03 Create your own custom ribbon menu
Create a custom ribbon menu with just the features you need.

LESSON 02 Reduce your working hours significantly by using simple shortcuts!

STEP 01 Basic use of Alt
Get Excel shortcut hints with Alt
Remove the Quick Launch Toolbar function name and launch it with Alt
Let's learn about various Alt combination shortcuts.
STEP 02 How to use shortcut keys using Ctrl
How to use Ctrl in Paste Options
Quick analysis function that allows you to work quickly with Ctrl
Olli's Excel NOTE format copy function
Ollie's Tips: Understanding Excel Paste and Various Paste Options
STEP 03 [Paste Selected] dialog box
Try the Paste Options dialog box and calculation functions

CHAPTER 02 Understanding Cells, Rows/Columns, Sheets, and Data

LESSON 01 Let's learn about cells, rows/columns, and tables.

STEP 01 Understand the concepts of cells and rows/columns!
Cells, rows/columns, and the basics of tables!
Easily distinguish and memorize rows/columns
Select rows/columns and add/delete in 1 second
Olli's Excel NOTE delete/insert function
Ollie's tip: Stop merging cells! Instead, center the selection!
STEP 02 Let's handle rows and columns properly!
Select and deselect multiple rows/columns at once
Hide and re-show unnecessary rows/columns
Always display important rows and columns with the freeze frame feature
Ollie's Tips on Selecting Various Cells, Ranges, and Tables in Excel
How to use Ollie's tip: Move Options
STEP 03 Handle Excel tables properly!
Basic principles of organizing Excel data
Applying table functions to Excel data

LESSON 02 Text, Cell, Number Format, Font Style, and Alignment

STEP 01 Apply font style and cell format
Applying font styles
Apply cell format
Enter special characters (symbols)
Ollie's Excel NOTE wingdings font with various shapes
Ollie's Excel NOTE: Entering special emoji characters in Excel
Applying the same style to the entire Excel NOTE document
STEP 02 Text and Number Format Styles
Understanding Text and Number Formats
Dates and various display formats
Number format error mark
Learn about Ollee's Honey Tip Date and Time Formats
Ollie's Tips: Various Custom Display Formats
Fixing Number Format Errors Using Ollie's Honey Tip Function

LESSON 03: Managing Worksheets Smartly

STEP 01 Let's handle the worksheet freely.
Add/delete worksheets
Moving and duplicating worksheets
Rename a worksheet and apply a color
Hide Ollie's Honey Tip Worksheet
STEP 02 How to select various worksheets
How to multiple select a worksheet
Organizing Ollie's Honey Tip Worksheet for Reporting

LESSON 04: Using the Fill Handle and AutoFill Features

STEP 01 Using the Fill Handle
Using the fill handle for regular and numeric data
Using the fill handle for numeric data
Filling Repeated Text in Ollie's Excel NOTE
STEP 02 Various ways to use filling
How to use Quick Fill Basics
Separate data neatly with the Text to Split Wizard
Olli's Excel NOTE Autofill Options Icon
STEP 03 Using a Custom List
Add a custom list
How to set the default save setting for Ollee's Excel NOTE to PC

CHAPTER 03: Organizing Excel Data Smartly

LESSON 01: Basic Data Sorting and Applying Filters

STEP 01 The basics of data organization are sorting
Sort ascending/descending
Applying more than one criteria with custom sorting
Ollie's Tip: Aligning Data Horizontally (Row-wise)
STEP 02 Using Filters Smartly
Applying filters to data
How to sort and filter by color
Using text filters
It's much better to use the table function instead of the filter.
Apply slicers to tables for convenient filtering
Hide slicer items with no data in Ollie's Excel NOTE
STEP 03: Using filters without using a mouse
How to filter using only the keyboard like an Excel expert
Ollie's Tip: Organize and Filter Merged Cells

LESSON 02: How to Use Find and Replace Properly

STEP 01 Basic Find and Replace Functions
Find and Replace feature
Change cell formats at once with the Replace function
How to use Olli's Excel NOTE format changer
STEP 02 Using Wildcards
Find and Replace Excel Data Using Wildcards
Learn about the options in the Find and Replace dialog box for Ollie's Honey Tips.
STEP 03 Check and process duplicate data
The simplest way is to use the find function (when you know what you are looking for)
Convenient conditional formatting (when you don't know what value you're looking for)
Delete duplicate data immediately with the duplicate removal feature.

LESSON 03: How to Use Data Validation and Advanced Filters

STEP 01 How to Use Validation
Creating a listbox with validation
Input messages and error warnings
Learn about Ollie's various validation options.
STEP 02 Filtering Data with Advanced Filters
Using Advanced Filters 1 - One Condition at Current Location
Using Advanced Filters 2 - Two or more conditions in different locations
How to use the advanced filter AND and OR conditions in Olli's Excel NOTE
STEP 03 FILTER and UNIQUE functions
Using the FILTER function as a filter replacement
Olli's Excel NOTE FILTER function and formula explanation
Remove duplicate data with the UNIQUE function
Ollie's Excel NOTE UNIQUE function explanation
Create simple dynamic data with data validation

CHAPTER 04: Excel's Core! Using Formulas and Functions

LESSON 01 Understanding and Using Basic Excel Formulas

STEP 01 Understanding the Basics of Excel Formulas
Learn basic Excel operators
Excel's order of operations
STEP 02 Basics and Applications of Formula Input
Entering formulas in Excel
Ollie's Excel NOTE: Making the Most of Excel's Formula Input Bar
Understanding Fill Handles and References
Ollie's Tip: Maintain Cell Format and Use the Fill Handle

LESSON 02 Essential Basic Functions for Excel Utilization

STEP 01 Basic functions, sum and average
SUM function for total
AVERAGE function for average
Olli's Excel NOTE SUM, AVERAGE functions
COUNT series functions for counting numbers - COUNTA, COUNTBLANK functions
Olli's Excel NOTE COUNT, COUNTA, COUNTBLANK functions
MAX and MIN functions to extract maximum/minimum values
Olli's Excel NOTE MAX, MIN functions
How to easily input functions without knowing Ollie's secret tip
Ollie's Excel NOTE Simple automatic calculation function
STEP 02 Application functions essential for practical use
How to use the IF function when there is only one condition
Ollie's Excel NOTE IF function
How to use nested IF functions when there are multiple conditions
Ollie's Excel NOTE Nested IF Function Formula Explanation
Olli's Excel NOTE IFS function specialized for cases with multiple conditions
SUMIF and AVERAGEIF functions that calculate only when conditions are met
Olli's Excel NOTE SUMIF, AVERAGEIF functions
COUNTIF counts only when a condition is met
Ollie's tip: IFS series functions that determine two or more conditions
Easily memorize the order of multi-conditional functions in the IFS series.
STEP 03 Logical function that combines conditions
AND function that must satisfy both
OR function that satisfies only one of the two conditions
How to use FALSE and TRUE, which are calculated as 1 and 0

LESSON 03 Date & Time Functions for Handling Dates and Times

STEP 01 Entering and calculating date and time
How to enter date and time data
How to calculate date and time
TODAY and NOW functions that always display today and the current time
The difference between shortcut keys and functions for entering the current time in Olli's Excel NOTE
STEP 02 Various functions for handling time and date
DATE and TIME functions that combine time and date
Olli's Excel NOTE Various date and time functions
Unifying messy date data formats
STEP 03 Creating an Automatic Calendar with Date Functions
WEEKDAY function to determine the day of the week
Ollie's Excel NOTE WEEKDAY function
Create an automatic calendar by simply selecting the year and month.
Ollie's Tip: How to Make Overflowing Months Transparent in the Automatic Calendar

LESSON 04 Text functions for free text manipulation

STEP 01 Basic functions for extracting text
LEFT and RIGHT functions that extract from the right or left
Ollie's Excel NOTE LEFT, RIGHT Function
MID function to extract as much as needed from the middle
Olli's Excel NOTE MID function
STEP 02 Practical functions for processing text
SEARCH function to find the location of text
Olli's Excel NOTE SEARCH function
TRIM and SUBSTITUTE functions for cutting and replacing text
Olli's Excel NOTE TRIM, SUBSTITUTE functions
CONCAT function to concatenate text
TEXTJOIN function to join text with delimiters
Olli's Excel NOTE TEXTJOIN function
STEP 03 Display format set with function
Changing the display format with the TEXT function - text and numbers
Olli's Excel NOTE TEXT function
Changing the display format with the TEXT function - Time display format

LESSON 05: Lookup and Reference Functions to Find Desired Data

STEP 01 VLOOKUP function to find the desired value
Basic usage of the VLOOKUP function
Ollie's Excel NOTE VLOOKUP function and formula explanation
Basic usage of the HLOOKUP function
Ollie's Excel NOTE HLOOKUP function
STEP 02 IFERROR function for handling errors
IFERROR and ISERROR functions
Olli's Excel NOTE ISERROR, IFERROR functions
Using the IFERROR function in the VLOOKUP function
Ollie's Tips on Various Excel Errors and How to Fix Them
STEP 03 Advanced Use of Lookup and Reference Functions
Using the XLOOKUP function
Olli's Excel NOTE XLOOKUP function
Understanding the basics of INDEX and MATCH functions
Ollie's Excel NOTE MATCH function
Olli's Excel NOTE INDEX function
Using the INDEX and MATCH functions
Olli's Excel NOTE INDEX & MATCH Function Combination
Ollie's Tip: Define Cells and Ranges by Name

CHAPTER 05 Using Excel's Data Analysis Tools

LESSON 01 Conditionally formatting data to highlight it

STEP 01 Highlighting Specific Cells with Conditional Formatting
Conditional Formatting Basics! Highlight Cell Rules
Highlighting the top/bottom n% of data
Highlight duplicate or unique values
Ollie's Tip: Deleting and Editing Conditional Formatting
STEP 02 How to visually highlight data
Data bars that highlight data in a bar graph
Color toning feature that highlights data with color
A set of icons that highlight data with icons
STEP 03 How to apply conditional formatting
Highlight entire rows when selecting specific data
How to change the default gridline color in Ollie's Honey Tip Worksheet

LESSON 02 How to Use Charts to See Data at a Glance

STEP 01 Learn how to use basic charts
Three basic ways to insert a chart
Learn about three icons for Olli's Excel NOTE chart function.
Change the type of inserted chart
Editing charts neatly
STEP 02 How to insert an advanced chart
Waterfall chart to check the increase and decrease of data at a glance
Treemap chart to check the proportion of overall data
STEP 03 Sparklines that summarize data
Broken line sparkline chart
Bar Sparkline Chart

LESSON 03: Pivot Tables: Freely Process Data

STEP 01 Creating a Pivot Table
Learn the basics of inserting a pivot table.
Changing the settings of an inserted pivot table
STEP 02 Inserting Pivot Slicers and Charts
Inserting a Pivot Slicer and Timeline
Inserting a Pivot Chart
STEP 03 Data Analysis Using Pivot Tables
Create a simple dashboard using only the pivot function.
Useful SUBTOTAL function in Ollie's Honey Tip Filter Report

CHAPTER 06 Excel's printing functions, security, and application functions

LESSON 01: The know-how of a skilled print maker

STEP 01 Basics of Worksheet Printing
Printing Excel documents
Specifying the print range
Ollie's Excel NOTE Various printing options
STEP 02 Worksheet Printing Application Function
Specifying margins for printed documents
Ollie's Excel NOTE Various print size customization options
Specifying headers/footers
Repeat printing of header (title) rows
STEP 03 Print the entire workbook
Print all worksheets in a workbook at once
Ollie's Excel NOTE Various print range options

LESSON 02 Document Protection and Useful Excel Features

STEP 01 Password-Protecting an Excel Document
Password-protecting an Excel document
Protecting Sheet Structure with Workbook Protection
Protecting entered data with sheet protection
STEP 02 Some tips to make Excel easier
Remove repeated blank spaces at once
Create repeated blanks at once
Processing asterisks in the last digits of a resident registration number using a function
Olli's Excel NOTE REPLACE function
Displaying up and down signs (▲, ▼) in reports
Learn about Ollie's interactive memo and note features.

Become an Excel expert in 3 steps with Ollie!

Even Excel beginners don't have to worry! We've compiled all the essential information, from basics to practical use.
If you follow the 3-step process step by step, you will become an Excel expert in no time!

STEP 01 Excel for Visual Reading: Start with the basics! Learn what the Excel screen looks like, basic shortcuts, and how to work with cells! This user-friendly guide is easy to understand just by looking at it!

STEP 02: All the essential features you need in the real world: Data sorting and filtering, frequently used functions, pivot tables! We'll teach you only the most practical features you can use in your work.

STEP 03: All-in-One: Now it's time to make it your own! Even seemingly intimidating VLOOKUP and INDEX-MATCH functions are a piece of cake with All-in-One! From chart creation to data analysis, we've prepared examples for common practical situations, so don't worry.

What kind of readers is this book for?

ㆍNew employees in their 20s and 30s who were upset and said, “Why am I so bad at Excel...”
ㆍA prospective employee who is full of thoughts like, “If I’m good at Excel, my specs will be amazing...”
ㆍPeople who gave up because they felt mentally exhausted just looking at thick Excel books
ㆍPeople who say, “I’m busy, but I want to quickly learn only what I need for my work!”
ㆍ“The video lectures are too long and boring...
Those who have wondered, “Isn’t there an easier way to learn?”
ㆍThose who thought, “It would be nice if an Excel expert could teach me...”
ㆍPeople who say, “I want to learn everything from the basics to practical skills at once!”

Features of this book

A friendly Excel class with Ollie!

Wow! There's an Excel book this easy to understand? Say goodbye to dense explanations and dense images! Who knew learning Excel could be this fun with Olli's cute explanations and Instatoon-style tutorials? Solve common work-related situations with Olli, and Excel will soon become your friendly friend!

A wealth of practical tips you can use right away!

We've carefully selected and included only the features that you'll think, "Ah, this is something I really need in practice!"
From basic data entry to VLOOKUP and INDEX-MATCH functions! Even seemingly intimidating pivot tables are a breeze with Olly! Creating charts for reports is no problem either.
In addition, 'Olli's Excel NOTE' will teach you the secret skills of professionals, and 'Olli's Honey Tips' will teach you all the hidden honey tips of Excel experts.
Don't worry, all examples come with practice files!

Let's go together with Excel LAN cable shooter 'Oli'!

Now, your LAN cable shooter is Ollie! Even when you're wondering, "What should I do?", Ollie will quickly provide you with a solution.
Ask Olly about all the Excel challenges you face at work! Even Excel, which was once difficult to master on your own, becomes a whole new experience with Olly.
As you tackle common situations in your practice, you'll soon find yourself saying, "Excel? Let me do it!"