• Home
  • About Us
    • Who We Are?
    • What We Do?
    • Mission & Vision
    • Message From Chairman
    • Partners & Achievement
    • Gallery
    • FAQs
  • Courses
    • ACCA
      • CAT-Certified Accounting Technician
      • ACCA-SKILLS LEVEL
      • ACCA PROFESSIONAL LEVEL
      • B.SC HONS IN APPLIED ACCOUNTING
    • CIMA
      • CIMA-CBA LEVEL
      • CIMA-OPERATIONAL LEVEL
      • CIMA-MANAGEMENT LEVEL
      • CIMA-STRATEGIC LEVEL
    • CIPS
    • Business & Finance
      • Financial Feasibility Study of Projects
      • Finance for Non- Finance Managers
      • Accounting and Financial Reporting program for Retail Companies
      • International Financial Reporting Standards (IFRS)
      • International Standards on Auditing (ISA)
    • Banking Courses
      • Certified Anti Money Laundering Specialist (CAMS)
      • Certified Global Sanctions Specialist(CGSS)
      • Certified Documentary Credit Specialist (CDCS)
      • Certificate for Specialists in Demand Guarantees (CSDG®)
      • Certified Information Systems Auditor (CISA)
      • COBIT
    • English Language
      • IELTS Regular
      • IELTS Exam Management
      • General English | Bringing Brilliance in Speech
      • Business English Communication
    • Soft Skills
      • Accounts Management System(Quickbooks)
      • TallyPrime for Accounting, Inventory & Payroll Management
      • Basic to Advanced MS Office Excel Essentials | Weekend Course
      • Advanced MS Office Excel Essentials
      • CRASH COURSE ON INCOME TAX AND VAT MANAGEMENT
    • IT & IS
      • Professional Graphics Design Course
      • Google Cloud Associate Certification
      • Learn Python By Building Real-World Projects
      • Professional Digital Marketing Certification
      • On-Demand Professional Digital Marketing Course
    • Short Course
      • INCOTERMS® 2020” and its impacts on Sales Contract
      • Virtualisation of Trade Operations and Digital Documentations. 
      • Data Visualization and Developing Insights in Excel
      • Data Analysis in Excel
  • Freelancing
    • What is it
    • Our position
    • Freelancing Courses
    • Opportunity with LCBS
    • Book Now
  • Events & Schedule

    Event List

    • ACCA Events
    • CIMA Events
    • English Events
    • Banking Courses
    • IT & Freelancing
    • Talent Management
    • Islamic Finance
    CLASS SCHEDULE
      • ACCA Class Schedule
      • CIMA Class Schedule
  • Exam

    Quick Link

    • ACCA Exam
    • CIMA Exam
    • CIPFA Exam
    • Pearson VUE Exam
    • Kryterion Exam
    • Exams Tips & Technique
    • IELTS Exam Booking
    April 2021
    Mon Tue Wed Thu Fri Sat Sun
    2930311234
    567891011
    12131415161718
    19202122232425
    262728293012
  • Talent Management

    About Talent management

    Our Approach

    Career Planning

    Study Abroad

    Skills Enhancement

    Placement

    Continuous Improvement

    CV Bank
  • Training
  • E-Campus
  • Study Abroad
