Free Practice Sheets

ch60-capstone-project-final-assessment.xlsx

ch59-excel-sql-external-data-apis.xlsx

ch58-office-scripts-power-automate.xlsx

ch57-vba-automation-userforms-events.xlsx

ch56-vba-programming-loops-conditions.xlsx

ch55-vba-introduction-macro-recording.xlsx

ch54-advanced-dashboard-design-kpi.xlsx

ch53-advanced-pivottables-data-models.xlsx

ch52-dax-fundamentals-measures.xlsx

ch51-power-pivot-data-model.xlsx

ch50-power-query-append-unpivot.xlsx

ch49-power-query-cleaning-transforming.xlsx

ch48-power-query-introduction.xlsx

ch47-solver-forecasting-sensitivity.xlsx

ch46-what-if-analysis-goal-seek.xlsx

ch45-financial-statistical-functions.xlsx

ch44-advanced-dynamic-arrays.xlsx

ch43-let-lambda-custom-functions.xlsx

ch42-advanced-xlookup-index-match.xlsx

ch41-advanced-formula-combinations.xlsx

ch40-interactive-dashboards-mis.xlsx

ch39-advanced-conditional-formatting.xlsx

ch38-charts-data-visualization.xlsx

ch37-pivotcharts-slicers-timelines.xlsx

ch36-pivottables-creation-grouping.xlsx

ch35-flash-fill-advanced.xlsx

ch34-text-to-columns-remove-duplicates.xlsx

ch33-sequence-randarray-take-drop.xlsx

ch32-dynamic-arrays-filter-sort-unique.xlsx

ch31-date-time-functions.xlsx

ch30-upper-lower-proper-substitute.xlsx

ch29-text-functions-left-right-mid.xlsx

ch28-iferror-ifna-error-handling.xlsx

ch27-xlookup-modern-lookup.xlsx

ch26-index-match-two-way-lookup.xlsx

ch25-hlookup-lookup-approximate.xlsx

ch24-vlookup-complete-guide.xlsx

ch23-averageif-averageifs.xlsx

ch22-sumif-sumifs-countif-countifs.xlsx

ch21-if-advanced-nested-ifs.xlsx

ch20-page-layout-print-settings.xlsx

ch19-find-replace-go-to-special.xlsx

ch18-data-validation-dropdowns.xlsx

ch17-conditional-formatting-basic.xlsx

ch16-excel-tables-structured-references.xlsx

ch15-filtering-advanced-filters.xlsx

ch14-sorting-data-multi-level.xlsx

ch13-logical-functions-if-and-or.xlsx

ch12-counta-countblank-large-small.xlsx

ch11-sum-average-min-max-count.xlsx

ch10-cell-references-absolute-mixed.xlsx

ch09-basic-formulas-operators.xlsx

ch08-copy-cut-paste-paste-special.xlsx

ch07-row-height-column-width-grouping.xlsx

ch06-number-formats-date-time.xlsx

ch05-formatting-cells-fonts-colors.xlsx

ch04-saving-opening-file-formats.xlsx

ch03-data-entry-autofill-flashfill.xlsx

ch02-workbooks-worksheets-cells-ranges.xlsx

ch01-introduction-excel-interface.xlsx

Flash Fill Practice Sheet.xlsx