Excel: Top 10 Tips to Become Better in Excel

Leila Gharani, Excel Instructor, Business Consultant

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Lessons (2h 3m)
    • 1. What You Will Learn

      2:40
    • 2. Tip 1 - Use Keyboard Shortcuts

      9:08
    • 3. Tip 2/1 - Master the Simpler Tasks

      18:12
    • 4. Tip 2/2 - Master the Simpler Tasks

      9:11
    • 5. Tip 3 - Quickly Navigate Larger Files

      11:23
    • 6. Tip 4 - Inspect Workbooks Before Distributing

      9:47
    • 7. Tip 5 - Use Protection Appropriately

      16:24
    • 8. Tip 6 - Import Text, CSV & Web Data Properly

      11:15
    • 9. Tip 7 - Audit & Debug Formulas

      6:19
    • 10. Tip 8 - Customized Number Formatting Tricks

      17:10
    • 11. Tip 9 - Solve Problems With Goal Seek

      6:11
    • 12. Tip 10 - Speed up Your Excel Files

      5:29

Project Description

Practice as You Watch

Download the Excel_Advanced_Top10Tips_Demo Workbook and practice along with me. 

Your Assignment

As you watch, think about your own Excel files and how you can apply the techniques you learn at work. Make a note of them.

Your Deliverable

Select one of the below:

  1. Pick at least 1 of the tips and apply it to your own file. Take a screenshot and post it to the project board with a short comment on which tip you have implemented and how it improved your file.
  2. From the exercise worbook (Excel_Advanced_Top10Tips_ExerciseBook), pick 1 exercise and complete it. Take a screenshot of the completed exercise and post to the project board. (The solutions are provided, but no cheating!)

Your Resources

The two files below will assist you througout the course:

  • Excel_Advanced_Top10Tips_Demo - to follow along
  • Excel_Advanced_Top10Tips_ExerciseBook - to practice what you learnt

Don't Forget

Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases. Completing this project takes you one step closer.

Student Projects

Besim Sallovich
1 comment