Have any question?
Contact Us
09678-505050
​02 48118935-6
[email protected]
RegisterLogin
LCBS Dhaka Limited
  • Home
  • About Us
    • Who We Are?
    • What We Do?
    • Mission & Vision
    • Message From Chairman
    • Partners & Achievement
    • Gallery
    • FAQs
  • Courses
    • ACCA
      • CAT-Certified Accounting Technician
      • ACCA-SKILLS LEVEL
      • ACCA PROFESSIONAL LEVEL
      • B.SC HONS IN APPLIED ACCOUNTING
    • CIMA
      • CIMA-CBA LEVEL
      • CIMA-OPERATIONAL LEVEL
      • CIMA-MANAGEMENT LEVEL
      • CIMA-STRATEGIC LEVEL
    • CIPS
    • Business & Finance
      • Financial Feasibility Study of Projects
      • Finance for Non- Finance Managers
      • Accounting and Financial Reporting program for Retail Companies
      • International Financial Reporting Standards (IFRS)
      • International Standards on Auditing (ISA)
    • Banking Courses
      • Certified Anti Money Laundering Specialist (CAMS)
      • Certified Global Sanctions Specialist(CGSS)
      • Certified Documentary Credit Specialist (CDCS)
      • Certificate for Specialists in Demand Guarantees (CSDG®)
      • Certified Information Systems Auditor (CISA)
      • COBIT
    • English Language
      • IELTS Regular
      • IELTS Exam Management
      • General English | Bringing Brilliance in Speech
      • Business English Communication
    • Soft Skills
      • Accounts Management System(Quickbooks)
      • TallyPrime for Accounting, Inventory & Payroll Management
      • Basic to Advanced MS Office Excel Essentials | Weekend Course
      • Advanced MS Office Excel Essentials
      • CRASH COURSE ON INCOME TAX AND VAT MANAGEMENT
    • IT & IS
      • Professional Graphics Design Course
      • Google Cloud Associate Certification
      • Learn Python By Building Real-World Projects
      • Professional Digital Marketing Certification
      • On-Demand Professional Digital Marketing Course
    • Short Course
      • INCOTERMS® 2020” and its impacts on Sales Contract
      • Virtualisation of Trade Operations and Digital Documentations. 
      • Data Visualization and Developing Insights in Excel
      • Data Analysis in Excel
  • Freelancing
    • What is it
    • Our position
    • Freelancing Courses
    • Opportunity with LCBS
    • Book Now
  • Events & Schedule

    Event List

    • ACCA Events
    • CIMA Events
    • English Events
    • Banking Courses
    • IT & Freelancing
    • Talent Management
    • Islamic Finance
    CLASS SCHEDULE
      • ACCA Class Schedule
      • CIMA Class Schedule
  • Exam

    Quick Link

    • ACCA Exam
    • CIMA Exam
    • CIPFA Exam
    • Pearson VUE Exam
    • Kryterion Exam
    • Exams Tips & Technique
    • IELTS Exam Booking
    April 2021
    Mon Tue Wed Thu Fri Sat Sun
    2930311234
    567891011
    12131415161718
    19202122232425
    262728293012
  • Talent Management

    About Talent management

    Our Approach

    Career Planning

    Study Abroad

    Skills Enhancement

    Placement

    Continuous Improvement

    CV Bank
  • Training
  • E-Campus
  • Study Abroad

Short Course

  • Home
  • All courses
  • Short Course
  • Data Analysis in Excel

Data Analysis in Excel

SABIHA SHABNAM
SABIHA SHABNAM
Short Course
৳ 2,500.00
excel
  • Overview
  • Curriculum
  • Instructor
  • Reviews

COURSE OVERVIEW

Taking this course will help you unlock the power of your organization’s data by using data analysis and visualization tools build into Excel. Interpreting data into meaningful insights is essential skill to contribute to strategic progress of your organization. This course takes a deep dive into the data analytics process: collection, cleaning, analysis, and visualization. You will be able the leverage the techniques learned in this course in the area of planning, forecasting, budgeting, decision making, financial analysis and financial reporting.

 

TOPICS

  • Spreadsheet Modeling
  • Advance Excel formulas
  • Formulating pivot tables

 

Key Learning Outcome

  • Learn how to develop elaborative excel based databases: extracting, cleaning, sorting, tables
  • Applying advance formulas: VLOOKUP, Conditional Formatting, SUMIF, COUNTIF etc.
  • Learn to develop pivot tables and its applications
  • Each session includes practical examples that display how to apply the techniques to real-world business problems

Duration:    3 hours

 

Participants

It is essential to have basic Excel knowledge for the training. The course is designed for audience with variety of professional backgrounds and experience levels — including

Students

Analysts

Accountants

Finance professional

Planers

Free Sign Up

Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 50 hours
  • Skill level All levels
  • Language English
  • Students 87
  • Assessments Yes
Curriculum is empty
SABIHA SHABNAM
SABIHA SHABNAM

