Excel & Business Math - Excel Built-in Functions, Data Types and Keyboards are Fast

Overview

Explore essential Excel concepts in this 34-minute video tutorial focusing on data types, built-in functions, and keyboard shortcuts. Learn how to leverage default alignment for error tracking, utilize aggregate functions like COUNT, COUNTA, SUM, MAX, MIN, and AVERAGE, and input multiple ranges into these functions. Master time-saving keyboard shortcuts to enhance productivity in Excel. Download accompanying files and access comprehensive notes to reinforce your learning experience.

Syllabus

) Introduction.
) Reminder about Save All Class Files to correct Folder.
) Data Types and Default Alignment.
) Define Aggregate Calculations.
) Look at the Excel Built-in Functions: COUNT, COUNTA, SUM, MAX, MIN and AVERAGE.
) How to enter multiple ranges into an Aggregate Excel Built-in Function.
) Keyboard Shortcuts for Speed.
) Summary.