Courses › Microsoft Excel Essentials : Proficiency Certification
Microsoft Excel Essentials : Proficiency Certification
Learn Microsoft Excel Essentials for Corporate Office Work, Business Work or even for Personal Use. This course covers the very foundation of microsoft excel up to Interactive Dashboards and Macro Automations.
📋 10 Parts🎬 Video per part📂 Exercise files included🏆 Certificate on completion♾️ Lifetime access
Excel Basic Cells and Table Formatting, Basic Functions and Formulas, Conditional Formatting, Data Validation Rules.
The Excel Basic Cells and Table Formatting, Basic Functions and Formulas, Conditional Formatting, and Data Validation Rules course teaches essential spreadsheet skills for creating organized, accurate, and professional-looking Excel worksheets.
📂 Exercise File🎬 Video📤 Submit Work
2
Excel Automated Numbering using Text Functions, Average Functions, Constant Cell Values, Logical Statement IF and Multi-condition formatting.
The **Excel Automated Numbering using Text Functions, Average Functions, Constant Cell Values, Logical Statement IF, and Multi-condition Formatting** course teaches powerful Excel techniques to automate calculations, enhance data accuracy, and create dynamic, professional spreadsheets.
📂 Exercise File🎬 Video📤 Submit Work
3
Excel Percentage, Index, Offset, Match and Average Functions
The **Excel Percentage, INDEX, OFFSET, MATCH, and AVERAGE Functions** course teaches essential Excel formulas for performing calculations, retrieving data dynamically, and analyzing information more efficiently.
📂 Exercise File🎬 Video📤 Submit Work
4
AverageIfs, SumIfs and CountIfs Functions. Hybrid Functions
The **AVERAGEIFS, SUMIFS, COUNTIFS, and Hybrid Functions** course teaches advanced Excel techniques for performing multi-condition calculations and building powerful, efficient formulas for data analysis.
📂 Exercise File🎬 Video📤 Submit Work
5
Excel VLookUp Functions : True and False Variants
The **Excel VLOOKUP Functions: TRUE and FALSE Variants** course teaches how to perform both approximate and exact lookups, enabling accurate data retrieval and efficient spreadsheet management.
📂 Exercise File🎬 Video📤 Submit Work
6
Excel Pivot Table and Charts
The **Excel Pivot Table and Charts** course teaches how to summarize, analyze, and visualize data using PivotTables and PivotCharts to create insightful and interactive reports.
📂 Exercise File🎬 Video📤 Submit Work
7
Excel WhatIf Analysis and Solver
The **Excel What-If Analysis and Solver** course teaches how to evaluate different scenarios, optimize results, and make data-driven decisions using Excel's powerful analytical tools.
📂 Exercise File🎬 Video📤 Submit Work
8
Excel Power Query
The **Excel Power Query** course teaches how to import, clean, transform, and automate data preparation for faster, more efficient reporting and analysis in Excel.
📂 Exercise File🎬 Video📤 Submit Work
9
Excel Interactive Dashboard
The **Excel Interactive Dashboard** course teaches how to create dynamic dashboards with charts, slicers, and KPIs to transform data into clear, interactive business insights.
📂 Exercise File🎬 Video📤 Submit Work
10
Excel Macro Data Entry
The **Excel Macro Data Entry** course teaches how to automate data entry tasks using VBA macros to improve accuracy, reduce repetitive work, and increase productivity in Excel.