Nov 3, 2022 8:28 PM

Top 10 Excel Tricks You Probably Didn't Know

External YouTube Channel

In this video you'll learn to make a personal finance budget tracker so you can keep your finances in check.

In this video you'll learn 10 less known excel tricks from most common at level 1 all the way to top secret at level 5.

  • In Level 1 we go over filter by cell value and moving rows and columns by simply holding the shift key and dragging.
  • In Level 2 we learn to make synchronised changed across sheets and creating new windows to compare sheets.
  • In Level 3 we learn to import data from the internet and learn the excel data types feature.
  • In Level 4 we learn sparklines and how to save a pre-designed chart as a template.
  • In Level 5 we learn to format numbers in thousands or millions as is often the case in accountinng and finance. Lastly, we use trace precedents to see how formulas are being linked.