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
- AND
- ARABIC
- AVERAGE
- Basic Operations
- BIN2DEC
- BITAND
- BITOR
- CHAR
- CODE
- CONCATENATE
- CONVERT
- COS
- COUNT
- COUNTA
- COUNTIF
- COUNTUNIQUE
- DATEDIF
- DAY
- DEC2BIN
- DEGREES
- DETECTLANGUAGE
- EFFECT
- EQ and =
- EXACT and =
- FIND
- FV
- FV 2
- GOOGLEFINANCE
- GOOGLETRANSLATE
- GT
- GTE
- HOUR
- IF
- IF 2
- IF.xlsx
- IFS
- ISTEXT
- JOIN
- LARGE
- LEFT
-
LEN
- LOWER
- LT
- LTE
- MAX
- MID
- MIN
- MINUTE
- MODE.MULT
- MODE.SNGL
- MONTH
- NE and <>
- NOT
- NOW
- NPER
- OR
- PROPER
- PV
- RADIANS
- RAND
- RANDARRAY
- RANDBETWEEN
- RANK
- RATE
- RATE 2
- REPLACE
- REPT
- RIGHT
- ROMAN
- SEARCH
- SECOND
- SEQUENCE
- SIN
- SKEW
- SKEW.P
- SMALL
- SORT
- SPLIT
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUM, SUM2
- SUMPRODUCT
- SUMSQ
- T
- TEXTJOIN
- TOCOL
- TOROW
- TO_TEXT
- TRIM
- TRIM 2
- UNIQUE
- UPPER
- VAR.P
- VAR.S
- VSTACK
- XLOOKUP
- YEAR
SPREADHSEET PROJECTS AND EXPLANATIONS
- Absolute and Relative Reference
- Absolute Row Reference
- Cell, Column and Row Shortcuts
- Changing Locale
- Circular Dependency Error
- Create a Blank Spreadsheet
- Create a Calendar
- Create a Dashboard with Google Sheets
- Data Cleaning - Dates as Numbers
- Data Cleaning - Removing Duplicates
- Data Cleaning - Text with Numbers
- Date Picker
- Decimals and Percentages
- Detecting Outliers with Standard Deviation
- Dropdown from a Range
- Editing Shortcuts
- Find Year with Maximum Sales
- Formatting Shortcuts
- Increase/Decrease Decimals
- K-Nearest Neighbors
- Named Ranges
- Navigation Shortcuts
- Numbering Sections
- Paint Format
- Pitfalls - Conditional Formatting and Filters
- PEMDAS
- Randomize Range
- Removing Duplicates
- Removing Duplicates 2
- Renaming a Spreadsheet
- Resizing Columns
- Selecting a Table
- Selection Shortcuts
- Summary Statistics
- Understanding Dates as Numbers
TECHNICAL
FINANCE
- Constant Perpetuity
- Frequent Versus Continuous Compounding
- Growing Perpetuity
- Investments that Increase and Decrease by same Rate
- Investment that Triples
- Mortgage Calculation
- One Dollar Investment per Day
- Order of Returns
- Retirement Calculation
- Retirement.xlsx
- Retirement Planning Model
- Rule of 72
DATA SCIENCE
- Accuracy Metric
- Become a US President with 22% of the Popular Vote
- Central Tendency: Mean, Median and Mode
- Functions
- Global versus Local Variables
- Histograms
- IF Conditions
- IF Statement
- Line Equation
- Loops
- Measures of Dispersion: Range, Mean Absolute Deviation, Variance and Standard Deviation
- Power Functions
- Reading a Google Sheets into Python
- Relative and Cumulative Distributions
- Simple Interpolation
- Simple Linear Regression
- Two Die Simulation
- Variable Types
- Variance: Why divide by n-1? Empirical
- Variance: Why divide by n-1? Intuitive
- Variance: Why divide by n-1? Mathematical
WORKSHOP DATA SETS
ODSC EAST 2024
INTERVIEW TIPS
Happy learning, and thank you for your support!