Complete Excel Megacourse: Beginner to Expert

Learn how to use Microsoft Excel like a pro with this step-by-step course!

Created by: Creativity Unleashed
Amazing online courses to unleash your creativity

What Will I Learn?

• How to use Microsoft Excel and its basic functions
• How to create worksheets
• Everything about using and formatting cells
• How to use autofill
• The principles and use of formulas
• How to manipulate data through different functions
• How to use and master Excel’s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF
• Simple graphs and charts
• How to create a budgetary system
• All the new functions in Excel 365
• How to customize your charts
• How to use dashboards
• How to create 2D or 3D maps
• How to use Pivot Tables, Power Query, Power Pivot, and Dynamic Array Formulas to analyze large datasets efficiently
• Techniques for cleaning and preparing data to ensure accurate analysis results
• Tips and tricks for using Excel functions to check and manipulate data

Requirements

• No previous knowledge of Excel required
• A desire to learn!
• A positive attitude!

Target audience

• Anyone who wants to learn to use Microsoft Excel - no experience needed!
• Professionals who want to learn new tools of Excel
• Anyone who wants take their Excel skills from beginner to advanced
• Anyone with specialised needs (data analysts, businessmen, students, researchers, etc.)