In this modern world most businesses survival rest on the manipulation and analysis of data and majority of them uses Excel to achieve this. Having known its computing power and capabilities Excel is still the most underutilized tool. Majority of people uses Excels basic functions and use it for nothing more than a spreadsheet for simple bookkeeping. They also know that a lot more can be achieved with this program and its true understanding can yield truly fantastic results for any business in general and data analysts in particular.
Microsoft Excel is an amazing software and almost considered an industry standard for spreadsheet. Learning excel is an imperative if you want to progress and be successful at your workplace. Developing a skill to use EXCEL enhances your productivity and efficiency.
This most advanced Excel training workshop can help the business and finance user to become smart workers and use this program’s potential to enhance their productivity, efficiency and job enrichment.
After the completion of this workshop participant will be able to:
• Understand and use various Excel terms and terminology in communication.
• Filter data based on various conditions.
• Group worksheet data based operations.
• Use various advance level functions not only for calculations but also for making certain decisions based on a given data set.
• Use particular functions for a particular calculation.
• Present a specific set of data in numerous ways for having different insights.
• Develop and format charts for elegant presentations.
• Use Excel as forecasting, budgeting, and data analysis tool.
• Can format data based on certain conditions
• Can share worksheet for simultaneous working
Program is divided into three levels named as Excelling in MS Excel Level I, Excel Level II and Excel Level III. Levels I & II have already been conducted and their recording is available on the links below
Excelling in MS Excel – Level I
Excelling in MS Excel – Level II
Level III discusses data visualization features and techniques helping user to better understand the data for making useful decisions
EXCEL Level III Contents
Data visualizations for data understanding and communication
• Why Charts?
• Types of Charts
• Data requirements for charts
• Creating a chart.
• Adding a secondary axis to a chart.
• Formatting Charts
• Setting scales of Charts.
• Inserting images into chart columns.
• Inserting images to chart bars.
• Sparkline in cell
• What is Dashboard?
• Dashboard significance and its Importance.
• Requirements of developing dashboards
• Developing a strategy of building dashboards.
• Understanding Data Model
Developing Dashboard Using Pivot Tables
• Pivot Tables
• Pivot Charts
• Multiple Pivot Tables and Pivot Charts
• Developing Connections among Pivot Tables and Pivot Charts Using Slicers
• Controlling Dashboard using slicers
Developing Dashboard Using Dropdown lists
• Developing data model
• Developing Dropdown list using Data Validation Tool
• Developing Charts
• Controlling Dashboard using Dropdown list
Introducing Form Controls
• What are Form Control
• Activating Form Controls
• Types of Form Control
o Combo Box
o List Box
o Radio Button
o Check Box
Building Dashboard using Form Control
• Understanding data model requirement for Form Control
• Building Data model for Dashboard using specific Form Control
• Building Charts for Dashboard
• Controlling Dashboards using various Form Control
Bonus Topic (If Time Permits)
Using Camera Tool
• What is Camera Tool?
• Benefits of using Camera Tool
• Activating and using Camera Tools
ACCA’s global research and insights programme addresses the crucial issues for businesses,
economies, society and the profession now and in the future. Accounting for taxation is a major part of the work of any finance function in MENASA countries. Having said so, tax planning is still very poor and more often than not owners and finance managers do not empower professionals and rely more on exploring methods of evasion. Evasion and bribery can be avoided by understanding that indirect taxes are simple to account for and one can plan to reduce and manage cash flow around this tax which is here to stay.
ACCA is arranging a series of panel discussions across the MESA region to deliberate on the indirect taxes regime. These panel discussions will be led by Chas Roy-Chowdhury, head of global taxation, and other local professionals to share their experiences and insights on the topic.
Chas sits on the European Commission Platform for Tax Good Governance, represents ACCA at BIAC on tax matters, is Chair of the Taxation Working Group of the small business organisation UEAPME and a member of the Indirect and Direct Tax Working Parties at F餩ration des Experts Comptables Europ饮s (FEE) - the umbrella group for "first tier" European accountants.