SABIHA SHABNAM
Financial Management professional with 12 years expertise in analysis, reporting and budget management Worked for international organizations and NGOs: World Bank, UNICEF and icddr,b Experienced with roles in Strategic Planning, Result Based Management and Donor & Trust Fund Management Professional Experience Finance Specialist, UNICEF, New York (Current) • Facilitate Planning & Budgeting for Information Technology Division • Support Senior Management with data insights to influence cost optimization, resource mobilization and data driven strategic decision-making process • Leading roll-out of technical business solution related to IT financial data management process enabling cost transparency Finance/Budget Analyst, World Bank Group (IFC) 2012 - 2018 • Project Budgeting and Trust Fund Management for Advisory Services • Provide fiduciary support to project budget governance • Lead regional budget formulation Manager, Strategy, icddr,b, Dhaka, Bangladesh 2010 - 2012 • Lead annual strategic planning implementation • Report to management on implementation progress consolidating divisional inputs • Develop KPI’s based on Balanced Scorecard concept for performance assessment Financial Analyst, Goodyear Canada Inc., Toronto, Canada 2007 - 2010 • Responsible for analyzing and forecasting business unit financial performance • Develop rolling forecast; Perform variance analysis and report to management • Prepare financial reports SKILLS Analysis & Reporting Data Insights & Visualization Process Improvement & Efficiency Effective communication Proactive & Driven Advance Excel Data Modeling PowerBI SAP, COGNOS, Tableau Education • MBA, University of Windsor, Windsor, Canada, 2008 • BBA, University of Windsor, Windsor, Canada, 2006 Certification • Data Analytics, Cornell University, 2018 • Certified Technology Business Management Executive (CTBME®), 2019

Reviews

Average Rating

0
0 rating

Detailed Rating

5
0%
4
0%
3
0%
2
0%
1
0%
  • Overview
  • Curriculum
  • Instructor
  • Reviews
৳ 2,500.00
  • Share:

You May Like

Professional Graphics Design Course Read More
Avatar
Admin

Professional Graphics Design Course

0
৳ 10,000.00
Certified Information Systems Auditor (CISA) Read More
Avatar
Admin

Certified Information Systems Auditor (CISA)

0
৳ 75,000.00
Certificate for Specialists in Demand Guarantees (CSDG®) Read More
Avatar
LCBS Dhaka

Certificate for Specialists in Demand Guarantees (CSDG®)

58
৳ 15,000.00
Training on Procurement and Supply Chain Management, Basic to Advance Level Read More
Tapon Kumar Mozumder Asif Abdullah Chowdhury
Tapon Kumar Mozumder Asif Abdullah Chowdhury

Training on Procurement and Supply Chain Management, Basic to Advance Level

25
৳ 6,500.00
Web Design and Development with WordPress Read More
Avatar
LCBS Dhaka

Web Design and Development with WordPress

25
৳ 8,000.00 ৳ 6,000.00

Leave A Reply Cancel reply

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

All Courses

  • ACCA Professional Level
  • ACCA-Skills Level
  • banking-courses
  • Business & Finance
  • Certified Accounting Technician (CAT)
  • CIMA-CBA Level
  • CIMA-Management Level
  • CIMA-Operational Level
  • CIMA-Strategic Level
  • English Courses
  • IT & IS
  • OBU
  • Short Course
  • Soft Skills

Latest Courses

ACCA-PM – Performance Management

ACCA-PM – Performance Management

৳ 13,000.00
ACCA-CL- Corporate and Business Law

ACCA-CL- Corporate and Business Law

৳ 13,000.00
ACCA-FR-Financial Reporting

ACCA-FR-Financial Reporting

৳ 13,000.00
lcbs dhaka

+88 09678 505050

[email protected]

Company

  • Who We Are?
  • What We Do?
  • Why LCBS?
  • Mission & Vision
  • Latest News
  • Contact Us
  • Give Feedback

Academic

  • ACCA
  • Special Offers
  • CIMA
  • CIPFA
  • Courses
  • Become a Teacher
  • Events
  • Gallery
  • FAQs

Partners

  • Academic Partners
  • Training Partners
  • Exam Pertners

International Student

  • Entry criteria & requirements
  • Applying for a Visa
  • Fees & Payments
    • Privacy Policy & Our Pledge
    • Refund Policy
  • Accommodation & Others
    • Accommodation
    • Social Life
    • Counseling
    • Other Services
  • Testimonial
  • Contact Us

Copyright © 2021 LCBS Dhaka.

  • Privacy
  • Terms
  • Sitemap

Become A Teacher?

Get Started Now
No apps configured. Please contact your administrator.

Login with your site account

No apps configured. Please contact your administrator.

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Modal title

Message modal