Data Analysis in Excel

Teacher

Categories

৳2,500.00

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

Certification & Membership

Upcoming Batch

Course Features

Lectures 0
Quizzes 0
Duration 50 hours
Skill level All levels
Language English
Students 87
Assessments Yes

Curriculum is empty

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.