Data Analysis in Excel

Teacher

Sabiha Shabnam

Categories

IT & Software

৳6,000.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

Course Features

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

Curriculum is empty

Sabiha Shabnam

Data Analysis in Excel

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