Menu

Course Structure

5 Lesson
0 Quizzes

Time

4 months

Level

expert

Investment

45,000.00 LKR

Excel Toolkit + Booster Program

Excel Toolkit

 

Chapter 1: Excel Mastery Fundamentals

  • Discovering Excel’s Purpose and Capabilities

  • Navigating the Excel Interface

  • Boosting Productivity through Efficient Navigation

 

Chapter 2: Pro Excel Tools for Efficiency

  • Advanced Clipboard Usage

  • Font Customization for Better Visuals

  • Precision in Number Formatting

  • Consistent Styling with Formatting Guides

  • Expert Cell Management

  • Pro-Level Editing Tips

  • Intro to Conditional Formatting for Insights

  • Smart Sorting and Filtering Techniques

  • Automating Tasks with Flash Fill

  • Enhancing Excel with Add-Ins

  • Using Built-In Tools for Quick Data Analysis

 

Chapter 3: Core Formulas for Practical Use

  • Key Calculations for Accurate Results
    (SUM, AVERAGE, MAX, MIN, COUNT, etc.)

  • Text Manipulation Essentials (Part 1)
    (TRIM, PROPER, UPPER, LOWER, LEN)

  • Advanced Text Search & Replace
    (FIND, SEARCH, REPLACE, SUBSTITUTE)

  • Data Extraction & Joining Techniques
    (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)

  • Data Aggregation Basics
    (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, SUMIF, SUMIFS)

  • Date & Time Essentials (Part 1)
    (TODAY, NOW, DAY, MONTH, YEAR, DATE, EDATE)

 

Chapter 4: Keyboard Shortcuts to Save Time
(Covering CTRL-A to CTRL-Z)

 

Chapter 5: Pro Tips & Tricks for Workflow Efficiency

 

Chapter 6: Interactive Q&A with Real-World Scenarios

 

Booster 

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

Toolkit Level Intro

Preview

Booster Level Intro

Preview

Excel Academy Intro

Preview

Webinar Live (2025-05-24)

Preview

Webinar Recording (2025-05-24)

Preview
Telegram