Microsoft Excel (from beginner to advanced)

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Welcome to the world of Microsoft Excel, the industry-leading spreadsheet application designed to help you turn complex data into actionable insights. Whether you’re managing budgets, analyzing trends, or creating detailed reports, Excel is your go-to tool for seamless data organization and analysis.

සංකීර්ණ දත්ත ක්‍රියාකාරී තීක්ෂ්ණ බුද්ධියක් බවට පත් කිරීමට ඔබට උදවු කිරීමට නිර්මාණය කර ඇති කර්මාන්තයේ ප්‍රමුඛ පැතුරුම්පත් යෙදුම වන Microsoft Excel ලෝකයට සාදරයෙන් පිළිගනිමු. ඔබ අයවැය කළමනාකරණය කළත්, ප්‍රවණතා විශ්ලේෂණය කළත්, හෝ සවිස්තරාත්මක වාර්තා නිර්මාණය කළත්, Excel යනු බාධාවකින් තොරව දත්ත සංවිධානය කිරීම සහ විශ්ලේෂණය සඳහා ඔබේ යා යුතු මෙවලමයි.

Course Outline:

  1. Introduction to Microsoft Excel
    • Overview of the Excel interface
    • Navigating workbooks and worksheets
    • Basic data entry and editing techniques
  2. Formulas and Functions
    • Understanding cell references
    • Using basic functions (SUM, AVERAGE, IF, etc.)
    • Nesting functions and using named ranges
  3. Data Management
    • Sorting and filtering data
    • Using conditional formatting
  4. Charts and Graphs
    • Creating and formatting charts (bar, line, pie, etc.)
    • Adding trendlines and annotation
  5. PivotTables
    • Creating PivotTables to summarize data
  6. Advanced Data Analysis
    • Using advanced functions (VLOOKUP, INDEX-MATCH, etc.)
    • Working with arrays and array formulas
    • Using What-If Analysis tools
Show More

What Will You Learn?

  • Dynamic Spreadsheets: Create and manage spreadsheets effortlessly with a flexible grid of rows and columns. Customize your data presentation with a variety of cell formats and data types.
  • Advanced Formulas and Functions: Perform intricate calculations with an extensive library of built-in functions. From basic arithmetic to advanced statistical and financial analysis, Excel makes data manipulation straightforward.
  • Powerful Data Analysis Tools: Dive deep into your data using pivot tables, charts, and graphs. Quickly summarize, filter, and visualize your information to uncover trends and make informed decisions.

Course Content

THEORY LESSONS

  • Lesson 01 – Video ( විෂය කරුණු.(Introduction of Excel, Create Equations))
    01:11:03
  • Lesson 02 – Video ( විෂය කරුණු.(Basic Fuctions, SUM, AVERAGE, MAX, MIN, COUNT and Simple IF Function)
    01:07:10
  • Lesson 03 – Video ( විෂය කරුණු.(More IF Function, Auto Filter, Advanced Filter, Auto Fill)
    57:18
  • Lesson 04 – Video (විෂය කරුණු.(Conditional Formatting, Chats)
    35:50
  • Lesson 05 – Video (විෂය කරුණු. (SIMIF, COUNTIF, AVERAGEIF, Relative Reference and Abustle Reference)
    32:58
  • Lesson 06 – Video (විෂය කරුණු. (Sort, LEFT, RIGHT, MID FUNCTION)
    47:34
  • Lesson 07 – Video (විෂය කරුණු. (VLOOKUP FUNCTION)
    51:03
  • Lesson 08 – Video (Advanced Practical lesson)
    32:39
  • Lesson 09 – Video ((Project work)
    19:41

Short Video Lessons

Theory PDF Notes

PRACTICALS