Excel – Intro to the Basics, Formulas, and Functions

Free Download Excel – Intro to the Basics, Formulas, and Functions
Published 6/2024
Created by Robert Mathisen
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 195 Lectures ( 9h 1m ) | Size: 4.35 GB

Discover Microsoft Excel’s basics, gain a deep understanding of how it works, and how to use its 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.
Homepage

https://www.udemy.com/course/excel-intro-to-the-basics-formulas-and-functions/