Free Excel Alternatives: Sheets, LibreOffice, WPS
Free Excel alternatives compared: Google Sheets in depth (QUERY, IMPORTRANGE, ARRAYFORMULA), plus LibreOffice Calc and WPS Spreadsheets.
Excel Interview Scenarios, Solved in Excel
Eight practical Excel interview scenarios, from finding a top performer to cleaning messy names, each solved and run…
Excel Shortcuts, Calculation and Sharing
Excel shortcuts, calculation modes, iterative calculation, and sheet, workbook and sharing protection, each demonstrated with real results from…
Excel Power Query and Data Model Explained
Excel Power Query and the Data Model explained: Applied Steps, common transformations, relationships versus VLOOKUP, and a first…
Excel What-If Analysis: Goal Seek, Data Tables
Excel What-If Analysis explained: Goal Seek, one and two-variable Data Tables, Scenario Manager, and when to use Solver…
Excel Financial Functions: PMT, NPV, IRR Explained
Excel financial functions explained: PMT, FV, NPV, IRR, MIRR, IPMT, CUMIPMT, EFFECT, depreciation methods, and XNPV/XIRR, with real…
Excel Charts: Common Mistakes and How to Fix Them
Excel charts through the mistakes that go wrong: the header-row trap, series direction, hidden rows, axis scaling, pie…
Excel PivotTables Explained: Build, Group, Refresh
Excel PivotTables explained: building one, Show Values As, calculated fields and items, grouping dates, refreshing, and GETPIVOTDATA, with…
Excel Data Cleaning and Validation Explained
Excel data cleaning and validation: Text to Columns, Find and Replace, validation rules, list case sensitivity, and why…
Excel Tables, Sorting and Filtering Explained
Excel Tables, sorting and filtering explained: structured references, total rows, SUBTOTAL vs SUM, sort order, AutoFilter, Advanced Filter…