ACCA

₹1,800 ₹2,000

Course Includes

Duration2 Months
Enrolled9
Lectures60
Videos0
Notes0
CertificateYes

What you'll learn

high-level proficiency in Microsoft Excel, focusing on automation, complex data analysis, and visualization beyond basic spreadsheet tasks. It includes mastering tools like PivotTables, VBA Macros, Power Query, and complex formulas (e.g., XLOOKUP, INDEX/MATCH) to manipulate large datasets and create interactive dashboards.

Course Syllabus

Advanced Formulas and Functions:

Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH combinations.
Logical Functions: Nested IF, AND, OR, IFERROR.
Text & Date Functions: TEXTJOIN, LEFT, RIGHT, MID, DATEDIF.
Array Formulas: Basic examples, using IF, LEN, and MID within arrays.

Data Analysis and Visualization:

PivotTables and PivotCharts: Creating, customizing, and formatting.
Dashboard Creation: Developing interactive reports and visualizations.
Data Validation: Creating dropdown lists, restricting data input based on formulas.
Conditional Formatting: Advanced rules, using formulas to highlight data.

Data Analysis Tools:

What-If Analysis: Goal Seek, Data Tables, Scenario Manager.
Solver Add-in: For complex optimization problems.

Automation and Macros (VBA):

Macro Recorder: Recording and running macros to automate repetitive tasks.
VBA Programming: Introduction to visual basic editor, writing simple scripts, and user-defined functions.

Data Management and Protection: