Excel tranining
•Download as PPTX, PDF•
1 like•301 views
The document provides a 10-point guide for using Excel for daily work. It includes tips for customizing save options, using paste special, sorting and filtering data, removing duplicate data, outlining and subtotaling data, freezing panes, splitting views, conditional formatting, connecting first and last names, and having questions answered. The guide offers instructions for common Excel functions to help users work more efficiently with spreadsheets.
Excel tranining
- 1. PREPARE BY NAV CHANTHA Date : March- 2015 REVIEW EXCEL TIPS FOR DAILY ORK
- 2. 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
- 3. 1- Customize save on option – secure data •File => Options => Save Tab
- 4. 2- Using Past Special •Home Tap => Past => Past Specials
- 5. 3- Sort, Filter • Home Tap => Sort & Filter
- 6. 4- Remove Duplicates Data • Data Tab => Remove Duplicates
- 7. 5- Using Outline (Group, Ungroup, and subtotal) • Data Tab => select the column you want and group or ungroup
- 8. 6- Using View (Freeze Pan) • View Tab => Freeze Pane
- 9. 7- View (Split) • View Tab => Split
- 10. 8- Conditional Format • Home Tab => Conditional Formating
- 11. 9- Formal Connect First Name and Last Name • Example: B3& “ “&C3
- 12. 10- Question and Answer