• Home
  • About Us
    • About Achievers International Campus
  • Faculties
    • Faculty of ICT & Computing
      • Short Courses
      • Diploma Programmes
      • Higher Diploma Programmes
      • Degree Programmes
      • Masters Programmes
    • Faculty of Business and Law
      • Short Courses
      • Diploma Programmes
      • Higher Diploma Programmes
      • Degree Programmes
      • Masters Programmes
    • Faculty of Education & Language Studies
      • Diploma Programmes
      • Degree Programmes
    • Faculty of Engineering
      • Higher Diploma Programmes
    • School of Research
      • Doctoral Programmes
  • Partners
  • News & Events
  • Careers
  • Contact Us
    • Home
    • About Us
      • About Achievers International Campus
    • Faculties
      • Faculty of ICT & Computing
        • Short Courses
        • Diploma Programmes
        • Higher Diploma Programmes
        • Degree Programmes
        • Masters Programmes
      • Faculty of Business and Law
        • Short Courses
        • Diploma Programmes
        • Higher Diploma Programmes
        • Degree Programmes
        • Masters Programmes
      • Faculty of Education & Language Studies
        • Diploma Programmes
        • Degree Programmes
      • Faculty of Engineering
        • Higher Diploma Programmes
      • School of Research
        • Doctoral Programmes
    • Partners
    • News & Events
    • Careers
    • Contact Us
  • info@iaicampus.com
  • +94 777 30 77 30
🇦🇪 UAE Campus
Apply Online
Achievers International Campus
Achievers International Campus
  • Home
  • About Us
    • About Achievers International Campus
  • Faculties
    • Faculty of ICT & Computing
      • Short Courses
      • Diploma Programmes
      • Higher Diploma Programmes
      • Degree Programmes
      • Masters Programmes
    • Faculty of Business and Law
      • Short Courses
      • Diploma Programmes
      • Higher Diploma Programmes
      • Degree Programmes
      • Masters Programmes
    • Faculty of Education & Language Studies
      • Diploma Programmes
      • Degree Programmes
    • Faculty of Engineering
      • Higher Diploma Programmes
    • School of Research
      • Doctoral Programmes
  • Partners
  • News & Events
  • Careers
  • Contact Us

Certificate in Microsoft Excel

Achievers International Campus > Courses > ICT & Computing > Short Course Programmes > Certificate in Microsoft Excel
0 student
  • Course Overview
  • Course Contents
  • Apply Course

On completion of the certificate level course in Microsoft Excel, the participants would have learned the key fundamentals of Microsoft Excel in connection with adding and manipulating data, formulating data, managing works sheets, sorting and filtering data, creating and modifying charts, construct formulas, including the use of built-in functions, relative and absolute references and use the Excel online Help feature effectively.

  1. To enhance the overall practical knowledge in Excel
  2. Develop analytical skills
  3. Improve the effective and efficient decision making in the corporate world
  4. Make a competitive advantage in the business through the high level of data analyses

Fee & Duration

  • Duration : 03 days /18 hours
  • Course Fee :
  • Day 01 (6 Hours)
    6
    • 1. Introduction to the Interface (MS Excel)
    • 2. Creating, Saving and Duplicating Workbooks
    • 3. Adding and Manipulating Data
    • 4. Formatting Data
    • 5. Add and Copy Formulas
    • 6. Managing Worksheets
  • Day 02 (6 Hours)
    5
    • 1. Create and Modify Tables
    • 2. Visualize Data with Charts
    • 3. Modifying Charts
    • 4. Sort and Filter Data
    • 5. Use Auto Filter and Advance Filter
  • Day 03 (6 Hours)
    5
    • 1. Use Subtotal and Database Functions to Calculate Data
    • 2. Use Conditional Formatting
    • 3. Create Pivot Tables
    • 4. Absolute and Relative Reference
    • 5. Printing Data
Select Branch
No course programmes to display.

 

    Achievers International Campus
    A premier private sector higher education institute in Sri Lanka, Achievers International Campus has maintained a long-standing history of quality and excellence in education.

    ADDRESS

    • No. 41, Galle Road, Dehiwala, Sri Lanka
    • 0112 720 620
    • info@iaicampus.com
    • 0777 30 77 30

    ADDITIONAL

    • Our Courses
    • How to Apply
    • International Students
    • Corporate Training
    • Complaints Policy
    • Recruitment Partners

    STAFF & STUDENTS

    • Staff Portal
    • Student Portal
    • Careers at IAI Campus
    • Student Alumni

    © 2023 Achievers International Campus, All rights reserved

    • Terms of Use
    • Privacy Policy
    Modal title

    Message modal