ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
PREPARE BY NAV CHANTHA
Date : March- 2015
REVIEW
EXCEL TIPS
FOR
DAILY ORK
Table of Contents
1- Customize save on option – secure data
2- Using Past Special
3- Sort, Filter
4- Remove Duplicates Data
5- Using Outline (Group, Ungroup, and subtotal)
6- Using View (Freeze Pan)
7- View (Split)
8- Conditional Format
9- Formal Connect First Name and Last Name
10- Question and Answer
1- Customize save on option – secure
data
•File =>
Options =>
Save Tab
2- Using Past Special
•Home Tap
=> Past =>
Past
Specials
3- Sort, Filter
• Home Tap => Sort & Filter
4- Remove Duplicates Data
• Data Tab => Remove Duplicates
5- Using Outline (Group, Ungroup, and
subtotal)
• Data Tab => select the column you want and group or
ungroup
6- Using View (Freeze Pan)
• View Tab => Freeze Pane
7- View (Split)
• View Tab => Split
8- Conditional Format
• Home Tab => Conditional Formating
9- Formal Connect First Name and Last
Name
• Example: B3& “ “&C3
10- Question and Answer

More Related Content

Excel tranining