Excel Intermediate Lesson 12: Project – Build a GST Sales Dashboard
Final project: KPI cards, GST totals from a product master, best month, top region and product, collection rate and a slicer-driven chart, all from…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Excel Intermediate Lesson 11: Conditional Formatting With Formulas
Excel Intermediate Lesson 11: Conditional Formatting With Formulas
Highlight whole rows for overdue invoices, above-average amounts, a chosen month or the top 3, using formula rules and the $ that makes them…
Read article →Excel Intermediate Lesson 10: Dependent Drop-Down Lists
Excel Intermediate Lesson 10: Dependent Drop-Down Lists
Choose a region, then only that region's cities appear: build dependent drop-downs with Data Validation, INDEX/MATCH and FILTER, and validate entries.
Read article →Excel Intermediate Lesson 9: PivotTables Deeper (Grouping, % of Total, Slicers)
Excel Intermediate Lesson 9: PivotTables Deeper (Grouping, % of Total, Slicers)
Group dates by month and quarter, show values as % of total, add calculated fields, slicers and timelines, and check your pivot against formulas.
Read article →Excel Intermediate Lesson 8: LET for Readable, Faster Formulas
Excel Intermediate Lesson 8: LET for Readable, Faster Formulas
Name the parts of a long formula with LET so it is readable and calculates once. Worked examples: GST, share of total, top rep…
Read article →Excel Lesson 3: Formatting Cells So Reports Read Well
Excel Lesson 3: Formatting Cells So Reports Read Well
Number, currency, percentage and date formats, custom formats like 000 and lakhs, alignment and wrap text, borders, Format Painter, cell styles — and why…
Read article →Excel Intermediate Lesson 7: Logic With IFS, SWITCH, AND and OR
Excel Intermediate Lesson 7: Logic With IFS, SWITCH, AND and OR
Replace long nested IFs with IFS and SWITCH, combine conditions with AND/OR, and count with AND/OR logic in COUNTIFS. Grades, commissions and follow-up flags.
Read article →Excel Intermediate Lesson 6: Business Dates (WORKDAY, NETWORKDAYS, EOMONTH, FY Quarters)
Excel Intermediate Lesson 6: Business Dates (WORKDAY, NETWORKDAYS, EOMONTH, FY Quarters)
Due dates, delivery dates with holidays, working days in a month, Indian financial-year quarters and FY labels, all with formulas you can copy.
Read article →Excel Intermediate Lesson 5: Cleaning Text With TEXTSPLIT, TEXTBEFORE and TEXTAFTER
Excel Intermediate Lesson 5: Cleaning Text With TEXTSPLIT, TEXTBEFORE and TEXTAFTER
Clean messy ERP and bank exports: split pipe-separated text, fix case and spaces, pull invoice numbers and names with TEXTBEFORE, TEXTAFTER, TEXTSPLIT, TRIM and…
Read article →Excel Intermediate Lesson 4: Dynamic Arrays (FILTER, SORT, UNIQUE, SEQUENCE)
Excel Intermediate Lesson 4: Dynamic Arrays (FILTER, SORT, UNIQUE, SEQUENCE)
One formula, many results: FILTER, SORT, SORTBY, UNIQUE and SEQUENCE spill whole lists that update themselves. With real examples from a sales register.
Read article →Excel Intermediate Lesson 3: INDEX/MATCH and Advanced XLOOKUP
Excel Intermediate Lesson 3: INDEX/MATCH and Advanced XLOOKUP
Two-way lookups, lookups to the left, last-match searches and not-found defaults with INDEX/MATCH and XLOOKUP, with a regional targets grid.
Read article →Excel Intermediate Lesson 2: SUMIFS, COUNTIFS and AVERAGEIFS Reports
Excel Intermediate Lesson 2: SUMIFS, COUNTIFS and AVERAGEIFS Reports
Build region, month and status reports from a raw sales register with SUMIFS, COUNTIFS and AVERAGEIFS, including date ranges, wildcards and not-equal criteria.
Read article →