Functions, Data Analysis, Presentation and Finance w/ Excel

Explore Excel basics for data analysis and formatting across quarters, including merging cells, conditional formatting, data bars, and essential functions like count and sum if.

Build an Excel data model in section three to simulate income, state, GPA, admissions (early or regular), and financial aid using random numbers and a lookup table.

Explore section three with Excel: generate fake pay data using rand between in euros, apply bonuses via if statements, and compute totals, vlookup, pay rank, and correlations.

Explore Excel's financial functions under the formulas tab, including bonds, stocks, depreciation, discount rates, present value, future value, and bond price, with one missing input enough to solve.

Learn to build an amortization table in Excel, compute down payment and loan, apply the PMT function for monthly payments, and analyze interest versus principal using what-if analysis.

learn to format excel data, apply borders and colors, use conditional formatting and color scales, rank data with array formulas, and calculate totals, averages, standard deviation, and medians.

Learn to generate random numbers in a spreadsheet using rand, scale to different ranges, convert to integers, and use random between for bounds; test normal distribution with frequency and bins.

Use a random number generator to generate x values, square them to get y, and average results to approximate the area under the curve; this is Monte Carlo type 1.

Apply Monte-Carlo type 2 to determine how often y is below x squared by sampling random x and y, counting true cases, and forming a closer approximation.

Calculate final grades by weighting tests, the final, and homework, using grade_data. Apply database functions and an advanced filter to analyze averages and criteria like name and state.

Evaluate trendlines using forecast functions for linear and exponential smoothing, extend data to forecast the next point, and interpret slope, intercept, and R square for line estimation.

Enable the Excel analysis toolpak and use data analysis features like descriptive statistics, correlation, covariance, and regression, then build histograms with bins and review residuals.