• Home
  • Private Sector
  • Public Sector
  • Best Selling Programs
  • Ongoing Projects
  • Projects Covered
  • Upcoming Batch
  • Advisory
  • Main Site
    Book Live Counselling
    Enquiry Form
    Contact Us
    Notice
    LCBS Dhaka TrainingLCBS Dhaka Training
    • Home
    • Private Sector
    • Public Sector
    • Best Selling Programs
    • Ongoing Projects
    • Projects Covered
    • Upcoming Batch
    • Advisory
    • Main Site

      Short Course

      • Home
      • All courses
      • Short Course
      • Microsoft Excel for Intermediate Level
      CoursesShort CourseMicrosoft Excel for Intermediate Level
      • 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
        This content is protected, please login and enroll course to view this content!
        Prev Formula/Function — SUM, IF, AND, OR, IFERROR, DATEDIF
        Next View – Page Break, Free Panes

        Leave A Reply Cancel reply

        Your email address will not be published. Required fields are marked *

        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 -39/B, Road - 27, 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 Trainer
        • Explore Ireland

        HOTLINES

        +88 09678 505050

        +88 02 41021383

        +88 02 41021384

        +88 01746 388644

        +88 01746 388645

        ​+88 01680 436235

        © 2022 LCBS Dhaka. All right reserved.

        • Privacy
        • Terms
        • Sitemap