Excel Dashboard Training in Saudi Arabia, Riyadh, Jeddah, Dammam, Khobar

Excel Dashboard Training in Saudi Arabia, Riyadh, Jeddah, Dammam, Khobar

Build Dashboards in Excel That Persuade, Inform and Engage

Wow your boss and take your career to the next level.

Course Overview | Dashboard Training with MS Excel

A good visualization can communicatethe nature and potential impact of information and ideas more powerfully than any other form of communication. This visual language is used everywhere in the world, from live sports to the news to fitness apps. Even if you think you can’t speak this language, you hear it and understand it every day.

Building Dashboards in Excel

Building good dashboards in excel is quickly becoming a need-to-have skill for managers. If you're not doing it, other managers are, and they're getting noticed for it and getting credit for contributing to the company's success. So, it’s time to learn to speak it, too.

Excel Training in Saudi Arabia

Microsoft Excel Training in Saudi Arabia is an excellent choice for creating and distributing dashboards due to its ease of use and universal availability. It is a tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.

Training Objectives

In this comprehensive Excel Dashboard Course you will learn the techniques you can apply in Excel to make killer dashboards that will set your skill level apart from the crowd and enable you to report, communicate, analyze, check and plan quantitative information.

Create Excel Dashboards 

We will teach you how to create amazing interactive Excel dashboards, that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet.

Target Audience

·          Anyone who is interested in making effective business Communication through Data using excel.

·          Manager working in any stream who requires to present / Project / Analyse the data

·          Employee whose work is to create reports and present it in Effective Format

·          Corporate Executives

·          Business Analysts

·          Any advance or intermediate Excel user who wants to learn more skills in Excel

Course Benefits

This hands-on training on dashboard reporting in excel will provide you with an extremely advanced toolkit worth of knowledge that will take the design of your reports to the next level. You will be able to present valued information in a more accurate and concise way, which can be updated and interpreted easily to make good decisions.

You will be able to display key trends, comparisons and data graphically and interactively, so that you can see what you need immediately.

This course will help you turn plain and uninspiring information into smart, effective visualizations that powerfully convey ideas.

By applying the rules, we will share with you, you will have the skills to be able to create reports that save loads of time (allowing you to go home early J) and you’ll quickly become known as Excel Data Visualization Stars with reports that are:

·         Quick and easy to update.

·         Fully interactive so the reader can change the view themselves.

·         Easy to read and interpret

·         Professional presentation

PRE-REQUISITE

Participants should possess moderate level of Excel knowledge to get more out from this course.

Microsoft Excel – Executive Dashboards Training

EXCEL DASHBOARD DESIGN STRATEGIES FOR CREATING ADVANCED SUMMARY AND LOOKUP TABLES:

·          Layout And Organize The Raw Data That Your Excel Dashboards Will Use

·          Aggregation Functions:  Summarize Your Excel Dashboard Data Using SUMIF, SUMIFS, COUNTIF, COUNTIFS, SUM, MAX, MIN, AVERAGE, RANK, SMALL, LARGE...

·          Lookup Your Excel Dashboard Data Using VLOOKUP, MATCH, INDEX, LOOKUP...

·          Search For And Return Entire Data Columns Or Rows For Your Excel Dashboard Using INDIRECT, INDEX, MATCH And String Concatenation

·          Deal With Dates And Time In Your Excel Dashboard Using The TEXT, YEAR, DAY, MONTH, NETWORKDAYS.INTL, NOW, TODAY, TIME, TIMEVALUE, DATEVALUE, DAYS And SECONDS Functions

·          Process Your Worksheet Text In Your Excel Dashboard Using The LEFT, RIGHT, MID, SUBSTITUTE, REPLACE, SEARCH, LEN, TRIM, CLEAN And TEXT Functions

·          Use Advanced String Concatenation To Help Build Your Excel Dashboard Formulas And Displays

EXCEL DASHBOARD DESIGN KEY WORKSHEET LOGIC FUNCTIONS AND OPERATORS

·          Build Logic Decisions Using The Relational Operators: <, >, <=, >=, < >, =

