Language: English (US)

Discover Microsoft Excel's basics, gain a deep understanding of how it works, and how to use its Formulas and Functions.

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

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