MATERINYA SANAGT LENGKAP
WiseOwlTutorials
Formulas and basic functions in excel, in this course teaches you how to use Excel’s most essential tools to calculate, analyze, and organize data efficiently. You’ll learn how to write and combine formulas, understand cell references, and apply functions like SUM, AVERAGE, MIN, MAX, and COUNT to manage numerical data. The course also covers logical and text functions, as well as how to fix formula errors and use absolute and relative referencing. Through practical examples, you’ll gain confidence in building dynamic spreadsheets that automate calculations and save time. By the end, you’ll master the foundation of Excel formulas needed for professional data analysis and reporting. WiseOwlTutorials
To Register in Course you have to watch at least 30 Second of any lesson
What You'll Learn
-
Create and combine Excel formulas to automate calculations and data analysis efficiently
-
Apply fundamental functions like SUM, AVERAGE, MIN, MAX, and COUNT for numerical data management
-
Use logical functions such as IF to build decision-making formulas in spreadsheets
-
Troubleshoot and correct formula errors using cell references, absolute, and relative referencing techniques
Course Content
20 Lessons • 7 h 4 m total
Microsoft Excel Spilled Array Formulas
Excel Range Names The Basics
Excel Range Names Scope
Microsoft Excel The SORT and SORTBY Functions
Microsoft Excel The UNIQUE Function
Microsoft Excel The TRANSPOSE Function
Microsoft Excel The SEQUENCE Function
Microsoft Excel The FILTER Function
Microsoft Excel The XLOOKUP Function
Excel Range Names Implicit Intersection
Excel Basic IF Functions
Excel Nested IF Functions
Excel The IFS Function
Excel The SWITCH Function
Excel The AND OR and NOT Functions
Excel The SUM Function
Excel The AVERAGE MEDIAN and MODE Functions
Excel The MIN and MAX Functions
Excel The COUNT COUNTA and COUNTBLANK Functions
Excel The COUNTIF and COUNTIFS Functions
How to Get The Certificate
-
You must have an Account on the platform.
-
Complete all lessons.
-
Watch at least 50% of Lesson Duration.
-
Get your Certificate free 🎉 !
4.2
(21 reviews)
Overall rating
Reviews
Be the First One Review This Course
good
Wonderfull
AQSA NASIR
very helpfull
VERY INTERESTING COURSE
Good
Good and helpful
Good
Thoroughly elaborated.
THANKS.
top
Formulas and basic functions in excel Course Description
Formulas and basic functions in excel, in this course teaches you how to use Excel’s most essential tools to calculate, analyze, and organize data efficiently. You’ll learn how to write and combine formulas, understand cell references, and apply functions like SUM, AVERAGE, MIN, MAX, and COUNT to manage numerical data. The course also covers logical and text functions, as well as how to fix formula errors and use absolute and relative referencing. Through practical examples, you’ll gain confidence in building dynamic spreadsheets that automate calculations and save time. By the end, you’ll master the foundation of Excel formulas needed for professional data analysis and reporting. WiseOwlTutorials
Focus on Learning, Not Ads
Experience the full power of Mindluster with Premium.
No distractions, just pure education.
Cancel your subscription anytime