Get this course

Working with Data

Excel Quick Tips


Description
The most common questions about using Excel now have timely video answers. This set of quick tips provides helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, fixing a sheet you received, or getting tables ready for presentation. Each video is about one minute long, so you can jump in and get some helpful insights in no time.
Content
  • 1. Introduction
  • 2. Fill in a series of data
  • 3. Quickly insert multiple rows and columns
  • 4. Insert hyperlinks
  • 5. Create and manage drop-down lists
  • 6. Summing rows
  • 7. Work with stock and geography data
  • 8. Fill in contents with Flash Fill
  • 9. Quickly insert total
  • 10. Extract part of a cell's contents
  • 11. Select specific rows or columns
  • 12. Find named ranges
  • 13. Change sort order
  • 14. Filter data
  • 15. Remove duplicate entries
  • 16. Convert formula values to plain
  • 17. Transpose data from vertical to horizontal
  • 18. Text wrap
  • 19. Rotate and align cell data
  • 20. Copy cell formatting
  • 21. Apply international currency formats
  • 22. Apply cell styles
  • 23. Page options
  • 24. Adjust row height and column width
  • 25. Add headers and footers
  • 26. Align cells
  • 27. Add a watermark
  • 28. Conditional formatting by cell contents
  • 29. Copy and paste cell formatting
  • 30. Merge cells
  • 31. Change magnification
  • 32. Freeze and lock panel options
  • 33. Hide and unhide columns and rows
  • 34. Show and hide grouped data
  • 35. Insert and respond to comments
  • 36. Collaborate on an Excel file with others
  • 37. Highlight portions of a spreadsheet
  • 38. Draw and mark up sheets
  • 39. Set document recovery options
  • 40. Encrypt a workbook with a password
  • 41. Restrict editing
  • 42. Save as other file type
  • 43. Inspect a spreadsheet
  • 44. Check for compatibility issues
  • 45. Add and reference worksheets
  • 46. Lock cells
Completion rules
  • All units must be completed
Back