Apply conditional formatting rulesApply workbook templatesAudit formula precedents and dependentsBuild pivot tables for summariesCalculate running totals and averagesCalculate subtotals and totalsCompare and merge workbooksConsolidate multiple sheetsCopy formulas across rangesCreate amortization schedulesCreate and edit named rangesCreate and manage macrosCreate and modify tablesCreate charts for presentationsCreate dashboards for stakeholdersCreate dynamic named formulasCreate forecasting trendlinesCreate formulas for calculationsEnter numeric data into cellsFilter rows by criteriaFormat cells for readabilityFormat numbers and currenciesFreeze panes for navigationGenerate monthly reportsGroup and outline rows or columnsImport CSV or text filesInsert and format images or logosLink workbooks for live updatesMerge cells for headingsPerform percentage and ratio analysisPerform what-if analysisPrepare data for exportPrint selected ranges neatlyProtect workbook structureProtect worksheets from editsReconcile account balancesRecord repetitive tasks as macrosRefresh external data connectionsRemove duplicate rowsSchedule automatic backupsSet up recurring report templatesSort data by columnsSplit text into columnsTrace and fix formula errorsTrack changes and commentsTranslate data into another languageUpdate linked data sourcesUse Goal Seek to solve valuesUse Power Query to transform dataUse VLOOKUP or INDEX/MATCHUse data validation listsUse keyboard shortcuts efficientlyValidate data entry rules
Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
The rest of the map
Same library, five ways in.