yeonsoochoi

Are you using Excel well in your work? Small tips for Excel can help you reduce mistakes and increase work efficiency! In this course, we will carefully select 16 useful Excel tips and explain them in detail.

dmsgml1030

[Useful Excel Tips to Know (1)] that will get you recognized by your boss

Thank you ^-^
I'm glad you understood it well
I hope the Excel tips will help you with your work. If you have any questions while working with Excel, please ask at any time.

하루 3시간! 하룻밤 만에 성장할 수 있는 강의만 모았어요!

3시간 만에 완강할 수 있는 강의 ⏰

입문

초급

중급이상

엑셀

Excel

마이크로소프트 오피스 툴

MS-Office

Useful Excel Tips to Know (1) Orientation

Enter various data into cells and format cells

Several ways to specify a cell range

Try using the fill handle

Sorting data

Learn about the status bar

Useful features that can be used with the Move (F5) option

Useful features that can be used as auto-refresh options

How to fit data to the width of a column

Enter data easily using list boxes

Quickly open frequently opened files

Learn about name definitions

Using time data

Replace incorrectly entered dates and numbers with correct data

Split text

Connecting empty cells in a broken line graph by treating them as 0