Excel Formulas and Functions - Excel for Beginners

Overview

Learn essential Excel formulas and functions for beginners in this comprehensive tutorial. Master the basics of spreadsheet manipulation, including order of operations, editing and copying formulas, and hiding formulas. Explore various functions such as COUNT, AVERAGE IF, CONCATENATE, and COUNTIF. Gain practical skills to effectively use Microsoft Excel for data analysis and visualization, with interactive opportunities to ask questions throughout the session.

Syllabus

Introduction
Learning Objectives
Excel Formulas
Order of Operations
Editing a Formula
Copying a Formula
Hide Formula
Functions
View and Search Functions
Basic Excel Functions
Count Function
Average If Function
Concatenate
Countif