Excel Formulas & Functions - Find Answers in Your Excel Data
Excel Training-How to Use Formulas and Functions in Excel Spreadsheets-Learn on Excel 2010, Excel 2013, or Excel 2016
4.55 (7669 reviews)
34 642
students
1.5 hours
content
Oct 2021
last update
$59.99
regular price
What you will learn
Identify formulas and functions and know the difference between the two.
Locate and use any of the functions in Excel using various methods, such as the Formula Tab.
Use the 7 most important Excel functions in common spreadsheet computations.
Understand the important difference between Absolute and Relative cell references to increase your computing power.
Identify the various parts of an Excel formula so you can create or modify formulas to fit your needs.
Use the SUM function in Excel
Use AVERAGE and AVERAGEA functions in Excel
Use COUNT and COUNTA functions in Excel
Use IF functions in Excel
Use SUMIF and SUMIFS functions in Excel
Use COUNTIF and COUNTIFS functions in Excel
Use VLOOKUP in Excel
Use LEFT, RIGHT and MID functions in Excel
Course Gallery
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
Comidoc Review
Our Verdict
This course effectively equips learners with indispensable Excel skills across a variety of everyday computations. The instructor's focus on the seven most crucial functions—including VLOOKUP, SUMIF, and COUNTIF—provides students with a hands-on understanding of essential formulas that can be directly applied to their work or projects. While some users may yearn for more advanced techniques and keyboard shortcuts or seek an update for the latest Excel versions, this course is tailored for beginners who benefit from simple explanations and foundational concepts critical to becoming proficient in Excel spreadsheet management and data manipulation.
What We Liked
- Comprehensive coverage of fundamental Excel functions such as SUM, AVERAGE, COUNT, IF, and VLOOKUP
- Clearly explained formulas and techniques that are easy to follow
- Specifically designed for Excel 2010, 2013, and 2016 versions
- Highly relevant examples catering to common spreadsheet computations
Potential Drawbacks
- Lack of exercise sheets or templates to practice alongside the course
- Minimal coverage of advanced features such as keyboard shortcuts in Excel
- Some users expect more formulas and functions, especially for those with prior experience
- Limited applicability to newer versions of Excel
Related Topics
600086
udemy ID
02/09/2015
course created date
22/07/2019
course indexed date
Bot
course submited by