Menu

Course Structure

4 Lesson
0 Quizzes

Time

2 months

Level

intermediate

Investment

30,000.00 LKR

Excel Booster Program

Chapter 1: Mastering Cell References for Dynamic Control

  • Mastering Absolute & Relative References

  • Expert Use of Fixed Cells, Columns, and Rows

 

Chapter 2: Strategic Range Naming for Workflow Efficiency

  • Streamlined Range Management with Name Manager

  • Quick Selection with Named Ranges

 

Chapter 3: Advanced Lookup Techniques

  • In-Depth Exploration of LOOKUP Functions (2-argument)

  • VLOOKUP: Exact vs. Approximate Matches

  • HLOOKUP for Horizontal Lookups

  • Unlocking XLOOKUP (Error Handling, Multi-Range Lookup, Search Modes)

  • MATCH & INDEX for Powerful Lookup Combos

 

Chapter 4: Logic-Based Data Analysis

  • Using AND & OR for Complex Conditions

  • Decision-Making with IF Statements

  • Layered Analysis with Nested IFs

  • Advanced IF Variants using AND/OR

 

Chapter 5: Intelligent Date Calculations (Part 2)

  • Calculating Workdays with NETWORKDAYS

  • Custom Calendars with NETWORKDAYS.INTL

 

Chapter 6: Advanced Date Functions (Part 3)

  • Calculating Time Gaps with DATEDIF

 

Chapter 7: Data Validation & Controlled Input

  • Set Rules for Numbers, Dates, and Text

  • Create Drop-Down Lists for Consistency

  • Improve Data Entry with Helpful Messages and Restrictions

 

Chapter 8: Pro-Level Duplicate Management

  • Smart Duplicate Removal with Unique Identifiers

  • Using the UNIQUE Function

  • Clean Data Efficiently with Power Query

 

Chapter 9: Powerful Data Splitting Tools

  • Split Text with Delimiters

  • Use Fixed Width Options for Structured Breaks

 

Chapter 10: Office 365’s Most Powerful Formulas

  • Unlocking Cutting-Edge Excel Functions

 

Chapter 11: Storytelling with Charts & Visuals

  • Design Compelling Charts for Clear Communication

 

Chapter 12: Dynamic Data Summaries with Pivot Tables & Charts

  • Interactive Data Summaries for Instant Insights

 

Chapter 13: Expert Excel Tips for Peak Productivity

  • Proven Shortcuts and Techniques to Save Time

 

Chapter 14: Practical Solutions for Complex Excel Issues

  • Hands-On Scenarios with Expert Fixes for Common Problems

 

Meet Your Instructor

Vidura Chathuranga

Welcome to Excel with Vidu! I am Vidura Chathuranga, a certified business accountant (CA Sri Lanka, Membership: CBA 2259) with over a decade of hands-on experience in Accounting, Management, and Data Analysis. Currently, I contribute my expertise to a prestigious IT company in Sri Lanka. further I work as a corporate trainer and provide consultation services to corporate sector in the field of Microsoft Excel. My journey in Excel is not just professional, it is a passion. I hold a postgraduate diploma in Business Management from NSBM Green University . I am really good with numbers and love making sense of data analysis. I am excited to share my knowledge with you On Social media, I am known as Excel With Vidu, where I've been actively sharing insights and tips on harnessing Excel power. Now, I am thrilled to extend this learning experience to SLTMobitel Esiphala.lk, offering you a comprehensive course in Advanced Microsoft Excel. In my courses, expect not only technical proficiency but a practical approach to real-world scenarios. Together, we will dive deep into Excel functionalities, empowering you to streamline processes, create powerful dashboards, and extract meaningful insights. Join Us on this learning journey and lets master Excel together. Whether you're a seasoned professional or just starting out, there is always more to discover in the world of Excel.

Lessons

Booster Level Intro

Preview

Excel Academy Intro

Preview

Webinar Live (2025-05-24)

Preview

Webinar Recording (2025-05-24)

Preview
Telegram