Dalilk | Advanced Microsoft Excel Training

Course / Course Details

Advanced Microsoft Excel Training

Digital Skills and Software Courses

By - Mudasir Hussain
0 students
30 Hours
(0)

Course Description

This course equips participants with advanced Excel skills for professional data handling and business intelligence tasks. You will learn to apply complex formulas, automate tasks with macros, analyze data using PivotTables, create dashboards, and collaborate securely — empowering you to manage and report large datasets effectively.

🧩 Course Modules

📌 Module 1: Advanced Formatting & Functions

Applying advanced number formats
Conditional formatting using formulas
Absolute vs. Relative references
Named ranges and their use in formulas
Logical & lookup functions: IF, SUMIF, COUNTIF, VLOOKUP, HLOOKUP

📌 Module 2: Working with Data

Understanding structured lists
Sorting, subtotaling, and outlining data
Filtering: standard and advanced
Using Autofill for efficiency

📌 Module 3: Data Analysis Tools

Creating and managing PivotTables
Designing PivotCharts
Trendlines and chart analysis
What-If Analysis: Scenario Manager, Goal Seek
Data cleaning tools: Text to Columns, Remove Duplicates
Data validation techniques

📌 Module 4: Collaboration & Security

Creating shared workbooks
Consolidating data from multiple sheets
Using comments effectively
Applying security with password protection

📌 Module 5: 3D Referencing in Excel

What is a 3D reference?
Creating and editing 3D formulas
Managing multi-sheet references with defined names

📌 Module 6: Introduction to Macros

Enabling Developer tab
Recording and running macros
Macro recorder settings
Editing basic VBA code
Handling macro errors

Course Outcomes

By the end of this course, participants will:

Master complex formulas and dynamic data analysis tools
Automate repetitive Excel tasks using macros
Create interactive reports and dashboards
Improve collaboration and data security in Excel workbooks
Gain skills aligned with job roles in finance, analytics, and operations

Course Curriculum

0 chapters
0 lectures
0 quizzes
30 Hours total length

Toggle all chapters

Instructor

Mudasir Hussain

Experienced technology professional with 10+ years of expertise in software engineering, project management, and IT governance. As a Project Manager at OmanCloud, led the development of software for Oman Development Bank, delivering scalable solutions aligned with business objectives. Proven track record in e-Governance, including the creation of an app for farmers as part of Pakistan's agricultural digital initiatives. Skilled in leading cross-functional teams, driving digital transformation, and implementing robust IT strategies using technologies like Python, Docker, Kubernetes, and cloud platforms. Holds advanced certifications in AI, cloud computing, and project management, with a strong foundation in deep learning, data architecture, and Agile methodologies.

0 Rating