• Home
  • Register Now
  • Courses

    Our Courses

    • All Courses
    • Microsoft Office
    • Development
    • Business
    • Design
    • Photography
    • Music
    • Language
    Microsoft Powerpoint 2010

    Microsoft Powerpoint 2010

    Free
    Read More
    Microsoft Powerpoint 2010

    Microsoft Powerpoint 2010

    Free
    Read More
  • Become an Instructor
  • Blog
  • Contact
    Have any question?
    info@maxmind.lk
    maxmindeducation@gmail.com
    Login
    MAXMIND eLearningMAXMIND eLearning
    • Home
    • Register Now
    • Courses

      Our Courses

      • All Courses
      • Microsoft Office
      • Development
      • Business
      • Design
      • Photography
      • Music
      • Language
      Microsoft Powerpoint 2010

      Microsoft Powerpoint 2010

      Free
      Read More
      Microsoft Powerpoint 2010

      Microsoft Powerpoint 2010

      Free
      Read More
    • Become an Instructor
    • Blog
    • Contact

      Microsoft Office

      • Home
      • All courses
      • Microsoft Office
      • Microsoft Excel 2010

      Microsoft Excel 2010

      User Avatar
      WKD Dilshan Maduranga
      Microsoft Office
      (0 review)
      Free
      Microsoft-Excel-2016-Advanced-Training
      • Overview
      • Curriculum
      • Instructor
      • Reviews

      Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions.

      Microsoft Excel මුදුකංගය මගින් ඔබට ඉතා පහසුවෙන් හා ඉතා ඉක්මනින් කාර්යාලීයපැතුරුම්පත් හා විවිද ලේඛණ නිර්මාණය කරගත හැක. වැඩි විස්තර සදහා පහත Video ව නරබන්න.


      Certificate of Completion*
      පාඨමාලාව අවසානයේ වටිනා සහතිකපතක්*

      Course Features

      • Lectures 33
      • Quizzes 1
      • Duration 5.30 hours
      • Skill level All levels
      • Language Sinhala
      • Students 2
      • Assessments Yes
      CoursesMicrosoft OfficeMicrosoft Excel 2010
      • Section 01: Introduction 2

        • Lecture1.1
          01.1: Introduction to Microsoft Excel 2010 Course 06 min
        • Lecture1.2
          01.2 Microsoft Excel Interface 06 min
      • Section 02: Working With Cells 2

        • Lecture2.1
          2.1 Working With Cells – 01 12 min
        • Lecture2.2
          2.2 Working With Cells – 02 11 min
      • Section 03: Working With Worksheets 3

        • Lecture3.1
          3.1 Working With Worksheets 08 min
        • Lecture3.2
          3.2 Freezing Panes 05 min
        • Lecture3.3
          3.3 Protecting Work Sheet 05 min
      • Section 04: Sorting Data 1

        • Lecture4.1
          4.1 Sorting Data 05 min
      • Section 05: Outlining Data 1

        • Lecture5.1
          5.1: Outlining Data 05 min
      • Section 06: Filtering Data 1

        • Lecture6.1
          6.1 Filtering Data 06 min
      • Section 07: Formatting Tables 1

        • Lecture7.1
          7.1 Formating Tables 05 min
      • Section 08: Working With Charts 1

        • Lecture8.1
          8.1 Working With Charts 16 min
      • Section 09: Working With Sparklines 1

        • Lecture9.1
          9.1 Working With Sparklines 04 min
      • Section 10: Working With Conditional Formatting 1

        • Lecture10.1
          10.1 Working With Conditional Formatting 05 min
      • Section 11: Creating Formulas 2

        • Lecture11.1
          11.1: Creating Formulas 13 min
        • Lecture11.2
          11.2 Relative References & Absolute References 08 min
      • Section 12: Working With Functions 13

        • Lecture12.1
          12.1: Working With Functions 05 min
        • Lecture12.2
          12.2 NETWORKDAYS Function 04 min
        • Lecture12.3
          12.3 IF Function 04 min
        • Lecture12.4
          12.4 COUNTIF Function 10 min
        • Lecture12.5
          12.5 Count Blank_Nonblank Cells 04 min
        • Lecture12.6
          12.6 Sumproduct Function 04 min
        • Lecture12.7
          12.7 Nested If 05 min
        • Lecture12.8
          12.8 DateDif 04 min
        • Lecture12.9
          12.9 Text Functions 06 min
        • Lecture12.10
          12.10 Averageif Function 08 min
        • Lecture12.11
          12.11 Median| Mode | Round Functions 05 min
        • Lecture12.12
          12.12 SUMIF Function 03 min
        • Lecture12.13
          12.13 Vlookup 04 min
      • Section 13: Pivot Table 1

        • Lecture13.1
          13.1 Pivot Table 09 min
      • Section 14: Printing and Protecting 3

        • Lecture14.1
          14.1 Printing 14 min
        • Lecture14.2
          14.2 Saving Document 05 min
        • Lecture14.3
          14.3 Protecting Excel Document 03 min
      • Microsoft Excel 2010 Test 1

        • Quiz15.1
          Microsoft Excel 2010 Final Test 10 questions
      author avatar
      WKD Dilshan Maduranga

      Web Developer And Teacher

      Hi! I'm Dilshan. I have been working in freelancing web designing and development since 2010, I'm passionate about teaching computer. I invite you, sign up to my courses and join with me in this amazing adventure today.

      Reviews

      Average Rating

      0
      0 rating

      Detailed Rating

      5
      0%
      4
      0%
      3
      0%
      2
      0%
      1
      0%
      • Overview
      • Curriculum
      • Instructor
      • Reviews
      Free
      • Share:

      You May Like

      Microsoft Powerpoint 2010 Read More
      WKD Dilshan Maduranga

      Microsoft Powerpoint 2010

      2
      0
      Free
      Microsoft Word 2010 Read More
      WKD Dilshan Maduranga

      Microsoft Word 2010

      0
      0
      Free
      Preview Course Read More
      WKD Dilshan Maduranga

      Preview Course

      0
      0
      Free

      Leave A Reply Cancel reply

      You must be logged in to post a comment.

      All Courses

      • Microsoft Office

      Latest Courses

      Microsoft Excel 2010

      Microsoft Excel 2010

      Free

      Preview Course

      Free
      Microsoft Word 2010

      Microsoft Word 2010

      Free
      logo-eduma-the-best-lms-wordpress-theme

      (071) 906 52 69

      info@maxmind.lk

      maxmindeducation@gmail.com

      Company

      • About Us
      • Blog
      • Contact
      • BECOME AN INSTRUCTOR

      Links

      • Courses
      • Events
      • FAQs

      Copyright © 2020, MAXMIND INTERNATIONAL EDUCATION CENTER (PVT) LTD.
      Solution by DilMAX-IT

      • Privacy
      • Terms
      • Sitemap

      Become An Instructor?

      Join as a instructors and earn money hassle free!

      Get Started Now

      Login with your site account

      Lost your password?

      Not a member yet? Register now

      Register a new account

      Are you a member? Login now

      Modal title

      Message modal