Flash SaleπŸŽ‰|70% discount on Courses!
1day 4hours left!

Microsoft Excel - from Beginner to Advanced | AQskill

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.
(102 reviews)
1733 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

1day 4hours left




Course Features

93 Lessons(23 Hours)

1733 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: 4.9