·          Build Logic Decisions Using The IF, AND, OR, IFERROR Logical Functions, Using Choose Functions

·          Use The IS Functions To Detect Cell Inputs And Formula Problems

·          Use Logic In General, Figure Out The Strategies, Build Multiple Decisions, Figure Out Logical Triggers And Use Them In Your Excel Dashboards

USING ADJUSTABLE NAMES AND EXCEL TABLES IN  EXCEL DASHBOARD DESIGN

·          Names That Automatically Adjust To Changing Data Size, The Key To Building Advanced Excel Dashboards

·          Use Excel Table Syntax And Names In Your Excel Dashboard Formulas

·          Build Adjustable Cell And Range Names From Formulas

·          Cell And Range Naming Rules That Aid In Tracking Your Changing Data

·          Design Table, Column And Row Names That Automatically Adjust To Changing Raw Data And Start/Stop Positions Using The INDIRECT,  OFFSET, COUNTA, COUNTIF And MATCH Functions

ADVANCED EXCEL CHARTS FOR DASHBOARD DESIGN

·          Creating A Chart

·          Switching The Row And Column Orientation

·          Changing The Chart Type

·          Adding And Deleting Chart Elements

·          Formatting Chart Elements

·          Understanding Chart Types

·          Creating Combination Charts

·          Creating And Using Chart Templates

·          Charting A Noncontiguous Range

·          Converting A Chart To A Picture

·          Linking Title Text To A Cell

·          Working With Chart Axes

·          Working With Gridlines

·          Working With Data Labels

·          Combining Different Chart Types In One Chart

·          Creating Custom Markers

·          Creating Miniature Charts Suitable For Dashboards

·          Using Sparklines

·          Target Vs Actual Charts

·          Waterfall Charts

·          Mix Drawing Shapes With Charts To Produce Advanced Excel Dashboards

EXCEL DASHBOARD DESIGN STRATEGIES FOR CREATING VARIOUS SPEEDOMETER STYLE GAUGES

·          Layout And Build The Formulas And Tables That Your Speedometer Style Charts Will Use

·          Create And Format The Pie Charts Turning Them Into Speedometer Style Gauges

·          Combine Pie Charts With Doughnut Charts and Drawing Shapes To Create  Speedometer Style Gauges

USING PIVOT TABLES EFFECTIVELY FOR DASHBOARD DESIGN

·          Creating A Basic Pivot Table

·          Customizing Your Pivot Table

·          Formatting Numbers

·          Changing Summary Calculations

·          Suppressing Subtotals

·          Hiding And Showing Data Items

·          Sorting Your Pivot Table

·          Producing Pivot Table Views

·          External Data Sources

ENHANCING PIVOT TABLES

·          Grouping Data

·          Working With Field Settings

·          Creating Calculated Field

·          Creating A Calculated Item

·          Using Slicer Tool Effectively For Creating Dashboards

·          Using Powerpivot Feature To Create Report From Multiple Tables

USING PIVOT CHART DISPLAYS IN EXCEL DASHBOARD DESIGN

·          Layout And Organize The Raw Data That Your Pivot Table And Pivot Chart Will Use

·          Construct A Pivot Table For Your Pivot Chart Taking Advantage Of Dynamic Names And Excel Tables

·          Build A Pivot Chart For Your Pivot Table

·          Create Slicers And Timelines That Will Filter Your Pivot Tables And Charts

·          Format Your Pivot Charts, Slicers And Timelines For That Microsoft Excel Dashboard Look

·          Use Conditional Formatting In Your Excel Dashboard Pivot Table

·          Create Running Totals, Ranks... In Your Excel Dashboard Pivot Table

USING CONDITIONAL FORMATTING IN EXCEL DASHBOARD DESIGN

·          Change The Look Of Worksheet Cells Using Conditional Formatting

·          What Is A Conditional Formatting Rule And  Set Them Up

·          Manage Your Conditional Formatting Rules

·          Setup The Logic That Applies Multiple Conditional Formatting Rules To One Cell

·          Use Advanced Logic In Your Conditional Formatting, The Key To Building Advanced Excel Dashboard Displays

·          The Key Conditional Formatting Rules That Will Help You Make Your Excel Dashboards 

