Udemy Certificate 0

Advanced Microsoft EXCEL 2010

Name: Advanced Microsoft EXCEL 2010
Price: 19.99 USD
Availability: InStock

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.

55/100

CourseAsk score

What the provider tells you: 31/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

Create and troubleshoot nested IF formulas
Apply AVERAGEIF and SUMIF for conditional calculations
Perform horizontal and vertical lookups using HLOOKUP and VLOOKUP
Generate Sparklines to visualize trends within cells
Build and customize Pivot Tables and associated charts
Conduct What‑If analysis to explore data scenarios
Use Solver to find optimal solutions for linear problems

Course objectives

Teach advanced Excel functions and formulas
Show how to organize and analyze data with Pivot Tables and charts
Demonstrate scenario analysis and optimization tools within Excel

Data Analysis #excel #data analysis #pivot tables #charts #advanced excel #sparklines #if statements #sumif #averageif #lookup functions #what-if analysis #solver #nested IF #vlookup #hlookup

$19.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.