Chapters:
  • HOME
  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H
  • I
  • J
  • L
  • K
  • M
  • N
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • W
  • X
  • Y
  • Z
  • FIA
  • FIB
  • FIC
  • FID
  • FIE
  • FIF
  • FIG
  • FIH
  • FII
  • FIJ
  • FIK
  • FIL
  • FIM
  • FIN
  • FI0
  • FIP
  • FIQ
  • FIR
  • FIS
  • FIT
  • FIU
  • FIV
  • FIW
  • FIX
  • FIY
  • FIZ
  • Arrange Alphabet
  • Missing Letter
  • N1
  • N2
  • N3
  • N4
  • N5
  • N6
  • N7
  • N8
  • N9
  • N10
  • Domestic Animals
  • Wild Animals
  • Birds
  • Living Beings
  • Fruits
  • Vegetable
  • Transport
  • Colors
  • Living Things
  • Non Living Things
  • Body Parts
  • Twinkle Twinkle Little Star
  • Baa Baa Black Sheep
  • Johnny Johnny
  • Happy Birthday
  • Orange and Lemon
  • The Thirsty Crow
  • The Hare and The Tortoise
  • The Lion and The Mouse
  • The Greedy Dog
  • Reference

/
Tips and Tricks
What are aggregated charts? How do they improve visualizations?
Charts, as we know, are vital data visualization tools. Pivot tables, on the other hand, are useful for giving you a summary of your entire data set. Aggregate charts, in turn, allow you to create visualizations of your pivot tables, giving you the best of both worlds!
How naming ranges, constants, and formulas can simplify things for you.
Defining names for ranges, constant values, and formulas helps make your spreadsheets clear, eliminates manual errors, and makes short work of quick calculations. It also saves you time by preventing you from having to hunt for values and references.
Five important statistical functions, and when to use them.
The sample mean is probably the easiest piece of information one can extract from a data set.
More Tips