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.