TRANSLATE Function in Excel: Translate Text in a Cell
TRANSLATE uses Microsoft’s translation service to translate text between languages, right in the sheet.
Read article →Atul Vij
Charts Lesson 6: Build a One-Page Excel Dashboard
Charts Lesson 6: Build a One-Page Excel Dashboard
Put it together: KPI cards, a trend chart, region and product breakdowns, a selector, consistent layout and colours, and print-ready setup for a one-page…
Read article →Charts Lesson 4: Sparklines and In-Cell Charts
Charts Lesson 4: Sparklines and In-Cell Charts
Put tiny charts inside cells: line, column and win/loss sparklines, high/low markers, data bars and REPT bars — perfect for tables and dashboards.
Read article →Charts Lesson 3: Combo Charts — Actual vs Target
Charts Lesson 3: Combo Charts — Actual vs Target
Show actual against target in one chart: column + line combo, secondary axis for percentages, target as a marker line, and highlighting months below…
Read article →Charts Lesson 2: Column, Bar and Line Charts Done Properly
Charts Lesson 2: Column, Bar and Line Charts Done Properly
Build clean column, bar and line charts in Excel: select data, insert, sort, gap width, data labels, axis formatting, removing clutter and saving a…
Read article →Charts Lesson 1: Choosing the Right Chart
Charts Lesson 1: Choosing the Right Chart
Match the chart to the question: comparison, trend, composition, relationship and distribution, with the charts that work and the ones that mislead.
Read article →Excel Intermediate Lesson 12: Project – Build a GST Sales Dashboard
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 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 →