• 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
      • Certified Anti Money Laundering Specialist (CAMS)
      • Certified Anti Money Laundering Specialist (CAMS) Mock Test
      • Certified Global Sanctions Specialist(CGSS)
      • Certified Documentary Credit Specialist (CDCS)
      • Islamic Economics & Finance
      • Islamic Banking
    • English Language
      • IELTS Regular
      • IELTS Exam Management
      • General English | Bringing Brilliance in Speech
      • Business English Communication
    • Soft Skills
      • Accounts Management System(Quickbooks)
      • Tally.ERP 9 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
      • 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
  • Events & Schedule

    Event List

    • ACCA Events
    • CIMA Events
    • IELTS Events
    • CAMS Events
    • IT Training
    • 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
    January 2021
    Mon Tue Wed Thu Fri Sat Sun
    28293031123
    45678910
    11121314151617
    18192021222324
    25262728293031
  • Talent Management

    About Talent management

    Our Approach

    Career Planning

    Study Abroad

    Skills Enhancement

    Placement

    Continuous Improvement

    Coaching & Mentoring

  • Fees & Offers

    Special Offers 

    Fees 

  • Training
  • E-Campus
  • Contact Us
Have any question?
09678-505050
​02 48118935-6
info@lcbsdhaka.com
RegisterLogin
LCBS Dhaka LimitedLCBS 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
      • Certified Anti Money Laundering Specialist (CAMS)
      • Certified Anti Money Laundering Specialist (CAMS) Mock Test
      • Certified Global Sanctions Specialist(CGSS)
      • Certified Documentary Credit Specialist (CDCS)
      • Islamic Economics & Finance
      • Islamic Banking
    • English Language
      • IELTS Regular
      • IELTS Exam Management
      • General English | Bringing Brilliance in Speech
      • Business English Communication
    • Soft Skills
      • Accounts Management System(Quickbooks)
      • Tally.ERP 9 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
      • 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
  • Events & Schedule

    Event List

    • ACCA Events
    • CIMA Events
    • IELTS Events
    • CAMS Events
    • IT Training
    • 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
    January 2021
    Mon Tue Wed Thu Fri Sat Sun
    28293031123
    45678910
    11121314151617
    18192021222324
    25262728293031
  • Talent Management

    About Talent management

    Our Approach

    Career Planning

    Study Abroad

    Skills Enhancement

    Placement

    Continuous Improvement

    Coaching & Mentoring

  • Fees & Offers

    Special Offers 

    Fees 

  • Training
  • E-Campus
  • Contact Us

Short Course

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

Data Analysis in Excel

SABIHA SHABNAM
SABIHA SHABNAM
Short Course
(0 review)
৳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 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
  • Overview
  • Curriculum
  • Instructor
  • Reviews
৳2,500.00
  • Share:

You May Like

Web Design and Development with WordPress Read More
Avatar
LCBS Dhaka

Web Design and Development with WordPress

25
0
৳8,000.00
International Financial Reporting Standards (IFRS) Read More
Avatar
LCBS Dhaka

International Financial Reporting Standards (IFRS)

1
0
Free
International Standards on Auditing (ISA) Read More
Avatar
LCBS Dhaka

International Standards on Auditing (ISA)

0
0
Free
Finance for Non- Finance Managers Read More
Avatar
LCBS Dhaka

Finance for Non- Finance Managers

45
0
৳3,000.00
Accounting and Financial Reporting program for Retail Companies Read More
Avatar
LCBS Dhaka

Accounting and Financial Reporting program for Retail Companies

0
0
Free

Leave A Reply Cancel reply

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

All Courses

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

Latest Courses

ACCA-PM – Performance Management

ACCA-PM – Performance Management

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

ACCA-CL- Corporate and Business Law

৳13,000.00 ৳10,500.00
ACCA-FR-Financial Reporting

ACCA-FR-Financial Reporting

৳14,000.00 ৳10,500.00
lcbs dhaka

+88 09678 505050

info@lcbsdhaka.com

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 © 2019 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