Excel - Intro to the Basics, Formulas, and Functions - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: Excel - Intro to the Basics, Formulas, and Functions (/Thread-Excel-Intro-to-the-Basics-Formulas-and-Functions)

Excel - Intro to the Basics, Formulas, and Functions - OneDDL - 06-26-2024 Free Download Excel - Intro to the Basics, Formulas, and Functions Published 6/2024 Created by Robert Mathisen MP4 | Video: h264, 1280x720 | 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 [To see links please register or login] Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live [To see links please register or login] No Password - Links are Interchangeable