Resources

Here are several resources including YouTube video links that provide concise explanations of various topics . If you find the content helpful, liking the videos and subscribing to the channel would be greatly appreciated!

SPREADSHEETS

Here are explanations of Spreadsheet functions, operations and projects.

SPREADSHEETS FUNCTIONS

  1. AND
  2. ARABIC
  3. AVERAGE
  4. Basic Operations
  5. BIN2DEC
  6. BITAND
  7. BITOR
  8. CHAR
  9. CODE
  10. CONCATENATE
  11. CONVERT
  12. COS
  13. COUNT
  14. COUNTA
  15. COUNTIF
  16. COUNTUNIQUE
  17. DATEDIF
  18. DAY
  19. DEC2BIN
  20. DEGREES
  21. DETECTLANGUAGE
  22. EFFECT
  23. EQ and =
  24. EXACT and =
  25. FIND
  26. FV
  27. FV 2
  28. GOOGLEFINANCE
  29. GOOGLETRANSLATE
  30. GT
  31. GTE
  32. HOUR
  33. IF
  34. IF 2
  35. IF.xlsx
  36. IFS
  37. ISTEXT
  38. JOIN
  39. LARGE
  40. LEFT
  41. LEN
  42. LOWER
  43. LT
  44. LTE
  45. MAX
  46. MID
  47. MIN
  48. MINUTE
  49. MODE.MULT
  50. MODE.SNGL
  51. MONTH
  52. NE and <>
  53. NOT
  54. NOW
  55. NPER
  56. OR
  57. PROPER
  58. PV
  59. RADIANS
  60. RAND
  61. RANDARRAY
  62. RANDBETWEEN
  63. RANK
  64. RATE
  65. RATE 2
  66. REPLACE
  67. REPT
  68. RIGHT
  69. ROMAN
  70. SEARCH
  71. SECOND
  72. SEQUENCE
  73. SIN
  74. SKEW
  75. SKEW.P
  76. SMALL
  77. SORT
  78. SPLIT
  79. STDEV.P
  80. STDEV.S
  81. SUBSTITUTE
  82. SUM, SUM2
  83. SUMPRODUCT
  84. SUMSQ
  85. T
  86. TEXTJOIN
  87. TOCOL
  88. TOROW
  89. TO_TEXT
  90. TRIM
  91. TRIM 2
  92. UNIQUE
  93. UPPER
  94. VAR.P
  95. VAR.S
  96. VSTACK
  97. XLOOKUP
  98. YEAR


SPREADHSEET PROJECTS AND EXPLANATIONS

  1. Absolute and Relative Reference
  2. Absolute Row Reference
  3. Cell, Column and Row Shortcuts
  4. Changing Locale
  5. Circular Dependency Error
  6. Create a Blank Spreadsheet
  7. Create a Calendar
  8. Create a Dashboard with Google Sheets
  9. Data Cleaning - Dates as Numbers
  10. Data Cleaning - Removing Duplicates
  11. Data Cleaning - Text with Numbers
  12. Date Picker
  13. Decimals and Percentages
  14. Detecting Outliers with Standard Deviation
  15. Dropdown from a Range
  16. Editing Shortcuts
  17. Find Year with Maximum Sales
  18. Formatting Shortcuts
  19. Increase/Decrease Decimals
  20. K-Nearest Neighbors
  21. Named Ranges
  22. Navigation Shortcuts
  23. Numbering Sections
  24. Paint Format
  25. Pitfalls - Conditional Formatting and Filters
  26. PEMDAS
  27. Randomize Range
  28. Removing Duplicates
  29. Removing Duplicates 2
  30. Renaming a Spreadsheet
  31. Resizing Columns
  32. Selecting a Table
  33. Selection Shortcuts
  34. Summary Statistics
  35. Understanding Dates as Numbers


TECHNICAL

  1. RGB Explanation
  2. Why you should be careful when averaging percentages?


FINANCE

  1. Constant Perpetuity
  2. Frequent Versus Continuous Compounding
  3. Growing Perpetuity
  4. Investments that Increase and Decrease by same Rate
  5. Investment that Triples
  6. Mortgage Calculation
  7. One Dollar Investment per Day
  8. Order of Returns
  9. Retirement Calculation
  10. Retirement.xlsx
  11. Retirement Planning Model
  12. Rule of 72


DATA SCIENCE

  1. Accuracy Metric
  2. Become a US President with 22% of the Popular Vote
  3. Central Tendency: Mean, Median and Mode
  4. Functions
  5. Global versus Local Variables
  6. Histograms
  7. IF Conditions
  8. IF Statement
  9. Line Equation
  10. Loops
  11. Measures of Dispersion: Range, Mean Absolute Deviation, Variance and Standard Deviation
  12. Power Functions
  13. Reading a Google Sheets into Python
  14. Relative and Cumulative Distributions
  15. Simple Interpolation
  16. Simple Linear Regression
  17. Two Die Simulation
  18. Variable Types
  19. Variance: Why divide by n-1? Empirical
  20. Variance: Why divide by n-1? Intuitive
  21. Variance: Why divide by n-1? Mathematical


WORKSHOP DATA SETS

ODSC EAST 2024

  1. Predicting Home Prices - ODSCEast.xlsx
  2. Predicting Home Prices - ODSCEast - Google Sheets


INTERVIEW TIPS

  1. Avoid the Question Answer Loop


Happy learning, and thank you for your support!