Become an Expert in Excel & Google Sheet Formula & Functions
Master key formulas and functions in Excel and Google Sheets for better data insights and faster workflows.
4.13 (24 reviews)
3 779
students
3.5 hours
content
Sep 2024
last update
$13.99
regular price
What you will learn
Understanding Excel & Google sheet Formulas & Functions
User Interface Overview
Basic Arithmetic Operations
Using Cell References: Relative, Absolute, Mixed
SUM, AVERAGE, MIN, MAX
COUNT and COUNTA Functions
CONCATENATE and TEXTJOIN Functions
Formatting Dates and Times
VLOOKUP and HLOOKUP Functions
INDEX and MATCH Functions
Using Named Ranges for Enhanced Readability
Statistical Analysis with Functions: MEDIAN, MODE, STDEV, etc.
Analyzing Data Distributions and Variability
Nested Functions and Formula Nesting
Array Formulas for Complex Calculations
Financial Functions: PV, FV, NPV, IRR
Summarizing Data with PivotTables
Filtering and Analyzing Data with Slicers
Introduction to Power Query for Data Transformation
Integrating Power Query Results with Excel Functions
Error Checking and Correction Techniques
Utilizing Keyboard Shortcuts for Formula Writing
Course Gallery
Loading charts...
6182711
udemy ID
14/09/2024
course created date
17/09/2024
course indexed date
Bot
course submited by