EXCEL DASHBOARD DESIGN STRATEGIES FOR BUILDING  STATUS DISPLAYS

·          Use Conditional Formatting To Create Tables That Color Complete Areas Based Upon Logic

·          Use Conditional Formatting To Create Name Lists, Product Lists... That Change Color When Their Logical Criterion Have Been Met In Other Tables

·          Use Conditional Formatting To Create Icon Sets And Data Bars For Dashboard Tables

·          Applying Conditional Formatting In Pivot Table

CHARTLESS VISUALIZATION TECHNIQUES

·          Dynamic Labels

·          Linking Formulas To Text Boxes

·          In-Cell Charting

·          Using Symbols

CREATING INTERACTIVE DASHBOARD COMPONENTS

·          Adding A Scroll Bar To A Data Window

·          Adding Option Buttons To A Chart

·          Using A Spin Button

·          Using A Combo Box Drop-Down Menu

·          Using A List Box Control

·          Using The Check Box Control

SCENARIOS

·          Creating Scenarios

·          Options For Choosing Different Scenarios

DATA VALIDATION

·          Creating Data Validation

·          Working With  List & Dependent List

·          Creating List With Dynamic Ranges

·          Create Formulas In Your Data Validation That Allow It To Adjust To Changing Excel Dashboard Conditions

·          Create Cells That Only Allow Certain Date Ranges To Be Entered

·          Handling Input And Error Alerts

SECURING AND DISTRIBUTING YOUR DASHBOARDS AND REPORTS

·          Securing Access To The Entire Workbook

·          Limiting Access To Specific Ranges

·          Protecting The Workbook Structure

·          Linking Excel Dashboards To Powerpoint

·          Building Navigation Buttons

·          Distributing Your Dashboards Via PDF

This course can be scheduled at your convenience, to request this course please click here.

This course is available for delivery in UAE, Kingdom of Saudi Arabia, Bahrain, Qatar, Oman, Kuwait, GCC.

To know more whatsapp +971 55 8400399, email: info@thebscon.com

GCC VAT Training, VAT Training in GCC VAT Training in Dubai VAT Training in Saudi Arabia

VAT Training in GCC
VAT Training in Dubai
VAT Training in Saudi Arabia

This course is available for delivery in UAE, Kingdom of Saudi Arabia, Bahrain, Qatar, Oman, Kuwait, Egypt, Sudan, Africa, GCC.

To know more whatsapp +971 55 8400399, email: waheedensari@hotmail.com

Lead the Business with Analytics (Big Data, Data Analytics, Make Data Driven Business Decisions)

Lead the Business with Analytics

(Big Data, Data Analytics, Make Data Driven Business Decisions)

Course Overview

Businesses must understand the changing market and trends to stay ahead of competition. Data is the foundation of new waves of productivity growth, innovation and richer customer insight.

This is a hands-on course with a combination of lectures, problem cases and computational exercises. Objective of this course is introducing how businesses use data analytics to make better decisions and drive optimal results, why data is crucial for the organizations, how to develop a data strategy and how to succeed in managing data analytics projects.

Target Audience

The course is for analytically minded executive managers who are looking to leverage analytics to make critical business decisions. This course is beneficial for professionals from various backgrounds such as marketing, business planning, customer care, finance, analytics and IT, etc. from telecom, banking, retail, hospitality, tourism, healthcare, logistics and manufacturing industry.

Key Takeaways

·  Enabling the delegates to build a framework to link the business strategy with the initiatives on data analytics and how to apply data analytics in different domains of the organization.

·  Enabling the delegates in managing data analytics projects, selecting the tools and measuring ROI, and building data analytics teams.

·     A crash course on data science to develop the analytical thinking by understanding what is data science, what are the fundamental analytical techniques and how statistics is applied in real business problems.

·   Developing the understanding how data is used across different industries to deliver value.

Duration of the Course

2 days course.

Course Outline

Day 1: Data Analytics Crash Course

Delegates will solve business problem case study using data with the emphasize on statistical thinking, stressing conceptual understanding rather than mere knowledge of procedures and using MS Excel for analyzing data.

