Excel – Intro to the Basics, Formulas, and Functions

What you’ll learn:
The basics of Excel and the available features.
Gain a fundamental and deep understanding of how Excel works.
Understand the Functions that are available to you, their capabilities, and how they behave.
Learn how to Nest Functions together to get more out of these functions.

Requirements:
Must have access to Microsoft Excel (ideally O365, Office 2021, or Office 2019)

Description:
Getting to know Excel
Understanding Workbooks and Worksheets
Exploring the User Interface
Navigating
Shortcuts for moving the Cell Pointer
Ribbon
Dialog Boxes

Entering and Editing Data
Data Types
Entering Data
Editing & Deleting Cell Contents
Undo & Redo
Inserting Cells
AutoFill
AutoComplete
Intro to Formatting

Worksheet Operations
Moving and Resizing Windows
Activating a Worksheet
Adding, Deleting, and Renaming Worksheets
Zooming In & Out
Freezing Window Panes
Selecting, Adding, Deleting, and Hiding Rows and Columns

Working with Ranges
Finding and Replacing Data
Copying, Moving, and Cutting Ranges
Paste Special
Adding, Editing, and Removing Hyperlinks
Notes
Sort and Filter
Custom Sort

Formatting
Fonts
Text Alignment
Colors and Shading
Borders and Lines
Format Painter

Saving and Password Protection
Creating a New Workbook
Opening an Existing Workbook
Saving a Workbook
Changing the Default File Location
Password-Protecting a Workbook

Printing
Previewing the Printout
Changing your Page View
Previewing the Pages
Creating PDF Files

Intro to Formulas, Functions, and Cell References
Formulas
Functions
Relative & Absolute Cell References
Mixed References
Circular References

Math Functions
RANDBETWEEN
ROUND, ROUNDUP, ROUNDDOWN
INT, TRUNC, ROUND
MROUND
FLOOR, CEILING
ODD, EVEN
MOD
SUM, AutoSum, Alt + Plus Sign, Quick Analysis
Running Total Formula
SUMIF
SUMIFS

Logical Functions
AND
IF

or
IFS
Nested IF
ISEVEN
ISODD
ISBLANK
ISFORMULA
ISERROR, IFERROR

Statistical Functions
AVERAGE
MEDIAN
MODE
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
MAX, MIN

Text Functions
UPPER, LOWER, PROPER
LEN
TRIM
Concatenation using the Ampersand symbol (&)
LEFT, RIGHT, MID
TEXTBEFORE
TEXTAFTER
Text to Columns
TEXTJOIN
CONCATENATE
TEXTSPLIT
TEXT (including Leading Zeros and Padding Zeros)
TYPE
VALUE
T

Date & Time Functions
TODAY
MONTH
DAY
YEAR
WEEKDAY
DAYS
EOMONTH

NOW
HOUR
MINUTE
SECOND

Lookup Functions
XLOOKUP
UNIQUE
TRANSPOSE
VSTACK, HSTACK

Who this course is for:
Anyone looking for a deeper understanding of Microsoft Excel.