EXCEL-FORMULA.AW1
200+ Excel Formulas and Functions
Get started with the full-power course & master everyday Excel functions like: SUM, IF, VLOOKUP, LOOKUP, & Index.
- 15 Interaktive Lektionen Und 197 topics mapped to the official exam objectives
Intermediate Selbstgesteuert · 1 Jahr Zugang
15Interaktive Lektionen
197Topics
01 / Fähigkeiten, die Sie erwerben
What you will be able to do
Try Free →
Keine Kreditkarte benötigt
Supercharge your data skills with our 200+ Excel Formulas & Functions Course.
Gain hands-on training to perform day-to-day data analysis. The advanced course for business professionals covers functions that one can perform to streamline their data analytics procedure & enhance their work productivity. It includes mathematical functions like SUM, AVERAGE, MIN, MAX, ROUND, INT, &Logical functions such as IF, AND, OR, NOT, TRUE, and FALSE.
Develop your business intelligence by enrolling in the course & get access to a list of all Excel formulas curated just for your business.
- Efficiency Enhancement: Master your Excel skills with a top-tier formulas & Excel functions list to speed up your data & analytics tasks.
- Data Management Improvement: Organize, analyze, & present your data more efficiently with Excel formulas course & functions.
- Increased Work Productivity: Boost your work productivity by automating repetitive tasks & streamlining workflows.
- Career Advancement: Elevate your career by enhancing your advanced Excel skills.
- Mastering Navigation & Shortcuts: Master your Excel skills to use shortcuts for common tasks for easy navigation.
Course Highlights
-
15 Strukturierte Lektionen Umfassende Abdeckung der zentralen Kursziele
-
1 Jahr voller Zugang Selbstgesteuertes Lernen, jederzeit auf allen Geräten zugänglich
02 / Lektionen & Labore
See exactly what you will learn and practice
Unterrichtsplan
15 Interaktive Lektionen · 197 topics01 Preface +
02 Getting Started with Excel 2 topics +
- Using Excel
- Conclusion
03 The 10 Most Popular Functions in Excel 12 topics +
- SUM Function
- IF function
- LOOKUP function
- VLOOKUP function
- MATCH function
- CHOOSE function
- DATE function
- DAYS function
- FIND and FINDB functions
- INDEX function
- Conclusion
- Points to remember
04 Logical Functions in Excel 12 topics +
- AND function
- FALSE function
- TRUE function
- IFERROR function
- IFNA function
- IFS function
- NOT function
- OR function
- XOR function
- SWITCH function
- Conclusion
- Points to remember
05 Lookup and Reference Functions in Excel 19 topics +
- ADDRESS function
- AREAS function
- COLUMN and COLUMNS functions
- FILTER function
- FORMULATEXT function
- GETPIVOTDATA function
- HLOOKUP function
- HYPERLINK function
- INDIRECT function
- OFFSET function
- ROW and ROWS functions
- RTD function
- SORT and SORTBY functions
- TRANSPOSE function
- UNIQUE function
- XLOOKUP function
- XMATCH function
- Conclusion
- Points to remember
06 Math Functions in Excel 32 topics +
- ABS function
- ACOS and ACOSH functions
- ACOT and ACOTH functions
- ASIN and ASINH functions
- ATAN and ATANH functions
- CEILING and FLOOR functions
- COMBIN and COMBINA functions
- COS and COSH functions
- COT and COTH functions
- CSC and CSCH functions
- DECIMAL function
- DEGREES and RADIANS functions
- EVEN and ODD functions
- INT function
- LCM function
- LN and LOG functions
- MMULT functions
- MOD function
- POWER function
- PRODUCT function
- RAND and RANDBETWEEN functions
- ROMAN function
- ROUND, ROUNDUP, and ROUNDDOWN functions
- SEC and SECH functions
- SIGN function
- SIN and SINH function
- SQRT function
- SUBTOTAL function
- SUMIF, SUMPRODUCT, and SUMSQ functions
- TAN and TANH functions
- Conclusion
- Points to remember
07 Statistical Functions in Excel 28 topics +
- NORM.DIST and NORM.INV functions
- PERCENTILE.INC and PERCENTILE.EXC functions
- PHI function
- POISSON.DIST function
- PROB function
- QUARTILE.EXC and QUARTILE.INC functions
- RANK.AVG and RANK.EQ functions
- RSQ function
- SKEW and SKEW.S functions
- STDEVA and STDEVPA functions
- FORECAST and FORECAST.LINEAR functions
- GEOMEAN and HARMEAN functions
- The formula
- GROWTH function
- LOGNORM.DIST and LOGNORM.INV functions
- MEDIAN function
- MIN function
- NEGBINOM.DIST function
- STEYX function
- T.DIST, T.DIST.2T, and T.DIST.RT functions
- T.INV and T.INV.2T functions
- T.TEST function
- TREND function
- TRIMMEAN function
- VAR.P and VAR.S functions
- Z.TEST function
- Conclusion
- Points to remember
08 Text Functions in Excel 24 topics +
- CLEAN function
- CODE function
- CONCATENATE function
- DOLLAR function
- EXACT function
- FIND function
- FIXED function
- LEFT and RIGHT functions
- LEN function
- LOWER, UPPER functions
- MID function
- NUMBERVALUE function
- PROPER function
- REPLACE function
- SEARCH function
- SUBSTITUTE function
- Errors to avoid
- TEXT function
- TRIM function
- UNICHAR function
- UNICODE function
- VALUE function
- Conclusion
- Points to remember
09 Information Functions in Excel 17 topics +
- Cell function
- ERROR.TYPE function
- INFO function
- ISBLANK function
- ISERROR and ISERR functions
- ISEVEN and ISODD functions
- ISFORMULA function
- ISLOGICAL function
- ISNA function
- ISNUMBER function
- ISREF function
- ISTEXT function
- N function
- SHEET function
- Type function
- Conclusion
- Points to Remember
10 Financial Functions in Excel 14 topics +
- COUPDAYS, COUPNUM, and COUPPCD functions
- CUMIPMT and CUMPRINC functions
- DB and DDB functions
- DISC function
- DURATION and MDURATION functions
- EFFECT function
- INTRATE function
- IPMT function
- IRR, MIRR, and NPV functions
- NOMINAL function
- PRICE, YIELD, YIELDDISC, and YIELDMAT functions
- XIRR and XNPV functions
- VDB function
- Conclusion
11 Date and Time Functions in Excel 14 topics +
- DATE function
- Uses and applications
- DAY, MONTH, and YEAR functions
- The formula
- DAYS and DAYS360 functions
- EDATE and EOMONTH function
- HOUR, MINUTE, and SECOND functions
- ISOWEEKNUM and WEEKNUM functions
- NETWORKDAYS function
- NOW and TODAY functions
- TIME function
- WEEKDAY function
- Conclusion
- Points to remember
12 Database Functions in Excel 9 topics +
- DAVERAGE function
- DCOUNT function
- DCOUNTA function
- DGET function
- DMIN and DMAX functions
- DPRODUCT function
- DSUM function
- DSTDEV and DVAR functions
- Conclusion
13 Cube Functions in Excel 6 topics +
- CUBEMEMBER function
- CUBEKPIMEMBER function
- CUBEMEMBERPROPERTY function
- CUBERANKEDMEMBER function
- CUBEVALUE function
- Conclusion
14 Web Functions in Excel 4 topics +
- ENCODEURL function
- FILTERXML function
- WEBSERVICE function
- Conclusion
15 User-defined Functions in Excel 4 topics +
- CALL function
- EUROCONVERT function
- REGISTER.ID function
- Conclusion
03 / FAQS
Fragen, bevor Sie beginnen
How do I start learning Excel formula training? +
To learn Excel formulas & functions, you can start with the top-tier arithmetic operations & then navigate to advanced calculations. One can leverage the online resources, & practice formulas daily & even create an Excel formula cheat sheet for yourself.
What are the basic Excel formulas?+
Here is the list of all Excel formulas:
- SUM
- MIN & MAX
- AVERAGE
- COUNT
- POWER
- CEILING & FLOORa
- CONCAT
- TRIM
What is Hlookup?+
Hlookup, also known as Horizontal Lookup, is an Excel function used to search for a particular value in the above row of the table & then return a value in the specific row that you want to specify.
How many formulas are there in Excel? +
To be specific, there are over 450 primary formulas in Excel. Learn these to perform basic arithmetic operations, complex calculations, as well as data manipulation, and many more.
Keep going
You might also like
Ready to Master Your Excel Skills?
Learn to think like Excel, turn your boring spreadsheets into a robust data analytics tool & automate your workflow.