·        Data Science, Big Data, and Machine Learning

This section is about introducing data science, big data, machine learning, data science venn diagram, importance of data science, different types of data and machine learning.

·        Data Analytics Life Cycle

In this section delegates, will know the overview of phases and structure of a data science project, and key roles for a successful analytics project.

·        Data Science Toolbox

Technology is the major component which makes possible for management to analyze data. In this section delegates, will get an overview of technologies for data science.

·        Describing, Estimating and Inferencing Data

Focus of this section is on the fundamental tools and methods of data analysis and statistics, data visualization, descriptive statistical measures, exploratory data analysis, sampling and estimation, distributions and intervals, ANOVA and statistical inference.

·        Basic Predictive Analytics

In this section, focus is to gain a basic understanding of how to use and interpret trendlines and regression models, statistical issues associated with interpreting regression analysis results, and practical issues in using trendlines and regression as tools for making and evaluating decisions.

Day 2: Wining with Data

This module will provide an overview of leading, shaping the direction, and planning the strategies how to apply data analytics in different segments of the organization. Delegates will solve business problems and case studies to sharpen the analytical thinking.

·        Driving Extra Ordinary Results

Delegates will learn how small and large businesses from different industries using data to deliver value in diverse area, what are the results and how they overcome the challenges.

·        Building Strategic Framework & Implementing Analytics

Focus of this section is towards identifying where to play and how to win, identifying the strategic implications and developing the strategy. Delegates will get introduction of using big data strategy documents, business model maturity index, prioritization matrix, measuring the ROI, requirement gathering for analytics projects, analytics implementation methodology, and analytics change management.

·        Developing & Acquiring the Talent

As a data science leader, delegates need to know how to recruit, organize and manage data science team. In this section, we will cover key roles in data science team, what are expected qualifications and skills for each role, and how to manage data science team.

This course is available for delivery in UAE, Kingdom of Saudi Arabia, Bahrain, Qatar, Oman, Kuwait, Egypt, Sudan, Africa, GCC.

To know more whatsapp +971 55 8400399, email: waheedensari@hotmail.com

Advanced Social Networking - Social Media Masterclass

Social Networking | 2017 Marketing Strategies

Social Media Masterclass, Value for Money

1. Overview:

Online marketing & Social Media became one of the most successful tools in advertising for any kind of business. It’s the appropriate time to invest into the internet marketing and know the basic Concepts of that online world. The core of this course is awareness of Online Marketing world Techniques & Secrets, and how to reach targeted customers easily in a professional ways.

In this course we will Discuss the most popular online channels used by the targeted customers In order to reach potential internet customers, and how to create an integrated online marketing plan putting in consideration the popular online channels used by each country internet users that will help in building up a reputable online image for your business in the right place with the best ROI

2. Learning Objectives:

Upon completion of program, you'll be able to

ü Be aware of Main Social Media Channels

ü Understand how using Social Networks can achieve your business goals.

ü Creating Online Ads through Social Networks

ü Create a Social Network plan

ü Using Social Networks in Competitor’s Analysis

ü Manage & Monitor any Online Social Activity

3. Online Marketing Workshop Content

Day 1 :

• Introduction to Social Networks
• Social Networks Types
• Social Networks Statistics
• Advantages & Disadvantages of Social Networks
• How to use your Facebook effectively?
• Facebook Advertising
• How to use your LinkedIn effectively?
• LinkedIn Advertising
• How to use your Twitter effectively?
• Twitter Advertising

 Day 2:

• Instagram in Online Marketing for corporate
• Pinterest as a social network in Business area
• How to use Tumblr
• Google + and its Trend
• Flickr in e-Marketing
• How to use YouTube effectively?
• YouTube Advertising

Day 3 :

• How to settle a Social Media Plan
• Social Media Optimization
• Social Media Mix
• Monitoring & Tracking Social Media Activities
• KPIs of Social Media Strategy & online plans
• How to deal with Negative Comments

Day 4 :

• Learn the Behaviors of your Target Audience
• The Rules of Social Media Communicating
• Social Media Content Plan
• How social media changed the way we interact with the world
• The value and use of social media as communication tool
• Searching for the most relevant & targeted primary keyword and other similar keywords to your business field

