Скачать или смотреть Data Analytics Course Batch105 Excel Training : Session 5

Shortcuts & Basic Calculations

ALT + = for quick sum

SUMIF to add based on a condition

YouTube Summaries

Data Manipulation & Formatting

Autofill, Flash Fill, Transpose for rearranging data

YouTube Summaries

Sorting & Filtering

Custom sorting (by value, color, date) and filtering on multiple criteria

YouTube Summaries

Core Functions

SUM, AVERAGE, COUNT, basic arithmetic

IS functions: ISODD, ISLOGICAL, ISNUMBER

Rounding: ROUND, ROUNDUP, ROUNDDOWN, INT

SUBTOTAL for subtotals

MAX, MIN, RANDBETWEEN, MOD, COUNT

YouTube Summaries

Logical & Conditional Functions

AND, OR, IF with nested logic

YouTube Summaries

Text & Error Handling

IS_TEXT, LENGTH, TEXT formatting

LOWER, PROPER (with mention of UPPER)

YouTube Summaries

Lookup Functions

IF, INDEX, MATCH, VLOOKUP

YouTube Summaries

Statistical & Financial Functions

COUNTIFS, SUMIFS for multi‑criteria calculations

YouTube Summaries

Date functions: FRAC, WEEKDAY, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, DAYS360, WORKDAY

YouTube Summaries

Financial: PMT, FV, PV, NPV

YouTube Summaries

Regression & Analytics Tools

Regression using Data Analysis add‑in, correlation, R‑squared, standard error

YouTube Summaries

Dashboards, data visualization, macros, VBA basics