Excel 2019: Use Functions & Quick Analysis

Course description

This course explores essential functions, reference types, and analysis tools in Microsoft Excel 2019 that help transform raw data into meaningful results. Learners begin with Excel’s most frequently used built-in functions, SUM, AVERAGE, COUNT, MAX, and MIN, learning their syntax, use cases, and how to apply them to data ranges for quick calculations. Lessons demonstrate how AutoSum streamlines function entry, letting users automatically calculate sums, averages, and other metrics without manually typing formulas. Participants then learn to access and use the Function Library to select, insert, and modify formulas from categories such as financial, logical, and text functions. Building on these fundamentals, the course covers cell referencing, explaining relative, absolute, and mixed references and how each behaves when formulas are copied or moved across cells or worksheets, ensuring accurate results and reducing errors. The course concludes with an introduction to the Quick Analysis tool, which lets users instantly apply formatting, create charts, insert totals, and generate tables to interpret data visually and efficiently. Through demonstrations, learners see how Quick Analysis can summarize information and highlight trends with minimal effort, eliminating the need for manual setup. By the end, participants will be able to use common functions, apply precise referencing techniques, and leverage built-in analysis tools to improve data accuracy and presentation.

Course outline