Excel Analytics & Digital Visualization Skills (Excel Analytics – I)

Spreadsheet skills begin with knowing how to organize information—and grow into using formulas and charts to make that information easier to work with. Excel Analytics & Digital Visualization Skills (Excel Analytics – I) introduces those foundations in a sequence designed for first-semester. students following the Bengaluru North University syllabus.

Start with the spreadsheet essentials

The opening module covers the everyday building blocks: spreadsheet structure, basic text and cell formatting, arithmetic calculations, Paste Special, Freeze Panes, series completion, sorting, filtering and charts. Together, these topics introduce how spreadsheet data can be entered, arranged and presented.

Make common calculations with Excel functions

The next module turns to summarizing data. It introduces SUM, MIN, MAX, COUNT and AVERAGE, then moves into logical and conditional calculations with IF, SUMIF, AVERAGEIF and COUNTIF. These functions help students understand how spreadsheet formulas can answer straightforward questions about a dataset.

Work with text and validation

The final module introduces data validation and practical text functions: LEN, TRIM, PROPER, UPPER, LOWER and CONCATENATE. It rounds out the book’s progression from spreadsheet setup to working with numerical and text data.

A syllabus-led introduction

Organized into three modules with review questions, this first-edition textbook is written for undergraduate students and may also suit teachers and learners seeking a structured introduction to core Excel topics. The authors describe the presentation as accessible and note that the book can be used for self-study.

For students building their first spreadsheet toolkit, this volume offers a focused starting point in Excel analytics and digital visualization.