Course curriculum

    1. Introduction

    2. Move Data

    3. XLOOKUP()

    4. Filter List

    5. Ideas

    6. Remove Blanks

    7. Quick Analysis Tool

    8. AutoFit Column Width

    9. Absolute Cell Reference

    10. Paste Special Values

    11. Drop-Down List

    12. FILTER()

    13. Remove Duplicates

    14. Difference Between Lists

    15. Flash Fill

    16. AutoFill

    17. Data Types

    18. Transpose

    19. Freeze Panes

    20. Text to Columns

    21. Recommended Pivot table

    22. Slicers

    23. Conditional Formatting

    24. IF()

    25. 3D References

    26. Forecast Sheet

    27. SUMIFS()

    28. IFERROR()

    29. Ctrl-Arrow Keys

    30. Filled Maps

    31. PMT()

    32. Show Formulas

    33. Advanced Select

    34. Named Range Shortcut

    35. Hide Cells

    36. COUNTBLANK()

    37. Natural Language Query

    38. Goal Seek

    39. Insert Screenshot

    40. Power Pivot

    41. 3D Maps

    42. ISBLANK()

    43. Analysis ToolPak

    44. CONVERT()

    45. Get Data from Web

    46. People Graph

    47. SORT()

    48. Status Bar Info

    49. Insert Multiple Rows

    50. CHOOSE()

    51. UNIQUE()

About this course

  • Free
  • 51 lessons
  • 1 hour of video content