Udemy Certificate 0

Advanced Excel: Data Analysis and Visualization Techniques

Name: Advanced Excel: Data Analysis and Visualization Techniques
Price: 19.99 USD
Availability: InStock

About this course

This course is designed for professionals who want to master the advanced features and functions of Microsoft Excel. You will learn how to use formulas, functions, charts, pivot tables, macros, data analysis tools, and more to create dynamic and interactive spreadsheets that can automate tasks, enhance productivity, and present data in a clear and compelling way. You will also learn how to collaborate with others using Excel online and share your workbooks securely. By the end of this course, you will be able to:- Apply advanced formulas and functions to perform complex calculations and data analysis- Create and customize charts, graphs, sparklines, and slicers to visualize and summarize data- Use pivot tables and pivot charts to manipulate and analyze large data sets- Record, and run macros to automate repetitive tasks and simplify workflows- Use data analysis tools such as Goal Seek, Solver, Scenario Manager, and Data Tables to solve problems and optimize decisionsSection 0- Revision - Functions, Pivot tables, linking sheets, conditional formating, subtotal and data analysis.Section 1- Functions - Ifs, countifs, sumifs, averageifs, index, match and forecast.etsSection 2 - Data Analysis - Scenarios, Goal seek, Data tables, Solver and Forecast SheetsSection 3 - Power Query, Power Pivot and Pivot table calculationsSection 4 - Text Functions - Concatenate, search, len, right, mid, iferror and database functionsSection 5 - Vlookup - Web links, advanced vlookup featuresSection 6 - Macros - Record macros, add macros to command buttonsSection 7 - Form Controls - How to create form controls without using VBASection 8 - Data validation - How to create interdependent lists, how to use IndirectSection 9 - Final consolidation exercise

62/100

CourseAsk score

What the provider tells you: 38/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

apply advanced formulas and functions
create and customize charts and graphs
use pivot tables and pivot charts
record and run macros
implement data analysis tools like Goal Seek and Solver

Data Analysis #data visualization #excel #automation #data analysis #vlookup #macros #pivot tables #charts #data presentation #productivity #data tools #collaboration #formulas #advanced functions #scenarios #goal seek #solver

$19.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.