Advanced Microsoft EXCEL 2010
Enroll now →
About this course
In this course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. It also covers Sparklines, and gives you enhanced knowledge of Pivot Tables and Charts. We will also cover topics like What-IF analysis, Solver Etc.
What you'll learn
- Nesting IF statements
- Using AVERAGEIF and SUMIF
- Performing lookups with HLOOKUP and VLOOKUP
- Creating Sparklines
- Advanced use of Pivot Tables and Charts
- Conducting What-IF analysis
- Utilizing Solver in Excel
Skills you'll gain
Related courses
Data Science Foundations
USD 49
Data Analytics in the Public Sector with R
USD 49
Data Science as a Field
USD 99
Geographic Information Systems (GIS)
USD 49
Statistical Methods and Data Analysis
USD 49
Data Visualization & Analytics in Tableau
USD 49
Programming for Python Data Science: Principles to Practice
USD 49
Enhancing Reproducible Science with GitHub and Docker
USD 49
Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.