Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Excel: Data Analysis and Visualization Techniques
Rating: 3.7 out of 5(6 ratings)
30 students

Advanced Excel: Data Analysis and Visualization Techniques

Use advanced formulas, functions, charts, pivot tables, macros, and more to create powerful and efficient spreadsheets
Created byStephen Saxton
Last updated 9/2023
English

What you'll learn

  • Advanced Excel Course. Apply data validation, conditional formatting, and advanced filtering techniques to manage and analyze data.
  • Understand how Power Pivot works, create relationships between data sets
  • Use the What IF analysis tools, Goal Seek, Scenario Manager, Data Tables and Solver
  • Create and modify pivot tables and pivot charts to summarize and visualize data.
  • Create multi-level data validation lists
  • Use formulas and functions such as VLOOKUP, INDEX, MATCH, IF, and SUMIFS to perform complex calculations and data analysis.
  • Record and edit macros to automate repetitive tasks and customize the Excel interface.
  • Create date related rolling averages and totals

Course content

10 sections • 28 lectures • 6h 58m total length

  • Revision12:38

    This section covers all the main elements coverd on the Intermediate courses and sets the scene for this course.

Requirements

  • You can take this courses as a stand alone but it will help if you have knowledge of Excel

Description

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 decisions


Section 0- Revision - Functions, Pivot tables, linking sheets, conditional formating, subtotal and data analysis.

Section 1- Functions - Ifs, countifs, sumifs, averageifs, index, match and forecast.ets

Section 2 - Data Analysis - Scenarios, Goal seek, Data tables, Solver and Forecast Sheets

Section 3 - Power Query, Power Pivot and Pivot table calculations

Section 4 - Text Functions - Concatenate, search, len, right, mid, iferror and database functions

Section 5 - Vlookup - Web links, advanced vlookup features

Section 6 - Macros - Record macros, add macros to command buttons

Section 7 - Form Controls - How to create form controls without using VBA

Section 8 - Data validation - How to create interdependent lists, how to use Indirect

Section 9 - Final consolidation exercise

Who this course is for:

  • Intermdiate Excel users wanting to know more

Report abuse