Advanced Excel Functions & Visualization

In this lesson you will

Calculate totals and counts by condition
Choose a suitable chart

With clean data in hand, Excel's analytical functions and charts turn raw numbers into visible patterns a business can act on.

SUMIFS/COUNTIFS: Sum or count with multiple conditions, e.g. total sales for "Juba" AND "March."
Charts: Line charts for trends over time, bar charts for comparing categories, pie charts sparingly for simple proportions.
Sparklines: Tiny in-cell charts that show a trend at a glance within a table, useful for compact reports.
Choose the chart type based on the question being answered, not by what looks most decorative.

Practical Skill: Use SUMIFS to build a region-by-month sales summary table from raw transaction data, then chart it as a line chart showing the trend per region.

TemplateSUMIFS Summary & Chart

Worksheet

=== SUMIFS EXAMPLE ====SUMIFS(SalesAmount, Region, "Juba", Month, "March")  Adds sales where Region = "Juba" AND Month = "March" === REGION-BY-MONTH SUMMARY (built with SUMIFS) ===  Region    Jan       Feb       Mar  Juba      120,000   135,000   142,000  Wau        80,000    95,000    88,000  Malakal    60,000    58,000    70,000 Chart choice: Line chart with Month on the x-axis and oneline per region — clearly shows the trend for each regionover time, which a bar chart per month would make harderto compare.

Practice exercise

Use SUMIFS to total sales for each branch, calculate each branch's share of the total and show the result in a sorted bar chart.

Key takeaways

SUMIFS and COUNTIFS answer 'how much' and 'how many'
Growth divides by the earlier value
Chart titles should state the finding

In the full program Module 2: Excel Analysis Functions and Charts See how this topic is taught in depth, with practical activities and an assessment.

Free self-study lesson — no certificate. For the full instructor-led program, see registration options.