Day 5 :

• 10 Social Media Problems and Possible Solutions
• How to analysis your competitor’s online existence on Social media
• 7 Common Social Media Marketing Problems and Their Solutions
• The Negative Effect of Social Media on Society and Individuals
• Social Media trends in 2017

4. Methodology:

The course is geared towards Internet Business learning and uses participatory approaches as much as possible. A variety of methodologies will be used, including presentation, discussions, group work, video discussions, question and answers, practical sessions (hands-on practice), small and large group exercises, and simulations.

5. Learning Media and Formats:

• Online Presentation
• Online Case Studies
• Internet Marketing Books on CD
• Practical Workshop

6. Who Should Attend?

• Junior Marketer
• Senior Marketer
• Junior Online Marketer
• Senior Online Marketer
• Business Development Manager
• Web Developer
• Web Designer
• Business Owner
• Sales Manager
• Sales Executives
• Students
• CEO

7. Duration:

• 5 Days ( 5 hours per Day )

8. Languages:

• Arabic Speaking /  English Presentation
• English Speaking / English Presentation
• Arabic Speaking / Arabic Presentation

This course is available for delivery in UAE, Kingdom of Saudi Arabia, Bahrain, Qatar, Oman, Kuwait, Egypt, Sudan, Africa, GCC.

To know more whatsapp +971 55 8400399, email: waheedensari@hotmail.com

How it’s Done? Inhouse Training : Best Practices

How it’s Done?

In-house Training : Best Practices

Do Organizations Need training

• The answer is “YES”
• However, we must know the purpose and functions of training before we can use it.

Here is the in-house training cycle:

Understanding Requirements

Meeting the HR Team and knowing the requirements is the favorite part of what I do because the in-house training cycle kicks-off from here. Here the training objectives are discussed and input is recorded from the perspective of management.

This meeting enables us to understand the root cause of training need and corporate culture associated with it.

The GAP Concept / Meeting the RIGHT person

Once the initial requirements and information is collected then the stage it set to meet the Functional Manager in order to get technical details and objective for the training. Another purpose of this meeting is to narrow down the key areas to be center of attention and the manager wants to develop his/ her team in the training course.

We need to develop programs to fill the gaps.

Pre Training Assessment

Pre-assessments is the key driver for course success and in getting results from the training program. Pre-assessment is normally based on the initial meetings with the HR team after which we create the assessments to be filled by the participants before the training starts.

Post Training Assessment

Participants will be given a post training assessment to measure their level of knowledge after the training. In few courses we also gives refresher course after a considerable time to refresh the key topics/ gaps.

Evaluating the Training

Three Levels of Evaluation

• Immediate Feedback: Survey or interview directly after training
• Post-Training Test: Trainee applying learned tasks in workplace?
• Post-Training Appraisals: Conducted by immediate supervisors of trainees

Training Providers in Dubai, How to deal with Training Provider when you have limited Budget?

How to deal with Training Provider when you have limited Budget?

Normally the last quarter of every year is busy for training and development activities, the reasons are numerous but the main are: -

• Pending learning needs of staff
• Training calendar not matching
• Un-utilized training budget
• New hiring at year end and many more

Now the question is how to get the maximum out of a training provider?

The training departments of organizations usually prefer the following way of trainingdelivery: -

• In-house training (where a considerable number of staff is available training is customized for staff members of one company)
• Public Course (delegates from different organizations attend the course in public venue)
• e-Learning platforms

Common Situational Problems of HR Professionals

• What if there are courses for which either the Training Manager/HR doesn’t have enough delegates or budget to run an in-house
• There are no public courses available in the market of such training course
• Or the course is available but the dates are not compatible with your schedule

Win-Win Situation

NOW pick up your phone call or email your training provider and tell them that You have 2-3 participants available for specific course(s) and ask them; can you arrange this session for us and that you can also have other persons sit in the course.

Training company business is like any other business in the world, there are products,profit and loss, operations, administration, product development and CLIENTS. So there is no harm in keeping Clients’ Happy through better services.