Flash SaleπŸŽ‰|Courses on Promo!
20hours left!

Data Analysis with Microsoft Excel – from Beginner to Advanced - AQskill

Data Analysis with Microsoft Excel – from Beginner to Advanced

Master Microsoft Excel from basics to advanced features, including formulas, pivot tables, and data visualization, for real-world applications.
4.8
(6 reviews)
6 students enrolled

What you'll learn

  • Introduction to Excel, its interface, and navigation along with basic data entry and cell formatting.
  • Managing workbooks, worksheets, and data organization techniques like inserting, deleting, and renaming sheets.
  • Understanding and working with basic mathematical, logical, and lookup functions, as well as understanding formula syntax and structure.
  • Techniques for sorting, filtering, and using advanced filtering options in Excel, including AutoFilter and Power Query.
  • Use of conditional formatting, PivotTables, PivotCharts, and best practices for visualizing data.
  • Importing and exporting data from various sources, and cleaning and transforming imported data.
  • Use of \"What-If\" scenarios, Data Tables, Goal Seek, Solver, and Scenario Manager for data analysis.
  • Introduction to, recording, running, and debugging macros, with a focus on best practices and security considerations.
  • Sharing workbooks, using Excel in the cloud, and methods to protect and review work.
  • Advanced functions, dashboard design, Excel and Power BI integration, and leveraging the Excel Developer tab for customization.
×
Rate our course

20hours left

$28

78%

$129

Course Features

92 Lessons(23 Hours)

6 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: 4.8