Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master Excel 2013 from fundamental concepts to advanced techniques through this comprehensive 17-hour video course covering formulas, PivotTables, Flash Fill, charts, and recorded macros. Learn essential Excel skills starting with number formatting, keyboard shortcuts, and basic formulas, then progress through formula types, order of precedence, and percentage calculations. Explore cell references including relative, absolute, and mixed references, along with worksheet and workbook references and 3-D cell references. Dive deep into Excel tables with structured references, defined names, and aggregate functions. Master criteria-based calculations using SUMIFS, COUNTIFS, AVERAGEIFS with AND, OR, and BETWEEN logic through D functions and table features. Study logical functions including AND, OR, and IF functions for complex decision-making scenarios, plus IS functions for delivering numbers, text, and nested formulas. Understand rounding functions like ROUND, MROUND, ROUNDUP, and CEILING, then advance to SUMPRODUCT and lookup functions. Gain expertise in VLOOKUP with 20 practical examples, text functions for partial lookups, and alternative lookup methods using INDEX, MATCH, CHOOSE, and DGET functions. Learn error tracking techniques, data validation with lists and custom rules, and Excel 2013's Flash Fill feature for data extraction and combination. Explore custom number formatting, date functions including EDATE and EOMONTH, and array formulas for advanced calculations. Develop data management skills through sorting, subtotals, filtering with AND/OR criteria, and advanced filter techniques for data extraction. Master data import from various sources including text files, CSV files, and Access databases. Create sophisticated visualizations using conditional formatting with 50 examples, chart basics, templates, and specialized charts like pie-within-pie and combination charts with secondary axes. Apply statistical analysis through histograms, dot plots, and break-even analysis, concluding with recorded macro fundamentals including absolute and relative references.
