Flash SaleπŸŽ‰|70% discount on Courses!
5hours 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.
New Course
101 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

5hours left

₦3,300

70%

₦11,000

Course Features

93 Lessons(23 Hours)

101 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: New Course