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!
DATASETS
Here we have some recommended datasets.
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!