• Home
  • Training

    IT Training and Skills Development 

    Regular Short Courses

    Individual Effectiveness

    Innovation & Creativity

    International Certifications

    Leadership, Coaching & Team Excellence

    Sales, Marketing & Customer Centricity

    Neuro Linguistic Programming [NLP]

    Management Consultancy

  • Public Sector
    • About Public Sector Training
    • Key Expertise
    • Projects Covered
  • Best Selling Programs
  • Projects Covered
  • Credentials

    Our Clients

    Testimonials

    Gallery 

  • Main Site
    Book Live Counselling
    Apply for Training
    Contact Us
    LCBS Dhaka TrainingLCBS Dhaka Training
    • Home
    • Training

      IT Training and Skills Development 

      Regular Short Courses

      Individual Effectiveness

      Innovation & Creativity

      International Certifications

      Leadership, Coaching & Team Excellence

      Sales, Marketing & Customer Centricity

      Neuro Linguistic Programming [NLP]

      Management Consultancy

    • Public Sector
      • About Public Sector Training
      • Key Expertise
      • Projects Covered
    • Best Selling Programs
    • Projects Covered
    • Credentials

      Our Clients

      Testimonials

      Gallery 

    • Main Site

      Short Course

      • Home
      • All courses
      • Short Course
      • Explore Microsoft Excel

      Explore Microsoft Excel

      LCBS Dhaka
      LCBS Dhaka
      Short Course
      ৳750.00
      ms-excel-with-for-web-min
      • Overview
      • Curriculum
      • Instructor

      Introduction

      Excel is one of today’s most powerful and multipurpose business tools. If we are not aware with its effective/ wonderful functions, formulas, commands and keystrokes, we may set ourselves up for frustration and disappointment. The training will show us how to turn Excel into your most impressive productivity and useful Excel tips to help your everyday works faster. 


      Who will be benefited?

      This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio.


      Learning Outcomes:

      • Learn the most common Excel functions used in the Office
      • Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.
      • Use formulas and functions to perform calculations on data.
      • Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.
      • Create dynamic reports by mastering one of the most popular tools, PivotTables

      Why LCBS Dhaka

      LCBS Dhaka is unique with its products and services designed and offered locally & internationally. LCBS Dhaka is the only platform in Bangladesh with international recognition for the premium partnering with International organizations where internationally recognized Chartered qualifications & Certification courses are offered, Exams are taken, Corporate Training & Soft Skills provided as per employers needs, and job placement done. Since 2007 LCBS Dhaka has served the highest number of students, Corporate Clients and offered the highest number of courses with success globally. It ensures the delivery of quality education & Training with renowned training specialists from home and abroad. Quantity is not the priority- Quality, Commitment & Clients’ Feedback is our wealth. Hear from our clients whom we served already by visiting our YouTube channel- www.youtube.com/lcbsdhaka.


      Delivery Details:

      Total Class: 06 with an assessment 

      Total Duration: Total 9 hrs.

      Class Per Week: 2 Days per week (Friday & Saturday)

      Time: 8:00 pm to 09:30 Pm

      Class Duration: 1.5 hours/Day

      Language: Bangla, English

      Delivery Mode: Online

      Online: e-campus.lcbsdhaka.com

      Standard Course Fees: BDT- 750

      Course Features

      • Lectures 11
      • Quizzes 0
      • Duration 9 hours
      • Skill level All levels
      • Language English
      • Students 0
      • Assessments Yes
      CoursesShort CourseExplore Microsoft Excel
      • Day 1 3

        • Lecture1.1
          Know Excel – When and How to use Excel, Sharing basic concepts, Workbook vs Worksheet
        • Lecture1.2
          Excel – Ribbon, Rows, Columns, Formatting, Paste Special, Fill Cell
        • Lecture1.3
          Setting Excel Options — Understanding excel options, Personalizing, Default Font, Save Options, Save with Password, Default File Location, Advanced Options
      • Day 2 2

        • Lecture2.1
          Print — Page Break, Page Setup, Page Layout, Print Titles, Margins, Preview
        • Lecture2.2
          Conditional Formatting — Duplicate values, Icon Sets, Format Rules
      • Day 3 2

        • Lecture3.1
          Data Linking — Data Linking concept, Linking between Worksheets or Workbooks
        • Lecture3.2
          Formula/Function — SUM, IF, AND, OR, IFERROR, DATEDIF
      • Day 4 2

        • Lecture4.1
          Data Validation — Setting, Message, Drop-Down List, Alert
        • Lecture4.2
          View – Page Break, Free Panes
      • Day 5 1

        • Lecture5.1
          Pivot Table with Chart — Creating Pivot Table, Add/remove fields, Filtering, Use of Slicer, Pivot Charts, Power Pivot
      • Day 6 1

        • Lecture6.1
          Assessment
      LCBS Dhaka
      LCBS Dhaka
      Incorporated in 2007 in Ireland, LCBS Professional Tuition Ltd traded as Limerick College of Business Studies Ireland established itself as a leading institute in Ireland, and in 2010 established an identical but separate entity called LCBS Dhaka (Limerick College of Business Studies Dhaka) in Bangladesh, catering for all levels of finance both in practices and in industry. From its inception, LCBS Dhaka has been working to promote the belief that it is not just education & skill but Quality education & Applicable skill” is what we need to cater to materialize our vision. Our services are focused and tailor made towards the development of human capital so that they can serve with the best interest of their nation by upholding and implementing the highest standards of professionalism, promoting good governance and accountability through accomplishing the socio-economic objectives of the respective countries. LCBS Dhaka is an expert in market development of skill development services and qualifications. It has proved its expertise by contributing to the market expansion of many of the globally recognised professional accountancy qualifications.We have launched three of the world’s largest and most prestigious chartered qualifications CIMA and CIPFA in Bangladesh. LCBS Dhaka proudly represented CIMA in Bangladesh from 2010 to 2011 and now we are working as CIPFA Bangladesh. Since its inception LCBS Dhaka has been working closely with ACCA Global for its market development & growth in Bangladesh.
      • Overview
      • Curriculum
      • Instructor
      ৳750.00
      • Share:

      You May Like

      Content Writing training Read More
      LCBS Dhaka
      LCBS Dhaka

      Content Writing training

      0
      ৳4,000.00
      Vat & Tax Management Read More
      LCBS Dhaka
      LCBS Dhaka

      Vat & Tax Management

      0
      ৳6,000.00
      Procurement & Supply Chain – Short Training Read More
      LCBS Dhaka
      LCBS Dhaka

      Procurement & Supply Chain - Short Training

      0
      ৳6,500.00
      Certified Documentary Credit Specialist (CDCS) Read More
      Avatar
      Sohel Rana

      Certified Documentary Credit Specialist (CDCS)

      1
      ৳15,000.00
      𝐓𝐚𝐥𝐥𝐲𝐏𝐫𝐢𝐦𝐞 𝐟𝐨𝐫 𝐀𝐜𝐜𝐨𝐮𝐧𝐭𝐢𝐧𝐠, 𝐈𝐧𝐯𝐞𝐧𝐭𝐨𝐫𝐲 & 𝐏𝐚𝐲𝐫𝐨𝐥𝐥 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭  Read More
      Avatar
      Sohel Rana

      𝐓𝐚𝐥𝐥𝐲𝐏𝐫𝐢𝐦𝐞 𝐟𝐨𝐫 𝐀𝐜𝐜𝐨𝐮𝐧𝐭𝐢𝐧𝐠, 𝐈𝐧𝐯𝐞𝐧𝐭𝐨𝐫𝐲 & 𝐏𝐚𝐲𝐫𝐨𝐥𝐥 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 

      1
      ৳4,500.00

      All Courses

      • CAMS
      • General
      • Islamic Finance
      • IT & Software
      • Leadership
      • MIM
      • MS Office
      • NLP
      • Short Course
      • SUCCESSFUL TRAINING PROGRAM

      Latest Courses

      QUALIFICATIONS IN GLOBAL BUSINESS SERVICES `{`GBS`}`

      QUALIFICATIONS IN GLOBAL BUSINESS SERVICES `{`GBS`}`

      ৳100,000.00
      Advanced Diploma in Global Business Services [GBS]

      Advanced Diploma in Global Business Services [GBS]

      ৳200,000.00
      Financial Feasibility Study of Projects

      Financial Feasibility Study of Projects

      ৳2,500.00
      lcbs dhaka

      info@lcbsdhaka.com

      training@lcbsdhaka.com

      House# 120, Road # 9/A, Shankar Bus Stand, Dhanmondi , Dhaka -1209


      • Facebook

      • Youtube

      • Linkedin

      • Google


      • Twitter

      • Pinterest

      • Instagram

      • Play

      ACADEMIC & TRAINING

      • Academic Partners
      • Exam Partners
      • Training Partners
      • Events
      • FAQs

      INTERNATIONAL

      • Entry Criteria
      • Applying For A Visa
      • Social Life
      • Counseling
      • Refund Policy

      OTHERS

      • Other Service
      • Testimonials
      • Accommodation
      • Be a Partner
      • Explore Ireland

      HOTLINES

      +88 09678 505050

      + 88 02 48118935

      + 88 02 48118936

      +88 01746 388644

      +88 01746 388645

      ​+88 01680 436235

      © 2022 LCBS Dhaka All right reserved. Designed & Developed By GrowMore Dev

      • Privacy
      • Terms
      • Sitemap