10 Statistical Analysis jobs in the United Arab Emirates
Head - Data Analysis
Posted 21 days ago
Job Viewed
Job Description
The Director of Data Analysis is responsible for collecting, processing, and analysing real estate data from various sources, with the aim of providing accurate, data-driven insights that support strategic decision-making in the real estate sector in United Arab Emirates. The role focuses on enhancing market transparency, developing sector-wide performance indicators, and supporting policy formulation and investment planning based on data.
Responsibilities
- Collecting and analyzing real estate data from multiple sources
- Processing and cleaning data to ensure its accuracy, consistency, and readiness for analysis
- Analyzing real estate data to extract and update the real estate index, which enhances market transparency
- Preparing reports and dashboards to support strategic decision-making
- Developing sector performance indicators (e.g., price indices, supply and demand, occupancy rates, etc.)
- Supporting policy development and investment planning by providing data-driven recommendations
- Contributing to real estate market studies and identifying market trends to support and update strategic urban development plans
- Collaborating with government entities and investors to provide transparent and accurate insights into the real estate market
Requirements
- Bachelor's degree in Economics, Statistics, Business Administration, Data Analysis, or a related field.
- 5 years of experience in data analysis or market research, with knowledge of the real estate market.
- Certifications in data analysis or economics are not required but are preferred
- Certifications in Data Analysis, such as RICS or CF
Career in Data Analysis
Posted today
Job Viewed
Job Description
We are seeking a detail-oriented and analytical professional to join our team as a Data Analyst . In this role, you will be responsible for collecting, analyzing, and presenting data related to financial performance, sales performance, and other areas of responsibility.
Course: Effective Business Decisions Using Data Analysis
Posted today
Job Viewed
Job Description
Effective Business Decisions Using Data Analysis
ID 257
Course: Effective Business Decisions Using Data Analysis
This interactive, applications-driven 5-day course will highlight the added value that data analytics can offer a professional as a decision support tool in management decision making. It will show the use of data analytics to support strategic initiatives; to inform on policy information; and to direct operational decision making. The course will emphasize applications of data analytics in management practice; focus on the valid interpretation of data analytics findings; and create a clearer understanding of how to integrate quantitative reasoning into management decision making. Exposure to the discipline of data analytics will ultimately promote greater confidence in the use of evidence-based information to support management decision making.
This course will feature:- Discussions on applications of data analytics in management
- The importance of data in data analytics
- Applying data analytical methods through worked examples
- Focusing on management interpretation of statistical evidence
- How to integrate statistical thinking into the work domain
- Explain the scope and structure of data analytics.
- Apply a cross-section of useful data analytics.
- Interpret meaningfully and critically assess statistical evidence.
- Identify relevant applications of data analytics in practice.
- Professionals in management support roles
- Analysts who typically encounter data/analytical information regularly in their work environment
- Those who seek to derive greater decision-making value from data analytics
This course will utilise a variety of proven adult learning techniques to ensure maximum understanding, comprehension, and retention of the information presented. The daily workshops will be highly interactive and participative. This involves regular discussion of applications as well as hands-on exposure to data analytics techniques using Microsoft Excel. Delegates are strongly encouraged to bring and analyse data from their own work domain. This adds greater relevancy to the content. Emphasis is also placed on the valid interpretation of statistical evidence in a management context.
The Course Content- Day One: Setting the Statistical Scene in Management
- Introduction; The quantitative landscape in management
- Thinking statistically about applications in management (identifying KPIs)
- The integrative elements of data analytics
- Data: The raw material of data analytics (types, quality, and data preparation)
- Exploratory data analysis using Excel (pivot tables)
- Using summary tables and visual displays to profile sample data
- Day Two: Evidence-based Observational Decision Making
- Numeric descriptors to profile numeric sample data
- Central and non-central location measures
- Quantifying dispersion in sample data
- Examine the distribution of numeric measures (skewness and bimodal)
- Exploring relationships between numeric descriptors
- Breakdown analysis of numeric measures
- Day Three: Statistical Decision Making – Drawing Inferences from Sample Data
- The foundations of statistical inference
- Quantifying uncertainty in data – the normal probability distribution
- The importance of sampling in inferential analysis
- Sampling methods (random-based sampling techniques)
- Understanding the sampling distribution concept
- Confidence interval estimation
- Day Four: Statistical Decision Making – Drawing Inferences from Hypotheses Testing
- The rationale of hypotheses testing
- The hypothesis testing process and types of errors
- Single population tests (tests for a single mean)
- Two independent population tests of means
- Matched pairs test scenarios
- Comparing means across multiple populations
- Day Five: Predictive Decision Making - Statistical Modeling and Data Mining
- Exploiting statistical relationships to build prediction-based models
- Model building using regression analysis
- Model building process – the rationale and evaluation of regression models
- Data mining overview – its evolution
- Descriptive data mining – applications in management
- Predictive (goal-directed) data mining – management applications
Senior Data Analysis and Machine Learning Specialist
Posted today
Job Viewed
Job Description
We are seeking an experienced professional to drive the design, development, and deployment of advanced analytical solutions and machine learning models. This role will collaborate with stakeholders to extract insights from large datasets and translate them into actionable outcomes.
Key Responsibilities:- Analytical Model Development: Design, develop, and deploy machine learning models and analytical solutions for business-critical problems.
- Collaboration and Communication: Collaborate with data engineers to ensure data quality, integrity, and accessibility for modeling and analysis. Analyze complex datasets using statistical and predictive modeling techniques to uncover trends and patterns.
- Solutions Development: Translate business problems into analytical solutions, defining success metrics and model evaluation criteria.
- Mentorship and Training: Mentor junior analysts and guide best practices in feature engineering, model tuning, and validation.
- Stakeholder Management: Present findings and model results to stakeholders through clear, data-driven storytelling and visualization.
- Educational Background: Bachelor's degree in Computer Science, Mathematics, Statistics, or a related field.
- Professional Experience: 5+ years of experience in data science or applied machine learning roles.
- Technical Skills: Proficiency in Python or R, with strong experience in libraries such as scikit-learn, TensorFlow, PyTorch, or XGBoost.
This is an exciting opportunity to work on high-impact projects and contribute to driving business outcomes. As a key member of the team, you will have the chance to collaborate with talented professionals and advance your skills in data analysis and machine learning.
The successful candidate will be part of a dynamic environment that values innovation, teamwork, and continuous learning. If you are passionate about data science and eager to take on new challenges, we encourage you to apply for this opportunity.
Director Data Scientist - Analysis - Growth
Posted today
Job Viewed
Job Description
About the opportunity
The Growth Data Science Director will lead and accelerate growth strategies across marketing optimization, product initiatives (e.g., churn reduction), ecosystem plays, and ads revenue for talabat and Quick commerce. This role requires collaboration with product teams, senior marketing, and partner leadership to drive data-driven decisions and business growth.
What’s On Your Plate?
- Data Science: Define and execute data strategies aligned with company goals, leading cross-functional teams to develop innovative data-driven products and insights that impact business outcomes.
- Strategic Leadership and Business Acumen: Demonstrate strategic leadership, articulate vision, and incorporate emerging trends and technologies to add value.
- Collaboration and Influence: Work with stakeholders including executives, product managers, engineers, and external partners; represent the organization at industry events.
- Resource Management: Manage teams, budgets, and resources; prioritize projects; coach and mentor managers.
- Strategic Hiring and Talent Development: Recruit, develop career paths, and provide feedback to team members.
- Organizational Change Management: Lead change initiatives, communicate effectively, and manage resistance.
What you need to be successful
- 8-10+ years in data science, with leadership experience in managing teams or consulting.
- Ph.D. or Master’s in relevant fields such as computer science, statistics, or data science.
- Proven leadership in fostering high-performance teams and applying data science skills to create impactful products and insights.
- Deep knowledge of statistics, causality, experimentation, and modeling.
- Business acumen with experience in quantifying impact through data initiatives.
- Strategic thinking and ability to develop data-driven roadmaps aligned with organizational goals.
Who we are
Since 2004, talabat has been Kuwait’s leading on-demand food and Q-commerce app, serving eight countries. We leverage technology to simplify life, optimize operations, and provide earning opportunities. We foster a high-performance culture, value authenticity, and are proud of our awards and diverse team of over 6,000 Talabaty committed to making a difference.
#J-18808-LjbffrDirector Data Scientist - Analysis - Growth
Posted 4 days ago
Job Viewed
Job Description
About the opportunity
The Growth Data Science Director will lead and accelerate growth strategies across marketing optimization, product initiatives (e.g., churn reduction), ecosystem plays, and ads revenue for talabat and Quick commerce. This role requires collaboration with product teams, senior marketing, and partner leadership to drive data-driven decisions and business growth.
What’s On Your Plate?
- Data Science: Define and execute data strategies aligned with company goals, leading cross-functional teams to develop innovative data-driven products and insights that impact business outcomes.
- Strategic Leadership and Business Acumen: Demonstrate strategic leadership, articulate vision, and incorporate emerging trends and technologies to add value.
- Collaboration and Influence: Work with stakeholders including executives, product managers, engineers, and external partners; represent the organization at industry events.
- Resource Management: Manage teams, budgets, and resources; prioritize projects; coach and mentor managers.
- Strategic Hiring and Talent Development: Recruit, develop career paths, and provide feedback to team members.
- Organizational Change Management: Lead change initiatives, communicate effectively, and manage resistance.
What you need to be successful
- 8-10+ years in data science, with leadership experience in managing teams or consulting.
- Ph.D. or Master’s in relevant fields such as computer science, statistics, or data science.
- Proven leadership in fostering high-performance teams and applying data science skills to create impactful products and insights.
- Deep knowledge of statistics, causality, experimentation, and modeling.
- Business acumen with experience in quantifying impact through data initiatives.
- Strategic thinking and ability to develop data-driven roadmaps aligned with organizational goals.
Who we are
Since 2004, talabat has been Kuwait’s leading on-demand food and Q-commerce app, serving eight countries. We leverage technology to simplify life, optimize operations, and provide earning opportunities. We foster a high-performance culture, value authenticity, and are proud of our awards and diverse team of over 6,000 Talabaty committed to making a difference.
#J-18808-LjbffrData Scientist II - Analysis, Lifecycle
Posted today
Job Viewed
Job Description
Role Summary
As the leading delivery company in the region we have a great responsibility and opportunity to impact the lives of millions of customers, restaurant partners, and riders. To realize our potential we need to advance our platform to become much more intelligent in how it understands and serves our users.
As a data scientist on the analysis track your mission will be to improve the quality of the decisions made across product and business via relevant, reliable, and actionable data. You will own a particular domain across product and business and will work closely with the corresponding product and business managers as part of a talented team of data scientists and data engineers. You will own the entire data value chain including logging, data modeling, analysis, reporting, and experimentation.
Whats On Your Plate
- Leveraging ambiguous business problems as opportunities to drive objective criteria using data.
- Developing a deep understanding of the product experiences and business processes that make up your area of focus.
- Developing a deep familiarity with the source data and its generating systems through documentation, interacting with the engineering teams, and systematic data profiling.
- Contributing heavily to the design and maintenance of the data models that allow us to measure performance and comprehend performance drivers for your area of focus.
- Working closely with product and business teams to identify important questions that can be answered effectively with data.
- Delivering well-formed, relevant, reliable, and actionable insights and recommendations to support data-driven decision making through deep analysis and automated reports.
- Designing, planning, and analyzing experiments (A/B and multivariate tests).
- Supporting product and business managers with KPI design and goal setting.
- Mentoring other data scientists in their growth journeys.
- Contributing to improving our ways of work, our tooling, and our internal training programs.
What Did We Order
Technical Experience
- Excellent SQL.
- Competence with reproducible data analysis using Python or R.
- Familiarity with data modeling and dimensional design.
- Strong command over the entire data analysis lifecycle including problem formulation, data auditing, rigorous analysis, interpretation, recommendations, and presentation.
- Familiarity with different types of analysis including descriptive, exploratory, inferential, causal, and predictive analysis.
- Deep understanding of the various experiment design and analysis workflows and the corresponding statistical techniques.
- Familiarity with product data (impressions, events) and product health measurement (conversion, engagement, retention).
- Familiarity with BigQuery and the Google Cloud Platform is a plus.
- Data engineering and data pipeline development experience (e.g. via Airflow) is a plus.
- Experience with classical ML frameworks (e.g. Scikit-learn, XGBoost, LightGBM) is a plus.
Qualifications:
- Bachelor's degree in engineering, computer science, technology, or similar fields. A postgraduate degree is a plus but not required.
- 3 years of overall experience working in data science and machine learning.
- Experience doing data science in an online consumer product setting is a plus.
- A good problem solver with a figure-it-out growth mindset.
- An excellent collaborator.
- An excellent communicator.
- A strong sense of ownership and accountability.
- A keep-it-simple approach to #makeithappen.
Remote Work:
No
Employment Type:
Full-time
#J-18808-LjbffrBe The First To Know
About the latest Statistical analysis Jobs in United Arab Emirates !
Data Engineering and Analysis Intern
Posted 4 days ago
Job Viewed
Job Description
At General Motors we pride ourselves on designing, building and selling the world's best vehicles. We are seeking a new generation of visionaries to help launch bold engineering and business initiatives, and shape new directions for General Motors. As an intern you will gain hands-on career specific experiences to maximize your real-world potential.
Work Arrangement: This role is categorized as hybrid. This means the successful candidate is expected to report to the office at minimum three times per week or other frequency dictated by the business and two times per week remote.
Your Role:
As a Data Engineering and Analysis Intern, you’ll have the opportunity to gain hands-on experience in data-driven decision-making and contribute to our global sales operations. You will collaborate with senior team members, work on data collection, analysis, and reporting, and help optimize business processes using data science techniques.
What You'll Do:
- Assist in gathering and preparing data from various sources
- Clean, transform, and analyze data to ensure quality and accuracy
- Support data analysis, hypothesis testing, and exploratory data analysis (EDA)
- Help build and validate predictive models using basic machine learning techniques
- Generate reports and create data visualizations to highlight business insights
- Collaborate with cross-functional teams (Sales, Finance, CRM, Omnichannel) to support data-driven solutions
- Contribute to business performance tracking, including dashboards and KPIs
- Participate in training and mentorship opportunities to enhance your technical skills
Your Skills & Abilities:
- Currently undergoing bachelor's or master's degree in data science, Data Engineering, Business Analytics, or a related field
- Basic knowledge of programming languages (Python preferred) and data analysis tools (e.g., SQL, Excel)
- Basic knowledge of data visualization tools (Power BI, Tableau) is a plus
- Completed coursework in AI, machine learning, deep learning, and natural language processing (NLP)
- Worked on academic projects involving generative models (like GPT-3, GANs) or reinforcement learning
What We Offer:
- Mentorship from experienced professionals in business and data
- Exposure to real-world data challenges and solutions
- Opportunity to contribute to meaningful projects that impact business outcomes
#J-18808-Ljbffr
Business Intelligence Junior Consultant (Fleet Data Management and Analysis)
Posted 4 days ago
Job Viewed
Job Description
DEADLINE FOR APPLICATIONS
23 May 2025-23:59-GMT04:00 Gulf Standard Time (Dubai)WFP celebrates and embraces diversity. It is committed to the principle of equal employment opportunity for all its employees and encourages qualified candidates to apply irrespective of race colour national origin ethnic or social background genetic information gender gender identity and/or expression sexual orientation religion or belief HIV status or disability.
ABOUT WFP
The World Food Programme is the worlds largest humanitarian organization saving lives in emergencies and using food assistance to build a pathway to peace stability and prosperity for people recovering from conflict disasters and the impact of climate change.
At WFP people are at the heart of everything we do and the vision of the future WFP workforce is one of diverse committed skilled and high performing teams selected on merit operating in a healthy and inclusive work environment living WFPs values (Integrity Collaboration Commitment Humanity and Inclusion) and working with partners to save and change the lives of those WFP serves.
To learn more about WFP visit our website: follow us on social media to keep up with our latest news: YouTube LinkedIn Instagram Facebook Twitter TikTok.
WHY JOIN WFP
WFP is a 2020 Nobel Peace Prize Laureate.
WFP offers a highly inclusive diverse and multicultural working environment.
WFP invests in the personal & professional development of its employees through a range of training accreditation coaching mentorship and other programs as well as through internal mobility opportunities.
A career path in WFP provides an exciting opportunity to work across the various country regional and global offices around the world and with passionate colleagues who work tirelessly to ensure that effective humanitarian assistance reaches millions of people across the globe.
We offer an attractive compensation package (please refer to the Terms and Conditions section of this vacancy announcement).
JOB TITLE: Business Intelligence Junior Consultant (Fleet Data Management and Analysis)
TYPE OF CONTRACT: CST Junior L3
UNIT/DIVISION: Global Fleet Centre MSDF
DUTY STATION (City Country): Dubai UAE
DURATION: 12.06.2025 - 31.12.2025
BACKGROUND AND PURPOSE OF THE ASSIGNMENT:
ABOUT WFP
The United Nations World Food Programme is the worlds largest humanitarian agency fighting hunger worldwide. The mission of WFP is to help the world achieve Zero Hunger in our lifetimes. Every day WFP works worldwide to ensure that no child goes to bed hungry and that the poorest and most vulnerable particularly women and children can access the nutritious food they need.
ORGANIZATIONAL CONTEXT
The United Nations World Food Programme is the worlds largest humanitarian agency fighting hunger worldwide. The mission of WFP is to help the world achieve Zero Hunger in our lifetime. Every day WFP works worldwide to ensure that no child goes to bed hungry and that the poorest and most vulnerable particularly women and children can access the nutritious food they need.
To support this mission WFP Fleet Centre (FC) in Dubai is mandated to centrally set the global standards for and manage the light and Armoured vehicle leasing operations to enable effective safe and efficient fleets in all WFP offices. The vehicle leasing & insurance service is complemented by world-class expertise and technical assistance in fleet management fleet systems support disposal and driver and fleet management training. In addition having one of the largest humanitarian light vehicle fleets WFP is also spearheading collaboration efforts within the wider UN System to facilitate UN agency access to more effective and safer vehicles and to realize efficiency gains.
PURPOSE OF THE ASSIGNMENT
The Consultant will be working with Fleet Center Units to define and document business requirements for data analysis and reporting. The incumbent will also be required to come up with reporting solutions designed to present FMS (Fleet Management System) VTS (Vehicle Tracking System) and FC Portal data in ways that help relevant stakeholders make better decisions at both an operational and strategic level. The BI specialist also ensures the implementation of the reporting using WFP corporate tools i.e. Tableau and Dots. This position is suited for a good team player who can work independently is impeccably organized with strong data analysis skills.
ACCOUNTABILITIES/RESPONSIBILITIES:
Under the direct supervision of Head of FMSS Fleet Centre the consultant will have the following responsibilities:
1. Apply agile development of new visualizations in Tableau dashboards that support large data sets and analytics methodologies
2. Analyze and verify existing data-collecting and analytics systems
3. Analyze data research data sources and make corrections to existing data as needed to ensure accuracy
4. Ensure that relevant teams and individuals are consulted and involved in decision making at key points and that all decisions made are clearly documented and communicated
5. Enhance data analysis and delivery of a series of business intelligence dashboards and reports for different audiences informing them on dimensions identified as relevant for them with pertinent KPIs.
6. Maintain evaluate and adapt visualizations for effective use and broad understanding.
7. Maintain databases
8. Answer any questions users might have regarding the system and train peers and relevant stakeholders on delivered analytical tools and dashboards to ensure knowledge handover; assist with production of training material
9. Report progress and issues to all relevant stakeholders
10. Support the development of fleet systems by analyzing the needs coming from WFP offices and submit the clear business requirements to FC Management for review;
11. Conduct regular fleet systems data analysis and advice country offices to for corrective action to maintain high level of data quality (completeness correctness and timeliness)
12. Ensure vehicle tracking operational data such as VTS devices stock allocation airtime etc. are timely updated and reconciled between the VTS platform and FMS data base.
13. Any other duties as required.
QUALIFICATIONS & EXPERIENCE REQUIRED:
Education:
Bachelors Degree in Computer Science information technology management
data analytics/management or other relevant disciplines.
Experience:
Minimum of three years experience as a Tableau Data Visualization Specialist
Experience using Tableau for the creation of dashboards standard reports and adhoc reports
Experience working with multiple disparate data sources
Experience with advanced data visualization topics such as complex calculations table calculations parameters geographic mapping and performance
optimization
Familiar with Data Visualization best practices
Excellent client interaction problem solving & communication skills
Attention to detail; data analysis skills and quality assurance certification skills.
Willingness to travel as and if requested/required.
Knowledge & Skills:
At least 3 years of background developing and supporting Data Visualization
solutions using Tableau
Understanding of data modelling techniques
Advanced use of Microsoft Excel
Knowledge of SAP an asset
Analytical mind and business acumen
Strong mathematical skills (e.g. statistics algebra)
Problem-solving aptitude
Excellent communication and presentation skills
Knowledge of Fleet data and KPIs
Ability to work and deliver results within a highly complex organizational environment (i.e. with diverse team matrix structure and highly evolving operational context);
An understanding of working with different cultures.
Languages:
Verbal and written fluency in English (proficiency/level C) is required. Second UN Language (French Arabic or Spanish is desirable).
WFP LEADERSHIP FRAMEWORK
WFP Leadership Framework guides to the common standards of behavior that guide HOW we work together to accomplish our mission.
Click here to access WFP Leadership Framework
REASONABLE ACCOMMODATION
WFP is committed to supporting individuals with disabilities by providing reasonable accommodations throughout the recruitment process. If you require a reasonable accommodation please contact:
NO FEE DISCLAIMER
The United Nations does not charge any application processing training interviewing testing or other fee in connection with the application or recruitment process. Should you receive a solicitation for the payment of a fee please disregard it. Furthermore please note that emblems logos names and addresses are easily copied and reproduced. Therefore you are advised to apply particular care when submitting personal information on the web.
REMINDERS BEFORE YOU SUBMIT YOUR APPLICATION
We strongly recommend that your profile is accurate complete and includes your employment records academic qualifications language skills and UN Grade (if applicable).
Once your profile is completed please apply and submit your application.
Please make sure you upload your professional CV in the English language
Kindly note the only documents you will need to submit at this time are your CV and Cover Letter
Additional documents such as passport recommendation letters academic certificates etc. may potentially be requested at a future time
Please contact us at in case you face any challenges with submitting your application
Only shortlisted candidates will be notified
All employment decisions are made on the basis of organizational needs job requirements merit and individual qualifications. WFP is committed to providing an inclusive work environment free of sexual exploitation and abuse all forms of discrimination any kind of harassment sexual harassment and abuse of authority. Therefore all selected candidates will undergo rigorous reference and background checks.
No appointment under any kind of contract will be offered to members of the UN Advisory Committee on Administrative and Budgetary Questions (ACABQ) International Civil Service Commission (ICSC) FAO Finance Committee WFP External Auditor WFP Audit Committee Joint Inspection Unit (JIU) and other similar bodies within the United Nations system with oversight responsibilities over WFP both during their service and within three years of ceasing that service.
Required Experience:
Junior IC
#J-18808-LjbffrCourse: Data Management, Manipulation and Analysis using Excel
Posted today
Job Viewed
Job Description
Data Management, Manipulation and Analysis using Excel
ID 473
Course: Data Management, Manipulation and Analysis using Excel
This course is aimed at professionals who have, or will soon have, responsibility for managing and manipulating data using MS Excel on a day-to-day basis. The course assumes zero knowledge, begins with an introduction to the Excel environment, and ends with delegates being skilled in using 50+ MS Excel functions, sophisticated data management, and charting techniques, and advanced data analysis capability.
This course will feature:
- Advanced data analysis
- Both textual and numerical data
- Forecasting
- Advanced charting
By the end of this course, participants will be able to:
- Analyse relationships across information and data using MS Excel.
- Generate data forecasts using MS Excel.
- Organise your company’s data in a more structured manner.
- Analyse your data effectively using various MS Excel techniques.
- Select the appropriate chart for your data.
This course is suitable for a wide range of professionals but will greatly benefit:
- Administrators using MS Excel at a very basic level
- Administrators with a need to improve data management techniques utilising MS Excel
- New Administrative Staff with no prior knowledge of MS Excel
- HR professionals seeking to use MS Excel to analyse employee data and inventory data
- Oil and Gas, telecommunications, and electricity industry employees looking to improve their data management and data representation skills
This course will utilise a variety of proven adult learning techniques to ensure maximum understanding, comprehension, and retention of the information presented. The course will be split up into themes with a series of exercises based on each theme. The approach will also be incremental with each session building on prior knowledge. Each delegate will be introduced to practical, hands-on learning using MS Excel.
Delegates can bring their own Windows or Mac OS laptop to the sessions, for them to be comfortable with the environment and version of MS Excel that they will be working on.
The Course ContentDay One: An Introduction to the MS Excel Environment
- Cell referencing, cell formatting, and entering formula
- Copy and pasting
- Introductory charts
Day Two: Using MS Excel Functions for Fundamental Data Analysis
- Use of text function, FIND(), LEN(), LEFT(), RIGHT() and &
- Use of count functions, COUNTA(), COUNTIF(), COUNTIFS() and SUMIF()
- Basic statistical functions, Max and Average
- Filtering, sorting, and use of conditional formatting
Day Three: Intermediate MS Excel Functions
- Use of VLOOKUP() and HLOOKUP()
- Date functions, YEAR(), MONTH(), DAY(), YEARFRAC()
- Selecting appropriate charts
- Introduction to Pivot tables
Day Four: Carrying out Statistical Analysis using MS Excel
- Using MS Excel to calculate mean, mode, and median
- The difference between the various standard deviation and variance function in MS Excel
- Using MS Excel to examine inter-dependency
- Drawing histograms in MS Excel
- Introduction to Data Analysis functions
Day Five: What if and Scenario Analysis Using MS Excel
- Naming cells in MS Excel
- Linking cells together to undertake scenario analysis
- Introduction to solver
- Advanced charting
- Sharing MS Excel output with other office formats
European Quality Training and Management Consultancy
At European Quality Training and Management Consultancy, we provide high-quality training and consultancy services to develop future leaders. With a team of skilled experts, we tailor programs to meet the needs of public and private sectors, grounded in quality, ethics, and social responsibility. Our client-focused approach ensures professionalism and sustainable outcomes.
Subscribe now to our mailing list and keep up to date with our offers and news.
#J-18808-Ljbffr